23
23
#include <sqlite3cc/command.h>
24
#include <sqlite3cc/database.h>
25
#include <boost/thread/locks.hpp>
24
#include <sqlite3cc/connection.h>
25
#include <sqlite3cc/manipulator.h>
29
boost::recursive_mutex sqlite::command::_command_mutex;
32
29
sqlite::command::command(
30
connection &connection,
34
31
const std::string &sql )
36
basic_statement( database, sql ),
33
detail::basic_statement( connection, sql ),
38
35
_total_changes( 0 ),
39
36
_last_insert_rowid( 0 )
56
53
int sqlite::command::prepare(
57
54
const std::string &sql )
59
int error_code = basic_statement::prepare( sql );
60
assert( error_code != SQLITE_OK || sqlite3_column_count( _handle ) == 0 );
56
int code = detail::basic_statement::prepare( sql );
57
assert( code != SQLITE_OK || sqlite3_column_count( _handle ) == 0 );
65
62
int sqlite::command::step()
67
boost::lock_guard< boost::recursive_mutex > lock( _command_mutex );
68
int error_code = basic_statement::step();
69
if( error_code == SQLITE_OK ) {
70
_changes = sqlite3_changes( _database._handle );
71
_total_changes = sqlite3_total_changes( _database._handle );
72
_last_insert_rowid = sqlite3_last_insert_rowid( _database._handle );
64
connection::mutex_guard lock( _connection );
66
int code = detail::basic_statement::step();
67
if( code == SQLITE_ROW ) throw sqlite_error( "command has results" );
68
if( code != SQLITE_DONE ) throw sqlite_error( _connection, code );
70
_changes = sqlite3_changes( _connection._handle );
71
_total_changes = sqlite3_total_changes( _connection._handle );
72
_last_insert_rowid = sqlite3_last_insert_rowid( _connection._handle );
76
// finalise now (which shouldn't matter for commands), so that there are no
77
// active statements if we come to begin, commit or rollback a transaction
85
sqlite::detail::basic_statement &sqlite::detail::basic_statement::operator <<
86
< sqlite::detail::exec_t >(
87
const sqlite::detail::exec_t & )
89
sqlite::command &that = dynamic_cast< sqlite::command & >( *this );
91
int code = that.step();
92
if( code != SQLITE_DONE ) {
93
if( code == SQLITE_ROW )
94
throw sqlite_error( "statement returned results" );
96
throw sqlite_error( _connection, code );