Raw Data

Information

Knowledge

Intelligence / Insight / Wisdom

								
									CREATE TABLE "USER" (
										"user_id"	INTEGER,
										"user_email"	TEXT NOT NULL,
										"user_password"	TEXT,
										PRIMARY KEY("user_id" AUTOINCREMENT)
									);
									
									CREATE TABLE "TASK" (
										"task_id"	INTEGER,
										"task_user_id"	INTEGER NOT NULL,
										"task_category"	TEXT,
										"task_description"	TEXT,
										FOREIGN KEY("task_user_id") REFERENCES "USER"("user_id"),
										PRIMARY KEY("task_id" AUTOINCREMENT)
									);


							
						

								
								npm install sqlite3 //install sqlite database drivers
								npm install connect-sqlite3  //install module to configure session store

							
						

								
									var sqlite3 = require('sqlite3').verbose() //npm install sqlite3
									const bcrypt = require('bcryptjs');
									
									//Creating a new database instance - Indication of connected database
									//Before peforming any operations to database, make sure database is connected.
									let db = new sqlite3.Database('./mplsrenter.sqlite', (err) => {
										if (err) {
										  // Cannot open database
										  console.error(err.message)
										  throw err
										}else{
											//Successful database connection
											console.log('Connected to the SQLite database.') 
										}
									});
								
							

								
									//Create a profile
									let createProfile = (profile) =>{
										var createProfileSql ='INSERT INTO PROSPECTIVE_PROFILE (prof_id, prof_firstname,prof_lastname, prof_address, prof_decision_date, prof_email, prof_password, prof_phone, prof_rent_range, prof_image_url, prof_class_num) VALUES (?,?,?,?,?,?,?,?,?,?,?)'
										var params =[null, profile.firstName, profile.lastName, null, profile.move_date, profile.userEmail, profile.user_password, null, profile.user_rent_range, './images/user_profile_images/generic_profile_img.png', null];
									
										db.run(createProfileSql, params, function(err){
											if (err){
												return console.log(err.message);
											}
											console.log("Profile Created");
											console.log(`Rows inserted ${this.changes}`);	  
										});
									}
									
									//Return a user from database
									let authenticateUser = (username, password, done) =>{
									
										var findUser = 'SELECT * FROM PROSPECTIVE_PROFILE WHERE prof_email = ?';
									
										db.get(findUser, username, function (err, user) {
											console.log(user);
											if (!user) {
											  return done(null, false);
											}
											bcrypt.compare(password, user.prof_password, function (err, result) {
											  if (err) {
												return console.log(err.message);
											  }
											  if (result) {
												return done(null, user);
											  }
											});
									  
										  });
									}

									//Export functions to be used in other areas of program.
									module.exports = {db, createProfile, authenticateUser}
									
								
							

								
									//Require dependencies you installed
									var createError = require('http-errors');
									var express = require('express');
									var session = require('express-session');
									var path = require('path');
									var cookieParser = require('cookie-parser');
									var logger = require('morgan');
									var hbs = require('hbs');
									const passport = require('passport');
									var session = require('express-session');
									var SQLiteStore = require('connect-sqlite3')(session);

									//passport config
									require('./config/passport')(passport);
									
									var session_config = {
											secret: 'secret', //a random unique string key used to authenticate a session
											resave: true, //nables the session to be stored back to the session store, even if the session was never modified during the request
											saveUninitialized: true, //his allows any uninitialized session to be sent to the store. When a session is created but not modified, it is referred to as uninitialized.
											cookie: { secure: true }, //true is a recommended option. However, it requires an https-enabled website
											//store  parameter when saving session to database
											store: new SQLiteStore
									};
									
									session_config.cookie.secure = false;
									//IMPORTANT REVIEW IN CLASS - https://expressjs.com/en/resources/middleware/session.html

									//Express Sessions
									app.use(session(session_config))
									//Reference for above - https://www.section.io/engineering-education/session-management-in-nodejs-using-expressjs-and-express-session/


									//Passport middleware
									app.use(passport.initialize());
									app.use(passport.session());