Hi, > But there doesn't seem to be any code in propel to allow you to add/ > remove columns from an existing database. > It doesn't have any kind of helpers to let you modify an existing > database schema at all. > > So because of that, you wouldn't be able to do migrations in a > database independent way.
Right. Thats one of the main reasons the plugin doesn't do that. :) And it would be even harder to support YAML schema files, as they are first translated to propel XML files by symfony. Practically no chance of getting it to generate single ADD COLUMN statements or the like. I wrote the plugin to scratch some very specific itch. I don't use YAML schema files at all currently. Instead I have the whole database modeled in DBDesigner 4. After changing something I use dbd2propel.xsl to convert the DBDesigner file to propel XML and then regenerate the model (and SQL DDL). Then I practically just make a diff between the new and the previous lib.model.schema.sql file and copy'n'paste the differences to a new migration. So I actually have to write very little SQL by hand. Martin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-devs?hl=en -~----------~----~----~----~------~----~------~--~---
