SqliteDb.h

From Giona

#ifndef SQLITEDB_H_
#define SQLITEDB_H_

#include <cstring>
#include "sqlite3.h"
#include "Debug.h"
#include "SqliteDBResultSet.h"




class SqliteDb
{
public:
	
	static const int NO_ERROR 			= 0;
	static const int ERROR_NULL_PARAMETER 		= 1;
	static const int ERROR_EMPTY_STRING 		= 2;
	static const int ERROR_CONNECTION_OPEN_YET 	= 3;
	static const int ERROR_DATABASE_NAME_NOT_SET 	= 4;
	static const int ERROR_SQLITE_ERROR		= 5;
	static const int ERROR_CONNECTION_NOT_OPEN	= 6;
	static const int ERROR_CANT_CREATE_RESULT_SET	= 7;
	
	SqliteDb();
	virtual ~SqliteDb();
	bool isConnected();
	int getLastError();
	bool setDataBaseName(char* dataBaseName);
	char* getDatabaseName();
	bool openDataBase();
	bool closeDataBase();
	bool executeSqlCommand(char* sqlCommand);
	SqliteDBResultSet* executeQuery(char* query);
	char* apex(char* field);
	
private:
	bool connected;
	sqlite3* db;
	int lastError;
	char* dataBaseName;
	SqliteDBResultSet* rsTmp;
	int nRows;
	
	bool compileResultSet(int num_fields, char **p_fields, char **p_col_names);
	static int select_callback(void *p_data, int num_fields, char **p_fields, char **p_col_names);
};


#endif /*SQLITEDB_H_*/

BACK