23
23
#include <sqlite3cc/command.h>
24
24
#include <sqlite3cc/database.h>
25
#include <sqlite3cc/manipulator.h>
25
#include <boost/thread/locks.hpp>
29
boost::recursive_mutex sqlite::command::_command_mutex;
29
32
sqlite::command::command(
30
33
database &database,
31
34
const std::string &sql )
53
56
int sqlite::command::prepare(
54
57
const std::string &sql )
56
int code = basic_statement::prepare( sql );
57
assert( code != SQLITE_OK || sqlite3_column_count( _handle ) == 0 );
59
int error_code = basic_statement::prepare( sql );
60
assert( error_code != SQLITE_OK || sqlite3_column_count( _handle ) == 0 );
62
65
int sqlite::command::step()
64
database::database_mutex_guard lock( _database );
66
int code = basic_statement::step();
67
if( code == SQLITE_ROW ) throw sqlite_error( "command has results" );
68
if( code != SQLITE_DONE ) throw sqlite_error( _database, code );
70
_changes = sqlite3_changes( _database._handle );
71
_total_changes = sqlite3_total_changes( _database._handle );
72
_last_insert_rowid = sqlite3_last_insert_rowid( _database._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::basic_statement &sqlite::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( _database, code );
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 );