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);
}
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 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);
}
