stringtree-migrate-driver-mysql

A MySQL driver for stringtree-migrate - the simple, flexible, database-independent, way to manage automated schema updates.

Installation

$ npm install stringtree-migrate-driver-mysql

Usage Example:

 var config = {
   host: 'localhost', port: 3306,
   database: 'test', user: 'uu', password: 'pp'
 };
 var scripts = [
   { level: 1, up: "create table ugh ( aa int )" },
   { level: 23, up: [
       "insert into ugh (aa) values (33)",
       "insert into ugh (aa) values (44)"
     ]
   }
 ];

 var driver = require('stringtree-migrate-driver-mysql')(config);
 var migrate = require('stringtree-migrate')(driver, scripts);
 ...
 // ensure database is at level 23 or greater
 migrate.ensure(23, function(err, level) {
   .. code that needs the db ..;
 });
 
 ..or
  
 // ensure database has had all available updates applied
 migrate.ensure(function(err, level) {
   .. code that needs the db ..;
 });

For more details, see https://github.com/stringtree/stringtree-migrate

Configuration

The supplied config parameter is passed direct to the createPool method of node-mysql, so anything supported there is available. As a practical minimum, you should supply the connection details and credentials for your database, as shown in the example.

Related resources

• https://github.com/stringtree/stringtree-migrate
• https://github.com/stringtree/stringtree-migrate-driver-testsuite