Guest User

Untitled

a guest
Feb 25th, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. const express = require('express');
  2. const { Client } = require ('pg');
  3.  
  4. const router = express.Router();
  5. const { check, validationResult } = require('express-validator/check');
  6. const connectionString = 'postgres://notandi:@localhost/v2';
  7.  
  8. function form(req, res) {
  9. const data = {};
  10. res.render('form', { data });
  11. }
  12.  
  13. router.get('/', form);
  14.  
  15. function SkraIGogn(name, email, ssn, amount){
  16. const client = new Client({
  17. user: 'postgres',
  18. host: 'localhost',
  19. database: 'postgres',
  20. password: 'Pluto050196',
  21. });
  22. 'INSERT INTO Data(name, email, ssn, amount) VALUES ($1, $2, $3, $4) Returning *';
  23. }
  24. router.post('/',
  25. // Þetta er bara validation! Ekki sanitization
  26. check('name').isLength({ min: 1 }).withMessage('Nafn má ekki vera tómt'),
  27. check('email').isLength({ min: 1}).withMessage('Netfang má ekki vera tómt'),
  28. check('email').isEmail().withMessage('Netfang verður að vera netfang'),
  29. check('ssn').isLength({ min: 1 }).withMessage('Kennitala má ekki vera tóm'),
  30. check('ssn').matches(/^[0-9]{6}-?[0-9]{4}$/).withMessage('Kennitala verður að vera á formi 000000-0000'),
  31.  
  32. async (req, res) => {
  33. console.log(req.body);
  34. const data = req.body;
  35. const errors = validationResult(req);
  36. if (!errors.isEmpty()) {
  37. console.log('test', data.name);
  38. data.err = errors.array().map(i => i.msg);
  39. return res.render('form' ,{ data });
  40. }
  41. await SkraIGogn (data.name, data.email, data.ssn, data.amount);
  42. res.redirect('/thanks');
  43. }
  44. );
  45.  
  46.  
  47. module.exports = router;
Add Comment
Please, Sign In to add comment