execsql

execsql

An npm project. Node.js Execute you *.sql file which contains multiple sql statements. Usate: init database.

Usage

As a CLI tool

• Make sure that you have execsql installed globally

  npm install -g execsql
  

• Configure your db access for the first time

  execsql -c "localhost" "root" "root"
  

• Execute a bunch of sql statements

  execsql "use db_cam; delete from admin;"
  

• Execute a .sql file

  execsql -f ./db.sql
  

As a Node dependency

• Make sure that you have execsql installed locally

  npm install execsql
  

• Require and use

  var execsql = require('execsql'),
  	dbConfig = {
  		host: 'localhost',
  		user: 'root',
  		password: 'root'
  	},
  	sql = 'use db_cam;',
  	sqlFile = __dirname + '/db.sql';
  execsql.config(dbConfig)
  	.exec(sql)
  	.execFile(sqlFile, function(err, results){
  		console.log(results);
  	}).end();