| import * as Knex from 'knex'; | |
| export async function up(knex: Knex): Promise<any> { | |
| return knex.schema.createTable('test_setup', (table: Knex.TableBuilder) => { | |
| table.integer('foobar'); | |
| }); | |
| } | |
| export async function down(knex: Knex): Promise<any> { | |
| return knex.schema.dropTable('test_setup'); | |
| } |
| require('ts-node/register'); | |
| module.exports = { | |
| client: 'pg', | |
| connection: process.env.DATABASE_URL, | |
| pool: { | |
| min: 2, | |
| max: 10 | |
| }, | |
| migrations: { | |
| tableName: 'knex_migrations', | |
| directory: 'migrations' | |
| }, | |
| timezone: 'UTC' | |
| }; |
| { | |
| "name": "my-app", | |
| "version": "0.0.1", | |
| "description": "", | |
| "main": "src/server.js", | |
| "private": true, | |
| "scripts": { | |
| "knex:migrate:make": "knex --knexfile src/database/knexfile.ts -x ts migrate:make", | |
| "knex:migrate:latest": "knex --knexfile src/database/knexfile.ts migrate:latest", | |
| "knex:migrate:rollback": "knex --knexfile src/database/knexfile.ts migrate:rollback" | |
| }, | |
| "dependencies": { | |
| "knex": "^0.16.3", | |
| "pg": "^7.9.0", | |
| "ts-node": "^8.1.0", | |
| "typescript": "^3.3.4000" | |
| } | |
| } |
This creates a .ts file in migrations directory
npm run knex:migrate:make -- some-migration-namenpm run knex:migrate:latestnpm run knex:migrate:rollbackknexfile.ts requires require('ts-node/register'); to work.require()s