Skip to content

Latest commit

 

History

History
139 lines (98 loc) · 3.1 KB

README.markdown

File metadata and controls

139 lines (98 loc) · 3.1 KB
Raw

Kohana Flexible Migrations

Kohana Flexible migrations is a Rails inspired migration module for kohana.

It's based on kohana-migrations module by Matías Montes and Jamie Madill.

Some features:

  • Kohana 3.2 compatibility
  • Solves the problem with migrations numbers using a timestamp instead of a integer
  • Migration generation with one click
  • Supports migrations and rollbacks
  • Due the naming convention for files, you can work on teams without concerns!
  • Nice web interface

Installation

  1. Download module, and copy the folder to your modules directory. (e.g. modules/flexiblemigrations)

  2. Enable flexiblemigrations and orm modules in bootstrap.php

'flexiblemigrations' => MODPATH.'flexiblemigrations'
               'orm' => MODPATH.'orm'

  1. Run the migrations.sql script on your DB server

  2. Create and grant WRITE privileges to /application/migrations folder

Usage

Enter url: yoursite/migrations and that's it! you will see a nice web interface with a menu.

  1. Click on 'Generate NEW migration' you can set a name and create a new migration file.

E.g. for a migration called 'typical migration' the generated file could be:

20120526170715_typical_migration.php
  1. Edit your file and add the DB functions

A typical migration file looks like:

<?
class typical_migration extends Migration
{
  public function up()
  {
    $this->create_table
    (
      'table_name',
      array
      (
        'published'             => array('boolean'),
        'published_at'          => array('datetime'),
        'user_id'               => array('integer'),
        'image_file_name'       => array('string[255]'),
        'full_description'      => array('text'),
      )
    );

    $this->add_column('another_table_name', 'column_name', array('datetime', 'default' => NULL));
  }

  public function down()
  {
    $this->drop_table('table_name');
    $this->remove_column('another_table_name', 'column_name');
  }
}
?>
  1. When you finish editing, simply click on 'Run all pending migrations'. If you made a mistake, click on 'Rollback'

Enjoy!

Migration functions

All possible functions are:

create_table($table_name, $fields, $primary_key = TRUE)
drop_table($table_name)
rename_table($old_name, $new_name)

add_column($table_name, $column_name, $params)
rename_column($table_name, $column_name, $new_column_name)
change_column($table_name, $column_name, $params)
remove_column($table_name, $column_name)

add_index($table_name, $index_name, $columns, $index_type = 'normal')
remove_index($table_name, $index_name)

Possible DB columns datatypes are: *

text
string[NumberOfCharacters]
decimal
integer
datetime
date
boolean
float
timestamp
time
binary

In all cases you can pass the default value (see file example above)

Legacy versions

For Kohana < 3.2 versions please download 'kohana-legacy' branch instead of 'master'.

To do

  • Improve web interface
  • Code refactor
  • More code comments
  • Console support
  • Support several DB engines (Postgre, Oracle, etc)
  • Bug fixing
  • Improve documentation

Contact

To get some help or give suggestions please contact the author.