FlintSable
5/13/2017 - 4:14 PM

get post put delete

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');