@sql-extra/insertinto v0.1.13

@sql-extra/insertinto

Generate SQL command for INSERT INTO.

const insertInto = require('@sql-extra/insertinto');
// insertInto.stream(<table>, <stream>, <parameters>, [options]) -> Promise (sql command)
// insertInto(<table>, <values>, <parameters>, [options])
// -> sql command

// options: {
//   pk: null  // primary key (on conflict): none
// }


var par = [];
insertInto('food', [{code: 'F1', name: 'Mango'}], par);
// INSERT INTO "food" ("code", "name") VALUES
// ($1, $2);
// par: [ 'F1', 'Mango' ]


insertInto('food', [{code: 'F1', name: 'Mango'}, {code: 'F2', name: 'Lychee'}], {pk: 'code'});
// INSERT INTO "food" ("code", "name") VALUES
// ($1, $2),
// ($3, $4)
// ON CONFLICT ("code") DO NOTHING;
// par: [ 'F1', 'Mango', 'F2', 'Lychee' ]