odbc_database.h

Go to the documentation of this file.

#ifndef _WX_DATABASE_ODBC_H_
#define _WX_DATABASE_ODBC_H_

#include "wx/database/wxprec.h"

class wxOdbcInterface;

#define ERR_BUFFER_LEN 1024
#define ERR_STATE_LEN 10


class WXDLLIMPEXP_DATABASE wxOdbcDatabase : public wxDatabase
{
public:
  // ctor()
  wxOdbcDatabase();
  
  // dtor()
  virtual ~wxOdbcDatabase();
  
  // open database
  virtual bool Open();
  virtual bool Open(const wxString& strConnection);
  virtual bool Open(const wxString& strDSN, const wxString& strUser, const wxString& strPassword);
#if wxUSE_GUI
  virtual bool Open(const wxString& strConnection, bool bPromptForInfo, wxWindow* parent = NULL);
#endif

  // close database  
  virtual bool Close();
  
  // Is the connection to the database open?
  virtual bool IsOpen();

  // transaction support
  virtual void BeginTransaction();
  virtual void Commit();
  virtual void RollBack();
  
  // query database
  virtual int RunQuery(const wxString& strQuery, bool bParseQuery);
  virtual wxDatabaseResultSet* RunQueryWithResults(const wxString& strQuery);
  
  // wxPreparedStatement support
  virtual wxPreparedStatement* PrepareStatement(const wxString& strQuery);
 
  // Database schema API contributed by M. Szeftel (author of wxActiveRecordGenerator)
  virtual bool TableExists(const wxString& table);
  virtual bool ViewExists(const wxString& view);
  virtual wxArrayString GetTables();
  virtual wxArrayString GetViews();
  virtual wxArrayString GetColumns(const wxString& table);
  virtual wxArrayString GetPKColumns(const wxString& table);

  static bool IsAvailable();

private:
  virtual wxPreparedStatement* PrepareStatement(const wxString& strQuery, bool bParseQuery);
  
  //SQLHENV m_sqlEnvHandle;
  void* m_sqlEnvHandle;
  //SQLHDBC m_sqlHDBC;
  void* m_sqlHDBC;

  wxString m_strDSN;
  wxString m_strUser;
  wxString m_strPassword;

  wxString m_strConnection;
#if wxUSE_GUI
  bool m_bPrompt;
  wxWindow* m_pParent;
#endif

  bool m_bIsConnected;
  wxOdbcInterface* m_pInterface;

public:

  // error handling
  //void InterpretErrorCodes( long nCode, SQLHSTMT stmth_ptr = NULL );
  void InterpretErrorCodes( long nCode, void* stmth_ptr = NULL );

  //SQLHANDLE allocStmth();
  void* allocStmth();
};

#endif//_WX_DATABASE_ODBC_H_