QuotedIdentifierAssociationTest::testUpdateEntityWithIdentifierAssociationWithQuotedJoinColumn()

Complexity

Conditions	1
Paths	1

Size

Total Lines	27
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function testUpdateEntityWithIdentifierAssociationWithQuotedJoinColumn()
	{
		$user = new User();
		$user->name = 'John Doe';
		$this->_em->persist($user);
		$this->_em->flush();

		$userData = new UserData();
		$userData->name = '123456789';
		$userData->user = $user;
		$this->_em->persist($userData);
		$this->_em->flush();

		$userData->name = '4321';
		$this->_em->flush();

		$queries = $this->_sqlLoggerStack->queries;
		$platform = $this->_em->getConnection()->getDatabasePlatform();
		$quotedTableName = $platform->quoteIdentifier('quote-user-data');
		$quotedColumn = $platform->quoteIdentifier('name');
		$quotedIdentifier = $platform->quoteIdentifier('user-id');

		$this->assertNotEquals('quote-user-data', $quotedTableName);
		$this->assertNotEquals('name', $quotedColumn);
		$this->assertNotEquals('user-id', $quotedIdentifier);

		$this->assertSQLEquals(sprintf('UPDATE %s SET %s = ? WHERE %s = ?', $quotedTableName, $quotedColumn, $quotedIdentifier), $queries[$this->_sqlLoggerStack->currentQuery - 1]['sql']);
	}