@@ 428-435 (lines=8) @@ | ||
425 | self::assertSame($qb2, $qb); |
|
426 | } |
|
427 | ||
428 | public function testDelete() |
|
429 | { |
|
430 | $qb = new QueryBuilder($this->conn); |
|
431 | $qb->delete('users', 'u'); |
|
432 | ||
433 | self::assertEquals(QueryBuilder::DELETE, $qb->getType()); |
|
434 | self::assertEquals('DELETE FROM users u', (string) $qb); |
|
435 | } |
|
436 | ||
437 | public function testDeleteWithoutAlias() |
|
438 | { |
|
@@ 437-444 (lines=8) @@ | ||
434 | self::assertEquals('DELETE FROM users u', (string) $qb); |
|
435 | } |
|
436 | ||
437 | public function testDeleteWithoutAlias() |
|
438 | { |
|
439 | $qb = new QueryBuilder($this->conn); |
|
440 | $qb->delete('users'); |
|
441 | ||
442 | self::assertEquals(QueryBuilder::DELETE, $qb->getType()); |
|
443 | self::assertEquals('DELETE FROM users', (string) $qb); |
|
444 | } |
|
445 | ||
446 | public function testDeleteWhere() |
|
447 | { |
|
@@ 765-773 (lines=9) @@ | ||
762 | self::assertFalse($qb->getParameters() === $qb_clone->getParameters()); |
|
763 | } |
|
764 | ||
765 | public function testSimpleSelectWithoutTableAlias() |
|
766 | { |
|
767 | $qb = new QueryBuilder($this->conn); |
|
768 | ||
769 | $qb->select('id') |
|
770 | ->from('users'); |
|
771 | ||
772 | self::assertEquals('SELECT id FROM users', (string) $qb); |
|
773 | } |
|
774 | ||
775 | public function testSelectWithSimpleWhereWithoutTableAlias() |
|
776 | { |
|
@@ 814-822 (lines=9) @@ | ||
811 | self::assertEquals('SELECT u.id FROM users u INNER JOIN permissions p ON p.user_id = u.id, articles INNER JOIN comments c ON c.article_id = articles.id', $qb->getSQL()); |
|
812 | } |
|
813 | ||
814 | public function testSelectAllFromTableWithoutTableAlias() |
|
815 | { |
|
816 | $qb = new QueryBuilder($this->conn); |
|
817 | ||
818 | $qb->select('users.*') |
|
819 | ->from('users'); |
|
820 | ||
821 | self::assertEquals("SELECT users.* FROM users", (string) $qb); |
|
822 | } |
|
823 | ||
824 | public function testSelectAllWithoutTableAlias() |
|
825 | { |
|
@@ 824-832 (lines=9) @@ | ||
821 | self::assertEquals("SELECT users.* FROM users", (string) $qb); |
|
822 | } |
|
823 | ||
824 | public function testSelectAllWithoutTableAlias() |
|
825 | { |
|
826 | $qb = new QueryBuilder($this->conn); |
|
827 | ||
828 | $qb->select('*') |
|
829 | ->from('users'); |
|
830 | ||
831 | self::assertEquals("SELECT * FROM users", (string) $qb); |
|
832 | } |
|
833 | ||
834 | /** |
|
835 | * @group DBAL-959 |