46 lines
1.1 KiB
JavaScript
46 lines
1.1 KiB
JavaScript
const SQLite = require('sqlite3').verbose();
|
|
|
|
function initDb(dbPath = './database.sqlite') {
|
|
return new Promise((resolve, reject) => {
|
|
const db = new SQLite.Database(dbPath, (err) => {
|
|
if (err) {
|
|
reject(err);
|
|
} else {
|
|
db.run(`CREATE TABLE IF NOT EXISTS users (
|
|
id TEXT PRIMARY KEY,
|
|
username TEXT,
|
|
discord_id TEXT DEFAULT NULL,
|
|
google_id TEXT DEFAULT NULL,
|
|
discriminator TEXT,
|
|
avatar TEXT
|
|
)`, (err) => {
|
|
if (err) reject(err);
|
|
else resolve(db);
|
|
});
|
|
}
|
|
});
|
|
});
|
|
}
|
|
|
|
function initDb (dbPath = './database.sqlite') {
|
|
return new Promise((resolve, reject) => {
|
|
const db = new sqlite3.Database(dbPath, (err) => {
|
|
if (err) {
|
|
reject(err);
|
|
} else {
|
|
db.run(`
|
|
CREATE TABLE IF NOT EXISTS restaurants (
|
|
id INTEGER PRIMARY KEY,
|
|
nom TEXT NOT NULL,
|
|
description TEXT,
|
|
adresse TEXT NOT NULL,
|
|
menu TEXT
|
|
);
|
|
`);
|
|
}
|
|
db.close();
|
|
resolve();
|
|
});
|
|
});
|
|
};
|
|
module.exports = initDb;
|