Dumps stuff into MySQL

import-sql.js

var child_process = require('child_process');
var ConnectionConfig = require('mysql/lib/ConnectionConfig');

// first argument = mysql://whatever.com/whatevs
// second argument = string of sql file
module.exports = function(url, sqlData, cb) {
  var opt = ConnectionConfig.parseUrl(url);

  var args = [];
  if (opt.user) args.push("--user="+opt.user);
  if (opt.password) args.push("--password="+opt.password);

  var stderr = "";
  var stdout = "";

  var proc = child_process.spawn("mysql", args);
  proc.stdout.on('data', function(data){
    stdout += String(data);
  });
  proc.stderr.on('data', function(data){
    stderr += String(data);
  });
  proc.on('exit', function(code){
    if (code !== 1) {
      return cb(new Error(stderr));
    }
    cb(null, stdout, code);
  });

  proc.stdin.write("CREATE DATABASE "+opt.database+";\n");
  proc.stdin.write("USE "+opt.database+";\n");
  proc.stdin.write(String(sqlData));
  proc.stdin.end();
};