-
Notifications
You must be signed in to change notification settings - Fork 1
/
routes.js
116 lines (93 loc) · 3.33 KB
/
routes.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
var Schema = require('./js_backend/Schema');
var DbEditor = require('./js_backend/DbManipulator.js');
var bcrypt = require('bcrypt-nodejs');
var path = require('path');
global.root = path.resolve(__dirname);
var newUserId = 1000000000;
function init(){
var q = 'SELECT MAX(' + Schema.User.column.id + ') as max ' +
'FROM ' + Schema.User.table + ';';
console.log(q);
DbEditor.rawQuery(q, function(err, rows){
if(!err && rows[0].max !== null){
console.log(rows);
newUserId = rows[0].max + 1;
console.log('New user\'s id: ' + newUserId );
}
});
}
init();
function incrementUserId(){
newUserId += 1;
console.log('Update new user\'s id to -> ' + newUserId);
}
function toString(string){
return '\'' + string +'\'';
}
module.exports = function(app, passport) {
//POST signup
app.post('/signup', function(req, res, next) {
var user = req.body;
DbEditor.query(Schema.User.table, [Schema.User.column.username], [Schema.User.column.username + '='], ['\''+user.username+'\''], function(err, rows) {
console.log(err);
if (!err) {
if (rows.length === 0) { // no match username
// VALIDATION
var password = user.password;
var hash = bcrypt.hashSync(password);
var fname = user.firstName;
var lname = user.lastName;
//save user
var q = 'INSERT INTO ' + Schema.User.table + ' ' +
'VALUES (' + newUserId + ', \'' + user.username + '\', \'' + hash + '\''+ ', ' + toString(fname) + ', ' + toString(lname) + ')' ;
console.log('signup' + q);
DbEditor.rawQuery(q, function(err, rows){
if(!err){
res.redirect('/#/login');
incrementUserId();
}
});
} else { //when there is a match username
//render invalid username.
}
} else { //when error occur during query
//render please retry?
}
});
});
//POST signin
app.post('/signin', function(req, res, next) {
console.log(req.body);
passport.authenticate('local', {
successRedirect: '/#/',
failureRedirect: '/#/login'
},
function(err, user, info) {
if (err) {
return; //render web with error message
}
if (!user) {
return; //render web with info message
}
req.logIn(user, function(err) {
if (err) {
return; //render web with error message
} else {
console.log('login succuss' + user.username);
res.redirect('/');
}
});
})(req, res, next);
});
app.get('/signout', function(req, res, next) {
if (!req.isAuthenticated()) {
res.redirect('/#/login');
} else {
req.logout();
res.redirect('/#/login');
}
});
app.get('*', function(req, res, next) {
res.sendFile(root + '/index.html');
});
};