sql-selectobject v0.0.9

sql-selectobject

Returns SQL Query of Select using an Object.

var select = require('sql-selectobject');
// select(<table>, <object>, <operator>, <separator>);

select('food', {'type': 'chocolate cake', 'brand': 'cadbury'}, '=', 'OR');
// {
//   "query": "SELECT * FROM \"food\" WHERE \"type\" = $1 OR \"brand\" = $2;",
//   "data": ["chocolate cake", "cadbury"]
// }

select('food', {'type': '%cake', 'brand': '%bakery'}, 'LIKE');
// {
//   "query": "SELECT * FROM \"food\" WHERE \"type\" LIKE $1 AND \"brand\" LIKE $2;",
//   "data": ["%cake", "%bakery"]
// }

select('food', {'price': 200}, '<');
// {
//   "query": "SELECT * FROM \"food\" WHERE \"price\" < $1;",
//   "data": [200]
// }

select('food', {'name': 'Patanjali Aam Biscuits'});
// {
//   "query": "SELECT * FROM \"food\" WHERE \"name\" = $1;",
//   "data": ["Patanjali Aam Biscuits"]
// }