recipebook/database.js at master · oshanshrestha/recipebook · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
const { Client } = require('pg')

var DBconnecter = {
    getAll: function(callback) {
        const client = new Client(/*{
            user: 'LearnPostGres',
            host: 'localhost',
            database: 'recipeBook',
            password: 'APPMSXPS',
            port: 5432,
        }*/)

        client.connect()

        client.query('SELECT * FROM recipes', (err, res) => {
            if (err) {
                console.error("Error running queries.")
            }
            callback(res)
        })
    },
    insertData: function(name, ingredients, directions, callback) {
        const client = new Client()

        client.connect()


        client.query('INSERT INTO recipes (name, ingredients, directions) VALUES ($1, $2, $3);', [name, ingredients, directions], (err, res) => {
            if (err) {
                console.error("Error running queries.\n", err)
            }
            console.log('Recipe added succesfully')
            callback(res)
        })
    },
    alterData: function(id, name, ingredients, directions, callback) {
        const client = new Client()

        client.connect()

        client.query('UPDATE recipes SET name=$2, ingredients=$3, directions=$4 WHERE id=$1;', [id, name, ingredients, directions], (err, res) => {
            if (err) {
                console.error("Error running queries.\n", err)
            }
            console.log('Recipe edited succesfully')
            console.log(res)
            callback(res)
        })
    },
    deleteData: function(id, callback) {
        const client = new Client()

        client.connect()

        client.query('DELETE FROM recipes WHERE id = $1;', [id], (err, res) => {
            if (err) {
                console.error("Error running queries.\n", err)
            }
            console.log('Recipe deleted succesfully')
            console.log(res)
            callback(res)
        })
    }
}
module.exports = DBconnecter