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-and-doctrine-migrations

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.


Reply via email to