Built motion from commit (unavailable).|2.5.26

[motion2.git] / server / migrations / 2.5.25.js

diff --git a/server/migrations/2.5.25.js b/server/migrations/2.5.25.js
new file mode 100644 (file)
index 0000000..998c0d6
--- /dev/null
+++ b/server/migrations/2.5.25.js
@@ -0,0 +1,172 @@
+'use strict';\r
+\r
+var BPromise = require('bluebird');\r
+var util = require('util');\r
+\r
+var logger = require('../config/logger')('migration');\r
+\r
+var Sequence = function () { };\r
+\r
+Sequence.prototype.enqueue = function (fn) {\r
+  this.tail = this.tail ? this.tail.finally(fn) : fn();\r
+};\r
+\r
+var Migration = function (queryInterface) {\r
+  this.queryInterface = queryInterface;\r
+  this.sequence = new Sequence();\r
+};\r
+\r
+Migration.prototype.changeColumn = function (table, column, type) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .changeColumn(table, column, type)\r
+      .then(function () {\r
+        logger.info('Changed column %s in table %s', column, table);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(JSON.stringify(err));\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.addColumn = function (table, column, type) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .addColumn(table, column, type)\r
+      .then(function () {\r
+        logger.info('Added column %s to %s', column, table);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(JSON.stringify(err));\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.dropTable = function (table) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .dropTable(table, {\r
+        force: true\r
+      })\r
+      .then(function () {\r
+        logger.info('table dropped %s', table);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(JSON.stringify(err));\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.addIndex = function (table, column, indexName) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .addIndex(table, column, {\r
+        indexName: indexName\r
+      })\r
+      .then(function () {\r
+        logger.info('addIndex %s %s %s', table, column.join(','), indexName);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(JSON.stringify(err));\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.removeIndex = function (table, indexName) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .removeIndex(table, indexName)\r
+      .then(function () {\r
+        logger.info('removeIndex %s %s', table, indexName);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(JSON.stringify(err));\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.query = function (sql) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface.sequelize\r
+      .query(sql)\r
+      .then(function () {\r
+        logger.info('query %s', sql);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(JSON.stringify(err));\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.removeColumn = function (table, column) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .removeColumn(table, column)\r
+      .then(function () {\r
+        logger.info('Removed column %s from %s', column, table);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(\r
+          util.inspect(err, {\r
+            showHidden: false,\r
+            depth: null\r
+          })\r
+        );\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.renameColumn = function (table, oldColumn, newColumn) {\r
+  var _this = this;\r
+  this.sequence.enqueue(function () {\r
+    return _this.queryInterface\r
+      .renameColumn(table, oldColumn, newColumn)\r
+      .then(function () {\r
+        logger.info('Renamed column from %s to %s on %s', oldColumn, newColumn, table);\r
+      })\r
+      .catch(function (err) {\r
+        logger.info(\r
+          util.inspect(err, {\r
+            showHidden: false,\r
+            depth: null\r
+          })\r
+        );\r
+      });\r
+  });\r
+};\r
+\r
+Migration.prototype.final = function (resolve) {\r
+  this.sequence.enqueue(function () {\r
+    return resolve();\r
+  });\r
+};\r
+\r
+module.exports = {\r
+  up: function (queryInterface, Sequelize) {\r
+    return new BPromise(function (resolve) {\r
+      var migration = new Migration(queryInterface);\r
+      \r
+      // START settings\r
+      migration.addColumn('settings', 'stopRecordingOnTransfer', {\r
+        type: Sequelize.BOOLEAN,\r
+        defaultValue: false\r
+      });\r
+      // END settings\r
+\r
+      // START FINAL\r
+      migration.final(resolve);\r
+      // END FINAL\r
+    });\r
+  },\r
+\r
+  down: function (queryInterface, Sequelize) {\r
+    // var migration = new Migration(queryInterface);\r
+  }\r
+};\r