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

let LikeDao = {
    selectByID: ID => {
        let sql = `SELECT * FROM like_or_dislike WHERE like_id = '${ID}'`
        return db.query(sql)
    },
    selectByUserID: UserID => {
        let sql = `SELECT * FROM like_or_dislike WHERE user_id = '${UserID}'`
        return db.query(sql)
    },
    selectByArticleID: ArticleID => {
        let sql = `SELECT * FROM like_or_dislike WHERE article_id = '${ArticleID}'`
        return db.query(sql)
    },
    insert: Like => {
        let createdAt = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss')
        sql = `insert into like_or_dislisk(create_time, user_id, article_id, like_type) values('${Like.CreatedAt}', '${UserID}', '${ArticleID}', '${createdAt}')`
        return db.query(sql)
    }
}

module.exports = LikeDao