sql-insertobject v0.0.8

sql-insertobject

Returns SQL Query of Insert using an Object.

var insert = require('sql-insertobject');
// insert(<table>, <object>);

insert('food', {'id': 'beans', 'mass': 'light'});
// {
//   "query": "INSERT INTO \"food\" (\"id\", \"mass\") VALUES ($1, $2);",
//   "data": ["beans", "light"]
// }

insert('food', {'id': 'dal', 'mass': null});
// {
//   "query": "INSERT INTO \"food\" (\"id\", \"mass\") VALUES ($1, $2);",
//   "data": ["dal", null]
// }

insert('food', {'id': 'cake'});
// {
//   "query": "INSERT INTO \"food\" (\"id\") VALUES ($1);",
//   "data": ["cake"]
// }