workshopDev/server.js at master · DonRenato/workshopDev · 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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
const express = require("express");
const nunjuncks = require('nunjucks');

const db = require("./db");


const server = express();

nunjuncks.configure("views", {
    express: server,
    noCache: true,
});

server.use(express.static("public"));

server.use(express.urlencoded({ extended: true}));


server.get("/", function(req, res){


    db.all(`SELECT * FROM ideas`, function(err, rows){
        if(err) {
            console.log(err);
            return res.send("Erro no banco de dados");
        }
        const reversedIdeas = [...rows].reverse();

        let lastIdeas = [];

        for(let idea of reversedIdeas){
            if(lastIdeas.length < 2 ){
                lastIdeas.push(idea);
            }
        }

        return res.render("index.html", { ideas: lastIdeas });
    });
})

server.get("/ideias", function(req, res){
    db.all(`SELECT * FROM ideas`, function(err, rows){
        if(err) {
            console.log(err);
            return res.send("Erro no banco de dados");
        }
        const reversedIdeas = [...rows].reverse();

        return res.render("ideias.html", { ideas: reversedIdeas});
    });
})

server.post("/", function(req, res){
    const query = `INSERT INTO ideas(
               image,
               title,
               category,
               description,            link
               ) VALUES(?,?,?,?,?);`

    const values = [
               req.body.image,
               req.body.title,
               req.body.category,
               req.body.description,
               req.body.link
           ]

     db.run(query, values, function(err){
        if(err) {
            console.log(err);
            return res.send("Erro no banco de dados");
        }

        return res.redirect("/ideias");
     });

    })

// server.delete("/:id", function(req, res){
//     const id = req.params.id;
//     db.run(`DELETE FROM ideas where id = ?`,[id],function(err){
//         if(err) {
//             console.log(err);
//             return res.send("Erro no banco de dados");
//         }

//             console.log("deletei")
//             return res.redirect("/ideias");
//          });
// })


server.listen(3000);