-
Notifications
You must be signed in to change notification settings - Fork 1
/
signUp.js
28 lines (22 loc) · 838 Bytes
/
signUp.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
const dbConnection = require("./db/dbConnection");
const signUp = (email, hashedPassword, cb) => {
const sqlInsertUser = `INSERT INTO users (email, password) VALUES($1, $2);`;
const returnID = 'SELECT id FROM users WHERE email=$1'
const sqlInsertProfile = `INSERT INTO profiles (user_id) VALUES((SELECT id FROM users WHERE email=$1)) RETURNING user_id;`;
dbConnection.query(sqlInsertUser, [email, hashedPassword], (err, result) => {
if(err) {
cb(err);
} else {
dbConnection.query(sqlInsertProfile, [email], (err, res) => {
if(err) {
cb(err);
} else {
cb(null, res);
}
});
}
});
};
// signUp('a@g', 'cool', console.log);
// signUp('worf@enterprise', 'brave', console.log);
module.exports = signUp;