Migrations by Mat'as Montes
An open source utility for Codeigniter inspired by Ruby on Rails.
The one thing Ruby on Rails has that Codeigniter does not have built in is database migrations. That function to keep track of database changes (versions) and migrate your database to what ever version you need. Migrate up or migrate down. With this library you can now do this.
Copy the files to these locations.
config/migrations.php -> application/config/
libraries/Migrations.php -> application/libraries/
controllers/migrate.php -> application/controllers/
The migration files included in this are just examples. You should install them where ever you
point your $config["migrations_path"]
to.
$this->config->load('migrations', true); //load the migrations.php config file
$this->load->library('migrations', $this->config->item('migrations')); //initialize the migrations library passing in the application config details
$this->migrations->set_verbose(TRUE); // echo statements or not
$this->migrations->version(id); // migrate the database to a particular version
$this->migrations->latest(); // migrate the database to the latest version
$this->migrations->install(); // install to the latest version.
The migrate.php controller just shows the use of these functions. If you are going to use it.
comment out the show_error()
in the construct, and put it back in place when you are done.
Migration files should be named vvv_a_migration.php where vvv is a 3 digit version number ie: 001_create_db.php
Each migration file should contain one class named Migration_a_migration (note that the class name is of the form 'Migration'.'migration file name'). ###ie: 001_create_db.php could look like;
<?php
class Migration_create_db extends Migration{
}
/* End of file 001_create_db.php */
/* Location: ./application/migrations/001_create_db.php */
if ( ! $this->migration->latest())
{
show_error($this->migration->error);
}
if ( ! $this->migration->version(5))
{
show_error($this->migration->error);
}