SqliteDb.h

From Giona

Revision as of 12:24, 15 December 2007 (view source) Rmarino (Talk | contribs) ← Previous diff		Revision as of 12:24, 15 December 2007 (view source) Rmarino (Talk | contribs) Next diff →
Line 15:		Line 15:
	public:		public:
-	static const int NO_ERROR = 0;	+	static const int NO_ERROR = 0;
-	static const int ERROR_NULL_PARAMETER = 1;	+	static const int ERROR_NULL_PARAMETER = 1;
-	static const int ERROR_EMPTY_STRING = 2;	+	static const int ERROR_EMPTY_STRING = 2;
-	static const int ERROR_CONNECTION_OPEN_YET = 3;	+	static const int ERROR_CONNECTION_OPEN_YET = 3;
	static const int ERROR_DATABASE_NAME_NOT_SET = 4;		static const int ERROR_DATABASE_NAME_NOT_SET = 4;
-	static const int ERROR_SQLITE_ERROR = 5;	+	static const int ERROR_SQLITE_ERROR = 5;
-	static const int ERROR_CONNECTION_NOT_OPEN = 6;	+	static const int ERROR_CONNECTION_NOT_OPEN = 6;
	static const int ERROR_CANT_CREATE_RESULT_SET = 7;		static const int ERROR_CANT_CREATE_RESULT_SET = 7;

---

Revision as of 12:24, 15 December 2007

#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);
	bool openDataBase();
	bool closeDataBase();
	bool executeSqlCommand(char* sqlCommand);
	
	SqliteDBResultSet* executeQuery(char* query);
	
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