Not possible to use a custom naming strategy (No column X on table Client_OAuth2)

[intellix]

I'm attempting to validate/drop/create my schema. With this module and a config like within: "apigility-oauth2-doctrine-skeleton" I'm getting the following error:

[Doctrine\DBAL\Schema\SchemaException]                             
  There is no column with name 'clientId' on table 'Client_OAuth2'. 

Can't quite work out what's causing it as the XML definitions look fine.

[intellix]

This all works perfectly in your example repository so must be something within my own and I shall debug further. Apologies for not checking before!

[intellix]

Ok, I've traced that this is caused by me using the UnderscoreNamingStrategy within my Db module.

[TomHAnderson]

Can you provide an example application and/or enough source direction to duplicate the error? Supporting different naming strategies probably falls within the scope of this module.

[intellix]

Basically, within my Module.php, I'm doing:

public function onBootstrap($e)
{
    $em = $e->getTarget()->getServiceManager()->get('doctrine.entitymanager.orm_default');
    $em->getConfiguration()->setNamingStrategy(new \Doctrine\ORM\Mapping\UnderscoreNamingStrategy(CASE_LOWER));
}

[TomHAnderson]

I can duplicate the problem. I didn't find an easy solution. I look forward to your solution.

[intellix]

Had a look into how it all works and traced it down to the <unique-constraint> within the Client entity definition: https://github.com/TomHAnderson/zf-oauth2-doctrine/blob/master/config/orm/ZF.OAuth2.Doctrine.Entity.Client.dcm.xml#L12

It seems like Doctrine doesn't currently support the ability to specify a property rather than column name. The quick fix I can see is copying the definitions provided and changing to an underscore. Not sure about long-term... Possible to dynamically provide a unique constraint?

[TomHAnderson]

I fixed this with a dynamic index modification to the metadata directly. I even named the index based on the column name.