|
@@ 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 |