sql-ddl-sync - npm Package Compare versions

Comparing version 0.3.17 to 0.3.18

Changelog.md

@@ -0,4 +1,7 @@
+### v0.3.18 - 2022-01-11
+- Add support for `defaultExpression` ie. `uuid()` for [MySQL 8.0.13+](https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html)
+
 ### v0.3.17 - 2022-01-10
 - Add UUID support for PostgreSQL
-- Add support for `defaultExpression` ie. `uuid_generate_v4()`
+- Add support for `defaultExpression` ie. `uuid_generate_v4()` for PostgreSQL
 
@@ -5,0 +8,0 @@ ### v0.3.16 - 2019-11-04

lib/Dialects/mysql.js

@@ -287,2 +287,5 @@ var SQL  = require("../SQL");
 	}
+	if (property.hasOwnProperty("defaultExpression")) {
+		type += " DEFAULT (" + property.defaultExpression + ")";
+	}
 
@@ -289,0 +292,0 @@ return {

package.json

@@ -13,3 +13,3 @@ {
 	],
-	"version": "0.3.17",
+	"version": "0.3.18",
 	"license": "MIT",
@@ -16,0 +16,0 @@ "repository": "http://github.com/dresende/node-sql-ddl-sync.git",

test/integration/mysql.js

@@ -90,2 +90,9 @@ var should  = require("should");
 	});
+
+	it("should detect default expressions", function () {
+		should.equal(
+			Dialect.getType(null, { mapsTo: 'abc', type: 'text', defaultExpression: 'uuid()' }, driver).value,
+			'VARCHAR(255) DEFAULT (uuid())'
+		);
+	});
 });

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

Total package byte prevSize

72364

increased by0.71%

Lines of code

2084

increased by0.43%

No dependency changes