# moving.co CLI

A CLI to move sql databases around.

## :white_check_mark: Prerequisites

You will need...

### Node.js 14+

* OSX: `brew install node` using [Homebrew](http://brew.sh/)
* Linux: `apt install nodejs` ([see Ubuntu/Debian specific instructions](https://nodejs.org/en/download/package-manager/#debian-and-ubuntu-based-linux-distributions)) or `pacman -S nodejs` (Arch Linux)
* Windows: [Install](https://nodejs.org/en/download/)

## :package: Installation

1. Please enter your dB details in the `.env.sample` file, and rename to `.env`
2. Add entries for the `POST_TYPES` you're interested in
2. Add any custom `METAKEYS` associated with your posts
3. Start up the seed container using `docker-compose up -d`
4. Load your dirty database `docker exec -i scratch-mariadb mysql -uroot -proot --database=unclean < ./dump.sql`

## :electric_plug: Run

1. Run `npm get` to grab data-models from your existing database
2. Run `npm run migrate` to create tables from data-models in a temproary sqlite database

## :robot: Deployment

TBD

## :pill: Tests & Code Quality

TBD

## :heart: Built With

* [Sequelize](https://sequelize.org/) - an ORM tool
* [Umzug](https://github.com/sequelize/umzug) - Migration tracking