Exemplos de OC\DB\QueryBuilder QueryBuilder::innerJoin em PHP

Exemplo n.º 1

Arquivo: querybuildertest.php Projeto: gwdg/core

 /**
  * @dataProvider dataJoin
  *
  * @param string $fromAlias
  * @param string $tableName
  * @param string $tableAlias
  * @param string $condition
  * @param array $expectedQueryPart
  * @param string $expectedQuery
  */
 public function testInnerJoin($fromAlias, $tableName, $tableAlias, $condition, $expectedQueryPart, $expectedQuery)
 {
     $this->queryBuilder->from('data1', 'd1');
     $this->queryBuilder->innerJoin($fromAlias, $tableName, $tableAlias, $condition);
     $this->assertSame($expectedQueryPart, $this->queryBuilder->getQueryPart('join'));
     $this->assertSame('SELECT  FROM ' . $expectedQuery, $this->queryBuilder->getSQL());
 }