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, options) {
65 this.sequence.enqueue(function() {
66 return _this.queryInterface
67 .addIndex(table, column, {
68 indexName: options.indexName,
69 indicesType: options.indicesType
72 logger.info('addIndex %s %s %s [%s]', table, column.join(','), options.indexName, options.indicesType);
74 .catch(function(err) {
75 logger.info(JSON.stringify(err));
80 Migration.prototype.removeIndex = function(table, indexName) {
82 this.sequence.enqueue(function() {
83 return _this.queryInterface
84 .removeIndex(table, indexName)
86 logger.info('removeIndex %s %s', table, indexName);
88 .catch(function(err) {
89 logger.info(JSON.stringify(err));
94 Migration.prototype.query = function(sql) {
96 this.sequence.enqueue(function() {
97 return _this.queryInterface.sequelize
100 logger.info('query %s', sql);
102 .catch(function(err) {
103 logger.info(JSON.stringify(err));
108 Migration.prototype.removeColumn = function(table, column) {
110 this.sequence.enqueue(function() {
111 return _this.queryInterface
112 .removeColumn(table, column)
114 logger.info('Removed column %s from %s', column, table);
116 .catch(function(err) {
127 Migration.prototype.renameColumn = function(table, oldColumn, newColumn) {
129 this.sequence.enqueue(function() {
130 return _this.queryInterface
131 .renameColumn(table, oldColumn, newColumn)
133 logger.info('Renamed column from %s to %s on %s', oldColumn, newColumn, table);
135 .catch(function(err) {
146 Migration.prototype.final = function(resolve) {
147 this.sequence.enqueue(function() {
153 up: function(queryInterface, Sequelize) {
154 return new BPromise(function(resolve) {
155 var migration = new Migration(queryInterface);
158 migration.renameColumn('users', 'phoneBarEnableVideoRecording', 'phoneBarEnableScreenRecordingByAgent');
160 migration.addColumn('users', 'phoneBarEnableAutomaticScreenRecording', {
161 type: Sequelize.BOOLEAN,
165 migration.addColumn('users', 'screenrecording', {
166 type: Sequelize.BOOLEAN,
171 // START chat_messages
172 migration.addIndex("chat_messages", ["body"], {
173 indexName: "fti_chat_messages",
174 indicesType: "FULLTEXT"
178 // START mail_interactions
179 migration.addIndex("mail_interactions", ["subject", "to"], {
180 indexName: "fti_mail_interactions",
181 indicesType: "FULLTEXT"
184 migration.addColumn("mail_interactions", "lastMsgText", {
185 type: Sequelize.TEXT("tiny"),
188 // END mail_interactions
190 // START mail_messages
191 migration.addColumn("mail_messages", "plainBody", {
192 type: Sequelize.TEXT("medium"),
196 migration.addIndex("mail_messages", ["plainBody", "subject"], {
197 indexName: "fti_mail_messages",
198 indicesType: "FULLTEXT"
202 // START openchannel_messages
203 migration.addIndex("openchannel_messages", ["body"], {
204 indexName: "fti_openchannel_messages",
205 indicesType: "FULLTEXT"
207 // END openchannel_messages
209 // START sms_messages
210 migration.addIndex("sms_messages", ["body"], {
211 indexName: "fti_sms_messages",
212 indicesType: "FULLTEXT"
215 // START chat_applications
216 migration.query('ALTER TABLE chat_applications CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
217 // END chat_applications
219 // START fax_applications
220 migration.query('ALTER TABLE fax_applications CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
221 // END fax_applications
223 // START mail_applications
224 migration.query('ALTER TABLE mail_applications CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
225 // END mail_applications
227 // START openchannel_applications
228 migration.query('ALTER TABLE openchannel_applications CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
229 // END openchannel_applications
231 // START sms_applications
232 migration.query('ALTER TABLE sms_applications CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
233 // END sms_applications
236 migration.final(resolve);
241 down: function(queryInterface, Sequelize) {
242 // var migration = new Migration(queryInterface);