deckard

KO | EN

gitlite — search

#javascript #react #llm #go #golang #rust #deep-learning #docker #macos #kubernetes #pytorch #security #mcp #open-source

(★ 12)

Deckard is a framework agnostic tool for running database migrations.

deckard Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

![](https://user-images.githubusercontent.com/1455979/61998340-756f7380-b063-11e9-8f10-05e078321ccd.png)
# Deckard
[![Build Status](https://travis-ci.org/bradcypert/deckard.svg?branch=master)](https://travis-ci.org/bradcypert/deckard)
[![Maintainability](https://api.codeclimate.com/v1/badges/3c85f35a6a7865558b27/maintainability)](https://codeclimate.com/github/bradcypert/deckard/maintainability)
[![GoDoc](https://godoc.org/github.com/bradcypert/deckard?status.svg)](https://godoc.org/github.com/bradcypert/deckard)

### A framework agnostic tool for running database migrations.
###### Currently, Deckard only supports MySQL & Postgres. More databases coming soon!

Deckard consists of two major packages -- cmd and lib. The `lib` package contains the logic that deckard runs on, as well as the supporting database layers. The `cmd` package simply wraps the `lib` package in an easy to use CLI. IE: If you want to use deckard as a CLI you can, but you can also specify it as a dependency and build ontop of it!

## CLI Usage
```bash
deckard create add_login_date_to_users
# modify the created files
deckard up --host=localhost --port=5432 --user=user --password=pass --database=app
deckard down --host=localhost --port=5432 --user=user --password=pass --database=app
```

#### TODO LIST:
- [x] Up Migrations for Postgres
- [x] Down Migrations for Postgres
- [x] Verify integrity for Postgres
- [x] Create new migrations from Deckard
- [x] Allow reading from Config file instead of cmd flags
- [x] Support for MySQL

#### Managing your databases via YAML config.
Deckard also supports managing your databases via YAML.
Instead of writing
```bash
deckard up --host=localhost --port=5432 --user=user --password=pass --database=app
```

You can simply write
```bash
deckard up --key=prod
```
provided you have a a `.deckard.yml` in your home directory. In this instance, your YAML should look like this:
```yaml
prod:
    host: localhost
    port: 5432
    user: user
    password: pass
    database: app
    driver: postgres
```

Alternatively, you can provide deckard the path to the configuration value you want to use.
```bash
deckard up --config=/usr/app/deckard.yml --key=prod
```

#### Verifying a migration was ran against the database.
Sometimes, you may find yourself curious if the migration was ran against the DB. You certainly can fire up your favorite database client and query for the metadata entry (or the schema change!), but Deckard also allows you to verify that a given migration has been ran against a given database. Simply use `deckard verify ~/path/to/my/migration.up.sql` and deckard will verify that that migration has been ran. A word of warning: We simply check to ensure the metadata table contains a matching entry for the migration. Basically, deckard is only verifying that the migration has been applied in the "UP" position. It won't verify that the schema is currently matching the changes that were introduced in that migration.

#### The Ups and Downs of Deckard
Before we ever run an `up` or a `down` migration, we have to verify that a metadata table exists and create it if it does not.

Deckard uses this metadata to keep track of what has and has not been ran via Deckard. Deckard works best when all schema changes are ran via migrations, and can not infer changes made outside of the Deckard toolchain.

When we run an up migration, we validate our database state against our metadata to figure out which migrations need to be ran. The same goes with down migrations as well. Finally, the up and down migrations additionally create or remove a row in the metadata table. If, for some reason, Deckard was to blow up after running a query but before successfully modifying the metadata table, you'll be able to get deckard back on the right path with a 1 row update. I say this as a caveat, but I've not yet ran into this issue.

#### Running a select number of migrations
Often times, especially with Down migrations, you'll only want to run 1 migration, or maybe a set number of migrations. To do so, you can use the `steps` flag.
For example, If I only want to run the down query for the last migration ran, I can run:
```
deckard down --config=myconfig.deckard.yml --key=myDbKey --steps=1
```

## Contributing

#### Issues on Deckard
I use Github issues to track small improvements and work for Deckard. Additionally, issues are a great place for questions to be asked. Please check there if you have questions, concerns or are running into issues with the tool.

For now, throwaway DBs can be created via the following docker commands:

###### Postgres
```bash
docker run -e "POSTGRES_USER=test" -e "POSTGRES_PASSWORD=test" -e "POSTGRES_DB=test_db" -p "5432:5432" postgres
```

###### MySQL
```bash
docker run --name mysql -p "3306:3306" -e MYSQL_ROOT_PASSWORD=test -e MYSQL_DATABASE=test_db mysql:8
```

deckard

deckard Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

deckard

deckard Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README