Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php declare(strict_types=1); namespace Doctrine\Tests\ORM\Functional\ValueConversionTy..
Decoded Output download
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\ValueConversionType;
use Doctrine\Tests\Models\ValueConversionType as Entity;
use Doctrine\Tests\Models\ValueConversionType\AuxiliaryEntity;
use Doctrine\Tests\Models\ValueConversionType\InversedOneToManyCompositeIdForeignKeyEntity;
use Doctrine\Tests\Models\ValueConversionType\OwningManyToOneCompositeIdForeignKeyEntity;
use Doctrine\Tests\OrmFunctionalTestCase;
use PHPUnit\Framework\Attributes\Depends;
use PHPUnit\Framework\Attributes\Group;
/**
* The entities all use a custom type that converst the value as identifier(s).
* {@see \Doctrine\Tests\DbalTypes\Rot13Type}
*
* Test that OneToMany associations with composite id of which one is a
* association itself work correctly.
*/
#[Group('DDC-3380')]
class OneToManyCompositeIdForeignKeyTest extends OrmFunctionalTestCase
{
protected function setUp(): void
{
$this->useModelSet('vct_onetomany_compositeid_foreignkey');
parent::setUp();
$auxiliary = new Entity\AuxiliaryEntity();
$auxiliary->id4 = 'abc';
$inversed = new Entity\InversedOneToManyCompositeIdForeignKeyEntity();
$inversed->id1 = 'def';
$inversed->foreignEntity = $auxiliary;
$inversed->someProperty = 'some value to be loaded';
$owning = new Entity\OwningManyToOneCompositeIdForeignKeyEntity();
$owning->id2 = 'ghi';
$inversed->associatedEntities->add($owning);
$owning->associatedEntity = $inversed;
$this->_em->persist($auxiliary);
$this->_em->persist($inversed);
$this->_em->persist($owning);
$this->_em->flush();
$this->_em->clear();
}
public static function tearDownAfterClass(): void
{
$conn = static::$sharedConn;
$conn->executeStatement('DROP TABLE vct_owning_manytoone_compositeid_foreignkey');
$conn->executeStatement('DROP TABLE vct_inversed_onetomany_compositeid_foreignkey');
$conn->executeStatement('DROP TABLE vct_auxiliary');
}
public function testThatTheValueOfIdentifiersAreConvertedInTheDatabase(): void
{
$conn = $this->_em->getConnection();
self::assertEquals('nop', $conn->fetchOne('SELECT id4 FROM vct_auxiliary LIMIT 1'));
self::assertEquals('qrs', $conn->fetchOne('SELECT id1 FROM vct_inversed_onetomany_compositeid_foreignkey LIMIT 1'));
self::assertEquals('nop', $conn->fetchOne('SELECT foreign_id FROM vct_inversed_onetomany_compositeid_foreignkey LIMIT 1'));
self::assertEquals('tuv', $conn->fetchOne('SELECT id2 FROM vct_owning_manytoone_compositeid_foreignkey LIMIT 1'));
self::assertEquals('qrs', $conn->fetchOne('SELECT associated_id FROM vct_owning_manytoone_compositeid_foreignkey LIMIT 1'));
self::assertEquals('nop', $conn->fetchOne('SELECT associated_foreign_id FROM vct_owning_manytoone_compositeid_foreignkey LIMIT 1'));
}
#[Depends('testThatTheValueOfIdentifiersAreConvertedInTheDatabase')]
public function testThatEntitiesAreFetchedFromTheDatabase(): void
{
$auxiliary = $this->_em->find(
AuxiliaryEntity::class,
'abc',
);
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => 'abc'],
);
$owning = $this->_em->find(
OwningManyToOneCompositeIdForeignKeyEntity::class,
'ghi',
);
self::assertInstanceOf(AuxiliaryEntity::class, $auxiliary);
self::assertInstanceOf(InversedOneToManyCompositeIdForeignKeyEntity::class, $inversed);
self::assertInstanceOf(OwningManyToOneCompositeIdForeignKeyEntity::class, $owning);
}
#[Depends('testThatEntitiesAreFetchedFromTheDatabase')]
public function testThatTheValueOfIdentifiersAreConvertedBackAfterBeingFetchedFromTheDatabase(): void
{
$auxiliary = $this->_em->find(
AuxiliaryEntity::class,
'abc',
);
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => 'abc'],
);
$owning = $this->_em->find(
OwningManyToOneCompositeIdForeignKeyEntity::class,
'ghi',
);
self::assertEquals('abc', $auxiliary->id4);
self::assertEquals('def', $inversed->id1);
self::assertEquals('abc', $inversed->foreignEntity->id4);
self::assertEquals('ghi', $owning->id2);
}
#[Depends('testThatTheValueOfIdentifiersAreConvertedBackAfterBeingFetchedFromTheDatabase')]
public function testThatInversedEntityIsFetchedFromTheDatabaseUsingAuxiliaryEntityAsId(): void
{
$auxiliary = $this->_em->find(
AuxiliaryEntity::class,
'abc',
);
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => $auxiliary],
);
self::assertInstanceOf(InversedOneToManyCompositeIdForeignKeyEntity::class, $inversed);
}
#[Depends('testThatEntitiesAreFetchedFromTheDatabase')]
public function testThatTheProxyFromOwningToInversedIsLoaded(): void
{
$owning = $this->_em->find(
OwningManyToOneCompositeIdForeignKeyEntity::class,
'ghi',
);
$inversedProxy = $owning->associatedEntity;
self::assertSame('def', $inversedProxy->id1, 'Proxy identifier is converted');
self::assertEquals('some value to be loaded', $inversedProxy->someProperty);
}
#[Depends('testThatEntitiesAreFetchedFromTheDatabase')]
public function testThatTheCollectionFromInversedToOwningIsLoaded(): void
{
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => 'abc'],
);
self::assertCount(1, $inversed->associatedEntities);
}
}
?>
Did this file decode correctly?
Original Code
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\ValueConversionType;
use Doctrine\Tests\Models\ValueConversionType as Entity;
use Doctrine\Tests\Models\ValueConversionType\AuxiliaryEntity;
use Doctrine\Tests\Models\ValueConversionType\InversedOneToManyCompositeIdForeignKeyEntity;
use Doctrine\Tests\Models\ValueConversionType\OwningManyToOneCompositeIdForeignKeyEntity;
use Doctrine\Tests\OrmFunctionalTestCase;
use PHPUnit\Framework\Attributes\Depends;
use PHPUnit\Framework\Attributes\Group;
/**
* The entities all use a custom type that converst the value as identifier(s).
* {@see \Doctrine\Tests\DbalTypes\Rot13Type}
*
* Test that OneToMany associations with composite id of which one is a
* association itself work correctly.
*/
#[Group('DDC-3380')]
class OneToManyCompositeIdForeignKeyTest extends OrmFunctionalTestCase
{
protected function setUp(): void
{
$this->useModelSet('vct_onetomany_compositeid_foreignkey');
parent::setUp();
$auxiliary = new Entity\AuxiliaryEntity();
$auxiliary->id4 = 'abc';
$inversed = new Entity\InversedOneToManyCompositeIdForeignKeyEntity();
$inversed->id1 = 'def';
$inversed->foreignEntity = $auxiliary;
$inversed->someProperty = 'some value to be loaded';
$owning = new Entity\OwningManyToOneCompositeIdForeignKeyEntity();
$owning->id2 = 'ghi';
$inversed->associatedEntities->add($owning);
$owning->associatedEntity = $inversed;
$this->_em->persist($auxiliary);
$this->_em->persist($inversed);
$this->_em->persist($owning);
$this->_em->flush();
$this->_em->clear();
}
public static function tearDownAfterClass(): void
{
$conn = static::$sharedConn;
$conn->executeStatement('DROP TABLE vct_owning_manytoone_compositeid_foreignkey');
$conn->executeStatement('DROP TABLE vct_inversed_onetomany_compositeid_foreignkey');
$conn->executeStatement('DROP TABLE vct_auxiliary');
}
public function testThatTheValueOfIdentifiersAreConvertedInTheDatabase(): void
{
$conn = $this->_em->getConnection();
self::assertEquals('nop', $conn->fetchOne('SELECT id4 FROM vct_auxiliary LIMIT 1'));
self::assertEquals('qrs', $conn->fetchOne('SELECT id1 FROM vct_inversed_onetomany_compositeid_foreignkey LIMIT 1'));
self::assertEquals('nop', $conn->fetchOne('SELECT foreign_id FROM vct_inversed_onetomany_compositeid_foreignkey LIMIT 1'));
self::assertEquals('tuv', $conn->fetchOne('SELECT id2 FROM vct_owning_manytoone_compositeid_foreignkey LIMIT 1'));
self::assertEquals('qrs', $conn->fetchOne('SELECT associated_id FROM vct_owning_manytoone_compositeid_foreignkey LIMIT 1'));
self::assertEquals('nop', $conn->fetchOne('SELECT associated_foreign_id FROM vct_owning_manytoone_compositeid_foreignkey LIMIT 1'));
}
#[Depends('testThatTheValueOfIdentifiersAreConvertedInTheDatabase')]
public function testThatEntitiesAreFetchedFromTheDatabase(): void
{
$auxiliary = $this->_em->find(
AuxiliaryEntity::class,
'abc',
);
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => 'abc'],
);
$owning = $this->_em->find(
OwningManyToOneCompositeIdForeignKeyEntity::class,
'ghi',
);
self::assertInstanceOf(AuxiliaryEntity::class, $auxiliary);
self::assertInstanceOf(InversedOneToManyCompositeIdForeignKeyEntity::class, $inversed);
self::assertInstanceOf(OwningManyToOneCompositeIdForeignKeyEntity::class, $owning);
}
#[Depends('testThatEntitiesAreFetchedFromTheDatabase')]
public function testThatTheValueOfIdentifiersAreConvertedBackAfterBeingFetchedFromTheDatabase(): void
{
$auxiliary = $this->_em->find(
AuxiliaryEntity::class,
'abc',
);
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => 'abc'],
);
$owning = $this->_em->find(
OwningManyToOneCompositeIdForeignKeyEntity::class,
'ghi',
);
self::assertEquals('abc', $auxiliary->id4);
self::assertEquals('def', $inversed->id1);
self::assertEquals('abc', $inversed->foreignEntity->id4);
self::assertEquals('ghi', $owning->id2);
}
#[Depends('testThatTheValueOfIdentifiersAreConvertedBackAfterBeingFetchedFromTheDatabase')]
public function testThatInversedEntityIsFetchedFromTheDatabaseUsingAuxiliaryEntityAsId(): void
{
$auxiliary = $this->_em->find(
AuxiliaryEntity::class,
'abc',
);
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => $auxiliary],
);
self::assertInstanceOf(InversedOneToManyCompositeIdForeignKeyEntity::class, $inversed);
}
#[Depends('testThatEntitiesAreFetchedFromTheDatabase')]
public function testThatTheProxyFromOwningToInversedIsLoaded(): void
{
$owning = $this->_em->find(
OwningManyToOneCompositeIdForeignKeyEntity::class,
'ghi',
);
$inversedProxy = $owning->associatedEntity;
self::assertSame('def', $inversedProxy->id1, 'Proxy identifier is converted');
self::assertEquals('some value to be loaded', $inversedProxy->someProperty);
}
#[Depends('testThatEntitiesAreFetchedFromTheDatabase')]
public function testThatTheCollectionFromInversedToOwningIsLoaded(): void
{
$inversed = $this->_em->find(
InversedOneToManyCompositeIdForeignKeyEntity::class,
['id1' => 'def', 'foreignEntity' => 'abc'],
);
self::assertCount(1, $inversed->associatedEntities);
}
}
Function Calls
None |
Stats
MD5 | 27345f67177dee460dd613699fea12d5 |
Eval Count | 0 |
Decode Time | 94 ms |