PHP-Phinx数据库迁移

关于Phinx和Composer的安装

• http://docs.phinx.org/en/latest/install.html
• https://blog.csdn.net/xdbse/article/details/53529622

初始化phinx 生成phinx.yml文件

/// phinx 默认安装到了 /Users/userName/vendor路径下 在phpstorm的中的终端中执行

/Users/userName/vendor/bin/phinx init

phinx.yml:

phinx的table脚本文件路径
paths:
     migrations: '%%PHINX_CONFIG_DIR%%/db/migrations' 

数据库的配置类Phinx.php

dbmigrations/Phinx.php :

<?php
require_once dirname(dirname(__FILE__))."/params.php";
return [
    'paths' => [
    'migrations' => __DIR__ . '/db/migrations',
    'seeds' => __DIR__ . '/db/seeds',
],
'environments' => [
    'default' => [
    'adapter' => 'mysql',
        'host' => DEFAULT_DB_HOST,
        'name' => DEFAULT_DB_NAME,
        'user' => DEFAULT_DB_USER,
        'pass' => DEFAULT_DB_PASS,
        'port' => DEFAULT_DB_PORT,
        'charset' => 'utf8',
        'collation' => 'utf8_unicode_ci',
        ],
    ],
];

创建migration类

/// 脚本类 要求驼峰
cd dbmigrations
/Users/userName/vendor/bin/phinx Create MyTableClass

生成文件: dbmigrations/db/migrations/20180920074812_my_table_class.php

table

20180920074812_my_table_class.php

<?php


use Phinx\Migration\AbstractMigration;

class MyTableClass extends AbstractMigration
{

    public function up()
    {
        $this->down();
        $this->table("my_table") //表名
        ->addColumn('accountId','string','unique', array('limit'=> 64,'comment' => '用户id'))//唯一
        ->addColumn('chainStatus','integer',array('default' => 0))
        ->addIndex(array('accountID'), array('unique' => true)) // 添加索引
        ->addTimestamps()
        ->create();
    }

    public function down()
    {
        if ($this->hasTable("my_table")) {
            $this->dropTable("my_table");
        }
    } 

}

或者–创建seed类

cd dbmigrations
/Users/userName/vendor/bin/phinx seed:create MyTableClass

-----

<?php
//  项目根目录/db/seeds/MyTableClass.php
use Phinx\Seed\AbstractSeed;

class MyTableClass extends AbstractSeed
{
    /**
    * 插入数据
    */
    public function run()
    {
        $data = array(
        array(
            'id'    => 1,
        ),
        array(
            'id'    => 2,
        )
        );

        $posts = $this->table('users');
        $posts->insert($data)->save();
    }
}

最后登入服务器 执行迁移

 cd dbmigrations
 phinx migrate

---------------

Phinx by Rob Morgan - https://phinx.org. 0.8.0

using config file ./phinx.php
using config parser php
using migration paths
- /xxx/dbmigrations/db/migrations
using seed paths
warning no environment specified, defaulting to: default
using adapter mysql
using database 5bf3b4903f058

== 20190225075226 MyTableClass: migrating
PHP Warning:  Invalid argument supplied for foreach() in phar:///usr/local/bin/phinx/src/Phinx/Db/Table/Column.php on line 615
== 20190225075226 MyTableClass: migrated 0.0740s

All Done. Took 0.1040s

获取服务器环境中的mysql变量

env | grep mysql

----------

mysql_0_host=xxxx
mysql_0_password=xxxx
mysql_0_dbname=xxx
mysql_0_username=root
mysql_0_port=3306

浏览器输入 domain/adminer.php 登入数据库 就可以看到创建的table了!

后期增加表字段 需要另外创建一个migrate类 比如: 添加一个type列

• /Users/userName/vendor/bin/phinx Create AddColumnType

<?php


use Phinx\Migration\AbstractMigration;

class AddColumnType extends AbstractMigration
{
    function  up(){
        $this->table('my_table')
        ->addColumn('type','string',array('limit'=> 10))
        ->update();
    }

    function down(){
        if($this->table('my_table')->hasColumn('type')) {
            $this->table('my_table')->removeColumn('type')->update();
        }
    }
}

phinx migrate