3 const waterfall = require('async/waterfall')
4 const eachSeries = require('async/eachSeries')
5 const fs = require('fs')
6 const path = require('path')
8 const constants = require('./constants')
9 const db = require('./database')
10 const logger = require('../helpers/logger')
16 function migrate (finalCallback) {
19 function checkApplicationTableExists (callback) {
20 db.sequelize.getQueryInterface().showAllTables().asCallback(function (err, tables) {
21 if (err) return callback(err)
23 // No tables, we don't need to migrate anything
24 // The installer will do that
25 if (tables.length === 0) return finalCallback(null)
31 function loadMigrationVersion (callback) {
32 db.Application.loadMigrationVersion(callback)
35 function abortMigrationIfNotNeeded (actualVersion, callback) {
37 if (actualVersion >= constants.LAST_MIGRATION_VERSION) return finalCallback(null)
39 return callback(null, actualVersion)
42 function getMigrations (actualVersion, callback) {
43 // If there are a new migration scripts
44 logger.info('Begin migrations.')
46 getMigrationScripts(function (err, migrationScripts) {
47 return callback(err, actualVersion, migrationScripts)
51 function doMigrations (actualVersion, migrationScripts, callback) {
52 eachSeries(migrationScripts, function (entity, callbackEach) {
53 executeMigration(actualVersion, entity, callbackEach)
55 if (err) return callback(err)
57 logger.info('Migrations finished. New migration version schema: %s', constants.LAST_MIGRATION_VERSION)
64 // ---------------------------------------------------------------------------
66 module.exports = migrator
68 // ---------------------------------------------------------------------------
70 function getMigrationScripts (callback) {
71 fs.readdir(path.join(__dirname, 'migrations'), function (err, files) {
72 if (err) return callback(err)
74 const filesToMigrate = []
76 files.forEach(function (file) {
77 // Filename is something like 'version-blabla.js'
78 const version = file.split('-')[0]
85 return callback(err, filesToMigrate)
89 function executeMigration (actualVersion, entity, callback) {
90 const versionScript = parseInt(entity.version)
92 // Do not execute old migration scripts
93 if (versionScript <= actualVersion) return callback(null)
95 // Load the migration module and run it
96 const migrationScriptName = entity.script
97 logger.info('Executing %s migration script.', migrationScriptName)
99 const migrationScript = require(path.join(__dirname, 'migrations', migrationScriptName))
101 db.sequelize.transaction().asCallback(function (err, t) {
102 if (err) return callback(err)
106 queryInterface: db.sequelize.getQueryInterface(),
107 sequelize: db.sequelize,
108 Sequelize: db.Sequelize
110 migrationScript.up(options, function (err) {
116 // Update the new migration version
117 db.Application.updateMigrationVersion(versionScript, t, function (err) {
123 t.commit().asCallback(callback)