djordje/li3_migrations

Database migrations for Lithium PHP framework

dev-master 2018-04-30 07:53 UTC

Requires

• php: >=5.3
• composer/installers: dev-master
• unionofrad/li3_fixtures: dev-master

BSD-3-Clause

• Djordje Kovacevic

• php
• db
• mysql
• lithium
• li3
• migrate

README

Dependencies

li3_fixtures - Installation instructions

lithium from master branch (after v0.11) with integrated li3_sqltools

Usage

create migration

Create new migration file with li3 create migration command:

li3 create migration Users
//app/resources/migration/20130506002905_Users.php

	namespace app\resources\migration;

	class Users extends \li3_migrations\models\Migration {

		protected $_fields = [];

		protected $_records = [];
    
		protected $_meta = [];

		protected $_source = 'users';

		public function up() {}

		public function down() {}

	}

Each field can have a type, length, if default or nullable

	protected $_fields = [
		'id' => ['type' => 'id'],
		'name' => ['type' => 'string', 'default' => 'foo', 'length' => 128, 'null' => false],
		'bar_id' => ['type' => 'integer']    
	];
  

Meta can be used to set constraints, table engine, charset

	protected $_meta = [
		'constraints' => [
			[
				'type' => 'foreign_key',
				'column' => 'id',
				'toColumn' => 'id',
				'to' => 'other_table'
			]
		],
		'table' => ['charset' => 'utf8', 'engine' => 'InnoDB']
	];
  

Examples

Create new table up and down

	public function up() {
		return $this->create()
	}
    
	public function down() {
		return $this->drop();
	}
  

Create new table and add records

	protected $_records = array(
		['name' => 'foo', 'type' => 1],
		['name' => 'bar', 'type' => 1]
	);

	public function up() {
		if (!$this->create())
			return false;
    
		return $this->save();
	}

	public function down() {
		return $this->drop();
	}
  

You can provide arguments to command:

• source - custom table name (this is value of source property): --source=site_users
• library - specify library to use: --library=li3_usermanager

migrate

Run migrations with li3 migrate command:

Available li3 migrate actions:

• up - accept timestamp param: li3 migrate up or li3 migrate up 20130505 or li3 migrate up 20130505102033
• down - accept timestamp param: li3 migrate down 1 or li3 migrate down 20130505 or li3 migrate down 20130505102033
• show-available - generate table with all available migrations in current library
• show-state - show timestamp of latest applied migration