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