[DDC-1206] Add option to SchemaTool for ignoring unsupported tables Created: 13/Jun/11  Updated: 05/Mar/12

Status: Open
Project: Doctrine 2 - ORM
Component/s: Tools
Affects Version/s: None
Fix Version/s: None
Security Level: All

Type: New Feature Priority: Minor
Reporter: Jani Hartikainen Assignee: Benjamin Eberlei
Resolution: Unresolved Votes: 1
Labels: None


 Description   

I suggest adding a new feature to SchemaTool, which allows you to ignore tables, which contain unsupported column types.

Use case:

  • You have a legacy database, or a database that is also shared with another application
  • You want to use SchemaTool to speed up development
  • The database contains tables which are not used in the Doctrine 2 application, and contain unsupported column types

I've encountered this already a few times myself - Basically if you try to use orm:schema-tool:update with a database that contains tables with unsupported column types, it'll throw an error and you won't be able to use it at all. Because schema tool is extermely convenient when developing, I think it would be very useful to have support for this feature.

Implementation:

I think this should be doable by just changing SchemaTool/SchemaManager so, that SchemaManager would contain an additional method (or flag) which works like createSchema, but ignores tables that cause an exception, and SchemaTool would include a flag for using this instead of the standard approach.

I'm looking into implementing this myself, and will submit a patch if this seems like a reasonable approach.



 Comments   
Comment by Jani Hartikainen [ 15/Jun/11 ]

Relevant patches (pull request made):

DBAL https://github.com/jhartikainen/dbal/tree/DDC-1206
ORM https://github.com/jhartikainen/doctrine2/tree/DDC-1206

Comment by Michael Graf [ 05/Mar/12 ]

has there been any progres on this feature? I have POINT in my DB and would rather ignore the table than create a custom type.

Generated at Sat Aug 30 02:23:36 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.