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 wxDatabaseResultSet * RunQueryWithResults ()
 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...
 
wxDatabaseResultSet * ExecuteQuery ()
 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 wxPostgresPreparedStatement * CreateStatement (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

wxDynamicPostgresInterface * m_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.