-
Notifications
You must be signed in to change notification settings - Fork 1
/
server.js
119 lines (101 loc) · 3.48 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
'use strict';
const pg = require('pg');
const express = require('express');
const bodyParser = require('body-parser');
const cors = require('cors');
const superagent = require('superagent');
const request = require('request');
const cheerio = require('cheerio');
const app = express();
const PORT = process.env.PORT || 3000;
// const DATABASE_URL = process.env.DATABASE_URL || 'postgres://postgres:1234@localhost:5432/avalanche'; // arthur
// const DATABASE_URL = process.env.DATABASE_URL || 'postgres://amgranad:amber123@localhost:5432/avalanche'; //amber
const DATABASE_URL = process.env.DATABASE_URL || 'postgres://alicialycan:534@localhost:5432/avalanche'; //alicia
const client = new pg.Client(DATABASE_URL);
client.connect();
client.on('error', err => {
console.error(err);
});
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({
extended: true
}));
app.use(cors());
app.use(express.static('./public'));
app.get('/nwac/:region', (req, res) => {
const url = `http://www.nwac.us/api/v2/avalanche-region-forecast/?format=json&zone=${req.params.region}`;
superagent.get(url)
.then(info => res.send(info.text))
.catch(err => console.error(err));
});
app.get('/scrape/:region', (req, res) => {
const region = req.params.region;
const regionUrls = {
'cascade-west-north-baker':'https://weather.com/weather/today/l/266:11:US',
'cascade-west-stevens-pass': 'https://weather.com/weather/today/l/427:11:US',
'cascade-west-snoqualmie-pass': 'https://weather.com/weather/today/l/USWA0413:1:US',
'cascade-west-south': 'https://weather.com/weather/today/l/124:11:US'
};
const url = regionUrls[region];
request(url, function (error, response, html) {
if (!error) {
var $ = cheerio.load(html);
var temp1 = $('.today_nowcard-phrase').html();
var temp2 = $('.today_nowcard-temp span').text();
var temps = [temp1, temp2];
}
res.send(temps);
});
});
app.get('/api/v1/feedback', (req, res) => {
client.query('SELECT * FROM feedback;')
.then(result => {
res.send(result.rows);
}).catch(err => {
console.error(err);
});
});
app.get('/api/v1/feedback/:id', (req, res) => {
client.query(`
SELECT * FROM feedback WHERE feedback_id=$1;
`, [req.params.id]).then(result => res.send(result.rows[0]))
.catch(err => console.error(err));
});
app.get('/api/v1/feedbackids', (req, res) => {
client.query(`
SELECT feedback_id FROM feedback;
`).then(result => res.send(result.rows))
.catch(err => console.error(err));
});
app.post('/api/v1/feedback', (req, res) => {
client.query(`
INSERT INTO feedback (name, email, location, comments, rating)
VALUES($1, $2, $3, $4, $5);
`, [
req.body.name,
req.body.email,
req.body.location,
req.body.comments,
req.body.rating
]).then(() => res.send('inserted successfully'))
.catch(err => console.error(err));
});
app.delete('/api/v1/feedback/:id', (req, res) => {
client.query(`
DELETE FROM feedback WHERE feedback_id=$1;
`, [req.params.id]).then(result => res.status(204).send(result))
.catch(err => console.error(err));
});
app.put('/api/v1/feedback/:name', (req, res) => {
client.query(`
UPDATE feedback
SET email='${req.body.email}', location='${req.body.location}', comments='${req.body.comments}', rating=${req.body.rating}
WHERE name='${req.body.name}';
`).then(() => {
res.send('updated successfully');
})
.catch(err => console.error(err));
});
app.listen(PORT, () => {
console.log(`listening on PORT ${PORT}`);
});