-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
122 lines (108 loc) · 4.08 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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
// handling URLencoded requests
// app.use(express.urlencoded({ extended: true }));
// handling JSON requests
// app.use(express.json());
//const lib = require("./lib/");
require('dotenv').config();
const express = require("express");
const path = require('path');
const axios = require('axios');
const port = 3000;
const app = express();
const db = require("./models");
const mysql = require('mysql2/promise');
app.use(express.static(__dirname + '/public'));
//app.use(express.static(path.join(__dirname, '/public')));
//app.use('/', express.static(path.join(__dirname, '/public')))
// APIs
app.use('/api/admin', require('./routes/administrador'));
app.use('/api/usuario', require('./routes/usuario'));
app.use('/api/categoria', require('./routes/categoria'));
app.use('/api/publicacao', require('./routes/publicacao'));
app.use('/api/fotos', require('./routes/fotos'));
// Session
const session = require('express-session');
app.use(session({
secret: 'I-Wanna-Be-A-10x-Dev',
resave: false,
saveUninitialized: false,
//store: store,
cookie: {
maxAge: 3600000
}
}));
// View Engine
app.set('views', './views');
app.set('view engine', 'ejs');
// Views
//app.use('/autenticacao', require('./routes/autenticacao')); // deprecated
app.use('/login', require('./routes/login'));
app.use('/registro', require('./routes/registro'));
app.use('/', require('./routes/home'));
app.use('/publicacao', require('./routes/tela-publicacao'));
app.use('/painel-usuario', require('./routes/painel-usuario'));
//app.use('/painel-admin', require('./routes/painel-admin'));
app.use('/auth', require('./routes/auth'));
inicializar().then(
() => {
db.sequelize.sync({ force: false, alter: false }).then(
() => {
console.log("Sincronização realizada com o BD!");
app.listen(port, () => {
console.log("Servidor escutando na porta " + port);
db.sequelize.query("select * from administrador;").then(
(query) => {
popularBase(query);
}
).catch(
err => console.log('Error: ' + err)
)
});
}
).catch(
(err) => {
console.log("Sincronização com o BD falhou. Error: " + err);
}
)
}
)
// Sincronização inicial seguida pela inicialização do servidor
// Se for realizar rebuild (force) da base, lembrar de fazer DROP FOREIGN KEY previamente para evitar erros.
const popularBase = async (selectAdmins) => {
if(selectAdmins[0].length < 1) {
const r = [];
r.push(await axios.post('http://localhost:3000/api/admin/popular-admin'));
r.push(await axios.post('http://localhost:3000/api/usuario/popular-usuario'));
r.push(await axios.post('http://localhost:3000/api/categoria/popular-categoria'));
r.push(await axios.post('http://localhost:3000/api/fotos/popular-fotos'));
r.push(await axios.post('http://localhost:3000/api/publicacao/popular-publicacao'));
for(elem of r) {
console.log(elem.data.msg);
}
}
}
async function inicializar () {
try {
// const { host, port, user, password, database } = config.database; // implemented with extra security
//const r = await db.sequelize.query('CREATE DATABASE IF NOT EXISTS breshopp;', { raw: true }); // tentar sem mysql/promise connection
const connection = await mysql.createConnection({
host: 'localhost',
port: 3306,
user: 'aluno',
password: 'ifpe2023'
});
const resultado = await connection.query(`CREATE DATABASE IF NOT EXISTS breshopp;`);
//console.log('Database "breshopp" foi criado com sucesso.');
} catch (err) {
console.log("Erro na criação de database: " + err);
}
}
//404 Errors
app.use(function(req,res){
res.status(404).render('404');
});
//500 Errors
app.use(function(error,req,res,next){
console.log(error);
res.status(500).render('500');
});