4
* Copyright (C) 2009 Tim Marston <edam@waxworlds.org>
6
* This file is part of sqlitepp (hereafter referred to as "this program").
7
* See http://www.waxworlds.org/edam/software/sqlitepp for more information.
9
* This program is free software: you can redistribute it and/or modify
10
* it under the terms of the GNU Lesser General Public License as published
11
* by the Free Software Foundation, either version 3 of the License, or
12
* (at your option) any later version.
14
* This program is distributed in the hope that it will be useful,
15
* but WITHOUT ANY WARRANTY; without even the implied warranty of
16
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17
* GNU Lesser General Public License for more details.
4
* Copyright (C) 2009 Tim Marston <tim@ed.am>
6
* This file is part of sqlite3cc (hereafter referred to as "this program").
7
* See http://ed.am/dev/sqlite3cc for more information.
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
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
19
19
* You should have received a copy of the GNU Lesser General Public License
20
20
* along with this program. If not, see <http://www.gnu.org/licenses/>.
27
#include "statement.hpp"
23
#ifndef SQLITE3CC_COMMAND_H_
24
#define SQLITE3CC_COMMAND_H_
27
#include <sqlite3cc/basic_statement.h>
35
* The command class represents an SQL command. Since there is very little
35
* The command class represents an SQL command. Since there is very little
36
36
* difference between a command an a statement, it is basically a shim around
37
37
* the statement class with the addition of an exec() method to execute the
42
public detail::basic_statement
44
44
//______________________________________________________________________________
49
* Constructor that provides the SQL statement to execute
49
* Constructor that provides a connection upon which to act and the SQL
52
* @param connection a reference to a connection
50
53
* @param sql an SQL statement in UTF-8
54
const std::string &sql )
56
statement( database, sql )
56
connection &connection,
57
const std::string &sql );
60
* Constructor that provides a connection upon which to act.
62
* @param connection a reference to a connection
65
connection &connection );
59
67
//______________________________________________________________________________
60
68
// public interface
64
* Execute the command. This is the same as doing a step().
72
* Prepare an SQL statement.
74
* @param sql an SQL statement in UTF-8
75
* @returns an sqlite error code
76
* @see sqlite3_prepare_v2()
79
const std::string &sql );
82
* Step through one execution cycle of the SQL statement. If this is an SQL
83
* statement that doesn't return any rows, only one cycle is required,
84
* otherwise, each cycle will return another row
86
* @return an sqlite error code
92
* Execute the command. This is the same as doing a step().
94
* @return an sqlite error code
65
95
* @see sqlite3_step()
103
* Get the number of changes made by the last successful execution of this
104
* command. This doesn't include changes made in trigger subcontexts.
106
* @return the number of changed rows
107
* @see sqlite3_changes()
115
* Get the number of changes made by the last successful execution of this
116
* command. This includes changes made in all trigger subcontexts.
118
* @return the number of changed rows
119
* @see sqlite3_total_changes()
121
inline int total_changes()
123
return _total_changes;
127
* Get the rowid of the last row inserted via a successful INSERT command
128
* (regardless of whether that is this command or not).
130
* @return the last inserted rowid
132
inline long long last_insert_rowid()
134
return _last_insert_rowid;
137
//______________________________________________________________________________
141
/** non-recursive number of changes made by the last execution */
144
/** recursive number of changes made by the last execution */
147
/** the rowid of the last successful insert command */
148
long long _last_insert_rowid;
78
#endif /* COMMAND_HPP_ */
157
// template specialisations for detail::basic_statement::operator <<()
159
basic_statement &basic_statement::operator << < detail::exec_t >(
160
const detail::exec_t & );
163
} // namespace detail
166
} // namespace sqlite
169
#endif /* SQLITE3CC_COMMAND_H_ */
added
removed
include/sqlite3cc/command.h
