moonfishdotcom/drinkon-database — pull request #7 by spatte21 (2014-09-26 10:06:39+00:00)
Title: Added a gulp build process to construct and test the database scripts

This pull request fixes issue #1.

I've added a build folder that contains a gulp project to build and test the database (gulp is a node build tool). To set it up (having checked out this branch) go to the *build* folder and run npm install to download the dependencies.

You can run the following 3 builds:

`gulp create-script`

This will result in a create-database.sql script in the *new* folder (i.e. the root of the schema files)

`gulp run-script` also just `gulp` as its the default

This will create the script and then test it by running against a specified host. Any failures in the script will be reported in the build results. If successful the database will remain after the build completes. **This step will drop any existing database with the same name (see command line parameters below).**

`gulp clean`

This removes the database and the script.

To specify database settings, supply the following parameters:

`--user` the user to run the script as (mandatory for the run-script and clean tasks)
`--password` the password to use (optional, leaving it out implies a blank password)
`--host` the mySql host (optional, defaults to 127.0.0.1)
`--database` the database to create when testing (optional, defaults to test_drinkon)