php项目代码迁移,如何在PHP项目中使用phinx进行数据迁移和建表
建表
phinx\bin\phinx.bat migrate -e production
建设 phinx.yml文件
paths:
migrations: %%PHINX_CONFIG_DIR%%\database\migrations
seeds: %%PHINX_CONFIG_DIR%%\database\seeds
environments:
default_migration_table: phinxlog
default_database: development
production:
adapter: mysql
host: localhost
name: jitamin2
user: root
pass: ‘‘
port: 3306
charset: utf8
development:
adapter: mysql
host: localhost
name: development_db
user: root
pass: ‘‘
port: 3306
charset: utf8
testing:
adapter: mysql
host: localhost
name: testing_db
user: root
pass: ‘‘
port: 3306
charset: utf8
%%PHINX_CONFIG_DIR%%\database\migrations下面的文件示例20161222061456_create_users_table.php如下：
/*
* This file is part of Jitamin.
*
* Copyright (C) Jitamin Team
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
use Phinx\Migration\AbstractMigration;
class CreateUsersTable extends AbstractMigration
{
/**
* Change Method.
*/
public function change()
{
$table = $this->table(‘users‘);
$table->addColumn(‘username‘, ‘string‘, [‘limit‘=>50])
->addColumn(‘password‘, ‘string‘, [‘null‘ => true])
->addColumn(‘is_ldap_user‘, ‘boolean‘, [‘null‘ => true, ‘default‘ => false])
->addColumn(‘name‘, ‘string‘, [‘null‘ => true])
->addColumn(‘email‘, ‘string‘)
->addColumn(‘google_id‘, ‘string‘, [‘null‘=> true, ‘limit‘ => 30])
->addColumn(‘github_id‘, ‘string‘, [‘null‘ => true, ‘limit‘ => 30])
->addColumn(‘notifications_enabled‘, ‘boolean‘, [‘null‘ => true, ‘default‘ => false])
->addColumn(‘timezone‘, ‘string‘, [‘null‘ => true, ‘limit‘ => 50])
->addColumn(‘language‘, ‘string‘, [‘null‘ => true, ‘limit‘ => 5])
->addColumn(‘disable_login_form‘, ‘boolean‘, [‘null‘ => true, ‘default‘ => false])
->addColumn(‘twofactor_activated‘, ‘boolean‘, [‘null‘ => true, ‘default‘ => false])
->addColumn(‘twofactor_secret‘, ‘string‘, [‘null‘ => true, ‘limit‘ => 16])
->addColumn(‘token‘, ‘string‘, [‘null‘=> true, ‘default‘ => ‘‘])
->addColumn(‘notifications_filter‘, ‘integer‘, [‘null‘ => true, ‘default‘ => 4])
->addColumn(‘nb_failed_login‘, ‘integer‘, [‘null‘ => true, ‘default‘ => 0])
->addColumn(‘lock_expiration_date‘, ‘biginteger‘, [‘null‘ => true])
->addColumn(‘gitlab_id‘, ‘integer‘, [‘null‘ => true])
->addColumn(‘role‘, ‘string‘, [‘limit‘ => 25, ‘default‘ => ‘app-user‘])
->addColumn(‘is_active‘, ‘boolean‘, [‘null‘ => true, ‘default‘ => true])
->addColumn(‘avatar_path‘, ‘string‘, [‘null‘ => true])
->addColumn(‘skin‘, ‘string‘, [‘null‘ => true, ‘limit‘=>15])
->addIndex([‘username‘], [‘unique‘ => true])
->addIndex([‘email‘], [‘unique‘ => true])
->create();
}
}
数据迁移命令如下：
phinx\bin\phinx.bat seed:run -e production
%%PHINX_CONFIG_DIR%%\database\seeds下面的文件示例CreateGroupsTable.php如下：
/*
* This file is part of Jitamin.
*
* Copyright (C) Jitamin Team
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
use Jitamin\Foundation\Security\Role;
use Phinx\Seed\AbstractSeed;
class UserSeeder extends AbstractSeed
{
/**
* Run Method.
*/
public function run()
{
$data = [
[
‘username‘ => ‘admin‘,
‘password‘ => bcrypt(‘admin‘),
‘email‘ => [email protected],
‘role‘ => Role::APP_ADMIN,
],
];
$users = $this->table(‘users‘);
$users->insert($data)
->save();
}
}
原文：http://www.cnblogs.com/haoliansheng/p/6640721.html