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