文档*http://docs.phinx.org/en/latest/
教程*[https://robmorgan.id.au/posts/getting-started-with-phinx/]
安装
composer require "robmorgan/phinx
查看所有命令
vendor/bin/phinx
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查看连接状态
image.png
生成数据库迁移文件
执行 vendor/bin/phinx create CreateMembersTable
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
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
