anch::sql::SQLite3PreparedStatement Class Reference

SQLite3 prepared statement implementation. More...

#include <sqlite3PreparedStatement.hpp>

Inheritance diagram for anch::sql::SQLite3PreparedStatement:

Collaboration diagram for anch::sql::SQLite3PreparedStatement:

Public Member Functions
	SQLite3PreparedStatement (sqlite3 *dbCon, const std::string &query)
virtual	~SQLite3PreparedStatement () noexcept
virtual ResultSet *	executeQuery () override
virtual uint64_t	executeUpdate () override
Public Member Functions inherited from anch::sql::PreparedStatement
	PreparedStatement () noexcept
virtual	~PreparedStatement () noexcept
void	set (std::size_t idx, int16_t value)
void	set (std::size_t idx, uint16_t value)
void	set (std::size_t idx, int32_t value)
void	set (std::size_t idx, uint32_t value)
void	set (std::size_t idx, int64_t value)
void	set (std::size_t idx, uint64_t value)
void	set (std::size_t idx, const std::string &value)
void	set (std::size_t idx, const char *const value)
virtual void	set (std::size_t idx, const anch::sql::Date &value)
virtual void	set (std::size_t idx, const anch::sql::Time &value)
virtual void	set (std::size_t idx, const anch::sql::Timestamp &value)

Additional Inherited Members
Protected Member Functions inherited from anch::sql::PreparedStatement
std::set< std::size_t >	getPlaceholders (const std::string &query) const
void	checkIndex (std::size_t index) const
Protected Attributes inherited from anch::sql::PreparedStatement
std::map< std::size_t, std::string >	_values
std::size_t	_nbPlaceholders

Detailed Description

SQLite3 prepared statement implementation.

Compile prepared statement in constructor, manage bind and statement execution.

Author

Vincent Lachenal

Since

0.1

Constructor & Destructor Documentation

SQLite3PreparedStatement()

anch::sql::SQLite3PreparedStatement::SQLite3PreparedStatement	(	sqlite3 *	dbCon,
		const std::string &	query )

SQLite3PreparedStatement constructor

Parameters

dbCon	the database connection
query	the SQL query

Exceptions

SqlException

any error

~SQLite3PreparedStatement()

virtual anch::sql::SQLite3PreparedStatement::~SQLite3PreparedStatement ( )

virtualnoexcept

SQLite3PreparedStatement destructor

Member Function Documentation

executeQuery()

virtual ResultSet * anch::sql::SQLite3PreparedStatement::executeQuery ( )

overridevirtual

Execute prepared statement for SELECT statement

Returns

the result set

Exceptions

SqlException

any error

Implements anch::sql::PreparedStatement.

Here is the call graph for this function:

executeUpdate()

virtual uint64_t anch::sql::SQLite3PreparedStatement::executeUpdate ( )

overridevirtual

Execute prepared statement for update database (INSERT, UPDATE, DELETE)

Returns

the number of affected rows

Exceptions

SqlException

any error

Implements anch::sql::PreparedStatement.

Here is the call graph for this function:

---

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

• anch-sql/sqlite/inc/sql/sqlite3PreparedStatement.hpp