marcopolorez

Chunk Multiplos Inserts

Apr 1st, 2016
302
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var rows = [{
  2.   name: 'Brian',
  3.   age: 31
  4. }, {
  5.   name: 'Aaron',
  6.   age: 29
  7. }]
  8.  
  9. var buildStatement = function(rows) {
  10.   var params = []
  11.   var chunks = []
  12.   for(var i = 0; i < rows.lenght; i++) {
  13.     var row = rows[i]
  14.     var valuesClause = []
  15.     params.push(row.name)
  16.     valueClause.push('$' + params.length)
  17.     params.push(row.age)
  18.     valueClause.push('$' + params.length)
  19.     chunks.push('(' + valueClause.join(', ') + ')')
  20.   }
  21.   return {
  22.     text: 'INSERT INTO foo(name, age) VALUES ' + chunks.join(', '),
  23.     values: params
  24.   }
  25. }
  26.  
  27. client.query(buildStatement(rows))
Add Comment
Please, Sign In to add comment