package
NodeJS SQL DDL Synchronization
npm install sql-ddl-syncGitHub-flavored package documentation.
Across all versions, last 30 days.
17,530 in 30 days
Runtime metadata.
Tagged topics.
Estimated unpacked size across 2 packages.
1.4 MB
Includes dependencies.
npm install sql-ddl-syncThis module is part of ORM. It's used synchronize model tables in supported dialects. Sorry there is no API documentation for now but there are a couple of tests you can read and find out how to use it if you want.
Install orm & the required driver (eg: mysql).
Create a file with the contents below and change insert your database credentials.
Run once and you'll see table ddl_sync_test appear in your database. Then make some changes to it (add/drop/change columns)
and run the code again. Your table should always return to the same structure.
var orm = require("orm");
var mysql = require("mysql");
var Sync = require("sql-ddl-sync").Sync;
orm.connect("mysql://username:password@localhost/database", function (err, db) {
if (err) throw err;
var driver = db.driver;
var sync = new Sync({
dialect : "mysql",
driver : driver,
debug : function (text) {
console.log("> %s", text);
}
{ type: 'uuid', defaultExpression: 'uuid_generate_v4()' }To test, first make sure you have development dependencies installed. Go to the root folder and do:
npm installThen, just run the tests.
npm testIf you have a supported database server and want to test against it, first install the module:
# if you have a mysql server
npm install mysql
# if you have a postgresql server
npm install pgAnd then run:
node test/run-db --uri 'mysql://username:password@localhost/database'dresende
dresende@thinkdigital.pt