forked from alexandersrjones/lunge
-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
141 lines (116 loc) · 3.66 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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
const express = require('express');
const hbs = require('hbs');
const mysql = require('mysql');
const bodyParser = require('body-parser');
var app = express();
app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());
app.set('view engine', 'hbs');
app.use(express.static(__dirname + '/views'));
app.use(express.static(__dirname + '/public'));
hbs.registerPartials(__dirname + '/views/partials');
app.get('/', (request, response) => {
response.render('market.hbs')
});
app.get('/account', (request, response) => {
response.render('account.hbs')
});
app.get('/sellerPage', (request, response) => {
response.render('sellerPage.hbs')
});
app.get('/sellerRegister', (request, response) => {
response.render('sellerRegister.hbs')
});
app.get('/regimePage', (request, response) => {
response.render('regimePage.hbs')
});
app.get('/databaseTesting', (request, response) => {
response.render('databaseTesting.hbs')
});
app.get('/userCreation', (request, response) => {
response.render('userCreation.hbs')
});
//Dynamic for Heroku, default 3000 for local hosting
app.listen(process.env.PORT || 3000, () => {
});
// Create connection
const db = mysql.createConnection({
host : 'lunge-database.ch0uzb2cuoae.us-west-2.rds.amazonaws.com',
user : 'admin',
password : 'o0SgT30xueqiajnVsPaT',
database : 'lunge',
port: 3306,
timeout: 60000,
debug: true
});
// Connect
db.connect((err) => {
if(err){
throw err;
}
console.log('MySql Connected...');
});
app.post('/submit',function(req,res){
var username=req.body.username;
var firstname=req.body.firstname;
var lastname=req.body.lastname;
var password=req.body.password;
var email=req.body.email;
var gender=req.body.gender;
res.write('Hey "' + req.body.firstname+'".\n');
res.write('You sent the email "' + req.body.email+'".\n');
res.write('You sent the username "' + req.body.username+'".\n');
var sql = "INSERT INTO testfield (username, firstname, lastname, password, email, gender) VALUES ('"+username+"', '"+firstname+"','"+lastname+"', '"+password+"', '"+email+"', '"+gender+"')";
db.query(sql, function (err, result) {
if (err) throw err;
console.log("1 record inserted");
res.end();
});
});
app.post('/getuser',function(req,res){
var username=req.body.username;
var sql = "SELECT * FROM testfield WHERE testfield.username = '"+username+"'";
db.query(sql, function (err, result) {
if (err) throw err;
console.log("1 record pulled");
res.send(result);
});
});
// Select posts
app.get('/get', (req, res) => {
let sql = 'SELECT * FROM testfield';
let query = db.query(sql, (err, results) => {
if(err) throw err;
console.log(results);
res.send('Posts fetched...');
});
});
// Select single post
app.get('/getpost/:id', (req, res) => {
let sql = `SELECT * FROM posts WHERE id = ${req.params.id}`;
let query = db.query(sql, (err, result) => {
if(err) throw err;
console.log(result);
res.send('Post fetched...');
});
});
// Update post
app.get('/updatepost/:id', (req, res) => {
let newTitle = 'Updated Title';
let sql = `UPDATE posts SET title = '${newTitle}' WHERE id = ${req.params.id}`;
let query = db.query(sql, (err, result) => {
if(err) throw err;
console.log(result);
res.send('Post updated...');
});
});
// Delete post
app.get('/deletepost/:id', (req, res) => {
let newTitle = 'Updated Title';
let sql = `DELETE FROM posts WHERE id = ${req.params.id}`;
let query = db.query(sql, (err, result) => {
if(err) throw err;
console.log(result);
res.send('Post deleted...');
});
});