db-migrate - npm Package Compare versions

Comparing version 0.3.2 to 0.4.0

CHANGELOG.md

@@ -112,1 +112,13 @@ ## 0.1.0
   - Update error message when using an invalid data type #67 (via @swang)
+
+## 0.4.0
+
+New Feature:
+  - Added support for renameColumn in MySQL #80 (via @akinnunen)
+
+Improvement:
+  - Added --version flag #73 (via @mcandre)
+  - Lazily require migrations #77, #78 (via @btakita)
+
+Fix
+  - Fixed typo in lib/driver/pg.js for BLOB datatype #76

lib/driver/mysql.js

@@ -135,4 +135,11 @@ var util = require('util');
   },
-//  renameColumn: function(tableName, oldColumnName, newColumnName, callback) {
-//  },
+  
+  renameColumn: function(tableName, oldColumnName, newColumnName, callback) {
+    var self = this, columnTypeSql = util.format("SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '%s' AND COLUMN_NAME = '%s'", tableName, oldColumnName);
+    this.all(columnTypeSql, function(err, result) {
+      var columnType = result[0].COLUMN_TYPE; 
+      var alterSql = util.format("ALTER TABLE %s CHANGE %s %s %s", tableName, oldColumnName, newColumnName, columnType);
+      self.runSql(alterSql, callback);
+    });
+  },
 
@@ -139,0 +146,0 @@ changeColumn: function(tableName, columnName, columnSpec, callback) {

lib/driver/pg.js

@@ -36,3 +36,3 @@ var util = require('util');
             return 'TIMESTAMP';
-          case type.BLOG:
+          case type.BLOB:
             return 'BYTEA';
@@ -39,0 +39,0 @@ }

lib/driver/sqlite3.js

@@ -79,2 +79,6 @@ var util = require('util');
   } else {
+    if (typeof(config.filename) === 'undefined') {
+      console.error('filename is required in database.json');
+      return;
+    }
     var db = new sqlite3.Database(config.filename, mode);
@@ -81,0 +85,0 @@ db.on("error", callback);

lib/migration.js

@@ -78,9 +78,13 @@ var fs = require('fs');
     this.title = parseTitle(this.name);
-
-    var migrationFile = require(this.path);
-    this._up = migrationFile.up;
-    this._down = migrationFile.down;
   }
 };
 
+Migration.prototype._up = function() {
+  return require(this.path).up.apply(this, arguments);
+};
+
+Migration.prototype._down = function() {
+  return require(this.path).down.apply(this, arguments);
+};
+
 Migration.prototype.write = function(callback) {
@@ -87,0 +91,0 @@ fs.writeFile(this.path, migrationTemplate, callback);

package.json

@@ -14,3 +14,3 @@ {
   ],
-  "version": "0.3.2",
+  "version": "0.4.0",
   "engines": {
@@ -46,7 +46,8 @@ "node": ">=0.6.0"
     "mkdirp": "~0.3.4",
-    "moment": "~1.7.2"
+    "moment": "~1.7.2",
+    "pkginfo": "~0.3.0"
   },
   "devDependencies": {
     "vows": "~0.6.2",
-    "db-meta": "~0.4.0"
+    "db-meta": "~0.4.1"
   },
@@ -53,0 +54,0 @@ "scripts": {

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Lines of code

1515

increased by0.87%

Worsened metrics

Total package byte prevSize

74532

decreased by-27.66%

Dependency count

6

increased by20%

Number of package files

20

decreased by-33.33%

Number of low supply chain risk alerts

8

increased by14.29%

Dependency changes

• + Addedpkginfo@~0.3.0

• + Addedpkginfo@0.3.1(transitive)