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);
157 migration.addColumn('settings', 'limitTabs', {
158 type: Sequelize.INTEGER,
162 migration.addColumn('settings', 'disabledCookie', {
163 type: Sequelize.BOOLEAN,
167 migration.addColumn('settings', 'previewRecallmeReminderInterval', {
168 type: Sequelize.INTEGER,
174 migration.addColumn('cm_hopper', 'recallmeNotifiedDate', {
175 type: Sequelize.DATE,
180 // START voice_queues
181 migration.addColumn('voice_queues', 'dialPreviewRecallmeReminder', {
182 type: Sequelize.BOOLEAN,
187 // START cloud_providers
188 migration.changeColumn('cloud_providers', 'service', {
189 type: Sequelize.ENUM('AmazonAWS', 'Google', 'MicrosoftAzure')
192 migration.addColumn('cloud_providers', 'type', {
193 type: Sequelize.ENUM('Outlook365', 'Dynamics365'),
197 migration.addColumn('cloud_providers', 'data3', {
198 type: Sequelize.STRING,
202 migration.addColumn('cloud_providers', 'data4', {
203 type: Sequelize.STRING,
207 migration.addColumn('cloud_providers', 'data5', {
208 type: Sequelize.TEXT,
212 migration.addColumn('cloud_providers', 'data6', {
213 type: Sequelize.TEXT,
217 migration.addColumn('cloud_providers', 'data7', {
218 type: Sequelize.TEXT,
221 // END cloud_providers
223 // START mail_accounts
224 migration.addColumn('mail_accounts', 'provider', {
225 type: Sequelize.ENUM('gmail', 'hotmail', 'yahoo', 'outlook365'),
231 // START mail_servers_in
232 migration.query('UPDATE mail_servers_in SET host = \'imap.gmail.com\' WHERE service = \'gmail\' AND host IS NULL');
233 migration.query('UPDATE mail_servers_in SET port = 993 WHERE service = \'gmail\' AND port IS NULL');
235 migration.query('UPDATE mail_servers_in SET host = \'imap-mail.outlook.com\' WHERE service = \'hotmail\' AND host IS NULL');
236 migration.query('UPDATE mail_servers_in SET port = 993 WHERE service = \'hotmail\' AND port IS NULL');
238 migration.query('UPDATE mail_servers_in SET host = \'imap.mail.yahoo.com\' WHERE service = \'yahoo\' AND host IS NULL');
239 migration.query('UPDATE mail_servers_in SET port = 993 WHERE service = \'yahoo\' AND port IS NULL');
241 migration.query('UPDATE mail_servers_in SET host = \'outlook.office365.com\' WHERE service = \'outlook365\' AND host IS NULL');
242 migration.query('UPDATE mail_servers_in SET port = 993 WHERE service = \'outlook365\' AND port IS NULL');
244 migration.addColumn('mail_servers_in', 'modernAuthentication', {
245 type: Sequelize.BOOLEAN,
247 after: 'authentication'
250 migration.addColumn('mail_servers_in', 'CloudProviderId', {
251 type: Sequelize.INTEGER
254 migration.addIndex('mail_servers_in', ['CloudProviderId'], 'CloudProviderId');
256 migration.query('ALTER TABLE `mail_servers_in` ADD CONSTRAINT `mail_servers_in_ibfk_2` FOREIGN KEY (`CloudProviderId`) REFERENCES `cloud_providers`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE');
257 // END mail_servers_in
259 // START mail_servers_out
260 migration.query('UPDATE mail_servers_out SET host = \'smtp.gmail.com\' WHERE service = \'gmail\' AND host IS NULL');
261 migration.query('UPDATE mail_servers_out SET port = 465 WHERE service = \'gmail\' AND port IS NULL AND secure = 0');
262 migration.query('UPDATE mail_servers_out SET port = 587 WHERE service = \'gmail\' AND port IS NULL AND secure = 1');
264 migration.query('UPDATE mail_servers_out SET host = \'smtp-mail.outlook.com\' WHERE service = \'hotmail\' AND host IS NULL');
265 migration.query('UPDATE mail_servers_out SET port = 587 WHERE service = \'hotmail\' AND port IS NULL');
267 migration.query('UPDATE mail_servers_out SET host = \'smtp.mail.yahoo.com\' WHERE service = \'yahoo\' AND host IS NULL');
268 migration.query('UPDATE mail_servers_out SET port = 465 WHERE service = \'yahoo\' AND port IS NULL');
270 migration.query('UPDATE mail_servers_out SET host = \'smtp.office365.com\' WHERE service = \'outlook365\' AND host IS NULL');
271 migration.query('UPDATE mail_servers_out SET port = 587 WHERE service = \'outlook365\' AND port IS NULL');
273 migration.addColumn('mail_servers_out', 'modernAuthentication', {
274 type: Sequelize.BOOLEAN,
276 after: 'authentication'
279 migration.addColumn('mail_servers_out', 'CloudProviderId', {
280 type: Sequelize.INTEGER
283 migration.addIndex('mail_servers_out', ['CloudProviderId'], 'CloudProviderId');
285 migration.query('ALTER TABLE `mail_servers_out` ADD CONSTRAINT `mail_servers_out_ibfk_2` FOREIGN KEY (`CloudProviderId`) REFERENCES `cloud_providers`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE');
286 // END mail_servers_out
289 migration.final(resolve);
294 down: function(queryInterface, Sequelize) {
295 // var migration = new Migration(queryInterface);