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

const mysqlCli = global.yoho.utils.mysqlCli;

const TABLE_ACT_ARTICLE = 'act_article';

class Article {
    static allArticles() {
        return mysqlCli.query(`select * from ${TABLE_ACT_ARTICLE}`);
    }

    static createArticle({userName, content}) {
        return mysqlCli.insert(
            `insert into ${TABLE_ACT_ARTICLE} (user_name, content) values ('${userName}', '${content}');`
        );
    }
}

module.exports = Article;