NodeJS SQL DDL Synchronization
npm install sql-ddl-sync
This 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.
orm & the required driver (eg:
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 = ;var mysql = ;var Sync = Sync;orm;
To test, first make sure you have development dependencies installed. Go to the root folder and do:
Then, just run the tests.
If you have a supported database server and want to test against it, first install the module:
# if you have a mysql servernpm install mysql# if you have a postgresql servernpm install pg
And then run:
node test/run-db --uri 'mysql://username:password@localhost/database'