1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
#ifndef __SQLITE_PREPARED_STATEMENT_H__
#define __SQLITE_PREPARED_STATEMENT_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/dynarray.h"
#include "PreparedStatement.h"
#include "sqlite3.h"
WX_DEFINE_ARRAY_PTR(sqlite3_stmt*, StatementVector);
class DatabaseResultSet;
class SqlitePreparedStatement : public PreparedStatement
{
public:
// ctor
SqlitePreparedStatement(sqlite3* pDatabase);
SqlitePreparedStatement(sqlite3* pDatabase, sqlite3_stmt* pStatement);
SqlitePreparedStatement(sqlite3* pDatabase, StatementVector statements);
// dtor
virtual ~SqlitePreparedStatement();
virtual void Close();
void AddPreparedStatement(sqlite3_stmt* pStatement);
// get field
virtual void SetParamInt(int nPosition, int nValue);
virtual void SetParamDouble(int nPosition, double dblValue);
virtual void SetParamString(int nPosition, const wxString& strValue);
virtual void SetParamNull(int nPosition);
virtual void SetParamBlob(int nPosition, const void* pData, long nDataLength);
virtual void SetParamDate(int nPosition, const wxDateTime& dateValue);
virtual void SetParamBool(int nPosition, bool bValue);
virtual int GetParameterCount();
virtual int RunQuery();
virtual DatabaseResultSet* RunQueryWithResults();
sqlite3_stmt* GetLastStatement() { return (m_Statements.size() > 0) ? m_Statements[m_Statements.size()-1] : NULL; }
private:
int FindStatementAndAdjustPositionIndex(int* pPosition);
sqlite3* m_pDatabase; // Database pointer needed for error messages
StatementVector m_Statements;
};
#endif // __SQLITE_PREPARED_STATEMENT_H__
|
