本文整理匯總了PHP中Propel\Runtime\ActiveQuery\Criteria::addAlias方法的典型用法代碼示例。如果您正苦於以下問題：PHP Criteria::addAlias方法的具體用法？PHP Criteria::addAlias怎麽用？PHP Criteria::addAlias使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Propel\Runtime\ActiveQuery\Criteria的用法示例。
在下文中一共展示了Criteria::addAlias方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testAppendPsToCreatesAnInConditionUsingATableAlias
public function testAppendPsToCreatesAnInConditionUsingATableAlias()
{
$c = new Criteria();
$c->addAlias('bar_alias', 'bar');
$cton = new InCriterion($c, 'bar_alias.COL', array('foo'));
$params = array();
$ps = '';
$cton->appendPsTo($ps, $params);
$this->assertEquals('bar_alias.COL IN (:p1)', $ps);
$expected = array(array('table' => 'bar', 'column' => 'COL', 'value' => 'foo'));
$this->assertEquals($expected, $params);
}示例2: testDoDeleteTableAlias
public function testDoDeleteTableAlias()
{
if ($this->runningOnSQLite()) {
$this->markTestSkipped('SQLite does not support Alias in Deletes');
}
$con = Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME);
$c = new Criteria(BookTableMap::DATABASE_NAME);
$c->addAlias('b', BookTableMap::TABLE_NAME);
$c->add('b.TITLE', 'War And Peace');
$c->doDelete($con);
if ($this->isDb('pgsql')) {
$expectedSQL = $this->getSql("DELETE FROM `book` AS b WHERE b.TITLE='War And Peace'");
} else {
$expectedSQL = $this->getSql("DELETE b FROM `book` AS b WHERE b.TITLE='War And Peace'");
}
$this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'doDelete() accepts a Criteria with a table alias');
}示例3: testDoDeleteTableAlias
public function testDoDeleteTableAlias()
{
$con = Propel::getServiceContainer()->getWriteConnection(BookTableMap::DATABASE_NAME);
$c = new Criteria(BookTableMap::DATABASE_NAME);
$c->addAlias('b', BookTableMap::TABLE_NAME);
$c->add('b.TITLE', 'War And Peace');
$c->doDelete($con);
$expectedSQL = "DELETE b FROM `book` AS b WHERE b.TITLE='War And Peace'";
$this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'doDelete() accepts a Criteria with a table alias');
}示例4: testMergeWithAliasesThrowsException
/**
* @expectedException \Propel\Runtime\Exception\LogicException
*/
public function testMergeWithAliasesThrowsException()
{
$c1 = new Criteria();
$c1->addAlias('b', BookTableMap::TABLE_NAME);
$c2 = new Criteria();
$c2->addAlias('b', AuthorTableMap::TABLE_NAME);
$c1->mergeWith($c2);
}