doctrine /
dbal
| @@ 500-510 (lines=11) @@ | ||
| 497 | self::assertEquals('INSERT INTO users (bar, foo) VALUES(?, ?)', (string) $qb); |
|
| 498 | } |
|
| 499 | ||
| 500 | public function testInsertSetValue() |
|
| 501 | { |
|
| 502 | $qb = new QueryBuilder($this->conn); |
|
| 503 | $qb->insert('users') |
|
| 504 | ->setValue('foo', 'bar') |
|
| 505 | ->setValue('bar', '?') |
|
| 506 | ->setValue('foo', '?'); |
|
| 507 | ||
| 508 | self::assertEquals(QueryBuilder::INSERT, $qb->getType()); |
|
| 509 | self::assertEquals('INSERT INTO users (foo, bar) VALUES(?, ?)', (string) $qb); |
|
| 510 | } |
|
| 511 | ||
| 512 | public function testInsertValuesSetValue() |
|
| 513 | { |
|
| @@ 512-525 (lines=14) @@ | ||
| 509 | self::assertEquals('INSERT INTO users (foo, bar) VALUES(?, ?)', (string) $qb); |
|
| 510 | } |
|
| 511 | ||
| 512 | public function testInsertValuesSetValue() |
|
| 513 | { |
|
| 514 | $qb = new QueryBuilder($this->conn); |
|
| 515 | $qb->insert('users') |
|
| 516 | ->values( |
|
| 517 | array( |
|
| 518 | 'foo' => '?' |
|
| 519 | ) |
|
| 520 | ) |
|
| 521 | ->setValue('bar', '?'); |
|
| 522 | ||
| 523 | self::assertEquals(QueryBuilder::INSERT, $qb->getType()); |
|
| 524 | self::assertEquals('INSERT INTO users (foo, bar) VALUES(?, ?)', (string) $qb); |
|
| 525 | } |
|
| 526 | ||
| 527 | public function testEmptyInsert() |
|
| 528 | { |
|
