-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
127 lines (116 loc) · 3.41 KB
/
server.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
117
118
119
120
121
122
123
124
125
126
127
const express = require('express');
const bodyParser = require('body-parser');
const bcrypt = require('bcrypt-nodejs');
const cors = require('cors');
//const knex = require('knex');
const database = require('knex')({
client: 'pg', //PostgreSQL
connection: {
host: '127.0.0.1', //home
port: 5432,
user: 'postgres',
password: 'test',
database: 'smart-brain'
}
});
database.select('*').from('users').then(data => {
});
const app = express();
// transform input json
app.use(bodyParser.json());
app.use(cors());
app.get('', (req, res) => {
res.json(database.users);
})
app.get('/profile/:id', (req, res) => {
const { id } = req.params;
database.select('*').from('users').where({
id: id
}).then(user => {
// cause in js empty array [] still true, so even no data will not be an error
if (user.length) {
res.json(user[0]);
} else {
res.status(400).json('ID not founded !');
}
})
})
// Signin
app.post('/signin', (req, res) => {
const { email, password } = req.body;
database.select('email', 'hash').from('login')
.where('email', '=', email)
.then(result => {
const isValid = bcrypt.compareSync(password, result[0].hash);
if (isValid) {
return database.select('*').from('users')
.where('email', '=', email)
.then(user =>
res.json(user[0]))
.catch(error => res.status(400).json('Unable to catch user!'))
} else {
res.status(400).json('Sign in failed!');
}
})
.catch(error => res.status(400).json('Wrong credentials!'))
})
// Register
app.post('/register', (req, res) => {
const { name, email, password } = req.body;
// 加密
const hash = bcrypt.hashSync(password);
database.transaction(trx => {
trx.insert({
hash: hash,
email: email
})
.into('login')
.returning('email')
.then(loginEmail => {
return trx('users')
.returning('*')
.insert({
name: name,
email: loginEmail[0].email,
joined: new Date()
})
.then(user => {
res.json({
status: 'S',
message: 'Register success',
user: user
});
})
})
.then(trx.commit)
.catch(trx.rollback)
}).catch(error => res.status(400).json(
{
status: 'E',
message: 'Register falied'
}
));
})
// update entries when user sent picture
app.put('/image', (req, res) => {
const { id } = req.body;
database('users')
.where('id', '=', id)
.increment('entries', 1) //every time entries increase 1
.returning('entries')
.then(entries => {
res.json(entries[0].entries);
}).catch(error => {
res.status(400).json('Update entries failed')
})
})
app.listen(3000, () => {
console.log('app is running on port 3000');
})
/*
/ res => this is working
/ signin => POST = success/fail
/ register => POST= user
/ profile/:user => GET = user
/ image => PUT
*/