-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathserver.js
84 lines (69 loc) · 2.09 KB
/
server.js
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
//console.log('hello node')
const express = require('express')
const app = express()
const bodyParser = require('body-parser')
const ObjectId = require('mongodb').ObjectID
const MongoClient = require('mongodb').MongoClient
const uri = "mongodb://beleza:beleza1@ds113606.mlab.com:13606/qbeleza"
app.use(bodyParser.urlencoded({ extended : true }))
MongoClient.connect(uri, { useNewUrlParser: true }, (err, client) => {
if (err) return console.log(err)
db = client.db('qbeleza')
app.listen(3000, function() {
console.log('server running on port 3000')
})
})
app.set('view engine','ejs')
app.route('/') //setado a rota, e abaixo as ações a serem tomadas dentro desta rota
.get(function(req, res) {
const cursor = db.collection('servicos').find()
res.render('index.ejs')
})
.post((req, res) => {
db.collection('servicos').save(req.body, (err, result) => {
if (err) return console.log(err)
console.log('Salvo no Banco de Dados')
res.redirect('/show')
})
})
app.route('/show')
.get((req, res) => {
db.collection('servicos').find().toArray((err, results) => {
if (err) return console.log(err)
res.render('show.ejs', { servicos: results })
})
})
app.route('/edit/:id')
.get((req, res) => {
var id = req.params.id
db.collection('servicos').find(ObjectId(id)).toArray((err, result) => {
if (err) return res.send(err)
res.render('edit.ejs', { servicos: result })
})
})
.post((req, res) => {
var id = req.params.id
var nome = req.body.nome
var descricao = req.body.descricao
var preco = req.body.preco
db.collection('servicos').updateOne({_id: ObjectId(id)}, {
$set: {
nome: nome,
descricao: descricao,
preco: preco
}
}, (err, result) => {
if (err) return res.send(err)
res.redirect('/show')
console.log('Atualizado no Banco de Dados')
})
})
app.route('/delete/:id')
.get((req, res) => {
var id = req.params.id
db.collection('servicos').deleteOne({_id: ObjectId(id)}, (err, result) => {
if (err) return res.send(500, err)
console.log('Deletado do Banco de Dados!')
res.redirect('/show')
})
})