/*
 *  Baltisot
 *  Copyright (C) 1999-2007 Nicolas "Pixel" Noble
 *
 *  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
 */

/* $Id: SQL.h,v 1.13 2007-06-19 13:39:34 pixel Exp $ */

#ifndef __SQL_H__
#define __SQL_H__

#include <map>
#include <mysql.h>
#include <Exceptions.h>

#ifdef errno
#undef errno
#endif

typedef std::map<String, String> AssocArray;
typedef std::map<String, String>::iterator AssocArrayIterator;

class SQLConnection : public Base {
  public:
      SQLConnection(const String & host, const String & user, const String & passwd, const String & db, int port = 3306, const String & socket = "", unsigned long clags = 0) throw (GeneralException);
      ~SQLConnection();
    int query(const String &);
    int numrows();
    int numfields();
    AssocArray fetchrow();
    int numaffectedrows();
    int insertid();
    int errno();
    String error();
  private:
    MYSQL * con;
    MYSQL_RES * res;
    int nr, nf, na, ii;
    MYSQL_FIELD * fields;
};

#endif