DBYwkcf5

1var Sequelize = require('sequelize')
2
3var _host = 'mysql'
4var _user = 'root'
5var _password = 'root'
6var _db = 'area'
7var _dialect = 'mysql'
8
9
10const db = {}
11
12const prequelize = new Sequelize("", _user, _password, {host: _host, dialect: _dialect, operatorsAliases: false,
13    pool: {
14        max: 5,
15        min: 0,
16        acquire: 30000,
17        idle: 10000
18        }
19    })
20    prequelize.query("CREATE DATABASE IF NOT EXISTS area").then(data => {
21        console.log("DATABASE CREATION?\n", data)
22           }).catch(err => {
23        console.log("DB CONNECTION ERROR WHILE TRYING TO CREATE DATABSE LOOK AFTER THAT TO SEE WHATSUP MY DUDE", err)
24    })
25    
26prequelize.sync()
27
28const sequelize = new Sequelize(_db, _user, _password, {host: _host, dialect: _dialect, operatorsAliases: false,
29    pool: {
30        max: 5,
31        min: 0,
32        acquire: 30000,
33        idle: 10000
34        }
35    })
36    
37    
38    db.Sequelize = Sequelize
39    db.sequelize = sequelize
40    sequelize
41    .authenticate()
42    .then(() => {
43        console.log("Connection established to db.")
44    })
45    .catch(err => {
46        console.log("Failed connection to database.")
47        console.log(err)
48    })
49    db.users = require('./models/usersM')(sequelize, Sequelize)
50    db.mail = require('./models/mailM')(sequelize, Sequelize)
51    db.auth = require('./models/authM')(sequelize, Sequelize)
52    db.action = require('./models/actionM')(sequelize, Sequelize)
53    db.reaction = require('./models/reactionM')(sequelize, Sequelize)
54    
55    db.users.sync({alter: true}).then(err => {
56        if (err)
57            console.log("Error: syncing Users table\n", err)
58        else
59        console.log("Users table synced successfully")
60    })
61    
62    db.mail.sync({alter: true}).then(err => {
63        if (err)
64            console.log("Error syncing Mail table\n", err)
65        else
66        console.log("Table users created successfuly")
67    })
68    
69    db.auth.sync({alter: true}).then(err => {
70        if (err)
71            console.log("Error syncing Auth table\n", err)
72        else
73        console.log("Auth table synced successfully")
74    })
75    
76    db.reaction.sync({alter: true}).then(err => {
77        if (err)
78            console.log("Error syncing Reaction table\n", err)
79        else
80        console.log("Reaction table synced successfully")
81    })
82    
83    db.action.sync({alter: true}).then(err => {
84        if (err)
85            console.log("Error syncing Action table\n", err)
86        else
87        console.log("Action table created successfuly")
88    })
89
90//c'est un test pour tenter de creer la db a l'export du module
91module.exports = function() {
92    const sequelize = new Sequelize("", _user, _password, {host: _host, dialect: _dialect, operatorsAliases: false,
93        pool: {
94            max: 5,
95            min: 0,
96            acquire: 30000,
97            idle: 10000
98            }
99        })
100        sequelize.query("CREATE DATABASE IF NOT EXISTS area").then(data => {
101            console.log("DATABASE CREATION?\n", data)
102        }).catch(err => {
103            console.log("DB CONNECTION ERROR WHILE TRYING TO CREATE DATABSE LOOK AFTER THAT TO SEE WHATSUP MY DUDE", err)
104        })
105        
106}
107
108module.exports = db;