#include <soar_db.h>

Inherited by soar_module::pooled_sqlite_statement.

Public Member Functions
void	bind_double (int param, double val)
void	bind_int (int param, int64_t val)
void	bind_null (int param)
void	bind_text (int param, const char *val)
double	column_double (int col)
int64_t	column_int (int col)
const char *	column_text (int col)
value_type	column_type (int col)
	sqlite_statement (sqlite_database new_db, const char new_sql, timer *new_query_timer=NULL)
virtual	~sqlite_statement ()
Public Member Functions inherited from soar_module::statement
void	clean ()
exec_result	execute (statement_action post_action=op_none)
void	prepare ()
void	reinitialize ()
void	set_timer (timer *new_query_timer)
	statement (const char new_sql, timer new_query_timer)
virtual	~statement ()
Public Member Functions inherited from soar_module::status_object< statement_status >
const char *	get_errmsg ()
int	get_errno ()
statement_status	get_status ()
	status_object ()
virtual	~status_object ()

Protected Member Functions
virtual bool	_destroy ()
virtual exec_result	_exec ()
virtual bool	_prep ()
virtual void	_reinit ()
void	sqlite_err ()

Protected Attributes
sqlite_database *	my_db
sqlite3_stmt *	my_stmt
Protected Attributes inherited from soar_module::statement
timer *	query_timer
const char *	sql
Protected Attributes inherited from soar_module::status_object< statement_status >
char *	my_errmsg
int	my_errno
statement_status	my_status

Detailed Description

Definition at line 350 of file soar_db.h.

Constructor & Destructor Documentation

soar_module::sqlite_statement::sqlite_statement	(	sqlite_database *	new_db,
		const char *	new_sql,
		timer *	new_query_timer = `NULL`
	)

inline

Definition at line 413 of file soar_db.h.

: statement( new_sql, new_query_timer ), my_db( new_db ), my_stmt( NULL ) {}

virtual soar_module::sqlite_statement::~sqlite_statement ( )

inlinevirtual

Definition at line 415 of file soar_db.h.

References _destroy(), and my_stmt.

   {
    if ( my_stmt )
     _destroy();
   }

Member Function Documentation

virtual bool soar_module::sqlite_statement::_destroy ( )

inlineprotectedvirtual

Implements soar_module::statement.

Definition at line 384 of file soar_db.h.

References my_stmt, and sqlite3_finalize().

Referenced by ~sqlite_statement().

   {
    sqlite3_finalize( my_stmt );
    my_stmt = NULL;
    return true;
   }

virtual exec_result soar_module::sqlite_statement::_exec ( )

inlineprotectedvirtual

Implements soar_module::statement.

Definition at line 392 of file soar_db.h.

References soar_module::err, my_stmt, soar_module::ok, soar_module::row, sqlite3_step(), SQLITE_DONE, sqlite_err(), SQLITE_OK, and SQLITE_ROW.

   {
    int sqlite_res = sqlite3_step( my_stmt );
    exec_result return_val = err;
    if ( ( sqlite_res != SQLITE_OK ) &&
      ( sqlite_res != SQLITE_DONE ) &&
      ( sqlite_res != SQLITE_ROW ) )
    {
     sqlite_err();
    }
    else
    {
     return_val = ( ( sqlite_res == SQLITE_ROW )?( row ):( ok ) );
    }
    return return_val;
   }

virtual bool soar_module::sqlite_statement::_prep ( )

inlineprotectedvirtual

Implements soar_module::statement.

Definition at line 362 of file soar_db.h.

References soar_module::sqlite_database::get_db(), my_db, my_stmt, soar_module::statement::sql, sqlite3_prepare_v2(), sqlite_err(), SQLITE_OK, and SQLITE_PREP_STR_MAX.

   {
    const char *tail;
    bool return_val = false;
    if ( sqlite3_prepare_v2( my_db->get_db(), sql, SQLITE_PREP_STR_MAX, &( my_stmt ), &tail ) == SQLITE_OK )
    {
     return_val = true;
    }
    else
    {
     sqlite_err();
    }
    return return_val;
   }

virtual void soar_module::sqlite_statement::_reinit ( )

inlineprotectedvirtual

Implements soar_module::statement.

Definition at line 379 of file soar_db.h.

References my_stmt, and sqlite3_reset().

   {
    sqlite3_reset( my_stmt );
   }

void soar_module::sqlite_statement::bind_double	(	int	param,
		double	val
	)

inline

Definition at line 428 of file soar_db.h.

References my_stmt, and sqlite3_bind_double().

Referenced by epmem_temporal_hash(), smem_lti_activate(), smem_lti_add_id(), smem_store_chunk(), and smem_temporal_hash_float().

   {
    sqlite3_bind_double( my_stmt, param, val );
   }

void soar_module::sqlite_statement::bind_int	(	int	param,
		int64_t	val
	)

inline

Definition at line 423 of file soar_db.h.

References my_stmt, and sqlite3_bind_int64().

Referenced by _epmem_promote_id(), _epmem_store_level(), _smem_print_lti(), _smem_process_cue_wme(), epmem_build_dnf(), epmem_get_variable(), epmem_init_db(), epmem_new_episode(), epmem_next_episode(), epmem_previous_episode(), epmem_print_episode(), epmem_process_query(), epmem_register_pedges(), epmem_rit_add_left(), epmem_rit_add_right(), epmem_rit_insert_interval(), epmem_set_variable(), epmem_temporal_hash(), epmem_valid_episode(), epmem_visualize_episode(), smem_disconnect_chunk(), smem_install_memory(), smem_lti_activate(), smem_lti_add_id(), smem_lti_calc_base(), smem_lti_get_id(), smem_print_lti(), smem_process_query(), smem_reverse_hash_float(), smem_reverse_hash_int(), smem_reverse_hash_str(), smem_setup_web_crawl(), smem_store_chunk(), smem_temporal_hash_add(), smem_temporal_hash_float(), smem_temporal_hash_int(), smem_temporal_hash_str(), smem_variable_create(), smem_variable_get(), smem_variable_set(), smem_visualize_lti(), and stats_db_store().

   {
    sqlite3_bind_int64( my_stmt, param, static_cast<sqlite3_int64>( val ) );
   }

void soar_module::sqlite_statement::bind_null ( int param )

inline

Definition at line 433 of file soar_db.h.

References my_stmt, and sqlite3_bind_null().

   {
    sqlite3_bind_null( my_stmt, param );
   }

void soar_module::sqlite_statement::bind_text	(	int	param,
		const char *	val
	)

inline

Definition at line 438 of file soar_db.h.

References my_stmt, sqlite3_bind_text(), SQLITE_PREP_STR_MAX, and SQLITE_STATIC.

Referenced by epmem_temporal_hash(), and smem_temporal_hash_str().

   {
    sqlite3_bind_text( my_stmt, param, val, SQLITE_PREP_STR_MAX, SQLITE_STATIC );
   }

double soar_module::sqlite_statement::column_double ( int col )

inline

Definition at line 450 of file soar_db.h.

References my_stmt, and sqlite3_column_double().

Referenced by epmem_print_episode(), epmem_visualize_episode(), smem_print_lti(), smem_print_store(), smem_process_query(), smem_reverse_hash_float(), smem_visualize_lti(), and smem_visualize_store().

   {
    return sqlite3_column_double( my_stmt, col );
   }

int64_t soar_module::sqlite_statement::column_int ( int col )

inline

Definition at line 445 of file soar_db.h.

References my_stmt, and sqlite3_column_int64().

Referenced by _epmem_store_level(), _smem_print_lti(), _smem_process_cue_wme(), epmem_build_dnf(), epmem_get_variable(), epmem_init_db(), epmem_next_episode(), epmem_previous_episode(), epmem_print_episode(), epmem_process_query(), epmem_register_pedges(), epmem_temporal_hash(), epmem_valid_episode(), epmem_visualize_episode(), smem_disconnect_chunk(), smem_install_memory(), smem_lti_activate(), smem_lti_calc_base(), smem_lti_get_id(), smem_print_lti(), smem_print_store(), smem_process_query(), smem_reset_id_counters(), smem_reverse_hash_int(), smem_store_chunk(), smem_temporal_hash_float(), smem_temporal_hash_int(), smem_temporal_hash_str(), smem_variable_get(), smem_visualize_lti(), and smem_visualize_store().

   {
    return sqlite3_column_int64( my_stmt, col );
   }

const char* soar_module::sqlite_statement::column_text ( int col )

inline

Definition at line 455 of file soar_db.h.

References my_stmt, and sqlite3_column_text().

Referenced by epmem_print_episode(), epmem_visualize_episode(), and smem_reverse_hash_str().

   {
    return reinterpret_cast<const char *>( sqlite3_column_text( my_stmt, col ) );
   }

value_type soar_module::sqlite_statement::column_type ( int col )

inline

Definition at line 460 of file soar_db.h.

References soar_module::double_t, soar_module::int_t, my_stmt, soar_module::null_t, sqlite3_column_type(), SQLITE_FLOAT, SQLITE_INTEGER, SQLITE_TEXT, and soar_module::text_t.

Referenced by epmem_init_db(), epmem_print_episode(), and epmem_visualize_episode().

   {
    int col_type = sqlite3_column_type( my_stmt, col );
    value_type return_val = null_t;
    switch ( col_type )
    {
     case SQLITE_INTEGER:
      return_val = int_t;
      break;
     case SQLITE_FLOAT:
      return_val = double_t;
      break;
     case SQLITE_TEXT:
      return_val = text_t;
      break;
    }
    return return_val;
   }

void soar_module::sqlite_statement::sqlite_err ( )

inlineprotected

Definition at line 356 of file soar_db.h.

References soar_module::sqlite_database::get_db(), my_db, soar_module::status_object< statement_status >::set_errmsg(), soar_module::status_object< statement_status >::set_errno(), sqlite3_errcode(), and sqlite3_errmsg().

Referenced by _exec(), and _prep().

   {
    set_errno( sqlite3_errcode( my_db->get_db() ) );
    set_errmsg( sqlite3_errmsg( my_db->get_db() ) );
   }

Field Documentation

sqlite_database* soar_module::sqlite_statement::my_db

protected

Definition at line 353 of file soar_db.h.

Referenced by _prep(), and sqlite_err().

sqlite3_stmt* soar_module::sqlite_statement::my_stmt

protected

Definition at line 354 of file soar_db.h.

Referenced by _destroy(), _exec(), _prep(), _reinit(), bind_double(), bind_int(), bind_null(), bind_text(), column_double(), column_int(), column_text(), column_type(), and ~sqlite_statement().

The documentation for this class was generated from the following file:

src/soar_db.h

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Field Documentation