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