doctrine / dbal

        self::assertEquals('SELECT u.*, p.* FROM users u ORDER BY u.name ASC, u.username DESC', (string) $qb);

    }

    public function testEmptySelect()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb2 = $qb->select();

        self::assertSame($qb, $qb2);

        self::assertEquals(QueryBuilder::SELECT, $qb->getType());

    }

    public function testSelectAddSelect()

    {

        self::assertEquals('SELECT u.*, p.* FROM users u', (string) $qb);

    }

    public function testEmptyAddSelect()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb2 = $qb->addSelect();

        self::assertSame($qb, $qb2);

        self::assertEquals(QueryBuilder::SELECT, $qb->getType());

    }

    public function testSelectMultipleFrom()

    {

        self::assertEquals('UPDATE users u SET u.foo = ? WHERE u.foo = ?', (string) $qb);

    }

    public function testEmptyUpdate()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb2 = $qb->update();

        self::assertEquals(QueryBuilder::UPDATE, $qb->getType());

        self::assertSame($qb2, $qb);

    }

    public function testDelete()

    {

        self::assertEquals('DELETE FROM users u WHERE u.foo = ?', (string) $qb);

    }

    public function testEmptyDelete()

    {

        $qb   = new QueryBuilder($this->conn);

        $qb2 = $qb->delete();

        self::assertEquals(QueryBuilder::DELETE, $qb->getType());

        self::assertSame($qb2, $qb);

    }

    public function testInsertValues()

    {

        self::assertEquals('INSERT INTO users (foo, bar) VALUES(?, ?)', (string) $qb);

    }

    public function testEmptyInsert()

    {

        $qb = new QueryBuilder($this->conn);

        $qb2 = $qb->insert();

        self::assertEquals(QueryBuilder::INSERT, $qb->getType());

        self::assertSame($qb2, $qb);

    }

    public function testGetConnection()

    {