Typeorm Migrate Sql - Generate Sql Files and Migrate

Typeorm Migrate Sql is a package that can generate new migrations in sql format and runs those generated migrations.

• MySQL
• MariaDB

You can install Typeorm Migrate Sql using npm, yarn, or pnpm.

# npm npm i typeorm-migrate-sql # yarn yarn add typeorm-migrate-sql # pnpm pnpm i typeorm-migrate-sql

Running our command via npx.

npx typeorm-migrate-sql help

We recommend that you add the following to package.json for convenience.

"scripts": { "migrate": "typeorm-migrate-sql" }

Then you may run the command like following.

npm run migrate -- help

npx typeorm-migrate-sql create add_user

The command creates two empty files called <timestamp>_add_user.up.sql and <timestamp>_add_user.down.sql in directory db/migrations. You can specify the directory via cli options.

npx typeorm-migrate-sql generate my_schema add_user

After modifying typeorm entities, you can run this command to generate two sql files called <timestamp>_add_user.up.sql and <timestamp>_add_user.down.sql in directory db/migrations. You can set connection options, location of entities, and the output directory via cli options.

npx typeorm-migrate-sql version my_schema

The command gets current migration version recorded in the database. Connection and some other options can be set via cli options.

# run either one npx typeorm-migrate-sql up my_schema npx typeorm-migrate-sql down my_schema npx typeorm-migrate-sql goto my_schema 1637690400000

These commands run migrations to a version. up applies an up migration, down applies a down migration, while goto migrates to the specific version. Similarly, options can be set via cli. Note that if the last migration failed, these commands will also fail.

The package is inspired by golang-migrate.

Contributing is welcome!

MIT

GitHub, npm, yarn