#migration #postgresql #sql

app seagull

Simple PostgreSQL migration tool

1 unstable release

0.1.0 May 21, 2020

#7 in #migrations

MIT license

20KB
442 lines

seagull

Getting Started

The basic workflow is as follows:

  1. seagull init
# seagull.toml

Commands

seagull init

creates a seagull.toml file for storing connection strings and other config values. This file is optional, you can use the other commands without it.

seagull poop

firstly creates a directory named migrations if one does not already exist. Secondly creates an empty .sql file in the format V{1}__{2}.sql where {1} is an auto-incremented version number and {2} is a description.

USAGE
# creates ./migrations/V1__initial.sql
$ seagull poop initial

# creates ./migrations/V1_create_users_table.sql 
$ seagull poop "create users table"

# creates ./migrations/V2_another_migration.sql assuming V1 exists
$ seagull poop another_migration

seagull migrate

firstly creates a database table named __migration_history if one does not already exist. Runs all migrations in the migrations directory in a single transaction. If one fails, they all fail and the database is rolled back.

USAGE

# reads config from seagull.toml
$ seagull migrate

# specify your PostgreSQL connection string
$ seagull migrate --database postgresql://postgres:mysecretpassword@localhost/postgres

# looks for migrations in src/migrations
$ seagull migrate --dir src/migrations

seagull remigrate

Same as seagull migrate except that it will firstly reset the whole database before running all migrations. Useful for development if you're using a Docker database and changing migrations often. Would NOT suggest running it on production! ☠️

# reads config from seagull.toml
$ seagull remigrate

# specify your PostgreSQL connection string
$ seagull remigrate --database postgresql://postgres:mysecretpassword@localhost/postgres

# looks for migrations in src/migrations
$ seagull remigrate --dir src/migrations

Dependencies

~11–20MB
~269K SLoC