Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const express = require('express');
- const { Client } = require ('pg');
- const router = express.Router();
- const { check, validationResult } = require('express-validator/check');
- const connectionString = 'postgres://notandi:@localhost/v2';
- function form(req, res) {
- const data = {};
- res.render('form', { data });
- }
- router.get('/', form);
- function SkraIGogn(name, email, ssn, amount){
- const client = new Client({
- user: 'postgres',
- host: 'localhost',
- database: 'postgres',
- password: 'Pluto050196',
- });
- 'INSERT INTO Data(name, email, ssn, amount) VALUES ($1, $2, $3, $4) Returning *';
- }
- router.post('/',
- // Þetta er bara validation! Ekki sanitization
- check('name').isLength({ min: 1 }).withMessage('Nafn má ekki vera tómt'),
- check('email').isLength({ min: 1}).withMessage('Netfang má ekki vera tómt'),
- check('email').isEmail().withMessage('Netfang verður að vera netfang'),
- check('ssn').isLength({ min: 1 }).withMessage('Kennitala má ekki vera tóm'),
- check('ssn').matches(/^[0-9]{6}-?[0-9]{4}$/).withMessage('Kennitala verður að vera á formi 000000-0000'),
- async (req, res) => {
- console.log(req.body);
- const data = req.body;
- const errors = validationResult(req);
- if (!errors.isEmpty()) {
- console.log('test', data.name);
- data.err = errors.array().map(i => i.msg);
- return res.render('form' ,{ data });
- }
- await SkraIGogn (data.name, data.email, data.ssn, data.amount);
- res.redirect('/thanks');
- }
- );
- module.exports = router;
Add Comment
Please, Sign In to add comment