public function getAllProductsInCategories()
{
$table = $this->getTableName();
$linker = 'catalog_category_product';
$joinString = $linker . '.product_id = ' . $table . '.product_id';
$predicate = new Predicate\Predicate();
$predicate->isNotNull('category_id');
$select = $this->getSelect()->join($linker, $joinString, $this->getCategoryLinkerFields())->where(array($predicate));
if ($this->enabledOnly()) {
$select->where(array('enabled' => 1));
}
return $this->selectManyModels($select);
}
public function testIsNotNullCreatesIsNotNullPredicate()
{
$predicate = new Predicate();
$predicate->isNotNull('foo.bar');
$parts = $predicate->getExpressionData();
$this->assertEquals(1, count($parts));
$this->assertContains('%1$s IS NOT NULL', $parts[0]);
$this->assertContains(array('foo.bar'), $parts[0]);
}
