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;