PHP JDatabaseQueryInspector::union示例

示例#1

文件： JDatabaseQueryTest.php 项目： rdiaztushman/joomla-platform

 /**
  * Tests the JDatabaseQuery::union method.
  *
  * @return  void
  *
  * @since   12.1
  */
 public function testUnionTwo()
 {
     $q = new JDatabaseQueryInspector($this->dbo);
     $q->union = null;
     $q->union('SELECT name FROM foo');
     $q->union('SELECT name FROM bar');
     $teststring = (string) $q->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.');
 }