3 var BPromise = require('bluebird');
4 var util = require('util');
6 var logger = require('../config/logger')('migration');
8 var Sequence = function() {};
10 Sequence.prototype.enqueue = function(fn) {
11 this.tail = this.tail ? this.tail.finally(fn) : fn();
14 var Migration = function(queryInterface) {
15 this.queryInterface = queryInterface;
16 this.sequence = new Sequence();
19 Migration.prototype.changeColumn = function(table, column, type) {
21 this.sequence.enqueue(function() {
22 return _this.queryInterface
23 .changeColumn(table, column, type)
25 logger.info('Changed column %s in table %s', column, table);
27 .catch(function(err) {
28 logger.info(JSON.stringify(err));
33 Migration.prototype.addColumn = function(table, column, type) {
35 this.sequence.enqueue(function() {
36 return _this.queryInterface
37 .addColumn(table, column, type)
39 logger.info('Added column %s to %s', column, table);
41 .catch(function(err) {
42 logger.info(JSON.stringify(err));
47 Migration.prototype.dropTable = function(table) {
49 this.sequence.enqueue(function() {
50 return _this.queryInterface
55 logger.info('table dropped %s', table);
57 .catch(function(err) {
58 logger.info(JSON.stringify(err));
63 Migration.prototype.addIndex = function(table, column, indexName) {
65 this.sequence.enqueue(function() {
66 return _this.queryInterface
67 .addIndex(table, column, {
71 logger.info('addIndex %s %s %s', table, column.join(','), indexName);
73 .catch(function(err) {
74 logger.info(JSON.stringify(err));
79 Migration.prototype.removeIndex = function(table, indexName) {
81 this.sequence.enqueue(function() {
82 return _this.queryInterface
83 .removeIndex(table, indexName)
85 logger.info('removeIndex %s %s', table, indexName);
87 .catch(function(err) {
88 logger.info(JSON.stringify(err));
93 Migration.prototype.query = function(sql) {
95 this.sequence.enqueue(function() {
96 return _this.queryInterface.sequelize
99 logger.info('query %s', sql);
101 .catch(function(err) {
102 logger.info(JSON.stringify(err));
107 Migration.prototype.removeColumn = function(table, column) {
109 this.sequence.enqueue(function() {
110 return _this.queryInterface
111 .removeColumn(table, column)
113 logger.info('Removed column %s from %s', column, table);
115 .catch(function(err) {
126 Migration.prototype.renameColumn = function(table, oldColumn, newColumn) {
128 this.sequence.enqueue(function() {
129 return _this.queryInterface
130 .renameColumn(table, oldColumn, newColumn)
132 logger.info('Renamed column from %s to %s on %s', oldColumn, newColumn, table);
134 .catch(function(err) {
145 Migration.prototype.final = function(resolve) {
146 this.sequence.enqueue(function() {
152 up: function(queryInterface, Sequelize) {
153 return new BPromise(function(resolve) {
154 var migration = new Migration(queryInterface);
156 //START mail_interactions
157 migration.query('ALTER TABLE mail_interactions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;');
158 //END mail_interactions
160 // START analytics_custom_reports
161 migration.query('UPDATE analytics_custom_reports SET joins = REPLACE(joins,\'"type":"outer_join"\',\'"type":"left_join"\') WHERE joins LIKE \'%"type":"outer_join"%\'');
162 // END analytics_custom_reports
164 // START square_projects
165 migration.query('UPDATE square_projects SET preproduction = REPLACE(preproduction,\'labelBackgroundColor=#ffffff;\',\'\')');
166 migration.query('UPDATE square_projects SET production = REPLACE(production,\'labelBackgroundColor=#ffffff;\',\'\')');
167 // END square_projects
169 // START mandatoryDisposition
170 migration.addColumn('voice_queues', 'mandatoryDisposition', {
171 type: Sequelize.BOOLEAN,
174 migration.addColumn('voice_queues', 'mandatoryDispositionPauseId', {
175 type: Sequelize.INTEGER
177 migration.query('ALTER TABLE voice_queues \
178 ADD CONSTRAINT `voice_queues_ibfk_4` \
179 FOREIGN KEY (`mandatoryDispositionPauseId`) \
180 REFERENCES tools_pauses(`id`) \
184 migration.addColumn('chat_websites', 'mandatoryDisposition', {
185 type: Sequelize.BOOLEAN,
188 migration.addColumn('chat_websites', 'mandatoryDispositionPauseId', {
189 type: Sequelize.INTEGER
191 migration.query('ALTER TABLE chat_websites \
192 ADD CONSTRAINT `chat_websites_ibfk_3` \
193 FOREIGN KEY (`mandatoryDispositionPauseId`) \
194 REFERENCES tools_pauses(`id`) \
199 migration.addColumn('fax_accounts', 'mandatoryDisposition', {
200 type: Sequelize.BOOLEAN,
203 migration.addColumn('fax_accounts', 'mandatoryDispositionPauseId', {
204 type: Sequelize.INTEGER
206 migration.query('ALTER TABLE fax_accounts \
207 ADD CONSTRAINT `fax_accounts_ibfk_3` \
208 FOREIGN KEY (`mandatoryDispositionPauseId`) \
209 REFERENCES tools_pauses(`id`) \
214 migration.addColumn('mail_accounts', 'mandatoryDisposition', {
215 type: Sequelize.BOOLEAN,
218 migration.addColumn('mail_accounts', 'mandatoryDispositionPauseId', {
219 type: Sequelize.INTEGER
221 migration.query('ALTER TABLE mail_accounts \
222 ADD CONSTRAINT `mail_accounts_ibfk_3` \
223 FOREIGN KEY (`mandatoryDispositionPauseId`) \
224 REFERENCES tools_pauses(`id`) \
229 migration.addColumn('openchannel_accounts', 'mandatoryDisposition', {
230 type: Sequelize.BOOLEAN,
233 migration.addColumn('openchannel_accounts', 'mandatoryDispositionPauseId', {
234 type: Sequelize.INTEGER
236 migration.query('ALTER TABLE openchannel_accounts \
237 ADD CONSTRAINT `openchannel_accounts_ibfk_2` \
238 FOREIGN KEY (`mandatoryDispositionPauseId`) \
239 REFERENCES tools_pauses(`id`) \
244 migration.addColumn('sms_accounts', 'mandatoryDisposition', {
245 type: Sequelize.BOOLEAN,
248 migration.addColumn('sms_accounts', 'mandatoryDispositionPauseId', {
249 type: Sequelize.INTEGER
251 migration.query('ALTER TABLE sms_accounts \
252 ADD CONSTRAINT `sms_accounts_ibfk_2` \
253 FOREIGN KEY (`mandatoryDispositionPauseId`) \
254 REFERENCES tools_pauses(`id`) \
259 // END mandatoryDisposition
262 migration.final(resolve);
267 down: function(queryInterface, Sequelize) {
268 // var migration = new Migration(queryInterface);