Version: 1.0.0
wxPostgresPreparedStatement Class Reference

#include <postgresql_preparedstatement.h>

+ Inheritance diagram for wxPostgresPreparedStatement:

Detailed Description

Definition at line 9 of file postgresql_preparedstatement.h.

Public Member Functions

 wxPostgresPreparedStatement (wxDynamicPostgresInterface *pInterface)
 
 wxPostgresPreparedStatement (wxDynamicPostgresInterface *pInterface, PGconn *pDatabase, const wxString &strSQL, const wxString &strStatementName)
 
virtual ~wxPostgresPreparedStatement ()
 
virtual void Close ()
 Close the result set (call wxDatabase::ClosePreparedStatement() instead on the statement) More...
 
void AddStatement (PGconn *pDatabase, const wxString &strSQL, const wxString &strStatementName)
 
virtual void SetParamInt (int nPosition, int nValue)
 Set the parameter at the 1-based position to an int value. More...
 
virtual void SetParamDouble (int nPosition, double dblValue)
 Set the parameter at the 1-based position to a double value. More...
 
virtual void SetParamString (int nPosition, const wxString &strValue)
 Set the parameter at the 1-based position to a wxString value. More...
 
virtual void SetParamNull (int nPosition)
 Set the parameter at the 1-based position to a NULL value. More...
 
virtual void SetParamBlob (int nPosition, const void *pData, long nDataLength)
 Set the parameter at the 1-based position to a Blob value. More...
 
virtual void SetParamDate (int nPosition, const wxDateTime &dateValue)
 Set the parameter at the 1-based position to a wxDateTime value. More...
 
virtual void SetParamBool (int nPosition, bool bValue)
 Set the parameter at the 1-based position to a boolean value. More...
 
virtual int GetParameterCount ()
 
virtual int RunQuery ()
 Run an insert, update, or delete query on the database. More...
 
virtual wxDatabaseResultSetRunQueryWithResults ()
 Run an insert, update, or delete query on the database. More...
 
- Public Member Functions inherited from wxPreparedStatement
 wxPreparedStatement ()
 Constructor. More...
 
virtual ~wxPreparedStatement ()
 Destructor. More...
 
virtual void SetParamBlob (int nPosition, const wxMemoryBuffer &buffer)
 Set the parameter at the 1-based position to a Blob value. More...
 
int ExecuteUpdate ()
 See RunQuery. More...
 
wxDatabaseResultSetExecuteQuery ()
 See RunQueryWithResults. More...
 
virtual bool CloseResultSet (wxDatabaseResultSet *pResultSet)
 Close a result set returned by the database or a prepared statement previously. More...
 
- Public Member Functions inherited from wxDatabaseErrorReporter
 wxDatabaseErrorReporter ()
 
virtual ~wxDatabaseErrorReporter ()
 
const wxString & GetErrorMessage ()
 
int GetErrorCode ()
 
void ResetErrorCodes ()
 
- Public Member Functions inherited from wxDatabaseStringConverter
 wxDatabaseStringConverter ()
 
 wxDatabaseStringConverter (const wxChar *charset)
 
virtual ~wxDatabaseStringConverter ()
 
void SetEncoding (wxFontEncoding encoding)
 
void SetEncoding (const wxCSConv *conv)
 
const wxCSConv * GetEncoding ()
 
virtual const wxCharBuffer ConvertToUnicodeStream (const wxString &inputString)
 
virtual size_t GetEncodedStreamLength (const wxString &inputString)
 
virtual wxString ConvertFromUnicodeStream (const char *inputBuffer)
 
virtual wxString ConvertFromUnicodeStream (const wxChar *inputBuffer)
 

Static Public Member Functions

static wxPostgresPreparedStatementCreateStatement (wxDynamicPostgresInterface *pInterface, PGconn *pDatabase, const wxString &strSQL)
 
static wxString TranslateSQL (const wxString &strOriginalSQL)
 
- Static Public Member Functions inherited from wxDatabaseStringConverter
static const wxCharBuffer ConvertToUnicodeStream (const wxString &inputString, const char *encoding)
 
static wxString ConvertFromUnicodeStream (const char *inputBuffer, const char *encoding)
 
static size_t GetEncodedStreamLength (const wxString &inputString, const char *encoding)
 
static wxString ConvertFromUnicodeStream (const wxChar *inputBuffer, const char *encoding)
 

Private Member Functions

int FindStatementAndAdjustPositionIndex (int *pPosition)
 

Static Private Member Functions

static wxString GenerateRandomStatementName ()
 

Private Attributes

wxDynamicPostgresInterfacem_pInterface
 
ArrayOfPostgresPreparedStatementWrappers m_Statements
 

Additional Inherited Members

- Protected Member Functions inherited from wxPreparedStatement
void CloseResultSets ()
 Close all result set objects that have been generated but not yet closed. More...
 
void LogResultSetForCleanup (wxDatabaseResultSet *pResultSet)
 Add result set object pointer to the list for "garbage collection". More...
 
- Protected Member Functions inherited from wxDatabaseErrorReporter
void SetErrorMessage (const wxString &strErrorMessage)
 
void SetErrorCode (int nErrorCode)
 
void ThrowDatabaseException ()
 

Constructor & Destructor Documentation

◆ wxPostgresPreparedStatement() [1/2]

wxPostgresPreparedStatement::wxPostgresPreparedStatement ( wxDynamicPostgresInterface pInterface)

◆ wxPostgresPreparedStatement() [2/2]

wxPostgresPreparedStatement::wxPostgresPreparedStatement ( wxDynamicPostgresInterface pInterface,
PGconn *  pDatabase,
const wxString &  strSQL,
const wxString &  strStatementName 
)

◆ ~wxPostgresPreparedStatement()

virtual wxPostgresPreparedStatement::~wxPostgresPreparedStatement ( )
virtual

Member Function Documentation

◆ AddStatement()

void wxPostgresPreparedStatement::AddStatement ( PGconn *  pDatabase,
const wxString &  strSQL,
const wxString &  strStatementName 
)

◆ Close()

virtual void wxPostgresPreparedStatement::Close ( )
virtual

Close the result set (call wxDatabase::ClosePreparedStatement() instead on the statement)

Implements wxPreparedStatement.

◆ CreateStatement()

static wxPostgresPreparedStatement* wxPostgresPreparedStatement::CreateStatement ( wxDynamicPostgresInterface pInterface,
PGconn *  pDatabase,
const wxString &  strSQL 
)
static

◆ FindStatementAndAdjustPositionIndex()

int wxPostgresPreparedStatement::FindStatementAndAdjustPositionIndex ( int *  pPosition)
private

◆ GenerateRandomStatementName()

static wxString wxPostgresPreparedStatement::GenerateRandomStatementName ( )
staticprivate

◆ GetParameterCount()

virtual int wxPostgresPreparedStatement::GetParameterCount ( )
virtual

Implements wxPreparedStatement.

◆ RunQuery()

virtual int wxPostgresPreparedStatement::RunQuery ( )
virtual

Run an insert, update, or delete query on the database.

Implements wxPreparedStatement.

◆ RunQueryWithResults()

virtual wxDatabaseResultSet* wxPostgresPreparedStatement::RunQueryWithResults ( )
virtual

Run an insert, update, or delete query on the database.

Implements wxPreparedStatement.

◆ SetParamBlob()

virtual void wxPostgresPreparedStatement::SetParamBlob ( int  nPosition,
const void *  pData,
long  nDataLength 
)
virtual

Set the parameter at the 1-based position to a Blob value.

Implements wxPreparedStatement.

◆ SetParamBool()

virtual void wxPostgresPreparedStatement::SetParamBool ( int  nPosition,
bool  bValue 
)
virtual

Set the parameter at the 1-based position to a boolean value.

Implements wxPreparedStatement.

◆ SetParamDate()

virtual void wxPostgresPreparedStatement::SetParamDate ( int  nPosition,
const wxDateTime &  dateValue 
)
virtual

Set the parameter at the 1-based position to a wxDateTime value.

Implements wxPreparedStatement.

◆ SetParamDouble()

virtual void wxPostgresPreparedStatement::SetParamDouble ( int  nPosition,
double  dblValue 
)
virtual

Set the parameter at the 1-based position to a double value.

Implements wxPreparedStatement.

◆ SetParamInt()

virtual void wxPostgresPreparedStatement::SetParamInt ( int  nPosition,
int  nValue 
)
virtual

Set the parameter at the 1-based position to an int value.

Implements wxPreparedStatement.

◆ SetParamNull()

virtual void wxPostgresPreparedStatement::SetParamNull ( int  nPosition)
virtual

Set the parameter at the 1-based position to a NULL value.

Implements wxPreparedStatement.

◆ SetParamString()

virtual void wxPostgresPreparedStatement::SetParamString ( int  nPosition,
const wxString &  strValue 
)
virtual

Set the parameter at the 1-based position to a wxString value.

Implements wxPreparedStatement.

◆ TranslateSQL()

static wxString wxPostgresPreparedStatement::TranslateSQL ( const wxString &  strOriginalSQL)
static

Member Data Documentation

◆ m_pInterface

wxDynamicPostgresInterface* wxPostgresPreparedStatement::m_pInterface
private

Definition at line 40 of file postgresql_preparedstatement.h.

◆ m_Statements

ArrayOfPostgresPreparedStatementWrappers wxPostgresPreparedStatement::m_Statements
private

Definition at line 44 of file postgresql_preparedstatement.h.