@@ -9,17 +9,17 @@ |
||
| 9 | 9 | class UserData |
| 10 | 10 | { |
| 11 | 11 | |
| 12 | - /** |
|
| 13 | - * @Id |
|
| 14 | - * @OneToOne(targetEntity="User") |
|
| 15 | - * @JoinColumn(name="`user-id`", referencedColumnName="`user-id`", onDelete="CASCADE") |
|
| 16 | - */ |
|
| 17 | - public $user; |
|
| 12 | + /** |
|
| 13 | + * @Id |
|
| 14 | + * @OneToOne(targetEntity="User") |
|
| 15 | + * @JoinColumn(name="`user-id`", referencedColumnName="`user-id`", onDelete="CASCADE") |
|
| 16 | + */ |
|
| 17 | + public $user; |
|
| 18 | 18 | |
| 19 | - /** |
|
| 20 | - * @Column(type="string", name="`name`") |
|
| 21 | - */ |
|
| 22 | - public $name; |
|
| 19 | + /** |
|
| 20 | + * @Column(type="string", name="`name`") |
|
| 21 | + */ |
|
| 22 | + public $name; |
|
| 23 | 23 | |
| 24 | 24 | |
| 25 | 25 | } |
@@ -11,39 +11,39 @@ |
||
| 11 | 11 | class QuotedIdentifierAssociationTest extends \Doctrine\Tests\OrmFunctionalTestCase |
| 12 | 12 | { |
| 13 | 13 | |
| 14 | - protected function setUp() |
|
| 15 | - { |
|
| 16 | - $this->useModelSet('quote'); |
|
| 17 | - parent::setUp(); |
|
| 18 | - } |
|
| 19 | - |
|
| 20 | - public function testUpdateEntityWithIdentifierAssociationWithQuotedJoinColumn() |
|
| 21 | - { |
|
| 22 | - $user = new User(); |
|
| 23 | - $user->name = 'John Doe'; |
|
| 24 | - $this->_em->persist($user); |
|
| 25 | - $this->_em->flush(); |
|
| 26 | - |
|
| 27 | - $userData = new UserData(); |
|
| 28 | - $userData->name = '123456789'; |
|
| 29 | - $userData->user = $user; |
|
| 30 | - $this->_em->persist($userData); |
|
| 31 | - $this->_em->flush(); |
|
| 32 | - |
|
| 33 | - $userData->name = '4321'; |
|
| 34 | - $this->_em->flush(); |
|
| 35 | - |
|
| 36 | - $queries = $this->_sqlLoggerStack->queries; |
|
| 37 | - $platform = $this->_em->getConnection()->getDatabasePlatform(); |
|
| 38 | - $quotedTableName = $platform->quoteIdentifier('quote-user-data'); |
|
| 39 | - $quotedColumn = $platform->quoteIdentifier('name'); |
|
| 40 | - $quotedIdentifier = $platform->quoteIdentifier('user-id'); |
|
| 41 | - |
|
| 42 | - $this->assertNotEquals('quote-user-data', $quotedTableName); |
|
| 43 | - $this->assertNotEquals('name', $quotedColumn); |
|
| 44 | - $this->assertNotEquals('user-id', $quotedIdentifier); |
|
| 45 | - |
|
| 46 | - $this->assertSQLEquals(sprintf('UPDATE %s SET %s = ? WHERE %s = ?', $quotedTableName, $quotedColumn, $quotedIdentifier), $queries[$this->_sqlLoggerStack->currentQuery - 1]['sql']); |
|
| 47 | - } |
|
| 14 | + protected function setUp() |
|
| 15 | + { |
|
| 16 | + $this->useModelSet('quote'); |
|
| 17 | + parent::setUp(); |
|
| 18 | + } |
|
| 19 | + |
|
| 20 | + public function testUpdateEntityWithIdentifierAssociationWithQuotedJoinColumn() |
|
| 21 | + { |
|
| 22 | + $user = new User(); |
|
| 23 | + $user->name = 'John Doe'; |
|
| 24 | + $this->_em->persist($user); |
|
| 25 | + $this->_em->flush(); |
|
| 26 | + |
|
| 27 | + $userData = new UserData(); |
|
| 28 | + $userData->name = '123456789'; |
|
| 29 | + $userData->user = $user; |
|
| 30 | + $this->_em->persist($userData); |
|
| 31 | + $this->_em->flush(); |
|
| 32 | + |
|
| 33 | + $userData->name = '4321'; |
|
| 34 | + $this->_em->flush(); |
|
| 35 | + |
|
| 36 | + $queries = $this->_sqlLoggerStack->queries; |
|
| 37 | + $platform = $this->_em->getConnection()->getDatabasePlatform(); |
|
| 38 | + $quotedTableName = $platform->quoteIdentifier('quote-user-data'); |
|
| 39 | + $quotedColumn = $platform->quoteIdentifier('name'); |
|
| 40 | + $quotedIdentifier = $platform->quoteIdentifier('user-id'); |
|
| 41 | + |
|
| 42 | + $this->assertNotEquals('quote-user-data', $quotedTableName); |
|
| 43 | + $this->assertNotEquals('name', $quotedColumn); |
|
| 44 | + $this->assertNotEquals('user-id', $quotedIdentifier); |
|
| 45 | + |
|
| 46 | + $this->assertSQLEquals(sprintf('UPDATE %s SET %s = ? WHERE %s = ?', $quotedTableName, $quotedColumn, $quotedIdentifier), $queries[$this->_sqlLoggerStack->currentQuery - 1]['sql']); |
|
| 47 | + } |
|
| 48 | 48 | |
| 49 | 49 | } |