Files
dokuwiki-plugin-struct/_test/QueryBuilderFromTest.php
Andreas Gohr 8fed17f342 clean up for the tests
This mostly corrects file and class names for PSR-2. Function names have
not been adjusted yet
2023-04-05 11:09:51 +02:00

67 lines
1.7 KiB
PHP

<?php
namespace dokuwiki\plugin\struct\test;
use dokuwiki\plugin\struct\meta\QueryBuilder;
use dokuwiki\plugin\struct\meta\StructException;
/**
* @group plugin_struct
* @group plugins
*/
class QueryBuilderFromTest extends StructTest
{
/**
* @noinspection SqlDialectInspection
* @noinspection SqlNoDataSourceInspection
*/
public function test_join()
{
$qb = new QueryBuilder();
$qb->addTable('first', 'T1');
$qb->addTable('second', 'T2');
$qb->addTable('third', 'T3');
$qb->addLeftJoin('T2', 'fourth', 'T4', 'T2.foo=T4.foo');
$expectedSQL = '
SELECT FROM first AS T1, second AS T2 LEFT OUTER JOIN fourth AS T4
ON T2.foo = T4.foo, third AS T3 WHERE
';
list($actual_sql, $actual_opts) = $qb->getSQL();
$this->assertEquals($this->cleanWS($expectedSQL), $this->cleanWS($actual_sql));
$this->assertEquals(array(), $actual_opts);
}
public function test_table_alias_exception()
{
$this->expectException(StructException::class);
$qb = new QueryBuilder();
$qb->addTable('first', 'T1');
$qb->addTable('second', 'T1');
}
public function test_leftjoin_missing_alias_exception()
{
$this->expectException(StructException::class);
$qb = new QueryBuilder();
$qb->addTable('first', 'T1');
$qb->addLeftJoin('T2', 'third', 'T3', 'T2.bar = T3.bar');
}
public function test_leftjoin_existing_alias_exception()
{
$this->expectException(StructException::class);
$qb = new QueryBuilder();
$qb->addTable('first', 'T1');
$qb->addTable('second', 'T2');
$qb->addLeftJoin('T2', 'third', 'T1', 'T2.bar = T1.bar');
}
}