use mysql;

use mysql::{params, error::Error, error::DriverError};

struct AccountInfo {

    is_registered: bool,

    is_admin: bool,

    is_contributor: bool,

}

struct ServerStatistics {

    rooms: u32,

    players: u32,

}

struct Achievements {}

trait DatabaseInterface {

    fn check_account(username: &str, password: &str) -> AccountInfo;

    fn store_stats(stats: &ServerStatistics) -> Result<(), ()>;

    fn store_achievements(achievements: &Achievements) -> Result<(), ()>;

    fn get_replay_name(replay_id: u32) -> Result<String, ()>;

}

struct Database {

    pool: Option<mysql::Pool>,

}

impl Database {

    fn new() -> Self {

        Self { pool: None }

    }

    fn connect(&mut self, url: &str) -> Result<(), Error> {

        self.pool = Some(mysql::Pool::new(url)?);

        Ok(())

    }

    fn check_account(&mut self, username: &str, password: &str) -> AccountInfo {

        AccountInfo {

            is_registered: false,

            is_admin: false,

            is_contributor: false,

        }

    }

    fn store_stats(&mut self, stats: &ServerStatistics) -> Result<(), Error> {

        if let Some(pool) = &self.pool {

        for mut stmt in pool.prepare(r"INSERT INTO gameserver_stats (players, rooms, last_update) VALUES (:players, :rooms, UNIX_TIMESTAMP())").into_iter() {

                stmt.execute(params!{

                "players" => stats.players,

                "rooms" => stats.rooms,

            })?;

        }

            Ok(())

        } else {

            Err(DriverError::SetupError.into())

        }

    }

    fn store_achievements(&mut self, achievements: &Achievements) -> Result<(), ()> {

        Ok(())

    }

    fn get_replay_name(&mut self, replay_id: u32) -> Result<String, ()> {

        Err(())

    }

}