/* 
 * File:   Db2DbiXX.hpp
 * Author: poul
 *
 * Created on 11. oktober 2010, 20:59
 */

#ifndef _DB2DBIXX_HPP
#define	_DB2DBIXX_HPP

#include "database.hpp"

#include <dbixx/dbixx.h>
#include <iostream>
#include <sstream>
#include <set>

using namespace std;
using namespace dbixx;

class Db2DbiXX  : public Database {
public:
    Db2DbiXX();
    Db2DbiXX(string dbargs);
    Db2DbiXX(const Db2DbiXX& orig);
    virtual ~Db2DbiXX();
    void createTables();
    void startGame(int gametype, string mapname, string basegame, string servername, OaStatStruct *oss);
    void addGameCvar(string cvar, string value);
    void endGame(int second);
    int getGameNumber();
    void setPlayerInfo(string guid, string nickname, bool isBot, int second, int team, string model, string headmodel, int skill, OaStatStruct *oss);
    void addKill(int second, string attackerID, string targetID, int type);
    //void addCapture(int second, string player, int team);
    void addAward(int second, string player, int award);
    void addScoreInfo(int second, string player, int score);
    void addCtf(int second, string player, int team, int event);
    void addCtf1f(int second, string player, int team, int event);
    void addElimination(int second, int roundnumber, int team, int event);
    void addCtfElimination(int second, int roundnumber, string player, int team, int event);
    void addHarvester(int second, string player1, string player2, int team, int event, int score);
    void addChallenge(int second, string player, int challenge, int amount);
    void doNotCommit();
private:
    session *sql;
    transaction *commitlock;
    bool isok;
    bool debug;
    int gamenumber;
    int getNextGameNumber();
    int getLastGameNumber();
    void Commit();
    void Rollback();
    bool Ok();
    void SetOk(bool ok);
    void DebugMessage(string msg);
    void InitStrings(string backend);
    void ReadConfigFromDb();
    bool IsDuplicate(string servername, tm thetime);
    string sql_backend;
    bool last_value;
    set<string> cvars2save;
    set<string> uservars2save;
};

#endif	/* _DB2DBIXX_HPP */