/**
 * 文章model
 * @author: leo <qi.li@yoho.cn>
 * @date: 28/06/2017
 */

const _ = require('lodash');
const mysqlCli = global.yoho.utils.mysqlCli;

const TABLE_ACT_ARTICLE = 'act_article';

class ArticleModel extends global.yoho.BaseModel {
    constructor(ctx) {
        super(ctx);
    }

    /**
     * 获取所有文章
     * @returns {*}
     */
    allArticles() {
        return mysqlCli.query(`select * from ${TABLE_ACT_ARTICLE}`);
    }

    /**
     * 发表文章
     * @param content
     * @returns {*}
     */
    createArticle({content}) {
        const session = this.ctx.req.session;
        const userId = _.get(session, 'user.id');

        return mysqlCli.insert(
            `insert into ${TABLE_ACT_ARTICLE} (user_id, content) values (:userId, :content);`,
            {
                userId,
                content
            }
        );
    }
}

module.exports = ArticleModel;