Nettrine, doctrine a table prefix listener

Na tohle by mohlo stačit použít vlastní naming strategy:

• https://www.doctrine-project.org/…trategy.html

Extendnout standardní a přetížit metodu classToTableName a tam udělat něco takového:

namespace My\Custom;

use Doctrine\ORM\Mapping\UnderscoreNamingStrategy;

class CustomNamingStrategy extends UnderscoreNamingStrategy
{
	function classToTableName($className) {
		return 'ns_' . parent::classToTableName($className);
	}
}

Následně zaregistrovat:

nettrine.orm:
	configuration:
		namingStrategy: My\Custom\NamingStrategy

Kde nettrine.orm je tato extension:

• Nettrine\ORM\DI\OrmExtension

Těch strategií je více:

• https://github.com/…Strategy.php
• https://github.com/…Strategy.php

Snad jsem to napsal správně :)

Editoval Gappa (30. 1. 8:09)

Kdysi kdesi jsem našel na internetu a použil:

<?php declare(strict_types = 1);

namespace App\Model;

use Doctrine\Common\EventSubscriber;
use Doctrine\ORM\Event\LoadClassMetadataEventArgs;
use Doctrine\ORM\Mapping\ClassMetadataInfo;

final class TablePrefixSubscriber implements EventSubscriber
{

	/** @var string */
	public $prefix = '';

	public function __construct(string $prefix)
	{
		$this->prefix = $prefix;
	}

	public function getSubscribedEvents(): array
	{
		return ['loadClassMetadata'];
	}

	public function loadClassMetadata(LoadClassMetadataEventArgs $args): void
	{
		$classMetadata = $args->getClassMetadata();

		if (strlen($this->prefix) > 0) {
			// Only add the prefixes to our own entities.
			//if (FALSE !== strpos($classMetadata->namespace, 'Some\Namespace\Part')) {
			// Do not re-apply the prefix when the table is already prefixed
			if (strpos($classMetadata->getTableName(), $this->prefix) === false) {
				$tableName = $this->prefix . $classMetadata->getTableName();
				$classMetadata->setPrimaryTable(['name' => $tableName]);
			}

			foreach ($classMetadata->getAssociationMappings() as $fieldName => $mapping) {
				if ($mapping['type'] === ClassMetadataInfo::MANY_TO_MANY && $mapping['isOwningSide'] === true) {
					$mappedTableName = $classMetadata->associationMappings[$fieldName]['joinTable']['name'];

					// Do not re-apply the prefix when the association is already prefixed
					if (strpos($mappedTableName, $this->prefix) !== false) {
						continue;
					}

					$classMetadata->associationMappings[$fieldName]['joinTable']['name'] = $this->prefix . $mappedTableName;
				}
			}
		}
	}

}

a registrace do DI:

services:
	subscriber1:
		create: App\Model\TablePrefixSubscriber('foo_')
		tags: [nettrine.subscriber]

Super, koukám, že to jde i jednoduššeji. Takže tohle taky funguje, jak má?

Pro mé použití ano (změna názvu tabulek, i joinovacích), zbytek musíš otestovat sám :)

Editoval Gappa (11. 3. 2021 20:51)