1 import { Pool } from "pg";
3 const pool = new Pool({
7 password: 'secretpassword',
11 export const createUserPost = async ({req, res}:any) => {
12 const { name, email } = req.body;
13 const client = await pool.connect();
15 await client.query('BEGIN');
16 const queryText = 'INSERT INTO users(name, email) VALUES($1, $2) RETURNING *';
17 const values = [name, email];
18 const { rows } = await client.query(queryText, values);
19 await client.query('COMMIT');
20 return res.status(201).send(rows[0]);
22 await client.query('ROLLBACK');