Migrations are a convenient way for you to alter your database in a structured and organized manner. This package adds additional functionality for versioning your database schema and easily deploying changes to it. It is a very easy to use and a powerful tool.
composer require cycle/migrations ^3.0use Cycle\Migrations;
use Cycle\Database;
use Cycle\Database\Config;
$dbal = new Database\DatabaseManager(new Config\DatabaseConfig([
'default' => 'default',
'databases' => [
'default' => [
'connection' => 'sqlite'
]
],
'connections' => [
'sqlite' => new Config\SQLiteDriverConfig(
connection: new Config\SQLite\MemoryConnectionConfig(),
queryCache: true,
),
]
]));
$config = new Migrations\Config\MigrationConfig([
'directory' => __DIR__ . '/../migrations/', // where to store migrations
'table' => 'migrations' // database table to store migration status
'safe' => true // When set to true no confirmation will be requested on migration run.
]);
$migrator = new Migrations\Migrator(
$config,
$dbal,
new Migrations\FileRepository($config)
);
// Init migration table
$migrator->configure();while (($migration = $migrator->run()) !== null) {
echo 'Migrate ' . $migration->getState()->getName();
}You can automatically generate a set of migration files during schema compilation. In this case, you have the freedom to alter such migrations manually before running them. To achieve that you must install the Cycle migrations extension.
MIT License (MIT). Please see LICENSE for more information. Maintained
by Spiral Scout.