const db = require('../config/mysqlConfig')
const moment = require('moment')

let CommentDao = {
    selectByID: ID => {
        let sql = `SELECT * FROM comment WHERE comment_id = '${ID}'`
        return db.query(sql)
    },
    selectByUserID: UserID => {
        let sql = `SELECT * FROM comment WHERE user_id = '${UserID}'`
        return db.query(sql)
    },
    selectByArticleID: ArticleID => {
        let sql = `SELECT * FROM comment WHERE article_id = '${ArticleID}'`
        return db.query(sql)
    },
    update: Comment => {
        let createdAt = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss')
        let sql = `UPDATE comment SET content = '${Comment.Content}' , update_time = '${createdAt}' `;
        sql += `WHERE comment_id = '${Comment.CommentID}'` 
        return db.query(sql)
    },
    insert: Comment => {
        let createdAt = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss')
        let sql = `INSERT INTO comment(article_id, user_id, content, create_time, update_time) values('${Comment.ArticleID}', '${Comment.UserID}', '${Comment.Content}', '${createdAt}', '${createdAt}')`
        db.query(sql)
    }
}

module.exports = CommentDao