Refinery is an extension and a command line interface of Migrations Class for the Codeigniter framework. It uses the Describe library for retrieving the database tables and as the basis for code generation.
Install Refinery through Composer:
$ composer require rougin/refinery$ vendor/bin/refinery create create_users_table
"20180621090905_create_users_table.php" has been created.// application/migrations/20180621090905_create_users_table.php
defined('BASEPATH') OR exit('No direct script access allowed');
class Migration_create_users_table extends CI_Migration
{
public function up()
{
$this->dbforge->add_field('id');
$this->dbforge->create_table('users');
}
public function down()
{
$this->dbforge->drop_table('users');
}
}Use --from-database option to create a migration from an existing database table.
CREATE TABLE IF NOT EXISTS `user` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`age` int(2) NOT NULL,
`gender` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;$ vendor/bin/refinery create create_users_table --from-database
"20180621090905_create_users_table.php" has been created.// application/migrations/20180621090905_create_users_table.php
defined('BASEPATH') OR exit('No direct script access allowed');
class Migration_create_users_table extends CI_Migration
{
public function up()
{
$this->dbforge->add_column('users', array(
'gender' => array(
'type' => 'string',
'constraint' => 10,
'auto_increment' => FALSE,
'default' => '',
'null' => FALSE,
'unsigned' => FALSE
),
));
$this->dbforge->add_column('users', array(
'age' => array(
'type' => 'integer',
'constraint' => 2,
'auto_increment' => FALSE,
'default' => '',
'null' => FALSE,
'unsigned' => FALSE
),
));
$this->dbforge->add_column('users', array(
'name' => array(
'type' => 'string',
'constraint' => 200,
'auto_increment' => FALSE,
'default' => '',
'null' => FALSE,
'unsigned' => FALSE
),
));
$this->dbforge->add_column('users', array(
'id' => array(
'type' => 'integer',
'constraint' => 10,
'auto_increment' => TRUE,
'default' => '',
'null' => FALSE,
'unsigned' => FALSE
),
));
$this->dbforge->create_table('users');
}
public function down()
{
$this->dbforge->drop_table('users');
}
}$ vendor/bin/refinery create add_name_in_users_table
"20180621090953_add_name_in_users_table.php" has been created.// application/migrations/20180621090953_add_name_in_users_table.php
defined('BASEPATH') OR exit('No direct script access allowed');
class Migration_add_name_in_users_table extends CI_Migration
{
public function up()
{
$this->dbforge->add_column('users', array(
'name' => array(
'type' => 'VARCHAR',
'constraint' => 50,
'auto_increment' => FALSE,
'default' => '',
'null' => FALSE,
'unsigned' => FALSE
),
));
}
public function down()
{
$this->dbforge->drop_column('users', 'name');
}
}| Command | Description |
|---|---|
create |
creates new table (create_users_table) |
add |
adds new column for a specific table (add_username_in_users_table) |
delete |
deletes specified column from table (delete_created_at_in_users_table) |
modify |
updates the specified column from table (modify_name_in_users_table) |
$ vendor/bin/refinery migrate
Migrating: 20180621090905_create_users_table
Migrated: 20180621090905_create_users_table
Migrating: 20180621090953_add_name_in_users_table
Migrated: 20180621090953_add_name_in_users_table$ vendor/bin/refinery rollback
Rolling back: 20180621090953_add_name_in_users_table
Rolled back: 20180621090953_add_name_in_users_tableNOTE: You can also specify the version you want to rollback on using the --version option. (e.g: --version=20180621090905)
$ vendor/bin/refinery rollback 20180621090905
Rolling back: 20180621090905_create_users_table
Rolled back: 20180621090905_create_users_table$ vendor/bin/refinery reset
Rolling back: 20180621090953_add_name_in_users_table
Rolled back: 20180621090953_add_name_in_users_table
Rolling back: 20180621090905_create_users_table
Rolled back: 20180621090905_create_users_tablePlease see CHANGELOG for more information what has changed recently.
$ composer testThe MIT License (MIT). Please see LICENSE for more information.