wxSqlitePreparedStatement Class Reference

#include <sqlite_preparedstatement.h>

Inheritance diagram for wxSqlitePreparedStatement:

Detailed Description

Definition at line 10 of file sqlite_preparedstatement.h.

Public Member Functions
	wxSqlitePreparedStatement (sqlite3 *pDatabase)
	wxSqlitePreparedStatement (sqlite3 *pDatabase, sqlite3_stmt *pStatement)
	wxSqlitePreparedStatement (sqlite3 *pDatabase, wxSqliteStatementVector statements)
virtual	~wxSqlitePreparedStatement ()
virtual void	Close ()
	Close the result set (call wxDatabase::ClosePreparedStatement() instead on the statement) More...
void	AddPreparedStatement (sqlite3_stmt *pStatement)
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...
sqlite3_stmt *	GetLastStatement ()
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)

Private Member Functions
int	FindStatementAndAdjustPositionIndex (int *pPosition)

Private Attributes
sqlite3 *	m_pDatabase
wxSqliteStatementVector	m_Statements

Additional Inherited Members
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)
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

wxSqlitePreparedStatement() [1/3]

wxSqlitePreparedStatement::wxSqlitePreparedStatement

(

sqlite3 *

pDatabase

)

wxSqlitePreparedStatement() [2/3]

wxSqlitePreparedStatement::wxSqlitePreparedStatement	(	sqlite3 *	pDatabase,
		sqlite3_stmt *	pStatement
	)

wxSqlitePreparedStatement() [3/3]

wxSqlitePreparedStatement::wxSqlitePreparedStatement	(	sqlite3 *	pDatabase,
		wxSqliteStatementVector	statements
	)

~wxSqlitePreparedStatement()

virtual wxSqlitePreparedStatement::~wxSqlitePreparedStatement ( )

virtual

Member Function Documentation

AddPreparedStatement()

void wxSqlitePreparedStatement::AddPreparedStatement

(

sqlite3_stmt *

pStatement

)

Close()

virtual void wxSqlitePreparedStatement::Close ( )

virtual

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

Implements wxPreparedStatement.

FindStatementAndAdjustPositionIndex()

int wxSqlitePreparedStatement::FindStatementAndAdjustPositionIndex ( int *  pPosition )

private

GetLastStatement()

sqlite3_stmt* wxSqlitePreparedStatement::GetLastStatement ( )

inline

Definition at line 38 of file sqlite_preparedstatement.h.

References m_Statements.

GetParameterCount()

virtual int wxSqlitePreparedStatement::GetParameterCount ( )

virtual

Implements wxPreparedStatement.

RunQuery()

virtual int wxSqlitePreparedStatement::RunQuery ( )

virtual

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

Implements wxPreparedStatement.

RunQueryWithResults()

virtual wxDatabaseResultSet* wxSqlitePreparedStatement::RunQueryWithResults ( )

virtual

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

Implements wxPreparedStatement.

SetParamBlob()

virtual void wxSqlitePreparedStatement::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 wxSqlitePreparedStatement::SetParamBool ( int  nPosition, bool  bValue  )

virtual

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

Implements wxPreparedStatement.

SetParamDate()

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

virtual

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

Implements wxPreparedStatement.

SetParamDouble()

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

virtual

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

Implements wxPreparedStatement.

SetParamInt()

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

virtual

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

Implements wxPreparedStatement.

SetParamNull()

virtual void wxSqlitePreparedStatement::SetParamNull ( int  nPosition )

virtual

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

Implements wxPreparedStatement.

SetParamString()

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

virtual

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

Implements wxPreparedStatement.

Member Data Documentation

m_pDatabase

sqlite3* wxSqlitePreparedStatement::m_pDatabase

private

Definition at line 43 of file sqlite_preparedstatement.h.

m_Statements

wxSqliteStatementVector wxSqlitePreparedStatement::m_Statements

private

Definition at line 44 of file sqlite_preparedstatement.h.

Referenced by GetLastStatement().