var promise = require('bluebird'); var options = { promiseLib: promise };
var pgp = require('pg-promise')(options)
var connectionString = 'postgres://localhost:5432/contacts_db'; var db = pgp(connectionString);
function createContact(req, res, next) { console.log(req.body) req.body.age = parseInt(req.body.age) db.none('insert into contacts(first, last, age, sex)' + 'values(${first}, ${last}, ${age}, ${sex})', req.body) .then(res.redirect('/')) }
function getAllContacts(req, res, next){ db.any('select * from contacts') .then(function(data){ console.log(data) res.render( 'index', { title:"All Contacts", data:data }) }) }
function removeContact(req, res, next) { let contactID = parseInt(req.params.id) db.result('delete from contacts where id = $1', contactID) }
function updateContact(req,res, next) { let contactID = parseInt(req.params.id)
db.none('UPDATE contacts WHERE id = $1 SET first=$1', [req.body.name, parseInt(req.params.id)] ).then(res.redirect('/'))
} module.exports = { createContact: createContact, getAllContacts: getAllContacts, removeContact: removeContact, updateContact: updateContact }
var express = require('express'); var router = express.Router(); var db = require('../queries')
/* GET home page. */ router.get('/', db.getAllContacts); router.post('/', db.createContact); router.delete('/:id', db.removeContact) router.put('/:id', db.updateContact)
module.exports = router;
console.log('form.js is working')
$(this).siblings('input').attr("readonly", false);
// axios.delete("http://localhost:3000/"+id) // $(this).parent().remove(); });