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]); }