anch::sql::MySQLPreparedStatement Class Reference

MySQL prepared statement implementation. More...

#include <mysqlPreparedStatement.hpp>

Inheritance diagram for anch::sql::MySQLPreparedStatement:

Collaboration diagram for anch::sql::MySQLPreparedStatement:

Public Member Functions
	MySQLPreparedStatement (MYSQL *dbCon, const std::string &query)
virtual	~MySQLPreparedStatement () 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

MySQL prepared statement implementation.

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

Author

Vincent Lachenal

Since

0.1

Constructor & Destructor Documentation

MySQLPreparedStatement()

anch::sql::MySQLPreparedStatement::MySQLPreparedStatement	(	MYSQL *	dbCon,
		const std::string &	query )

MySQLPreparedStatement constructor

Parameters

dbCon	the database connection
query	the SQL query

Exceptions

SqlException

any error

~MySQLPreparedStatement()

virtual anch::sql::MySQLPreparedStatement::~MySQLPreparedStatement ( )

virtualnoexcept

MySQLPreparedStatement destructor

Member Function Documentation

executeQuery()

virtual ResultSet * anch::sql::MySQLPreparedStatement::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::MySQLPreparedStatement::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/mysql/inc/sql/mysqlPreparedStatement.hpp