How create migration with exist data?

Hello,

I have a table order with such info id, name, email, order_id etc.

I want create new table user and transfer name, email data from order table

and create connection oneToMany (user -> order) and add new coluumn to order table user_id

I wrote migration script for a new table

class TestMigration implements Migration, RenameExtensionAwareInterface { /** * Modifies the given schema to apply necessary changes of a database * The given query bag can be used to apply additional SQL queries before and after schema changes * * @param Schema $schema * @param QueryBag $queries * @return void */ public function up(Schema $schema, QueryBag $queries) { $table = $schema->createTable('user'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('name', 'string', ['length' => 65]); $table->addColumn('email', 'string', ['notnull' => false, 'length' => 129]); $table->addColumn('createdAt', 'datetime'); $table->setPrimaryKey(['id']); } /** * Sets the RenameExtension * * @param RenameExtension $renameExtension */ public function setRenameExtension(RenameExtension $renameExtension) { // TODO: Implement setRenameExtension() method. } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

class TestMigration implements Migration, RenameExtensionAwareInterface {       /**      * Modifies the given schema to apply necessary changes of a database      * The given query bag can be used to apply additional SQL queries before and after schema changes      *      * @param Schema $schema      * @param QueryBag $queries      * @return void      */     public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->createTable('user');         $table->addColumn('id', 'integer', ['autoincrement' => true]);         $table->addColumn('name', 'string', ['length' => 65]);         $table->addColumn('email', 'string', ['notnull' => false, 'length' => 129]);         $table->addColumn('createdAt', 'datetime');         $table->setPrimaryKey(['id']);     }       /**      * Sets the RenameExtension      *      * @param RenameExtension $renameExtension      */     public function setRenameExtension(RenameExtension $renameExtension)     {         // TODO: Implement setRenameExtension() method.     } }

But I can’t find information how to correct get data fromn exits table and insert into new and in table order add FK(user_id).

I used this doc https://github.com/orocrm/platform/tree/master/src/Oro/Bundle/MigrationBundle

Thank you.

Topic

[andeskParticipant]

As you have access to the QueryBag in the up() method, you should be easily able to just add a Query to it.

I checked existing Migrations doing this in OroPlatform itself and found the Migration class Oro\Bundle\UserBundle\Migrations\Schema\v1_5\SetOwnerForEmailTemplates.php, maybe take a look how it is done there?

[Author]

Replies