xref: /plugin/struct/_test/QueryBuilderTest.php (revision 8fed17f342cc190557a6ce94d1787f9e2f63cb6c)

<?php

namespace dokuwiki\plugin\struct\test;

use dokuwiki\plugin\struct\meta\StructException;
use dokuwiki\plugin\struct\test\mock\QueryBuilder;

/**
 * @group plugin_struct
 * @group plugins
 */
class QueryBuilderTest extends StructTest
{

    public function test_join()
    {
        $qb = new QueryBuilder();

        $qb->addTable('first');
        $qb->addTable('second');
        $qb->addTable('third');

        $qb->addLeftJoin('second', 'fourth', 'fourth', 'second.foo=fourth.foo');
        $this->assertEquals(['first', 'second', 'fourth', 'third'], array_keys($qb->from));
    }

    public function test_placeholders()
    {
        $qb = new QueryBuilder();


        $foo = $qb->addValue('foo');
        $bar = $qb->addValue('bar');

        $input = "this is $foo and $bar and $foo again";
        $expect = "this is ? and ? and ? again";
        $values = ['foo', 'bar', 'foo'];

        $output = $qb->fixPlaceholders($input);

        $this->assertEquals($expect, $output[0]);
        $this->assertEquals($values, $output[1]);
    }

    public function test_placeholderfail()
    {
        $this->expectException(StructException::class);
        $qb = new QueryBuilder();
        $qb->fixPlaceholders('this has unknown placeholder :!!val7!!:');
    }
}