From 43865930f8580f6fe97ea9f54686a1b805358a6d Mon Sep 17 00:00:00 2001
From: Matthew Strapp <msattr@gmail.com>
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')

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