Slide 22
Slide 22 text
Making Plans
Make a plan: parse data, insert to database
1 const pgp = require('pg-promise')();
2 function main(params) {
3 return new Promise(function(resolve, reject) {
4 var db = pgp(params.postgres_url, []);
5 var d = new Buffer(params.__ow_body, 'base64').toString();
6 var decoded = JSON.parse(d);
7 db.one("INSERT INTO plans (location, travel_date) VALUES ($
8 [decoded.location, decoded.travel_date])
9 .then(function(data) {
10 var r = params.base_url + "/" + data.plan_id;
11 resolve({headers: {"Location": r}, statusCode: 303})
12 });
@lornajane