StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Having just figured this out myself, I'd like to shed some light on exactly how to accomplish this. </p> <p><strong>Symfony 2 & Doctrine 2.1</strong> <br> <sub>Note: I use YML for config, so that's what I'll be showing.</sub><br><br></p> <h1>Instructions</h1> <ol> <li><p>Open up your bundle's <em>Resources/config/services.yml</em></p></li> <li><p>Define a table prefix parameter: <br> <sub>Be sure to change <em>mybundle</em> and <em>myprefix_</em></sub></p> <pre><code>parameters: mybundle.db.table_prefix: myprefix_ </code></pre></li> <li><p>Add a new service:</p> <pre><code>services: mybundle.tblprefix_subscriber: class: MyBundle\Subscriber\TablePrefixSubscriber arguments: [%mybundle.db.table_prefix%] tags: - { name: doctrine.event_subscriber } </code></pre></li> <li><p>Create <em>MyBundle\Subscriber\TablePrefixSubscriber.php</em></p> <pre><code><?php namespace MyBundle\Subscriber; use Doctrine\ORM\Event\LoadClassMetadataEventArgs; class TablePrefixSubscriber implements \Doctrine\Common\EventSubscriber { protected $prefix = ''; public function __construct($prefix) { $this->prefix = (string) $prefix; } public function getSubscribedEvents() { return array('loadClassMetadata'); } public function loadClassMetadata(LoadClassMetadataEventArgs $args) { $classMetadata = $args->getClassMetadata(); if ($classMetadata->isInheritanceTypeSingleTable() && !$classMetadata->isRootEntity()) { // if we are in an inheritance hierarchy, only apply this once return; } $classMetadata->setTableName($this->prefix . $classMetadata->getTableName()); foreach ($classMetadata->getAssociationMappings() as $fieldName => $mapping) { if ($mapping['type'] == \Doctrine\ORM\Mapping\ClassMetadataInfo::MANY_TO_MANY && array_key_exists('name', $classMetadata->associationMappings[$fieldName]['joinTable']) ) { // Check if "joinTable" exists, it can be null if this field is the reverse side of a ManyToMany relationship $mappedTableName = $classMetadata->associationMappings[$fieldName]['joinTable']['name']; $classMetadata->associationMappings[$fieldName]['joinTable']['name'] = $this->prefix . $mappedTableName; } } } } </code></pre></li> <li><p>Optional step for postgres users: <a href="https://stackoverflow.com/questions/19380177/doctrine-how-to-prefix-sequence-names">do something similary for sequences</a></p></li> <li>Enjoy</li> </ol>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload