Download the PHP package rougin/refinery without Composer

Refinery

Refinery is a console-based package of Migrations Class for the Codeigniter 3. It uses the Describe package for retrieving the database tables for creating database migrations.

Installation

From an existing Codeigniter 3 project, the Refinery package can be installed through Composer:

Then configure the project's database connectivity settings:

[!NOTE] Although using database connection is not required in using Refinery, this is only applicable when creating migration files based on an existing database. Please see Creating from database below for its usage.

Basic Usage

Creating migration files

To create a new database migration, kindly run the create command:

[!NOTE]

• The Migration class under Refinery is directly extended on CI_Migration.
• The created file will be in migrations directory under application. If it does not exists, Refinery will automatically create the specified directory.

When creating database migrations, Refinery will try to guess the expected output of up and down methods of a migration file based on its name (e.g., add_name_in_users_table):

Please see the accepted keywords below when creating database migration files:

Running the migrations

Kindly use the migrate command to use the files for database migrations:

When running this command, the target timestamp (--target) will always be the latest file in the migrations directory if not specified (e.g., add_name_in_users_table). Use the --target option to migrate to a specific version:

To rollback a database, kindly use the rollback command:

[!NOTE] Without a --target option, the rollback will only revert to its previous version (e.g., create_users_table).

To reset back the database schema to version 0, the reset command can be used:

Creating from database

Refinery also allows to create a database migration based on the existing database table. Prior in creating its database migration, kindly ensure that the specified table already exists in the database schema:

After checking the database table exists, run the same create command with the --from-database option:

[!NOTE] The --from-database option only exists when creating files under the create_*_table prefix.

Creating sequential migrations

By default, Refinery uses a timestamp prefix as its numbering style when creating migration files. To change it to a sequential numbering, kindly update the value of migration_type in the config/migration.php to sequential:

Then run the create command to generate a migration file in sequential migration:

Alternatively, the --sequential option can also be added in the create command to update the said configuration:

[!NOTE] When using the --sequential option, the migration_type in the config/migration.php is also set as sequential.

Using refinery.yml

Refinery currently works out of the box after the configuration based on Installation. However, using a refinery.yml can be used for complex setups like specifying the new application path:

To create a refinery.yml, simply run the initialize command:

[!NOTE] %%CURRENT_DIRECTORY%% is a placeholder variable which is the current directory of refinery.yml.

app_path

This property specifies the application directory. It may updated to any directory (e.g., ciacme/application, ciacme/config, etc.) as long it can detect the config/config.php file from the defined directory:

[!NOTE] Refinery will try to check the path specified in app_path if it is a valid Codeigniter 3 project. Then it will perform another check if the application directory exists or if the config directory can be accessed directly from the directory defined in app_path.

Changelog

Please see CHANGELOG for more information what has changed recently.

Testing

Credits

• All contributors

License

The MIT License (MIT). Please see LICENSE for more information.