Phinx 数据库迁移工具

心已赠人 2021-09-10 07:54 474阅读 0赞

[文档\*http://docs.phinx.org/en/latest/][http_docs.phinx.org_en_latest]  
[教程\*\[https://robmorgan.id.au/posts/getting-started-with-phinx/\]][https_robmorgan.id.au_posts_getting-started-with-phinx]

### 安装 ###

`composer require "robmorgan/phinx`

### 查看所有命令 ###

`vendor/bin/phinx`

![6587214-e227e76800513c8c.png][]

image.png

### 生成配置文件 ###

vendor/bin/phinx init

使用`phinx.php`进行配置

// db.php
    <?php
    $config = array(
        'DB_HOST' => 'localhost',
        'DB_NAME' => 'lleg',
        'DB_USER' => 'root',
        'DB_PWD' => '',
    );
    $settings = $config;

// phinx.php
    <?php
    require 'db.php';
    return array(
        "paths" => array(
            "migrations"    => "/database/migrations",
            "seeds"         => "/database/seeds"
        ),
        "environments"   => array(
            "defaut_migration_table"    => "phinxlog",
            "default_database"          => "lleg",
            "default_environment"       => "development"
            "production"   => array(
                "adapter"   => "mysql",
                "host"      => $settings["DB_HOST"],
                "name"      => $settings["DB_NAME"],
                "user"      => $settings["DB_USER"],
                "pass"      => $settings["DB_PWD"],
                "port"      => 3306,
                "charset"   => "utf8"
            ),
            "development"   => array(
                "adapter"   => "mysql",
                "host"      => $settings["DB_HOST"],
                "name"      => $settings["DB_NAME"],
                "user"      => $settings["DB_USER"],
                "pass"      => $settings["DB_PWD"],
                "port"      => 3306,
                "charset"   => "utf8"
            )
        )
    );

### 查看连接状态 ###

执行 `vendor/bin/phinx status`查看连接状态

![6587214-fe7f6016265caf45.png][]

image.png

### 生成数据库迁移文件 ###

执行 `vendor/bin/phinx create CreateMembersTable`

![6587214-1deb3298d786c4c0.png][]

image.png

编辑文件, 添加数据库创建内容

public function change()
        {
            $user = $this->table('Members');
            $user->addColumn('username', 'string', ['limit'=>64]);
            $user->addColumn('password', 'string');
            $user->addColumn('status', 'integer', ['default' => 1, 'comment' => '状态']);
            $user->addColumn('register_time', 'timestamp', ['default' => 'CURRENT_TIMESTAMP']);
            $user->addColumn('last_login', 'datetime', ['null'=>true, 'comment'=>'最后登陆日期']);
            $user->save();
        }

默认会添加一个自增id,作为主键

### 数据库迁移 ###

执行 `vendor/bin/phinx migrate`

## 生成填充数据文件 ##

执行 `vendor/bin/phinx seed:create MemberSeeder`

![6587214-32ac7bd6152e354a.png][]

image.png

编辑填充文件

public function run()
        {
            $data = [
                [
                    'username' => 'zhangsan',
                    'password' => md5('123456'),
                ],
                [
                    'username' => 'lisi',
                    'password' => md5('123456'),
                ]
            ];
    
            $this->table('members')->insert($data)->saveData();
        }

### 填充数据 ###

执行 `vendor/bin/phinx seed:run` 将会进行所有Seed  
如果想运行指定的Seed需要用`- s`参数指定  
`vendor/bin/phinx seed:run -s MemberSeeder`

## 更新表结构 ##

当需要更新表结构的时候,需要再创建一个migrate  
执行`vendor/bin/phinx create ChangeArtist`  
再将需要更新的内容写到`change`函数

public function change()
        {
            $this->execute('alter table members drop column status;');
            $this->table('members')
                   ->addColumn('state', 'integer', ['default' => 1, 'comment' => '状态'])
                   ->update();
        }

最后执行`php vendor/bin/phinx migrate`  
之前的已经执行过的migrate不会执行, 只会执行更新的部分

### 回滚 ###

vendor/bin/phinx rollback

### 指定配置文件 ###

vendor/bin/phinx migrate --configuration ./config/phinx.php

简写

vendor/bin/phinx migrate -c ./config/phinx.php

[http_docs.phinx.org_en_latest]: https://links.jianshu.com/go?to=http%3A%2F%2Fdocs.phinx.org%2Fen%2Flatest%2F
[https_robmorgan.id.au_posts_getting-started-with-phinx]: https://links.jianshu.com/go?to=https%3A%2F%2Frobmorgan.id.au%2Fposts%2Fgetting-started-with-phinx%2F%255D
[6587214-e227e76800513c8c.png]: /images/20210804/0b5c5348573a40cda236e32701b09470.png
[6587214-fe7f6016265caf45.png]: /images/20210804/e317aa5102414efa95419680246964b5.png
[6587214-1deb3298d786c4c0.png]: /images/20210804/1a5de2520c74462898000f4f5f1e05d8.png
[6587214-32ac7bd6152e354a.png]: /images/20210804/5b6ae7dcf6fb4070a906b1781189ca87.png