Get started on DB work, still needs much work

1 files changed, 32 insertions, 1 deletions

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;