public function testAddAndDistinctColumns() { $table1 = "myTable1"; $column1 = "myColumn1"; $value1 = "myValue1"; $key1 = "{$table1}.{$column1}"; $table2 = "myTable2"; $column2 = "myColumn2"; $value2 = "myValue2"; $key2 = "{$table2}.{$column2}"; $this->c->add($key1, $value1, Criteria::EQUAL); $this->c->addAnd($key2, $value2, Criteria::EQUAL); $expect = "SELECT FROM myTable1, myTable2 WHERE myTable1.myColumn1=:p1 AND myTable2.myColumn2=:p2"; $params = array(); $result = $this->c->createSelectSql($params); $expect_params = array(array('table' => 'myTable1', 'column' => 'myColumn1', 'value' => 'myValue1'), array('table' => 'myTable2', 'column' => 'myColumn2', 'value' => 'myValue2')); $this->assertEquals($expect, $result, 'addAnd() called on a distinct column adds a criterion to the criteria'); $this->assertEquals($expect_params, $params, 'addAnd() called on a distinct column adds a criterion to the criteria'); }
/** * @param \Generated\Shared\Transfer\LocaleTransfer $localeTransfer * * @return \Propel\Runtime\ActiveQuery\Criteria */ protected function getLocaleCriteria(LocaleTransfer $localeTransfer) { $localeCriteria = new Criteria(); $localeCriteria->addAnd(PavCmsLocalizedBlockTableMap::COL_FK_LOCALE, $localeTransfer->getIdLocale(), Criteria::EQUAL); $localeCriteria->_or(); $localeCriteria->addAnd(PavCmsLocalizedBlockTableMap::COL_ID_CMS_LOCALIZED_BLOCK, null, Criteria::ISNULL); return $localeCriteria; }
/** * @param int $idLocale * * @return \Orm\Zed\Category\Persistence\SpyCategoryAttribute[]|\Propel\Runtime\Collection\ObjectCollection */ public function getLocalisedAttributes($idLocale) { $criteria = new Criteria(); $criteria->addAnd(SpyCategoryAttributeTableMap::COL_FK_LOCALE, $idLocale, Criteria::EQUAL); return $this->getAttributes($criteria); }