query (query, ...args) { this._pool.connect((err, client, done) => { if (err) throw err; const params = args.length === 2 ? args[0] : []; const callback = args.length === 1 ? args[0] : args[1]; client.query(query, params, (err, res) => { done(); if (err) { console.log(err.stack); return callback({ error: 'Database error.322' }, null); } callback({}, res.rows); }); }); }
app.get('/student', (req, res) => { pool.connect((err, client, done) => { const query = 'SELECT * FROM students'; client.query(query, (error, result) => { done(); if (error) { res.status(400).json({error}) } if(result.rows < '1') { res.status(404).send({ status: 'Failed', message: 'No student information found', }); } else { res.status(200).send({ status: 'Successful', message: 'Students Information retrieved', students: result.rows, }); } }); }); });
app.post('/student', (req, res) => { const data = { name : req.body.studentName, age : req.body.studentAge, classroom : req.body.studentClass, parents : req.body.parentContact, admission : req.body.admissionDate, } pool.connect((err, client, done) => { const query = 'INSERT INTO students(student_name,student_age, student_class, parent_contact, admission_date) VALUES($1,$2,$3,$4,$5) RETURNING *'; const values = [data.name, data.age, data.classroom, data.parents, data.admission]; client.query(query, values, (error, result) => { done(); if (error) { res.status(400).json({error}); } res.status(202).send({ status: 'SUccessful', result: result.rows[0], }); }); }); });