DatabaseLayer.h

Go to the documentation of this file.

#ifndef __DATABASE_LAYER_H__
#define __DATABASE_LAYER_H__

// For compilers that support precompilation, includes "wx.h".
#include "wx/wxprec.h"

#ifdef __BORLANDC__
    #pragma hdrstop
#endif

#ifndef WX_PRECOMP
    #include "wx/wx.h"
#endif

#include "wx/hashset.h"
#include "wx/arrstr.h"

#include "DatabaseErrorReporter.h"
#include "DatabaseStringConverter.h"
#include "DatabaseResultSet.h"
#include "PreparedStatement.h"

WX_DECLARE_HASH_SET( DatabaseResultSet*, wxPointerHash, wxPointerEqual, DatabaseResultSetHashSet );
WX_DECLARE_HASH_SET( PreparedStatement*, wxPointerHash, wxPointerEqual, DatabaseStatementHashSet );

class DatabaseLayer : public DatabaseErrorReporter, public DatabaseStringConverter
{
public:
  DatabaseLayer();
  
  virtual ~DatabaseLayer();
  
  // Open database
  virtual bool Open(const wxString& strDatabase) = 0;
  
  virtual bool Close() = 0;
  
  // transaction support
  virtual void BeginTransaction() = 0;
  virtual void Commit() = 0;
  virtual void RollBack() = 0;
 
  // query database
  virtual bool RunQuery(const wxString& strQuery);
  virtual bool RunQuery(const wxString& strQuery, bool bParseQueries) = 0;
  virtual DatabaseResultSet* RunQueryWithResults(const wxString& strQuery) = 0;
  
  virtual bool CloseResultSet(DatabaseResultSet* pResultSet);

  // PreparedStatement support
  virtual PreparedStatement* PrepareStatement(const wxString& strQuery) = 0;
  virtual bool CloseStatement(PreparedStatement* pStatement);

  // function names more consistent with JDBC and wxSQLite3
  // these just provide wrappers for existing functions
  bool ExecuteUpdate(const wxString& strQuery) { return RunQuery(strQuery); }
  DatabaseResultSet* ExecuteQuery(const wxString& strQuery) { return RunQueryWithResults(strQuery); }

protected:
  void CloseResultSets();
  void CloseStatements();
  
  void LogResultSetForCleanup(DatabaseResultSet* pResultSet) { m_ResultSets.insert(pResultSet); }
  void LogStatementForCleanup(PreparedStatement* pStatement) { m_Statements.insert(pStatement); }
  
private:
  DatabaseResultSetHashSet m_ResultSets;
  DatabaseStatementHashSet m_Statements;
};

#endif // __DATABASE_LAYER_H__

---