123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273 |
- <?php
- declare(strict_types=1);
- namespace Doctrine\Common\DataFixtures\Purger;
- use Doctrine\Common\DataFixtures\Sorter\TopologicalSorter;
- use Doctrine\DBAL\Platforms\AbstractPlatform;
- use Doctrine\DBAL\Schema\Identifier;
- use Doctrine\ORM\EntityManagerInterface;
- use Doctrine\ORM\Mapping\ClassMetadata;
- use function array_reverse;
- use function array_search;
- use function assert;
- use function count;
- use function is_callable;
- use function method_exists;
- use function preg_match;
- /**
- * Class responsible for purging databases of data before reloading data fixtures.
- */
- class ORMPurger implements PurgerInterface, ORMPurgerInterface
- {
- public const PURGE_MODE_DELETE = 1;
- public const PURGE_MODE_TRUNCATE = 2;
- /** @var EntityManagerInterface|null */
- private $em;
- /**
- * If the purge should be done through DELETE or TRUNCATE statements
- *
- * @var int
- */
- private $purgeMode = self::PURGE_MODE_DELETE;
- /**
- * Table/view names to be excluded from purge
- *
- * @var string[]
- */
- private $excluded;
- /**
- * Construct new purger instance.
- *
- * @param EntityManagerInterface $em EntityManagerInterface instance used for persistence.
- * @param string[] $excluded array of table/view names to be excluded from purge
- */
- public function __construct(?EntityManagerInterface $em = null, array $excluded = [])
- {
- $this->em = $em;
- $this->excluded = $excluded;
- }
- /**
- * Set the purge mode
- *
- * @param int $mode
- *
- * @return void
- */
- public function setPurgeMode($mode)
- {
- $this->purgeMode = $mode;
- }
- /**
- * Get the purge mode
- *
- * @return int
- */
- public function getPurgeMode()
- {
- return $this->purgeMode;
- }
- /** @inheritDoc */
- public function setEntityManager(EntityManagerInterface $em)
- {
- $this->em = $em;
- }
- /**
- * Retrieve the EntityManagerInterface instance this purger instance is using.
- *
- * @return EntityManagerInterface
- */
- public function getObjectManager()
- {
- return $this->em;
- }
- /** @inheritDoc */
- public function purge()
- {
- $classes = [];
- foreach ($this->em->getMetadataFactory()->getAllMetadata() as $metadata) {
- if ($metadata->isMappedSuperclass || (isset($metadata->isEmbeddedClass) && $metadata->isEmbeddedClass)) {
- continue;
- }
- $classes[] = $metadata;
- }
- $commitOrder = $this->getCommitOrder($this->em, $classes);
- // Get platform parameters
- $platform = $this->em->getConnection()->getDatabasePlatform();
- // Drop association tables first
- $orderedTables = $this->getAssociationTables($commitOrder, $platform);
- // Drop tables in reverse commit order
- for ($i = count($commitOrder) - 1; $i >= 0; --$i) {
- $class = $commitOrder[$i];
- if (
- (isset($class->isEmbeddedClass) && $class->isEmbeddedClass) ||
- $class->isMappedSuperclass ||
- ($class->isInheritanceTypeSingleTable() && $class->name !== $class->rootEntityName)
- ) {
- continue;
- }
- $orderedTables[] = $this->getTableName($class, $platform);
- }
- $connection = $this->em->getConnection();
- $filterExpr = $connection->getConfiguration()->getFilterSchemaAssetsExpression();
- $emptyFilterExpression = empty($filterExpr);
- $schemaAssetsFilter = method_exists($connection->getConfiguration(), 'getSchemaAssetsFilter') ? $connection->getConfiguration()->getSchemaAssetsFilter() : null;
- foreach ($orderedTables as $tbl) {
- // If we have a filter expression, check it and skip if necessary
- if (! $emptyFilterExpression && ! preg_match($filterExpr, $tbl)) {
- continue;
- }
- // If the table is excluded, skip it as well
- if (array_search($tbl, $this->excluded) !== false) {
- continue;
- }
- // Support schema asset filters as presented in
- if (is_callable($schemaAssetsFilter) && ! $schemaAssetsFilter($tbl)) {
- continue;
- }
- if ($this->purgeMode === self::PURGE_MODE_DELETE) {
- $connection->executeUpdate($this->getDeleteFromTableSQL($tbl, $platform));
- } else {
- $connection->executeUpdate($platform->getTruncateTableSQL($tbl, true));
- }
- }
- }
- /**
- * @param ClassMetadata[] $classes
- *
- * @return ClassMetadata[]
- */
- private function getCommitOrder(EntityManagerInterface $em, array $classes)
- {
- $sorter = new TopologicalSorter();
- foreach ($classes as $class) {
- if (! $sorter->hasNode($class->name)) {
- $sorter->addNode($class->name, $class);
- }
- // $class before its parents
- foreach ($class->parentClasses as $parentClass) {
- $parentClass = $em->getClassMetadata($parentClass);
- $parentClassName = $parentClass->getName();
- if (! $sorter->hasNode($parentClassName)) {
- $sorter->addNode($parentClassName, $parentClass);
- }
- $sorter->addDependency($class->name, $parentClassName);
- }
- foreach ($class->associationMappings as $assoc) {
- if (! $assoc['isOwningSide']) {
- continue;
- }
- $targetClass = $em->getClassMetadata($assoc['targetEntity']);
- assert($targetClass instanceof ClassMetadata);
- $targetClassName = $targetClass->getName();
- if (! $sorter->hasNode($targetClassName)) {
- $sorter->addNode($targetClassName, $targetClass);
- }
- // add dependency ($targetClass before $class)
- $sorter->addDependency($targetClassName, $class->name);
- // parents of $targetClass before $class, too
- foreach ($targetClass->parentClasses as $parentClass) {
- $parentClass = $em->getClassMetadata($parentClass);
- $parentClassName = $parentClass->getName();
- if (! $sorter->hasNode($parentClassName)) {
- $sorter->addNode($parentClassName, $parentClass);
- }
- $sorter->addDependency($parentClassName, $class->name);
- }
- }
- }
- return array_reverse($sorter->sort());
- }
- /**
- * @param array $classes
- *
- * @return array
- */
- private function getAssociationTables(array $classes, AbstractPlatform $platform)
- {
- $associationTables = [];
- foreach ($classes as $class) {
- foreach ($class->associationMappings as $assoc) {
- if (! $assoc['isOwningSide'] || $assoc['type'] !== ClassMetadata::MANY_TO_MANY) {
- continue;
- }
- $associationTables[] = $this->getJoinTableName($assoc, $class, $platform);
- }
- }
- return $associationTables;
- }
- private function getTableName(ClassMetadata $class, AbstractPlatform $platform): string
- {
- if (isset($class->table['schema']) && ! method_exists($class, 'getSchemaName')) {
- return $class->table['schema'] . '.' . $this->em->getConfiguration()->getQuoteStrategy()->getTableName($class, $platform);
- }
- return $this->em->getConfiguration()->getQuoteStrategy()->getTableName($class, $platform);
- }
- /**
- * @param mixed[] $assoc
- */
- private function getJoinTableName(
- array $assoc,
- ClassMetadata $class,
- AbstractPlatform $platform
- ): string {
- if (isset($assoc['joinTable']['schema']) && ! method_exists($class, 'getSchemaName')) {
- return $assoc['joinTable']['schema'] . '.' . $this->em->getConfiguration()->getQuoteStrategy()->getJoinTableName($assoc, $class, $platform);
- }
- return $this->em->getConfiguration()->getQuoteStrategy()->getJoinTableName($assoc, $class, $platform);
- }
- private function getDeleteFromTableSQL(string $tableName, AbstractPlatform $platform): string
- {
- $tableIdentifier = new Identifier($tableName);
- return 'DELETE FROM ' . $tableIdentifier->getQuotedName($platform);
- }
- }
|