FuelPHP Forums

efx

Hey,

I have migrations, on one I did a default create a record on category and later in the last migration I added a field to category. The problem is that when I create a new app, the record can't work with the missed field (because model has it setup) without run the last migration.

So the question, is the default records creation is the right place in migration ? How I can solve this issue on my migration code ?

Harro

Not sure I understand what you mean.

Your entire database should be created by migrations, migrations should be incremental and reversable. So if you deploy your code and run all migrations, the database schema is at the version the code expects.

What do you mean with "create a new app", and why is that app not up to date with your migrations?

efx

ok.

in migration 01 : I create category

in migration 02 : I create default records in category :

$category= \Model_Category::forge(array('status'=>'published', 'name'=> 'Toutes les rubriques', 'slug'=>'all', 'exposition'=>'all', 'post_count'=>0, 'order_id'=>NULL, 'permission'=>'public' ));
$category->save();

In migration 03 : I add a visibility field to category (so I change my model).

All my app track this migration and run fine.

But if I create a new app of this, it would like an error at migration 02 because Model has an extra 'visibility' field ?

Harro

You are talking about a new application against an already created database?

Have you checked what happens?

My guess would be nothing, if there is no migration config file, but the database has a migration table, the config file will be synced with the database. The database status is leading.

Having said that, multiple applications with migrations on the same database is waiting for a disaster to happen, so if I were you, I'd select one app as the primary app for that database, and make sure all migrations for that database are made in that app.

efx

I just moved the records created in 02 to 03 after the field creation, and work. I guess its not good to put records creation in DB from migration.

Its just an error you can't create things in Database when you have tables change in migrations because the migration doesn't track Model changes.

Harro

I don't see why you can't do that, we create records all the time in migrations.

Indeed, using Models might be a challenge, we always use direct DB calls to avoid issues like that.

efx

// Indeed, using Models might be a challenge, we always use direct DB calls to avoid issues like that.

ah perfect, I will try out from DB call, thanks !

efx

How I use DB,

Using Model is :

$category= \Model_Category::forge(array('status'=>'published', 'name'=> 'Toutes les rubriques', 'slug'=>'all', 'exposition'=>'all', 'post_count'=>0, 'order_id'=>NULL, 'permission'=>'public' ));

Using DB :

$query = \DB::insert('categories', array('status'=>'published', 'name'=> 'Toutes les rubriques', 'slug'=>'all', 'exposition'=>'all', 'post_count'=>0, 'order_id'=>NULL, 'permission'=>'public' ) );

or :

$query = DB::insert('categories');

$query->set(array( 'status'=>'published', 'name'=> 'Toutes les rubriques', 'slug'=>'all', 'exposition'=>'all', 'post_count'=>0, 'order_id'=>NULL, 'permission'=>'public'));

it doesn't add record, need to execute it ?

efx

ok it just need execute :)

\DB::insert('categories')->set(array( 'status'=>'published', 'name'=> 'Toutes les rubriques', 'slug'=>'all', 'exposition'=>'all', 'post_count'=>0, 'order_id'=>NULL, 'permission'=>'public'))->execute();

thanks for your input Harro

Harro

;-)

You're welcome.

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion