qop - A simple database migration tool

qop is a command-line tool for managing database migrations. It's designed to be simple, straightforward, and easy to use.

Features

• Backend-agnostic design (currently supports PostgreSQL)
• Simple migration file format (up.sql, down.sql)
• Timestamp-based migration IDs
• Command-line interface for managing migrations

Installation

cargo install --path .

Configuration

qop is configured using a qop.toml file. Here is an example for PostgreSQL:

[backend]
type = "postgres"
host = "localhost"
port = 5432
username = "postgres"
password = "password"
database = "postgres"
schema = "public"
table = "migrations"

The migration files are expected to be in a directory relative to the qop.toml file.

Usage

qop provides several commands to manage your database migrations.

migration

The core set of commands for managing migrations.

qop migration init

Initializes the migration table in your database. This table is used to track which migrations have been applied.

qop migration init --path path/to/your/qop.toml

Arguments:

• -p, --path <PATH>: Path to the qop.toml configuration file. (default: example/qop.toml)

qop migration new

Creates a new migration directory with up.sql and down.sql files. The directory name is a timestamp-based ID.

qop migration new --path path/to/your/qop.toml

This will create a directory structure like:

migrations/
└── id=1678886400000/
    ├── up.sql
    └── down.sql

Arguments:

• -p, --path <PATH>: Path to the qop.toml configuration file. (default: example/qop.toml)

qop migration up

Applies pending migrations. By default, it applies all pending migrations.

qop migration up --path path/to/your/qop.toml

Arguments:

• -p, --path <PATH>: Path to the qop.toml configuration file. (default: example/qop.toml)
• -c, --count <COUNT>: The number of migrations to apply. If not specified, all pending migrations are applied.
• -t, --timeout <TIMEOUT>: Statement timeout in seconds.

qop migration down

Reverts applied migrations. By default, it reverts the last applied migration.

qop migration down --path path/to/your/qop.toml

Arguments:

• -p, --path <PATH>: Path to the qop.toml configuration file. (default: example/qop.toml)
• -c, --count <COUNT>: The number of migrations to revert. (default: 1)
• -t, --timeout <TIMEOUT>: Statement timeout in seconds.

qop migration list

Lists all migrations, showing their status (applied or not) and when they were applied.

qop migration list --path path/to/your/qop.toml

Arguments:

• -p, --path <PATH>: Path to the qop.toml configuration file. (default: example/qop.toml)

manual

Generates documentation for qop.

qop manual

qop manual --path docs/ --format markdown

Arguments:

• -p, --path <PATH>: Path to write documentation to. (default: docs/man)
• --format <FORMAT>: Format for the documentation. Can be manpages or markdown. (default: manpages)

autocomplete

Generates shell completion scripts.

qop autocomplete

qop autocomplete --path completions/ --shell zsh

Arguments:

• -p, --path <PATH>: Path to write completion script to. (default: docs/autocomplete)
• --shell <SHELL>: The shell to generate completions for (e.g., zsh, bash, fish, powershell, elvish). (default: zsh)