exports.getExpenses = function getExpenses(user, callback) {
db.queryDB({
sql: 'SELECT id, title, description, type, date, user_id, created, updated FROM expense'
},
callback);
}
function linkKeyArt (keyID, artID, callback) {
var artKeyQuery = 'INSERT INTO keyArt (keyID, artID) ' +
'VALUES ("' + keyID + '", "' + artID + '")';
db.queryDB (artKeyQuery, function (err, rows) {
if (err) return callback (err);
return callback (null);
});
}
async.times (words.length, function (n, next) {
var term = db.escape (words[n].term);
var count = words[n].tf;
var query = 'INSERT INTO words (word, artID, count) ' +
'VALUES ("' + term + '", "' + artID + '", "' + count + '")';
db.queryDB (query, function (err, rows) {
return next (err);
});
},
function insertArticle (article, callback) {
article.title = db.escape (article.title);
var artQuery = 'INSERT INTO articles (title, date, url, wordcount, site) ' +
'VALUES ("' + article.title + '", "' + article.date + '", "' +
article.url + '", "' + article.wordCount + '", "' +
article.site + '")';
db.queryDB (artQuery, function (err, rows) {
if (err) return callback (err);
return callback (null, rows.insertId);
});
}