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
|
#ifndef DB_COMMAND_H
#define DB_COMMAND_H
#include <glibmm/ustring.h>
#include <boost/date_time/posix_time/posix_time_types.hpp>
#include <boost/shared_ptr.hpp>
#include <visibility.h>
#include "error.h"
namespace DB {
/// Exception thrown when binding a parameter of type the connector doesn't support.
class DLL_PUBLIC ParameterTypeNotSupported : public Error {
public:
ParameterTypeNotSupported();
};
/// Exception thrown when binding a parameter out of range of those defined in the command.
class DLL_PUBLIC ParameterOutOfRange : public Error {
public:
ParameterOutOfRange();
};
/// Represents the basics of any command to be executed against a database.
class DLL_PUBLIC Command {
public:
/// Creates a new command from the given SQL.
Command(const std::string & sql);
virtual ~Command() = 0;
/// Bind an integer to parameter i.
virtual void bindParamI(unsigned int i, int val) = 0;
/// Bind an integer to parameter i.
virtual void bindParamI(unsigned int i, long val) = 0;
/// Bind an integer to parameter i.
virtual void bindParamI(unsigned int i, long long val) = 0;
/// Bind an integer to parameter i.
virtual void bindParamI(unsigned int i, unsigned int val) = 0;
/// Bind an integer to parameter i.
virtual void bindParamI(unsigned int i, unsigned long int val) = 0;
/// Bind an integer to parameter i.
virtual void bindParamI(unsigned int i, unsigned long long int val) = 0;
/// Bind a boolean to parameter i.
virtual void bindParamB(unsigned int i, bool val) = 0;
/// Bind a floating point number to parameter i.
virtual void bindParamF(unsigned int i, double val) = 0;
/// Bind a floating point number to parameter i.
virtual void bindParamF(unsigned int i, float val) = 0;
/// Bind a string to parameter i.
virtual void bindParamS(unsigned int i, const Glib::ustring &) = 0;
/// Bind a duration to parameter i.
virtual void bindParamT(unsigned int i, const boost::posix_time::time_duration &) = 0;
/// Bind a date time to parameter i.
virtual void bindParamT(unsigned int i, const boost::posix_time::ptime &) = 0;
/// Bind null to parameter i.
virtual void bindNull(unsigned int i) = 0;
/// The SQL statement.
const std::string sql;
#define OPTWRAPPER(func) \
template<typename O> \
inline void func(unsigned int i, const O & o) { \
if (o) \
func(i, *o); \
else \
bindNull(i); \
}
OPTWRAPPER(bindParamI);
OPTWRAPPER(bindParamF);
OPTWRAPPER(bindParamS);
OPTWRAPPER(bindParamB);
OPTWRAPPER(bindParamT);
void bindParamS(unsigned int, const char * const);
void bindParamS(unsigned int, char * const);
};
typedef boost::shared_ptr<Command> CommandPtr;
}
#endif
|
