-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
53 lines (41 loc) · 1.53 KB
/
index.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
var express = require('express');
var pg = require('pg');
var bodyParser = require('body-parser');
var port = process.env.PORT || 3000;
var app = express();
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended: false}));
app.use(express.static('public')); //allow use to style.css
app.set('view engine', 'ejs'); //to use ejs
app.set('views', './views')
var DATABASE_URL = process.env.DATABASE_URL ||'postgres://' + process.env.POSTGRES_USER + ':' + process.env.POSTGRES_PASSWORD + '@localhost/songs';
//use both heroku and localhost
app.get('/', function(req, res){
res.redirect('/mediasearch')
}) //no route will redirect to search page
app.get('/mediasearch', function(req, res){
res.render('home');
})
app.post('/mediasearch', function(req, res){
pg.connect(DATABASE_URL, function(err, client, done){
client.query(`insert into purchased (media, song, artist, price, buyinfo) values ('${req.body.type}','${req.body.song}', '${req.body.artist}', '${req.body.price}', '${req.body.buyinfo}')`, function(err, result){
done();
pg.end();
}) //inserts data into database from api call
})
})
app.get('/addedmedia', function(req, res){
pg.connect(DATABASE_URL, function(err, client, done){
client.query(`select * from purchased`, function(err, result){
res.render('purchasedsongs', {data: result.rows});
done();
pg.end();
})
})
})
app.get('*', function(req, res){
res.status(404).send("Page not found! Try route to /mediasearch" ) //wildcard get request
})
app.listen(port, function(){
console.log("App Listening")
})