zoltanlaca/dibi-migrations

Dibi 数据库迁移库

维护者

详细信息

github.com/zoltanlaca/dibi-migrations

源代码

问题

安装: 40

依赖项: 0

建议者: 0

安全: 0

星级: 1

关注者: 1

分支: 0

开放问题: 0

v1.0.3 2024-07-08 21:03 UTC

Requires

Requires (Dev)

MIT 8e75c668a8c3113522f3dc76c29860ba6fee07d5

This package is auto-updated.

Last update: 2024-09-08 21:26:05 UTC

README

Dibi 数据库迁移库

安装

composer require zoltanlaca/dibi-migrations

基本配置

<?php
declare(strict_types=1);

use Dibi\Connection;
use Zoltanlaca\DibiMigrations\Configuration;
use Zoltanlaca\DibiMigrations\Exceptions\ConnectionException;
use Zoltanlaca\DibiMigrations\Migrations;

include_once dirname(__DIR__) . '/vendor/autoload.php';

try {
    $connection = new Connection([
        'driver' => 'mysqli',
        'host' => 'localhost',
        'username' => 'root',
        'password' => '',
        'database' => 'dibi_migrations',
    ]);
} catch (\Dibi\Exception $exception) {
    echo $exception->getMessage(). PHP_EOL;
    exit;
}

$config = New Configuration(
    $connection,
   __DIR__ . '/Migrations',
   'Zoltanlaca\DibiMigrations\Examples\Migrations',
   'migrations'
);

try {
    $migrations = new Migrations($config);
    $migrations->migrateUp();
} catch (ConnectionException $exception) {
    echo $exception->getMessage(). PHP_EOL;
    exit;
}

迁移到最新版本

$migrations->migrateUp();

仅迁移到指定版本

$migrations->migrateUp(20230518085154);

撤销迁移到第一个版本

$migrations->migrateDown();

撤销迁移到指定版本

$migrations->migrateUp(20230518085154);