本文整理汇总了PHP中JDatabaseQuery::union方法的典型用法代码示例。如果您正苦于以下问题：PHP JDatabaseQuery::union方法的具体用法？PHP JDatabaseQuery::union怎么用？PHP JDatabaseQuery::union使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类JDatabaseQuery的用法示例。
在下文中一共展示了JDatabaseQuery::union方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: testUnionTwo
/**
* Tests the JDatabaseQuery::union method.
*
* @return void
*
* @since 12.1
*/
public function testUnionTwo()
{
TestReflection::setValue($this->_instance, 'union', null);
$this->_instance->union('SELECT name FROM foo');
$this->_instance->union('SELECT name FROM bar');
$teststring = (string) TestReflection::getValue($this->_instance, 'union');
$this->assertThat($teststring, $this->equalTo(PHP_EOL . "UNION (SELECT name FROM foo)" . PHP_EOL . "UNION (SELECT name FROM bar)"), 'Tests rendered query with two unions sequentially.');
}示例2: testUnionTwo
/**
* Tests the JDatabaseQuery::union method.
*
* @return void
*
* @covers JDatabaseQuery::union
* @since 12.1
*/
public function testUnionTwo()
{
$this->_instance->union = null;
$this->_instance->union('SELECT name FROM foo');
$this->_instance->union('SELECT name FROM bar');
$teststring = (string) $this->_instance->union;
$this->assertThat($teststring, $this->equalTo(PHP_EOL . "UNION (SELECT name FROM foo)" . PHP_EOL . "UNION (SELECT name FROM bar)"), 'Tests rendered query with two unions sequentially.');
}示例3: testUnionObjectsArray
/**
* Tests the JDatabaseQuery::union method when passed two query objects in an array.
*
* @return void
*
* @since 12.??
*/
public function testUnionObjectsArray()
{
$this->_instance->select('name')->from('foo')->where('a=1');
$q2 = new JDatabaseQueryInspector($this->dbo);
$q2->select('name')->from('bar')->where('b=2');
$q3 = new JDatabaseQueryInspector($this->dbo);
$q3->select('name')->from('baz')->where('c=3');
TestReflection::setValue($this->_instance, 'union', null);
$this->_instance->union(array($q2, $q3));
$this->assertThat((string) $this->_instance, $this->equalTo(PHP_EOL . "SELECT name" . PHP_EOL . "FROM foo" . PHP_EOL . "WHERE a=1" . PHP_EOL . "UNION (" . PHP_EOL . "SELECT name" . PHP_EOL . "FROM bar" . PHP_EOL . "WHERE b=2)" . PHP_EOL . "UNION (" . PHP_EOL . "SELECT name" . PHP_EOL . "FROM baz" . PHP_EOL . "WHERE c=3)"));
}