public function testPgslqMakeDeleteQuery()
{
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->delete('test1, test2')->where('foo=:foo')->getQuery('pgsql');
$this->assertEquals("DELETE FROM \"test1\" AS t1, \"test2\" AS t2\nWHERE foo=:foo", $query);
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->delete()->tables('test1, test2')->where('foo=:foo')->getQuery('pgsql');
$this->assertEquals("DELETE FROM \"test1\" AS t1, \"test2\" AS t2\nWHERE foo=:foo", $query);
}
public function testMysqlMakeDeleteQuery()
{
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->delete('test1, test2')->where('foo=:foo')->getQuery('mysql');
$this->assertEquals("DELETE FROM `test1`, `test2`\nWHERE foo=:foo", $query);
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->delete()->tables('test1, test2')->where('foo=:foo')->getQuery('mysql');
$this->assertEquals("DELETE FROM `test1`, `test2`\nWHERE foo=:foo", $query);
}
protected function _testDbElement($id, $lft, $rgt, $lvl, $prt)
{
$query = new \T4\Dbal\QueryBuilder();
$query->select('*')->from('comments')->where('__id=:id')->params([':id' => $id]);
$res = $this->getT4Connection()->query($query)->fetch();
$this->assertEquals($lft, $res['__lft']);
$this->assertEquals($rgt, $res['__rgt']);
$this->assertEquals($lvl, $res['__lvl']);
$this->assertEquals($prt, $res['__prt']);
}
public function testAssignDelete()
{
$builder = new \T4\Dbal\QueryBuilder();
$b = $builder->delete('test')->where('foo=:foo');
$this->assertInstanceOf('\\T4\\Dbal\\QueryBuilder', $b);
$this->assertEquals($b, $builder);
$this->assertEquals('delete', $builder->mode);
$this->assertEquals(['test'], $builder->deleteTables);
$this->assertEquals('foo=:foo', $builder->where);
$builder = new \T4\Dbal\QueryBuilder();
$b = $builder->delete('test1, test2')->where('foo=:foo AND bar<:bar')->order('id')->limit(10);
$this->assertInstanceOf('\\T4\\Dbal\\QueryBuilder', $b);
$this->assertEquals($b, $builder);
$this->assertEquals('delete', $builder->mode);
$this->assertEquals(['test1', 'test2'], $builder->deleteTables);
$this->assertEquals('foo=:foo AND bar<:bar', $builder->where);
$this->assertEquals('id', $builder->order);
$this->assertEquals(10, $builder->limit);
}
