Quick Start

$ npm install json-sql

varjsonSql=require('json-sql')();varsql=jsonSql.build({type:'select',table:'users',fields:['name','age'],condition:{name:'Max',id:6}});sql.query// sql string:// select name, age from users where name = $p1 && id = 6;sql.values// hash of values:// { p1: 'Max' }

Documentation

Examples

varsql=jsonSql.build({type:'select',table:'users',join:{documents:{on:{'user.id':'documents.userId'}}}});sql.query// select * from users join documents on user.id = documents.userId;sql.values// {}

varsql=jsonSql.build({type:'insert',table:'users',values:{name:'John',lastname:'Snow',age:24,gender:'male'}});sql.query// insert into users (name, lastname, age, gender) values ($p1, $p2, 24, $p3);sql.values// { p1: 'John', p2: 'Snow', p3: 'male' }

varsql=jsonSql.build({type:'update',table:'users',condition:{id:5},modifier:{role:'admin'age:33}});sql.query// update users set role = $p1, age = 33 where id = 5;sql.values// { p1: 'admin' }

varsql=jsonSql.build({type:'remove',table:'users',condition:{id:5}});sql.query// delete from users where id = 5;sql.values// {}

Tests

$ npm install

$ gulptest

$ gulp coverage

License