public function testMysqlMakeInsertQuery()
{
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->insert()->table('test')->values(['foo' => ':foo', 'bar' => ':bar'])->getQuery('mysql');
$this->assertEquals("INSERT INTO `test`\n(`foo`, `bar`)\nVALUES (:foo, :bar)", $query);
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->insert('test')->values(['foo' => ':foo', 'bar' => ':bar'])->getQuery('mysql');
$this->assertEquals("INSERT INTO `test`\n(`foo`, `bar`)\nVALUES (:foo, :bar)", $query);
}
public function testPgslqMakeInsertQuery()
{
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->insert()->table('test')->values(['foo' => ':foo', 'bar' => ':bar'])->getQuery('pgsql');
$this->assertEquals("INSERT INTO \"test\"\n(\"foo\", \"bar\")\nVALUES (:foo, :bar)", $query);
$builder = new \T4\Dbal\QueryBuilder();
$query = $builder->insert('test')->values(['foo' => ':foo', 'bar' => ':bar'])->getQuery('pgsql');
$this->assertEquals("INSERT INTO \"test\"\n(\"foo\", \"bar\")\nVALUES (:foo, :bar)", $query);
}
public function testAssignInsert()
{
$builder = new \T4\Dbal\QueryBuilder();
$b = $builder->insert('test');
$this->assertInstanceOf('\\T4\\Dbal\\QueryBuilder', $b);
$this->assertEquals($b, $builder);
$this->assertEquals('insert', $builder->mode);
$this->assertEquals(['test'], $builder->insertTables);
$b = $builder->values(['foo' => ':foo', 'bar' => ':bar']);
$this->assertInstanceOf('\\T4\\Dbal\\QueryBuilder', $b);
$this->assertEquals($b, $builder);
$this->assertEquals(['foo' => ':foo', 'bar' => ':bar'], $builder->values);
}
