var express = require('express');
var router = express.Router();
var models = require('../models') // 引入模板
var Op = models.Sequelize.Op
// 查询所有
router.get('/', async function (req, res, next) {
// 搜索
var where = {}
var title = req.query.title;
var content = req.query.content;
console.log(req.query);
if (title) {
where = {
[Op.or]:[{ // 模糊搜索,一个关键字,搜索两个字段
title:{[Op.like]: '%' + title + '%'}
},
{
content:{[Op.like]: '%' + title + '%'}
}]
}
}
var articles = await models.Article.findAll({
order:[['id','DESC']],
where:where
})
res.json({articles: articles})
});
// 新增
router.post('/', async function(req,res,next){
//console.log(req.body.title);
await models.Article.create(req.body)// create创造
var articles = await models.Article.findAll({ // 返回所有数据
order:[['id','DESC']]
})
res.json({success:'新增成功',artcles:articles})
})
// 查询单条
router.get('/:id',async function(req,res,next){
var article = await models.Article.findByPk(req.params.id);
res.json({article: article});
})
// 修改
router.put('/:id',async function(req,res,next){
var article = await models.Article.findByPk(req.params.id);
article.update(req.body)
console.log(req.body);
res.json({success:'修改成功',article:article})
})
// 删除
router.delete('/:id',async function(req,res,next){
var article = await models.Article.findByPk(req.params.id);
article.destroy();
res.json({success:'删除成功'})
})
// 模糊搜索
module.exports = router;