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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
|
/*
CVSNT Generic API
Copyright (C) 2004 Tony Hoyle and March-Hare Software Ltd
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public
License along with this library; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
#ifdef _WIN32
#define WIN32_LEAN_AND_MEAN
#include <windows.h>
#include <winsock2.h>
#endif
#include <config.h>
#include "../lib/api_system.h"
#ifdef HAVE_SQLITE3_H
#include <sqlite3.h>
#else
// else what??
#endif
#include "../cvs_string.h"
#include "../FileAccess.h"
#include "../ServerIO.h"
#include "SQLiteConnection.h"
#include "SQLiteRecordset.h"
extern "C" CSqlConnection *SQLite_Alloc()
{
return new CSQLiteConnection;
}
CSQLiteConnection::CSQLiteConnection()
{
m_pDb=NULL;
}
CSQLiteConnection::~CSQLiteConnection()
{
Close();
}
bool CSQLiteConnection::Create(const char *host, const char *database, const char *username, const char *password)
{
if(CFileAccess::exists(database))
return false;
#ifdef _WIN32
__try
{
#endif
if(sqlite3_open(database, &m_pDb))
return false;
#ifdef _WIN32
}
__except (EXCEPTION_EXECUTE_HANDLER)
{
return false;
}
#endif
return true;
}
bool CSQLiteConnection::Open(const char *host, const char *database, const char *username, const char *password)
{
if(!CFileAccess::exists(database))
return false;
#ifdef _WIN32
__try
{
#endif
if(sqlite3_open(database, &m_pDb))
return false;
#ifdef _WIN32
}
__except (EXCEPTION_EXECUTE_HANDLER)
{
return false;
}
#endif
return true;
}
bool CSQLiteConnection::Close()
{
if(m_pDb)
sqlite3_close(m_pDb);
m_pDb=NULL;
return true;
}
bool CSQLiteConnection::IsOpen()
{
if(m_pDb)
return true;
return false;
}
CSqlRecordsetPtr CSQLiteConnection::Execute(const char *string, ...)
{
cvs::string str;
va_list va;
va_start(va,string);
cvs::vsprintf(str,64,string,va);
va_end(va);
CSQLiteRecordset *rs = new CSQLiteRecordset();
CServerIo::trace(3,"%s",str.c_str());
sqlite3_stmt *pStmt;
const char *zTail = NULL;
if(sqlite3_prepare(m_pDb,str.c_str(),(int)str.length(),&pStmt,&zTail))
return rs;
for(std::map<int,CSqlVariant>::iterator i = m_bindVars.begin(); i!=m_bindVars.end(); ++i)
{
switch(i->second.type())
{
case CSqlVariant::vtNull:
sqlite3_bind_null(pStmt,i->first+1);
break;
case CSqlVariant::vtChar:
case CSqlVariant::vtShort:
case CSqlVariant::vtInt:
case CSqlVariant::vtLong:
case CSqlVariant::vtUChar:
case CSqlVariant::vtUShort:
case CSqlVariant::vtUInt:
case CSqlVariant::vtULong:
sqlite3_bind_int(pStmt,i->first+1,(int)i->second);
break;
case CSqlVariant::vtLongLong:
case CSqlVariant::vtULongLong:
#ifdef _WIN32
sqlite3_bind_int64(pStmt,i->first+1,(__int64)i->second);
#else
sqlite3_bind_int64(pStmt,i->first+1,(long long)i->second);
#endif
break;
case CSqlVariant::vtString:
sqlite3_bind_text(pStmt,i->first+1,(const char *)i->second,-1,SQLITE_STATIC);
break;
case CSqlVariant::vtWString:
sqlite3_bind_text16(pStmt,i->first+1,(const wchar_t *)i->second,-1,SQLITE_STATIC);
break;
}
}
rs->Init(m_pDb,pStmt);
m_bindVars.clear();
return rs;
}
bool CSQLiteConnection::Error() const
{
int err = sqlite3_errcode(m_pDb);
if(err && err<100)
return true;
return false;
}
const char *CSQLiteConnection::ErrorString()
{
if(!m_pDb)
return "Open failed";
return sqlite3_errmsg(m_pDb);
}
unsigned CSQLiteConnection::GetInsertIdentity(const char *table_hint)
{
return (unsigned)sqlite3_last_insert_rowid(m_pDb);
}
bool CSQLiteConnection::BeginTrans()
{
if(sqlite3_exec(m_pDb,"BEGIN",NULL,NULL,NULL)==SQLITE_OK)
return true;
return false;
}
bool CSQLiteConnection::CommitTrans()
{
if(sqlite3_exec(m_pDb,"COMMIT",NULL,NULL,NULL)==SQLITE_OK)
return true;
return false;
}
bool CSQLiteConnection::RollbackTrans()
{
if(sqlite3_exec(m_pDb,"ROLLBACK",NULL,NULL,NULL)==SQLITE_OK)
return true;
return false;
}
bool CSQLiteConnection::Bind(int variable, CSqlVariant value)
{
m_bindVars[variable]=value;
return true;
}
|
