-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbinit.js
34 lines (31 loc) · 634 Bytes
/
dbinit.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
const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
host: 'localhost',
dialect: 'sqlite',
logging: false,
storage: 'database.sqlite',
});
sequelize.authenticate()
.then(()=>{
console.log("Database connected");
})
.catch(err=>{
console.log("ok",err);
});
const db = {};
db.sequelize = sequelize;
const scores = db.sequelize.define('scores', {
uid: {
type: Sequelize.STRING,
unique: true,
},
score: Sequelize.INTEGER,
match: Sequelize.INTEGER,
});
db.sequelize.sync()
.then(()=>{
console.log("sync complete");
})
.catch(err=>{
console.log("ok",err);
});