lefatoum2/NodeJs_Crud_Postgres_Auth02

Installation

npm init -y
npm install --save express body-parser cors pg

POST

app.post("api/v1/issues", (req, res)=> {
    const {label, status, priority } = req.body;

    pool.query(
            "INSERT INTO() VALUES()",[label,status,priority],
            (error,results) =>{
                if(error){
                    throw error;
                }
                res.status(200).json(results.rows)
            }
    );
 });

GET ALL

app.get("/api/v1/issues", (req, res)=>{
    pool.query(
        "select id, label, status, priority from issues",[], (error, results) =>{

        
        res.status(200).json(results.rows);
        }
    );
});

GET ID

app.get('api/v1/issues/:id', (req, res) =>{
    const {id} = req.params;

    pool.query(
        "select id,label, status, priority from issues where id = $1",[id],
        (error, results) => {
            if(error){
                throw error;
            }
            res.status(200).json(results.rows);
        }
    )
})

PUT

app.put("/api/v1/issues/:id", (req,res) => {
	const {id} = req.params;
	const {label, status, priority} = req.body;


	pool.query(
		"UPDATE issues SET label = $1, status = $2, priority = $3 where id = $4", [label, status, priority, id],
		(error, results) => {
			if(error){
				throw error
			}
			res.sendStatus(200);
		}
		);
});

DELETE

app.delete(api/v1/issues/:id, req, res) => {
	const {id} = req.params;

	pool.query("DELETE FROM issues WHERE id = $1", [id], (error, results) => {
		if(error){
			throw error;
		}
		res.sendStatus(200);
	});
});

app.listen(8000, () => {
  console.log(`Server is running.`);
});