首页 > 代码库 > 如何在PHP项目中使用phinx进行数据迁移和建表
如何在PHP项目中使用phinx进行数据迁移和建表
建表
phinx\bin\phinx.bat migrate -e production
建设 phinx.yml文件
paths: migrations: %%PHINX_CONFIG_DIR%%\database\migrations seeds: %%PHINX_CONFIG_DIR%%\database\seedsenvironments: 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如下:
<?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如下:
<?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 = http://www.mamicode.com/[>
如何在PHP项目中使用phinx进行数据迁移和建表
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。