Skip to content

Instantly share code, notes, and snippets.

@bjouhier
Last active April 6, 2016 21:49
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save bjouhier/f4f991895fbe62ab1972 to your computer and use it in GitHub Desktop.
Save bjouhier/f4f991895fbe62ab1972 to your computer and use it in GitHub Desktop.
"use strict";
exports.queryAll = function(conn, sql, args, cb) {
var allRows = [];
conn.execute(sql, args, {
resultSet: true
}, function(err, result) {
if (err) return cb(err);
function fetch() {
var max = 50;
result.resultSet.getRows(max, function(err, rows) {
if (err) return cb(err);
allRows.push(rows);
if (rows.length === max) {
fetch();
} else {
result.resultSet.close(function(err) {
if (err) return cb(err);
cb(null, Array.prototype.concat.apply([], allRows));
});
}
});
}
fetch();
});
}
@nethoncho
Copy link

Thanks for the queryAll example.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment