sql-deleteobject v0.0.8

sql-deleteobject

Returns SQL Query of Delete using an Object.

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

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

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

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

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