Nessie

ci

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

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)