peehaa/migres

Postgresql migration tool

v0.2.0 2019-08-07 19:51 UTC

Requires

• php: ^7.4
• ext-ctype: *
• ext-json: *
• ext-pdo: *
• ext-readline: *
• league/climate: ^3.5

Requires (Dev)

• maglnet/composer-require-checker: ^2.0.0
• phpstan/phpstan: ^0.11.12
• phpunit/phpunit: ^8.2.5
• slevomat/coding-standard: ^5.0.4
• squizlabs/php_codesniffer: ^3.4.2

MIT

• Pieter Hordijk

README

The PostgreSQL migration tool

Requirements

• PHP 7.4
• PostgreSQL 9.5

Usage

Note: this is alpha software. Do not use in production (yet). I would appreciate if you could test it and provide feedback in GitHub issues. <3

Warning: never allow untrusted input in table specifications as all migrations are translated to raw SQL!

• Add the project using composer composer install peehaa/migres
• Run the setup ./vendor/bin/migres setup
• Run without arguments to view the available commands ./vendor/bin/migres

All native PostgreSQL data types are implemented and the list can be found at: https://github.com/PeeHaa/migres/tree/master/src/DataType

TOC

• Creating a table
• Renaming a table
• Dropping a table
• Table methods
  • addColumn
  • dropColumn
  • renameColumn
  • changeColumn
  • primaryKey
  • namedPrimaryKey
  • dropPrimaryKey
  • renamePrimaryKey
  • addUniqueConstraint
  • dropUniqueConstraint
  • addIndex
  • addBtreeIndex
  • addHashIndex
  • addGistIndex
  • addGinIndex
  • dropIndex
  • addCheck
  • dropCheck
• Command line
  • Setup
  • Create new migration
  • Run migrations
  • Run rollbacks

Creating a table

<?php declare(strict_types=1);

namespace Vendor\Migrations;

use PeeHaa\Migres\DataType\BigSerial;
use PeeHaa\Migres\DataType\Boolean;
use PeeHaa\Migres\DataType\CharacterVarying;
use PeeHaa\Migres\MigrationSpecification;
use PeeHaa\Migres\Specification\Table;

class CreateTable extends MigrationSpecification
{
    public function change(): void
    {
        $this->createTable('users', function (Table $table) {
            $table->addColumn('id', new BigSerial());
            $table->addColumn('is_admin', new Boolean())->notNull()->default(false);
            $table->addColumn('name', new CharacterVarying(128))->notNull();
            $table->addColumn('email_address', new CharacterVarying(255))->notNull();
            $table->primaryKey('id');
            $table->addIndex('users_name', 'name');
            $table->addUniqueConstraint('email_address_unq', 'email_address');
        });
    }
}

Renaming a table

<?php declare(strict_types=1);

namespace Vendor\Migrations;

use PeeHaa\Migres\MigrationSpecification;

class RenameTable extends MigrationSpecification
{
    public function change(): void
    {
        $this->renameTable('users', 'members');
    }
}

Dropping a table

<?php declare(strict_types=1);

namespace Vendor\Migrations;

use PeeHaa\Migres\MigrationSpecification;

class RenameTable extends MigrationSpecification
{
    public function change(): void
    {
        $this->dropTable('members');
    }
}

Table methods

The table object defines the following methods:

Table::addColumn(string $name, \Migres\DataType\Type $dataType)

$table->addColumn('column_name', new Integer());

$table->addColumn('column_name', new Integer())->notNull;

$table->addColumn('column_name', new Integer())->default(12);

Table::dropColumn(string $name)

$table->dropColumn('column_name');

Table::renameColumn(string $oldName, string $newName)

$table->renameColumn('old_name', 'new_name');

Table::changeColumn(string $name, \Migres\DataType\Type $dataType)

$table->changeColumn('column_name', new IntegerType());

$table->changeColumn('column_name', new IntegerType())->notNull();

$table->changeColumn('column_name', new IntegerType())->default(12);

Table::primaryKey(string $column, [string ...$columns])

$table->primaryKey('column_name');

$table->primaryKey('column_name1', 'column_name2');

Table::dropPrimaryKey([string $name])

$table->dropPrimaryKey();

$table->dropPrimaryKey('table_name_pkey');

Table::namedPrimaryKey(string $name, string $column, [string ...$columns])

$table->namedPrimaryKey('custom_name_pkey', 'column_name');

$table->namedPrimaryKey('custom_name_pkey', 'column_name1', 'column_name2');

Table::renamePrimaryKey(string $oldName, string $newName)

$table->renamePrimaryKey('old_name', 'new_name');

Table::addUniqueConstraint(string $constraintName, string $column, [string ...$columns])

$table->addUniqueConstraint('constraint_name', 'column_name');

$table->addUniqueConstraint('constraint_name', 'column_name1', 'column_name2');

Table::dropUniqueConstraint(string $constraintName)

$table->dropUniqueConstraint('constraint_name');

Table::addIndex(string $indexName, string $column, [string ...$columns])

$table->addIndex('name_idx', 'column_name');

$table->addIndex('name_idx', 'column_name DESC');

$table->addIndex('name_idx', 'column_name1 DESC', 'column_name2 DESC');

Table::addBtreeIndex(string $indexName, string $column, [string ...$columns])

$table->addBtreeIndex('name_idx', 'column_name');

$table->addBtreeIndex('name_idx', 'column_name DESC');

$table->addBtreeIndex('name_idx', 'column_name1 DESC', 'column_name2 DESC');

Table::addHashIndex(string $indexName, string $column, [string ...$columns])

$table->addHashIndex('name_idx', 'column_name');

$table->addHashIndex('name_idx', 'column_name DESC');

$table->addHashIndex('name_idx', 'column_name1 DESC', 'column_name2 DESC');

Table::addGistIndex(string $indexName, string $column, [string ...$columns])

$table->addGistIndex('name_idx', 'column_name');

$table->addGistIndex('name_idx', 'column_name DESC');

$table->addGistIndex('name_idx', 'column_name1 DESC', 'column_name2 DESC');

Table::addGinIndex(string $indexName, string $column, [string ...$columns])

$table->addGinIndex('name_idx', 'column_name');

$table->addGinIndex('name_idx', 'column_name DESC');

$table->addGinIndex('name_idx', 'column_name1 DESC', 'column_name2 DESC');

Table::dropIndex(string $indexName)

$table->dropIndex('name_idx');

Table::addCheck(string $checkName, string $expression)

$table->addCheck('bigger_than_10_chk', 'column_name > 10');

Table::dropCheck(string $checkName)

$table->dropCheck('bigger_than_10_chk');

Command line

Setup

./vendor/bin/migres setup

This will run the setup wizard which guides you through the process of setting up the configuration.

Create new migration

./vendor/bin/migres create NewMigrationName

This will create a new migration and writes the file to the migrations directory.

Run migrations

./vendor/bin/migres migrate [-v[v][v]]

Run the migrations

Run rollbacks

./vendor/bin/migres rollback [-v[v][v]]

Rolls back the migrations