database.js

import sqlite3 from 'sqlite3';

const db = new sqlite3.Database('./database.db', (err) => {
  if(err) {
    console.error('Error opening database ' + err.message);
  } else {
    console.log('Database opened');
  }
});

db.serialize(() => {
  db.run('CREATE TABLE IF NOT EXISTS battles (id INTEGER PRIMARY KEY, maker INTEGER, taker INTEGER, maker_pokemons TEXT, maker_battling_pokemons TEXT, taker_pokemons TEXT, taker_battling_pokemons TEXT, maker_move TEXT, taker_move TEXT, status TEXT, current_turn INTEGER, is_competitive INTEGER, battle_log TEXT)');
  // db.run('CREATE TABLE IF NOT EXISTS hashes (hash TEXT PRIMARY KEY)');
  db.run('CREATE TABLE IF NOT EXISTS players (playerid INTEGER PRIMARY KEY, wallet TEXT, inventory TEXT, battles TEXT)');
  // db.run('CREATE TABLE IF NOT EXISTS converse (wallet TEXT PRIMARY KEY, fid INTEGER)');
  db.run('CREATE TABLE IF NOT EXISTS pokemons (id INTEGER PRIMARY KEY, name TEXT, type TEXT, hp INTEGER, attack INTEGER, defense INTEGER, speed INTEGER, atk1 TEXT, atk2 TEXT, atk3 TEXT, image TEXT)');
  db.run('CREATE TABLE IF NOT EXISTS battle_logs (battle_id INTEGER PRIMARY KEY, log TEXT)');

  // db.run('INSERT OR REPLACE INTO players (playerid, wallet, inventory, battles) VALUES (?, ?, ?, ?)', [1, "0x86924c37a93734e8611eb081238928a9d18a63c0", '[25,11,6,47,27,36,9]', '[]']); //create with few pokemons for testing
  // db.run('INSERT OR REPLACE INTO players (playerid, wallet, inventory, battles) VALUES (?, ?, ?, ?)', [397059, "0xC1bd4Aa0a9ca600FaF690ae4aB67F15805d8b3A1", '[25,11,6,47,27,36,9]', '[]']); //create with few pokemons for testing
})

export default db;