Exemplos de dokuwiki\plugin\struct\test\mock QueryBuilder::addOrderBy em PHP

Exemplo n.º 1

Arquivo: QueryBuilderOther.test.php Projeto: cosmocode/dokuwiki-plugin-struct

    public function test_order_by()
    {
        $qb = new QueryBuilder();
        $qb->addTable('first', 'T1');
        $qb->addOrderBy('Q.foo');
        $expectedSQL = '
            SELECT FROM first AS T1 WHERE ORDER BY Q.foo
';
        list($actual_sql, $actual_opts) = $qb->getSQL();
        $this->assertEquals($this->cleanWS($expectedSQL), $this->cleanWS($actual_sql));
        $this->assertEquals(array(), $actual_opts);
    }