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
|
#ifndef INSPIRCD_SQLAPI_2
#define INSPIRCD_SQLAPI_2
#include <string>
#include <deque>
#include <map>
#include "modules.h"
/* This is the voodoo magic which lets us pass multiple parameters
* to the SQLrequest constructor..voodoo...
*/
#define SQLreq(a, b, c, d, e...) SQLrequest(a, b, c, (SQLquery(d), ##e))
#define SQLREQID "SQLv2 Request"
#define SQLRESID "SQLv2 Result"
#define SQLSUCCESS "You shouldn't be reading this (success)"
enum SQLerrorNum { NO_ERROR, BAD_DBID, BAD_CONN, QSEND_FAIL };
typedef std::deque<std::string> ParamL;
class SQLexception : public ModuleException
{
};
class SQLbadColName : public SQLexception
{
public:
SQLbadColName() { }
};
class SQLerror : public classbase
{
SQLerrorNum id;
std::string str;
public:
SQLerror(SQLerrorNum i = NO_ERROR, const std::string &s = "")
: id(i), str(s)
{
}
SQLerrorNum Id()
{
return id;
}
SQLerrorNum Id(SQLerrorNum i)
{
id = i;
return id;
}
void Str(const std::string &s)
{
str = s;
}
const char* Str()
{
if(str.length())
return str.c_str();
switch(id)
{
case NO_ERROR:
return "No error";
case BAD_DBID:
return "Invalid database ID";
case BAD_CONN:
return "Invalid connection";
case QSEND_FAIL:
return "Sending query failed";
default:
return "Unknown error";
}
}
};
class SQLquery
{
public:
std::string q;
ParamL p;
SQLquery(const std::string &query)
: q(query)
{
log(DEBUG, "SQLquery constructor: %s", q.c_str());
}
SQLquery(const std::string &query, const ParamL ¶ms)
: q(query), p(params)
{
log(DEBUG, "SQLquery constructor with %d params: %s", p.size(), q.c_str());
}
SQLquery& operator,(const std::string &foo)
{
p.push_back(foo);
return *this;
}
SQLquery& operator%(const std::string &foo)
{
p.push_back(foo);
return *this;
}
};
class SQLrequest : public Request
{
public:
SQLquery query;
std::string dbid;
bool pri;
unsigned long id;
SQLerror error;
SQLrequest(Module* s, Module* d, const std::string &databaseid, const SQLquery &q)
: Request(SQLREQID, s, d), query(q), dbid(databaseid), pri(false), id(0)
{
}
void Priority(bool p = true)
{
pri = p;
}
void SetSource(Module* mod)
{
source = mod;
}
};
class SQLfield
{
public:
/* The data itself */
std::string d;
/* If the field was null */
bool null;
SQLfield(const std::string &data, bool n)
: d(data), null(n)
{
}
};
typedef std::vector<SQLfield> SQLfieldList;
typedef std::map<std::string, SQLfield> SQLfieldMap;
class SQLresult : public Request
{
public:
std::string query;
std::string dbid;
SQLerror error;
SQLresult(Module* s, Module* d)
: Request(SQLRESID, s, d)
{
}
/* Return the number of rows in the result */
virtual int Rows() = 0;
/* Return the number of columns in the result */
virtual int Cols() = 0;
/* Get a string name of the column by an index number */
virtual std::string ColName(int column) = 0;
/* Get an index number for a column from a string name.
* An exception of type SQLbadColName will be thrown if
* the name given is invalid.
*/
virtual int ColNum(const std::string &column) = 0;
/* Get a string value in a given row and column */
virtual SQLfield GetValue(int row, int column) = 0;
/* Return a list of values in a row, this should
* increment an internal counter so you can repeatedly
* call it until it returns an empty vector.
* This returns a reference to an internal object,
* the same object is used for all calls to this function
* and therefore the return value is only valid until
* you call this function again. It is also invalid if
* the SQLresult object is destroyed.
*/
virtual SQLfieldList& GetRow() = 0;
/* As above, but return a map indexed by key name */
virtual SQLfieldMap& GetRowMap() = 0;
/* Like GetRow(), but returns a pointer to a dynamically
* allocated object which must be explicitly freed. For
* portability reasons this must be freed with SQLresult::Free()
*/
virtual SQLfieldList* GetRowPtr() = 0;
/* As above, but return a map indexed by key name */
virtual SQLfieldMap* GetRowMapPtr() = 0;
/* Overloaded function for freeing the lists and maps returned
* above.
*/
virtual void Free(SQLfieldMap* fm) = 0;
virtual void Free(SQLfieldList* fl) = 0;
};
#endif
|
