Nessie

A db migration tool for deno.

Status / Roadmap

• Currently the cli can be used to create a migration file and to perform simple migrations and rollbacks

• By using Schema you can generate a sql string which you can use to modify your database

• CLI communicates with db and tracks migrations using a table

• CLI can rollback a migration

• CLI can migrate and rollback multiple files (currently only migrate multiple files)

• Add support for seed files

• Rework the codebase to have a cleaner interface and chained opperations

• Add support for soft deletes

• Add support for env or settings file

• Add tests

Supported databases

• PostgreSQL - in development
• MySQL - not started
• SQLite - not started

If you have a database system you would like to see in this list, feel free to make an issue or create a pr with your implementation.

Usage

• Create migration

deno run --allow-write --allow-read https://deno.land/x/nessie/cli.ts make create_users -p migrations

• Run migration (under construction, feel free to file any bugs you encounter)

deno run --allow-read --allow-net https://deno.land/x/nessie/cli.ts migrate -p migrations -c postgres://root:pwd@localhost:5000/nessie

• Rollback (under construction, feel free to file any bugs you encounter)

deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts migrate -p migrations -c postgres://root:pwd@localhost:5000/nessie

Contributing

I am looking for someone to help me out with this project, so feel free to make pr’s or create an issue!

Uses

• Denomander
• Deno Postgres

Examples

Minimal example for a migration file

import { Schema } from "../mod.ts";

export const up = (scema: Schema): void => {
    scema.create('users', table => {
        table.id()
        table.string('name', 100).nullable()
        table.boolean('isTrue').default('false')
        table.custom('custom_column int default 1')
        table.timestamps()
    })
};

export const down = (schema: Schema): void => {
    schema.drop('users')
};

See example folder for more (under development)