var db = require('./db');

var Akismetor = require('../services/akismetor');

var Comments = {

// Returns all comments by article with user information.

findByArticleId(id, cb) {

db.query('SELECT c.id, c.created_at, c.body, u.avatar_url, u.name FROM comments as c JOIN users as u on u.id = c.user_id WHERE c.article_id = $1 AND approved = true ORDER BY created_at ASC;', [ id ], cb)

},

findByCommentId(id, cb) {

db.query('SELECT c.id, c.created_at, c.body, u.avatar_url, u.name FROM comments as c JOIN users as u on u.id = c.user_id WHERE c.id = $1 AND approved = true ORDER BY created_at ASC;', [ id ], cb)

},

// Creates a new comment

create(newComment, cb) {

var approved = newComment.isSpam ? false : true;

db.query(

"INSERT INTO comments (user_id, approved, body, article_id) VALUES ($1, $2, $3, (SELECT id FROM articles WHERE slug = $4)) RETURNING id;",

[newComment.userId, approved, newComment.body, newComment.slug],

cb

);

}

}

module.exports = Comments;