execsql

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

Usage

As a CLI tool

1. Make sure that you have execsql installed globally

   npm install -g execsql

2. 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

1. Make sure that you have execsql installed locally

   npm install execsql

2. 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();