Thanks, but updating the structure is not the issue (the tools work pretty well for that).
The problem is migrating the data. The model for the "Document" table has changed in this example, thus the old columns are not in the model any more (and new columns are in the model that are not in the old table structure). Dave -- On Dec 26, 2:54 am, Alexandre Salomé <[email protected]> wrote: > Migration in Doctrine offers you some "tools methods" : add column, create > table, delete table, delete column, create FK... methods to alter the > structure (see > documentation<http://www.doctrine-project.org/documentation/manual/1_2/en/migrations>). > Model-stuff is still available. > > See this sample > :http://www.doctrine-project.org/documentation/cookbook/1_0/en/symfony... > > Good luck, Alexandre > > 2009/12/24 Dave <[email protected]> > > > > > I am trying to determine the "proper" way to update data when using > > doctrine migrations. > > > Having a legacy table similar to > > > Document -> id (PK), state (string, nn), state_code (string, nn), > > title (string, nn) > > > and changing it to be two tables similar to > > > State -> id (PK), state (string, nn), state_code (string, nn), slug > > (string, nn, based on state_code) > > Document -> id (PK), state_id (FK), title (string, nn), slug > > (string, nn, based on FK's state_code and title) > > > Adding the tables and adjusting the columns works fine, but so far it > > looks like I have to use Doctrine_Manager::connection()->getDbh() and > > perform the data changes via PDO since the models have changed enough > > that they cannot be used with the existing table. > > > Is there a more proper way to do the changes using Doctrine, or is > > bypassing Doctrine using PDO the best way (especially since there are > > many rows in the Document table). > > > -- > > > You received this message because you are subscribed to the Google Groups > > "symfony users" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<symfony-users%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/symfony-users?hl=en. > > -- > Alexandre Saloméhttp://alexandre-salome.fr -- You received this message because you are subscribed to the Google Groups "symfony users" 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-users?hl=en.
