Codeigniter-Migrations

Contributors

Based On

Migrations by Mat'as Montes

About

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.

Install

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.

Usage

$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

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 */

Examples

Make sure our database is up-to-date

if ( ! $this->migration->latest())
{
	show_error($this->migration->error);
}

Update (or come back to) migration 5

if ( ! $this->migration->version(5))
{
	show_error($this->migration->error);
}

jmannau/codeigniter-migrations

ErrorLooks like something went wrong!

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Error
Looks like something went wrong!

Packages