PHP Joomla\Database DatabaseQuery::unionDistinctの例

コード例 #1

ファイル: QueryTest.php プロジェクト: jbanety/database

 /**
  * Tests the \Joomla\Database\DatabaseQuery::unionDistinct method.
  *
  * @return  void
  *
  * @covers  \Joomla\Database\DatabaseQuery::unionDistinct
  * @since   1.0
  */
 public function testUnionDistinctArray()
 {
     TestHelper::setValue($this->instance, 'union', null);
     $this->instance->unionDistinct(array('SELECT name FROM foo', 'SELECT name FROM bar'));
     $teststring = (string) TestHelper::getValue($this->instance, 'union');
     $this->assertThat($teststring, $this->equalTo(PHP_EOL . "UNION DISTINCT (SELECT name FROM foo)" . PHP_EOL . "UNION DISTINCT (SELECT name FROM bar)"), 'Tests rendered query with two unions distinct.');
 }