/*
===========================================================================
oastat - OpenArena stat program
Copyright (C) 2010 Poul Sander (oastat@poulsander.com)

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
===========================================================================
*/

#ifndef _DB2POSTGRESQL_H
#define	_DB2POSTGRESQL_H

#include "database.hpp"
#include "postgresql/libpq-fe.h"

using namespace std;

class Db2PostgreSQL : public Database{
public:
    Db2PostgreSQL();
    Db2PostgreSQL(string args);
    Db2PostgreSQL(const Db2PostgreSQL& orig);
    virtual ~Db2PostgreSQL();
    void createTables();
    void startGame(int gametype, string mapname, string basegame);
    void endGame(int second);
    int getGameNumber();
    void setPlayerInfo(string guid, string nickname, bool isBot, int second, int team, string model, string headmodel, int skill);
    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);
private:
    int simpleQuery(const char *);
    string sqlescape(string sql);
    PGconn *conn;
    PGresult   *res;
    int gamenumber;
    char query_string[4096];
};

#endif	/* _DB2POSTGRESQL_H */