-import { waterfall, eachSeries } from 'async'
-import fs = require('fs')
-import path = require('path')
+import * as path from 'path'
+import * as Promise from 'bluebird'
-const db = require('./database')
+import { database as db } from './database'
import { LAST_MIGRATION_VERSION } from './constants'
-import { logger } from '../helpers'
-
-function migrate (finalCallback) {
- waterfall([
-
- function checkApplicationTableExists (callback) {
- db.sequelize.getQueryInterface().showAllTables().asCallback(function (err, tables) {
- if (err) return callback(err)
-
- // No tables, we don't need to migrate anything
- // The installer will do that
- if (tables.length === 0) return finalCallback(null)
-
- return callback(null)
- })
- },
-
- function loadMigrationVersion (callback) {
- db.Application.loadMigrationVersion(callback)
- },
-
- function createMigrationRowIfNotExists (actualVersion, callback) {
+import { logger, readdirPromise } from '../helpers'
+
+function migrate () {
+ const p = db.sequelize.getQueryInterface().showAllTables()
+ .then(tables => {
+ // No tables, we don't need to migrate anything
+ // The installer will do that
+ if (tables.length === 0) throw null
+ })
+ .then(() => {
+ return db.Application.loadMigrationVersion()
+ })
+ .then(actualVersion => {
if (actualVersion === null) {
- db.Application.create({
- migrationVersion: 0
- }, function (err) {
- return callback(err, 0)
- })
+ return db.Application.create({ migrationVersion: 0 }).then(() => 0)
}
- return callback(null, actualVersion)
- },
-
- function abortMigrationIfNotNeeded (actualVersion, callback) {
- // No need migrations
- if (actualVersion >= LAST_MIGRATION_VERSION) return finalCallback(null)
-
- return callback(null, actualVersion)
- },
+ return actualVersion
+ })
+ .then(actualVersion => {
+ // No need migrations, abort
+ if (actualVersion >= LAST_MIGRATION_VERSION) throw null
- function getMigrations (actualVersion, callback) {
+ return actualVersion
+ })
+ .then(actualVersion => {
// If there are a new migration scripts
logger.info('Begin migrations.')
- getMigrationScripts(function (err, migrationScripts) {
- return callback(err, actualVersion, migrationScripts)
- })
- },
+ return getMigrationScripts().then(migrationScripts => ({ actualVersion, migrationScripts }))
+ })
+ .then(({ actualVersion, migrationScripts }) => {
+ return Promise.each(migrationScripts, entity => executeMigration(actualVersion, entity))
+ })
+ .then(() => {
+ logger.info('Migrations finished. New migration version schema: %s', LAST_MIGRATION_VERSION)
+ })
+ .catch(err => {
+ if (err === null) return undefined
- function doMigrations (actualVersion, migrationScripts, callback) {
- eachSeries(migrationScripts, function (entity, callbackEach) {
- executeMigration(actualVersion, entity, callbackEach)
- }, function (err) {
- if (err) return callback(err)
+ throw err
+ })
- logger.info('Migrations finished. New migration version schema: %s', LAST_MIGRATION_VERSION)
- return callback(null)
- })
- }
- ], finalCallback)
+ return p
}
// ---------------------------------------------------------------------------
// ---------------------------------------------------------------------------
-function getMigrationScripts (callback) {
- fs.readdir(path.join(__dirname, 'migrations'), function (err, files) {
- if (err) return callback(err)
-
- const filesToMigrate = []
-
- files.forEach(function (file) {
- // Filename is something like 'version-blabla.js'
- const version = file.split('-')[0]
- filesToMigrate.push({
- version,
- script: file
+function getMigrationScripts () {
+ return readdirPromise(path.join(__dirname, 'migrations')).then(files => {
+ const filesToMigrate: {
+ version: string,
+ script: string
+ }[] = []
+
+ files
+ .filter(file => file.endsWith('.js.map') === false)
+ .forEach(file => {
+ // Filename is something like 'version-blabla.js'
+ const version = file.split('-')[0]
+ filesToMigrate.push({
+ version,
+ script: file
+ })
})
- })
- return callback(err, filesToMigrate)
+ return filesToMigrate
})
}
-function executeMigration (actualVersion, entity, callback) {
- const versionScript = parseInt(entity.version)
+function executeMigration (actualVersion: number, entity: { version: string, script: string }) {
+ const versionScript = parseInt(entity.version, 10)
// Do not execute old migration scripts
- if (versionScript <= actualVersion) return callback(null)
+ if (versionScript <= actualVersion) return undefined
// Load the migration module and run it
const migrationScriptName = entity.script
const migrationScript = require(path.join(__dirname, 'migrations', migrationScriptName))
- db.sequelize.transaction().asCallback(function (err, t) {
- if (err) return callback(err)
-
+ return db.sequelize.transaction(t => {
const options = {
transaction: t,
queryInterface: db.sequelize.getQueryInterface(),
sequelize: db.sequelize,
- Sequelize: db.Sequelize
+ db
}
- migrationScript.up(options, function (err) {
- if (err) {
- t.rollback()
- return callback(err)
- }
-
- // Update the new migration version
- db.Application.updateMigrationVersion(versionScript, t, function (err) {
- if (err) {
- t.rollback()
- return callback(err)
- }
- t.commit().asCallback(callback)
+ return migrationScript.up(options)
+ .then(() => {
+ // Update the new migration version
+ return db.Application.updateMigrationVersion(versionScript, t)
})
- })
})
}