2017 © Pedro Peláez
 

library php-database-migration

rake and mybatis SQL migration tool

image

hipay/php-database-migration

rake and mybatis SQL migration tool

  • Friday, February 26, 2016
  • by hipay
  • Repository
  • 4 Watchers
  • 0 Stars
  • 249 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 24 Forks
  • 0 Open issues
  • 18 Versions
  • 19 % Grown

The README.md

PhpDbMigration - full PHP database migration tool

This is a full standalone PHP tool based on symfony console and inspired by the rails database migration tool and MyBatis. It merge the functionnality of the two tools and has been desined to be as flexible as possible., (*1)

Installing it to your project

Just add it to your composer.json (don't forget to specify your bin directory) Warning, all migrate commands must be executed on your root folder like bin/migrate migrate:command..., (*2)

{
    "name": "jdoe/testproject",
    "authors": [
        {
            "name": "Jhon DOE",
            "email": "jdoe@gmail.com"
        }
    ],
    "require": {
        "php-database-migration/php-database-migration" :"3.4.*"
    },
    "config": {
        "bin-dir": "bin"
    }
}

Adding an environment

The first thing to do before playing with SQL migrations is to add an environment, let's add the dev one., (*3)

alt tag, (*4)

Initialization

Once the environment is added, you have to initialize it (create the changelog table on the good database), (*5)

alt tag, (*6)

Create a migration

It is time to create our first migration file., (*7)

alt tag, (*8)

Migrations file are like this, (*9)

--// add table users
-- Migration SQL that makes the change goes here.
create table users (id integer, name text);
-- @UNDO
-- SQL to undo the change goes here.
drop table users;

Up and down

You can now up all the pending migrations. If you decided to down a migration, the last one will be downed alone to prevent from mistake. You will be asked to confirm the downgrade of your database before runing the real SQL script. alt tag, (*10)

For developement purpose, it is also possible to up a single migration without taking care of the other ones., (*11)

alt tag, (*12)

Same thing for down, (*13)

alt tag, (*14)

The Versions

26/02 2016

dev-stable

dev-stable https://github.com/hipay/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

26/02 2016

v4.1.0

4.1.0.0 https://github.com/hipay/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

26/02 2016

v4.0.0

4.0.0.0 https://github.com/hipay/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

20/04 2015

v3.4.4

3.4.4.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

09/03 2015

v3.4.3

3.4.3.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

09/03 2015

v3.4.2

3.4.2.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

05/03 2015

v3.4.1

3.4.1.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

03/03 2015

v3.4.0

3.4.0.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

28/02 2015

v3.3.0

3.3.0.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

28/02 2015

v3.2.0

3.2.0.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

28/02 2015

v3.1.0

3.1.0.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

 

The Development Requires

by GUIDET Alexandre

sql migration rake mybatis

27/02 2015

2.2.1

2.2.1.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis

27/02 2015

v3.0.0

3.0.0.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis

27/02 2015

2.2.0

2.2.0.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis

21/02 2014

2.1.2

2.1.2.0 https://github.com/alwex/php-database-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis

04/02 2014

2.1.0

2.1.0.0 https://github.com/alwex/php-db-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis

04/02 2014

2.0.0

2.0.0.0 https://github.com/alwex/php-db-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis

21/06 2013

1.0.0

1.0.0.0 https://github.com/alwex/php-db-migration

rake and mybatis SQL migration tool

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by GUIDET Alexandre

sql migration rake mybatis