Migres

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

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

peehaa / migres Goto Github PK

migres's Introduction

Migres

Requirements

Usage

TOC

Creating a table

Renaming a table

Dropping a table

Table methods

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

Table::dropColumn(string $name)

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

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

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

Table::dropPrimaryKey([string $name])

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

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

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

Table::dropUniqueConstraint(string $constraintName)

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

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

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

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

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

Table::dropIndex(string $indexName)

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

Table::dropCheck(string $checkName)