Nessie

A modular database migration tool for Deno inspired by Laravel. Supports PostgreSQL, MySQL and SQLite.

See documentation for the query builder.
See documentation for the clients.

Supported databases

• PostgreSQL
• MySQL - Currently it works with password for 5.*, but for >=8 you have to send a blank password, see Deno MySQL for version support
• SQLite

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.

You can see examples of how to make a client plugin in the clients folder or in the section How to make a client.

Usage

• init: Generates a nessie.config.ts file

  deno run --allow-net --allow-read --allow-write https://deno.land/x/nessie/cli.ts init

• make [name]: Create migration

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

• make:seed [name]: Create seed

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

• migrate [amount?]: Run migration - will migrate your migrations in your migration folder (sorted by timestamp) newer than the latest migration in your db. Amount defines how many migrations, defaults to all available if not set.

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts migrate

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts migrate 1

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts migrate -c ./nessie.config.ts

• rollback [amount?]: Rollback - will rollback your migrations. Amount defines how many migrations, defaults to 1 if not set.

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts rollback

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts rollback 2

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts rollback all

• seed [matcher?]: Seed - will seed your database. Optional matcher will match all files in your seed folder by string literal or RegExp.

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts seed

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts seed seed_file.js

  deno run --allow-net --allow-read https://deno.land/x/nessie/cli.ts seed ".+.ts"

Flags

• -c, --config: Path to config file, will default to ./nessie.config.ts
• -d, --debug: Enables verbose output

Contributing

All contributions are welcome, make sure to read the contributing guideline.

Uses

• Denomander
• Deno Postgres
• Deno MySQL
• Deno SQLite

Examples

nessie.config.ts with all default values

import { ClientPostgreSQL } from "./clients/ClientPostgreSQL.ts";

const nessieOptions = {
  migrationFolder: "./db/migrations",
  seedFolder: "./db/seeds",
};

const connectionOptions = {
  database: "nessie",
  hostname: "localhost",
  port: 5432,
  user: "root",
  password: "pwd",
};

export default {
  client: new ClientPostgreSQL(nessieOptions, connectionOptions),
  exposeQueryBuilder: false,
};

Minimal example of a migration file

import { Migration } from "https://deno.land/x/nessie/mod.ts";

export const up: Migration = () => {
  return "CREATE TABLE table1 (id int);";
};

export const down: Migration = () => {
  return "DROP TABLE table1";
};

Using the native query builder (exposeQueryBuilder: true)

import { Migration } from "https://deno.land/x/nessie/mod.ts";
import { Schema } from "https://deno.land/x/nessie/qb.ts";

export const up: Migration<Schema> = ({ queryBuilder }) => {
  queryBuilder.create("users", (table) => {
    table.id();
    table.string("name", 100).nullable();
    table.boolean("is_true").default("false");
    table.custom("custom_column int default 1");
    table.timestamps();
  });

  queryBuilder.queryString(
    "INSERT INTO users VALUES (DEFAULT, 'Deno', true, 2, DEFAULT, DEFAULT);",
  )
  
  return queryBuilder.query
};

export const down: Migration<Schema> = ({ queryBuilder }) => {
  return queryBuilder.drop("users");
};

Seed file

import { Seed } from "https://deno.land/x/nessie/mod.ts";

export const run: Seed = () => {
  return "INSERT INTO testTable VALUES (1)"
};

See the example folder for more

How to make a client

A client needs to extend AbstractClient and implement the ClientI interface.

query: Takes a query string or array of query strings and sends them of to the batabase for execution. Should return whatever the database responds.

prepare: Will be run when the migration or rollback commands are executed. This should create the connection, set up the nessie_migrations table and prepare the database for incoming migrations.

migrate: Takes a number as an optional input, will default to all files if not set. Will run Math.min(amount, numberOfFiles) migration files. Only handles the up method.

rollback: Takes a number as an optional input, will default to 1 if not set. Will run Math.min(amount, numberOfFiles) migration files. Only handles the down method.

seed: Takes an optional matcher as input. Matcher can be regex or string. Will seed the database. Handles the run method in seed files.

close: Will be the last method run before the program is finished. This should close the database connection.