/sqlite3cc

To get this branch, use:
bzr branch http://bzr.ed.am/sqlite3cc
1 by edam
- initial commit
1
/*
2 by edam
- further initial development
2
 * basic_statement.cc
1 by edam
- initial commit
3
 *
22 by edam
updated email and web addresses
4
 * Copyright (C) 2009 Tim Marston <tim@ed.am>
1 by edam
- initial commit
5
 *
2 by edam
- further initial development
6
 * This file is part of sqlite3cc (hereafter referred to as "this program").
22 by edam
updated email and web addresses
7
 * See http://ed.am/dev/sqlite3cc for more information.
8
 *
9
 * This program is free software: you can redistribute it and/or modify it under
10
 * the terms of the GNU Lesser General Public License as published by the Free
11
 * Software Foundation, either version 3 of the License, or (at your option) any
12
 * later version.
13
 *
14
 * This program is distributed in the hope that it will be useful, but WITHOUT
15
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16
 * FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more
17
 * details.
1 by edam
- initial commit
18
 *
19
 * You should have received a copy of the GNU Lesser General Public License
20
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
21
 */
22
2 by edam
- further initial development
23
#include <sqlite3cc/basic_statement.h>
24
#include <sqlite3cc/exception.h>
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
25
#include <sqlite3cc/connection.h>
14 by edam
- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec
26
#include <sqlite3cc/manipulator.h>
1 by edam
- initial commit
27
#include <string.h>
28
29
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
30
sqlite::detail::basic_statement::basic_statement(
31
	connection &connection,
1 by edam
- initial commit
32
	const std::string &sql )
33
	:
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
34
	_connection( connection ),
1 by edam
- initial commit
35
	_handle( NULL ),
36
	_bind_index( 1 )
37
{
13 by edam
- made basic_statement::step() protected, for use by query and command only
38
	int code = prepare( sql );
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
39
	if( code != SQLITE_OK ) throw sqlite_error( connection, code );
1 by edam
- initial commit
40
}
41
42
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
43
sqlite::detail::basic_statement::basic_statement(
44
	connection &connection )
2 by edam
- further initial development
45
	:
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
46
	_connection( connection ),
2 by edam
- further initial development
47
	_handle( NULL ),
48
	_bind_index( 1 )
49
{
50
}
51
52
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
53
sqlite::detail::basic_statement::~basic_statement()
1 by edam
- initial commit
54
{
55
	finalize();
56
}
57
58
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
59
int sqlite::detail::basic_statement::prepare(
1 by edam
- initial commit
60
	const std::string &sql )
61
{
62
	finalize();
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
63
	return sqlite3_prepare_v2( _connection._handle, sql.c_str(),
1 by edam
- initial commit
64
		sql.length() + 1, &_handle, NULL );
65
}
66
67
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
68
int sqlite::detail::basic_statement::reset()
1 by edam
- initial commit
69
{
70
	return sqlite3_reset( _handle );
71
}
72
73
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
74
int sqlite::detail::basic_statement::clear_bindings()
1 by edam
- initial commit
75
{
76
	_bind_index = 1;
77
	return sqlite3_clear_bindings( _handle );
78
}
79
80
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
81
int sqlite::detail::basic_statement::bind_static(
1 by edam
- initial commit
82
	unsigned int index,
83
	const char *value,
84
	unsigned int value_length )
85
{
86
	return sqlite3_bind_text( _handle, index, value, value_length,
87
		SQLITE_STATIC );
88
}
89
90
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
91
int sqlite::detail::basic_statement::bind_static(
1 by edam
- initial commit
92
	unsigned int index,
93
	const char *value )
94
{
95
	return bind_static( index, value, strlen( value ) );
96
}
97
98
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
99
int sqlite::detail::basic_statement::bind_static(
1 by edam
- initial commit
100
	unsigned int index,
101
	const std::string &value )
102
{
103
	return bind_static( index, value.c_str(), value.length() );
104
}
105
106
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
107
int sqlite::detail::basic_statement::bind_null(
1 by edam
- initial commit
108
	unsigned int index )
109
{
110
	return sqlite3_bind_null( _handle, index );
111
}
112
113
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
114
int sqlite::detail::basic_statement::bind_static(
1 by edam
- initial commit
115
	const std::string &name,
116
	const char *value,
117
	unsigned int value_length )
118
{
2 by edam
- further initial development
119
	return bind_static( bind_parameter_index( name ), value, value_length );
1 by edam
- initial commit
120
}
121
122
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
123
int sqlite::detail::basic_statement::bind_static(
1 by edam
- initial commit
124
	const std::string &name,
125
	const char *value )
126
{
127
	return bind_static( name, value, ::strlen( value ) );
128
}
129
130
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
131
int sqlite::detail::basic_statement::bind_static(
1 by edam
- initial commit
132
	const std::string &name,
133
	const std::string &value )
134
{
135
	return bind_static( name, value.c_str(), value.length() );
136
}
137
138
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
139
int sqlite::detail::basic_statement::bind_null(
1 by edam
- initial commit
140
	const std::string &name )
141
{
2 by edam
- further initial development
142
	return bind_null( bind_parameter_index( name ) );
1 by edam
- initial commit
143
}
144
145
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
146
int sqlite::detail::basic_statement::finalize()
1 by edam
- initial commit
147
{
13 by edam
- made basic_statement::step() protected, for use by query and command only
148
	int code = SQLITE_OK;
1 by edam
- initial commit
149
150
	if( _handle ) {
13 by edam
- made basic_statement::step() protected, for use by query and command only
151
		code = sqlite3_finalize( _handle );
1 by edam
- initial commit
152
		_handle = NULL;
153
	}
154
13 by edam
- made basic_statement::step() protected, for use by query and command only
155
	return code;
2 by edam
- further initial development
156
}
157
158
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
159
int sqlite::detail::basic_statement::bind_parameter_index(
2 by edam
- further initial development
160
	const std::string &name )
161
{
162
	unsigned int index = sqlite3_bind_parameter_index( _handle, name.c_str() );
163
	if( !index ) throw std::range_error( "named parameter not found" );
164
	return index;
165
}
166
167
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
168
int sqlite::detail::basic_statement::step()
13 by edam
- made basic_statement::step() protected, for use by query and command only
169
{
170
	return sqlite3_step( _handle );
1 by edam
- initial commit
171
}
14 by edam
- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec
172
173
174
175
template< >
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
176
sqlite::detail::basic_statement &sqlite::detail::basic_statement::operator <<
14 by edam
- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec
177
	< sqlite::detail::null_t >(
178
	const sqlite::detail::null_t & )
179
{
180
	int code = bind_null( _bind_index );
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
181
	if( code != SQLITE_OK ) throw sqlite_error( _connection, code );
14 by edam
- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec
182
	_bind_index++;
183
	return *this;
184
}
185
186
187
template< >
16 by edam
- renamed database to connection to better identify what it is (would database_connection be better though?)
188
sqlite::detail::basic_statement &sqlite::detail::basic_statement::operator <<
14 by edam
- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec
189
	< sqlite::detail::set_index_t >(
190
	const sqlite::detail::set_index_t &t )
191
{
192
	_bind_index = t._index;
193
	return *this;
194
}