2017 © Pedro Peláez
 

library schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

image

mysql/schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  • Friday, November 20, 2015
  • by andre
  • Repository
  • 7 Watchers
  • 19 Stars
  • 685 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 8 Forks
  • 12 Open issues
  • 26 Versions
  • 0 % Grown

The README.md

Schematic - Database Migrations Tool

NO LONGER MAINTAINED

Due to the fact that Schematic was never truly fully completed with all the features I wanted it to have, I'm shelving it for the time being, if anyone would like to become the new active contributer let me know. However I've now moved on to Laravel as my main framework and Laravel migrations have now taken over from Schematic.

A database migrations tool, allows for easy database maintenance in a way that is easy to setup in a continuous integration environment., (*1)

Build Status Latest Stable Version Total Downloads Latest Unstable Version License Bitdeli Badge, (*2)

###Install locally via Composer

{
    require: {
        "mysql/schematic": "1.*.*"
    }
}

###Install it Globally

  • Run the following commands:

Download the PHAR file:, (*3)

wget --no-check-certificate https://github.com/andrefigueira/Schematic/raw/master/schematic.phar

Make the PHAR package executable, (*4)

chmod +x schematic.phar

Move it to the user bin folder, (*5)

mv schematic.phar /usr/local/bin/schematic

Then use Schematic, (*6)

schematic

Schematic will now be available globally for you!, (*7)

###Schema format

Schema is defined in schema files, these must be stored in the schema folder in json files representing the table they are for, e.g. (Make sure that you create the schema folder in the root of your project), (*8)

~/ProjectFolder/schemas/table_name.yaml

The schema file contains all of the configuration of the database in order to create it or amend it, see an example below., (*9)

In the current version you need to pass a type and null through always, you pass the length in parenthesis on the type field., (*10)

Schematic uses all of the base MySQL values so you just need to put them into this file and they will work, if you spell something incorrectly, it will stop running and throw and exception., (*11)

###Example Schema

schematic:
    name: Schematic
    version: 1.4.5
database:
    general:
        name: schematic
        charset: utf8
        collation: utf8_general_ci
        engine: InnoDB
    tables:
        hello_world:
            fields:
                id:
                    type: int(11)
                    'null': false
                    unsigned: true
                    autoIncrement: true
                    index: 'PRIMARY KEY'
                client_id:
                    type: int(24)
                    'null': false
                    unsigned: true
                    autoIncrement: false
                name:
                    type: varchar(128)
                    'null': false
                    unsigned: false
                    autoIncrement: false
                    rename: full_name
                description:
                    type: varchar(256)
                    'null': false
                    unsigned: false
                    autoIncrement: false
                created_date:
                    type: datetime
                    'null': false
                    unsigned: false
                    autoIncrement: false

Note that currently foreign keys are only added, but not removed, If created a new database with constraints, you must run the update twice to add the constraints., (*12)

Usage:

schematic [options] command [arguments], (*13)

Options:

--help -h Display this help message., (*14)

--quiet -q Do not output any message., (*15)

--verbose -v|vv|vvv Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug, (*16)

--version -V Display this application version., (*17)

--ansi Force ANSI output., (*18)

--no-ansi Disable ANSI output., (*19)

--no-interaction -n Do not ask any interactive question., (*20)

Available commands:

help Displays help for a command, (*21)

list Lists commands, (*22)

Migrations

migrations:execute Executes the database migration based on the JSON schema files, (*23)

migrations:generate Generates the database schema JSON files, (*24)

migrations:mapping Generates the database schema based on an existing database, (*25)

The script also creates a log of all of the database changes which are made., (*26)

The Versions

20/11 2015

dev-master

9999999-dev http://andrefigueira.github.io/Schematic/

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

16/09 2015

dev-feature/refactor-schematic

dev-feature/refactor-schematic http://andrefigueira.github.io/Schematic/

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

21/11 2014

dev-develop

dev-develop http://andrefigueira.github.io/Schematic/

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

20/11 2014

1.5.0

1.5.0.0 http://andrefigueira.github.io/Schematic/

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

19/11 2014

1.4.9

1.4.9.0 http://andrefigueira.github.io/Schematic/

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

19/11 2014

1.4.8

1.4.8.0 http://andrefigueira.github.io/Schematic/

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

04/11 2014

1.4.6

1.4.6.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

03/11 2014

1.4.5

1.4.5.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

01/11 2014

1.4.4

1.4.4.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

21/10 2014

1.4.3

1.4.3.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

20/10 2014

1.4.2

1.4.2.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

16/10 2014

1.4.1

1.4.1.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

15/10 2014

1.4.0

1.4.0.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

10/10 2014

1.3.4

1.3.4.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

17/04 2014

1.3.3

1.3.3.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

17/04 2014

1.3.2

1.3.2.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

The Development Requires

by Andre Figueira

orm database php migration mysql automation

17/04 2014

1.3.1

1.3.1.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

by Andre Figueira

orm database php migration mysql automation

17/04 2014

1.3.0

1.3.0.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

GPL-3.0+

The Requires

 

by Andre Figueira

orm database php migration mysql automation

17/04 2014

1.2.9

1.2.9.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

The Requires

 

by Andre Figueira

orm database php migration mysql automation

16/04 2014

1.2.8

1.2.8.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

The Requires

 

by Andre Figueira

orm database php migration mysql automation

26/03 2014

1.2.7

1.2.7.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

The Requires

  • php >=5.3.0

 

by Andre Figueira

orm database php migration mysql automation

19/12 2013

1.2.5

1.2.5.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

The Requires

  • php >=5.3.0

 

by Andre Figueira

orm database php migration mysql automation

13/12 2013

1.2.3

1.2.3.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

The Requires

 

by Andre Figueira

orm database php migration mysql automation

13/12 2013

1.2.2

1.2.2.0 https://github.com/andrefigueira/Schematic

A simple MySQL migration management tool in PHP, create and update databases automatically with a config json file without having to use inbuilt ORM functions.

  Sources   Download

The Requires

 

by Andre Figueira

orm database php migration mysql automation

12/12 2013

1.1

1.1.0.0

  Sources   Download

The Requires

 

12/12 2013

1.0

1.0.0.0

  Sources   Download

The Requires