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
|
// Copyright 2011 The Kyua Authors.
// All rights reserved.
//
// Redistribution and use in source and binary forms, with or without
// modification, are permitted provided that the following conditions are
// met:
//
// * Redistributions of source code must retain the above copyright
// notice, this list of conditions and the following disclaimer.
// * Redistributions in binary form must reproduce the above copyright
// notice, this list of conditions and the following disclaimer in the
// documentation and/or other materials provided with the distribution.
// * Neither the name of Google Inc. nor the names of its contributors
// may be used to endorse or promote products derived from this software
// without specific prior written permission.
//
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
// "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
// LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
// A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
// OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
// SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
// LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
// DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
// THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
// (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
// OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
/// \file utils/sqlite/statement.hpp
/// Wrapper classes and utilities for SQLite statement processing.
///
/// This module contains thin RAII wrappers around the SQLite 3 structures
/// representing statements.
#if !defined(UTILS_SQLITE_STATEMENT_HPP)
#define UTILS_SQLITE_STATEMENT_HPP
#include "utils/sqlite/statement_fwd.hpp"
extern "C" {
#include <stdint.h>
}
#include <memory>
#include <string>
#include "utils/sqlite/database_fwd.hpp"
namespace utils {
namespace sqlite {
/// Representation of a BLOB.
class blob {
public:
/// Memory representing the contents of the blob, or NULL if empty.
///
/// This memory must remain valid throughout the life of this object, as we
/// do not grab ownership of the memory.
const void* memory;
/// Number of bytes in memory.
int size;
/// Constructs a new blob.
///
/// \param memory_ Pointer to the contents of the blob.
/// \param size_ The size of memory_.
blob(const void* memory_, const int size_) :
memory(memory_), size(size_)
{
}
};
/// Representation of a SQL NULL value.
class null {
};
/// A RAII model for an SQLite 3 statement.
class statement {
struct impl;
/// Pointer to the shared internal implementation.
std::shared_ptr< impl > _pimpl;
statement(database&, void*);
friend class database;
public:
~statement(void);
bool step(void);
void step_without_results(void);
int column_count(void);
std::string column_name(const int);
type column_type(const int);
int column_id(const char*);
blob column_blob(const int);
double column_double(const int);
int column_int(const int);
int64_t column_int64(const int);
std::string column_text(const int);
int column_bytes(const int);
blob safe_column_blob(const char*);
double safe_column_double(const char*);
int safe_column_int(const char*);
int64_t safe_column_int64(const char*);
std::string safe_column_text(const char*);
int safe_column_bytes(const char*);
void reset(void);
void bind(const int, const blob&);
void bind(const int, const double);
void bind(const int, const int);
void bind(const int, const int64_t);
void bind(const int, const null&);
void bind(const int, const std::string&);
template< class T > void bind(const char*, const T&);
int bind_parameter_count(void);
int bind_parameter_index(const std::string&);
std::string bind_parameter_name(const int);
void clear_bindings(void);
};
} // namespace sqlite
} // namespace utils
#endif // !defined(UTILS_SQLITE_STATEMENT_HPP)
|
