From 43865930f8580f6fe97ea9f54686a1b805358a6d Mon Sep 17 00:00:00 2001 From: Matthew Strapp Date: Fri, 16 Apr 2021 12:58:44 -0500 Subject: Get started on DB work, still needs much work --- csci4131/hw6/strap012_hw6/api/utilities.js | 33 +++++++++++++++++++++++++++++- 1 file changed, 32 insertions(+), 1 deletion(-) (limited to 'csci4131/hw6/strap012_hw6/api/utilities.js') diff --git a/csci4131/hw6/strap012_hw6/api/utilities.js b/csci4131/hw6/strap012_hw6/api/utilities.js index eda6e72..8a97d20 100644 --- a/csci4131/hw6/strap012_hw6/api/utilities.js +++ b/csci4131/hw6/strap012_hw6/api/utilities.js @@ -1,11 +1,42 @@ const express = require('express') +const db = require ('../dbio') const router = express.Router() router.get('/contacts', function (req, res) { // TODO: Implement code to fetch contacts from the database - res.send("AAAAAAAAAAAA") + table = db.getContacts(); + res.send("AAAAAAAAAAAA"); }); + // TODO: Add implementation for other necessary end-points +router.post('/login', function(req, res) { + var loginInfo = req.body; + var login = loginInfo.login; + var pwd = loginInfo.password; + + // Query the database tbl_login with login and hashed password + rows = db.query(login,pwd); + // Provided there is no error, and the results set is assigned to a variable named rows: + if (rows.length >=1){// the length should be 0 or 1, but this will work for now + //success, set the session, return success + req.session.user=login; + res.json({status:'success'}); + res.send("SUCC"); + } else + res.send("FAIL"); + res.json({status:'fail'}); + }); + +router.get('/logout', function(req, res) { + if(!req.session.value) { + res.send('Session not started, can not logout!'); + } else { + console.log ("Successfully Destroyed Session!"); + req.session.destroy(); + res.send("Session Complete!"); + res.redirect('/login'); + } +}); module.exports = router; -- cgit v1.2.3