Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const express = require("express");
- const { Pool } = require("pg");
- const dotenv = require("dotenv");
- dotenv.config();
- // Conncet to DATABASE_URL from .env file
- const pool = new Pool({
- connectionString: process.env.DATABASE_URL
- });
- pool.on("connect", () => {
- console.log("connected to the db");
- });
- const app = express();
- app.use(express.json());
- // Get route
- app.get("/api", (req, res) => {
- // pg connect
- pool.connect((err, client, done) => {
- client.query('SELECT * FROM activities')
- .then(res => console.log('Success..'))
- .catch(err => console.error(err.stack))
- done();
- res.send(200);
- });
- // pool shutdown
- pool.end();
- // return res.status(200).send({ message: "Congratulations! You connected to postgres" });
- });
- // /api POST
- app.post('/api/add', (req, res) => {
- // pg connect
- pool.connect((err, client, done) => {
- client.query('INSERT INTO activities(activity, undone, done) VALUES("laundry", "yes", "no"')
- .then(res => console.log('Items added..'))
- .catch(err => console.error(err.stack))
- done();
- res.redirect('/api');
- });
- // pool shutdown
- pool.end();
- return res.status(200).send({ message: "Congratulations! made a post request to postgres" });
- });
- // /api DELETE
- app.delete('/delete/:id', (req, res) => {
- // pg connect
- pool.connect((err, client, done) => {
- client.query('DELETE FROM activities WHERE done = "yes"')
- .then(res => console.log('Items delted..'))
- .catch(err => console.error(err.stack))
- done();
- res.send(200);
- });
- // pool shutdown
- pool.end();
- });
- // api/ edit
- app.post('/api/edit', (req, res) => {
- // pg connect
- pool.connect((err, client, done) => {
- client.query('UPDATE activites SET activity = Cook , undone = no, done = yes WHERE activity = "laundry"')
- .then(res => console.log('Items updated..'))
- .catch(err => console.error(err.stack))
- done();
- res.redirect('/api');
- });
- // pool shutdown
- pool.end();
- });
- // Server listen
- app.listen(5000, () => {
- console.log("app running on port 5000");
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement