get post put delete
router.put('/users/update/enabled/:id', function(req, res) {
//tableName, column, ID, callback
models.burgers.update({
enabled:1
},{where:{
id:req.params.id
}}
).then(function(){
res.redirect('/users');
})
});
router.put('/update/:user_id', function(req, res) {
models.User.update({
name: req.body.name,
email: req.body.email,
age: req.body.age
},
{
where: { id : req.params.user_id }
}
).then(function() {
res.redirect('/user/' + req.params.user_id);
});
});
//when directed to users route, get user.js logic from model, call functions within it.
router.get('/users', function(req, res) {
models.Users.findAll().then(function(data){
res.render('index', { user: data });
});
});
router.get('/', function(req, res) {
models.User.findAll({
include: [ models.Workorder ]
}).then(function(user) {
// res.send(user);
res.render('user/index', {
user_id: req.session.user_id,
email: req.session.user_email,
logged_in: req.session.logged_in,
user: user
});
});
});
router.get('/:user_id', function(req, res) {
models.User.findOne({
include: [ models.Workorder ],
where: {
id: req.params.person_id
}
}).then(function(user) {
res.render('users/show', {
logged_in: req.session.logged_in,
id: person.id,
name: person.name,
email: person.email,
age: person.age,
created_at: person.created_at,
updated_at: person.updated_at,
workorder: user.Workorders
})
});
});
router.post('/users/create', function(req, res) {
models.User.create({
user_name:req.body.name,
enabled: 0
}).then(function(){
res.redirect('/users');
});
});
router.post('/create', function(req, res) {
models.User.create({
name: req.body.name,
email: req.body.email,
age: req.body.age
}).then(function() {
res.redirect('/');
});
});
router.delete('/users/delete/:id', function(req, res) {
//run user.js logic of deleteOne(table,id,callback)
models.User.destroy(
{where:{
id:req.params.id
}}).then(function(){
res.redirect('/userss');
})
})
//dependencies
const express = require('express');
const methodOverride = require('method-override');
const bodyParser = require('body-parser');
const router = express.Router();
const models = require('../models');