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;