index.js

const express = require('express');
const res = require('express/lib/response');
var cors = require('cors')
const {Client} = require('pg');
var bodyParser = require('body-parser');
const { json } = require('body-parser');
const port = 3001;
const app = express();
app.use(cors())
// app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json())

var client = new Client({
    user: process.env.user,
    host: process.env.host,
    database: process.env.database,
    password: process.env.password,
    port: process.env.port,
    ssl: {
        rejectUnauthorized: false
    }
})

function removeWhiteSpaceFromEnd(title) {
    var size = title.length;
    while (title[size - 1] == " ") {
      size--;
    }
    var temp = "";
    for (let j = 0; j < size; j++) {
      temp += title[j];
    }
    return temp;
}

app.get('/', (req, res) => {
    res.send("Welcome to the magic world -> Asity");
})

app.post('/signup', (req, res) => {
    var rawEmail = req.body.email
    var emailid = removeWhiteSpaceFromEnd(rawEmail);
    var rawPasscode = req.body.password
    var passcode = removeWhiteSpaceFromEnd(rawPasscode);
    if (emailid == "") {
        res.status(406);
        res.send({
          message: "Invalid Email",
        });
    }
    else if (passcode == "") {
        res.status(406);
        res.send({
          message: "Invalid Password",
        });
    }
    else {
        const insertquery = `insert into accounts(email, password) values('${emailid}', '${passcode}')`;
        client.query(insertquery, (err, result) => {
            if(err){
                res.send(err.message || err);
            }
            else{
                res.status(201);
                res.send(result.rows);
                console.log('Db insertion: Successful');
            }
        });
    }
});

app.get('/allUser', (req, res) => {
    var selectquery = 'select * from accounts order by user_id desc';
    client.query(selectquery, (err, result) => {
        if(err){
            res.send(err.message || err);
        }
        else{
            res.send(result.rows);
        }
    })
})

app.delete('/deleteUser', (req, res) => {
    var emailid = req.body.email;
    var deletequery = `delete from accounts where email = '${emailid}'`;
    client.query(deletequery, (err, result)=> {
        if(err){
            res.send(err.message || err);
        }
        else{
            res.send(result.rows[0]);
            console.log('User deleted');
        }
    })
})

app.patch('/edit', (req, res) => {
    var a = [];
    a = Object.keys(req.body);
    var updatesql = 'update accounts set ';
    for (var index = 1; index < a.length; index++) {
        var u = req.body[`${a[index]}`];
        if (index == a.length - 1) {
          updatesql += ` ${a[index]} = '${u}' `;
        } else {
          updatesql += ` ${a[index]} = '${u}', `;
        }
    }
    updatesql += `where user_id = ${req.body.user_id} returning *`;
    client.query(updatesql, (err, result) => {
        if(err){
            res.send(err.message || err);
        }
        else{
            // res.send(201);
            res.send(result.rows[0]);
            console.log('Update: Successful');
        }
    })

})
app.listen(process.env.PORT  || port, () => {
    console.log(`Example app listening at http://localhost:${port}`);
    client.connect((err) => {
        if(err){
           throw err;
        }
        console.log("Database connection: Successful");
    });
    
})