-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.v3.js
38 lines (34 loc) · 983 Bytes
/
server.v3.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
const express = require('express');
const app = express();
const bodyParser = require('body-parser');
app.use(bodyParser.json());
const db = require('./db');
const sql = db.sql();
const conn = db.initConn(sql);
db.deleteUser('v1');
db.createUser('v1', '123456');
app.get('/api/v1/login', (req, res) => {
conn.all(`
SELECT rowid AS id, login, password
FROM users
WHERE login = $login
`, {
$login: req.body.login
},
function (err, rows) {
if (err) {
res.send(err.message);
} else {
let loginFlag = false;
if (rows && rows.length > 0) {
if (req.query.password === rows[0].password) {
loginFlag = true;
}
}
res.send(loginFlag ? 'logged in' : 'bad news');
}
})
});
app.listen(3030, () => {
console.log("start");
});