PSQL prepared statement implementation. More...

#include <PostgresPreparedStatementImpl.h>

Inheritance diagram for sese::db::impl::PostgresPreparedStatementImpl:

Public Member Functions
	PostgresPreparedStatementImpl (std::string stmt_name, std::string stmt_string, uint32_t count, PGconn *conn) noexcept

	~PostgresPreparedStatementImpl () noexcept override

ResultSet::Ptr	executeQuery () noexcept override
	Execute query.

int64_t	executeUpdate () noexcept override
	Execute update.

bool	setDouble (uint32_t index, const double &value) noexcept override
	Set double-precision floating-point value.

bool	setFloat (uint32_t index, const float &value) noexcept override
	Set single-precision floating-point value.

bool	setInteger (uint32_t index, const int32_t &value) noexcept override
	Set integer value.

bool	setLong (uint32_t index, const int64_t &value) noexcept override
	Set long integer value.

bool	setText (uint32_t index, const char *value) noexcept override
	Set text value.

bool	setNull (uint32_t index) noexcept override
	Set to NULL.

bool	setDateTime (uint32_t index, const sese::DateTime &value) noexcept override
	Set to dateTime.

bool	getColumnType (uint32_t index, MetadataType &type) noexcept override
	Get result set column type.

int64_t	getColumnSize (uint32_t index) noexcept override
	Get result set column size. This interface is usually only effective when the type is binary or string, and the unit is bytes.

int	getLastError () const noexcept override
	Get the error code for the corresponding driver of the instance.

const char *	getLastErrorMessage () const noexcept override
	Get the error message for the corresponding driver of the instance. Need to check for null.

Public Member Functions inherited from sese::db::PreparedStatement
virtual	~PreparedStatement () noexcept=default

ErrorCode	getErrorCode () const

Protected Attributes
PGconn *	conn

std::string	stmtName

std::string	stmtString

uint32_t	count

Oid *	paramTypes

const char **	paramValues

std::string *	strings

int	error = 0

PGresult *	result

Additional Inherited Members
Public Types inherited from sese::db::PreparedStatement
using	Ptr = std::unique_ptr<PreparedStatement>

Detailed Description

PSQL prepared statement implementation.

Constructor & Destructor Documentation

◆ PostgresPreparedStatementImpl()

sese::db::impl::PostgresPreparedStatementImpl::PostgresPreparedStatementImpl	(	std::string	stmt_name,
		std::string	stmt_string,
		uint32_t	count,
		PGconn *	conn )

explicitnoexcept

References count().

◆ ~PostgresPreparedStatementImpl()

sese::db::impl::PostgresPreparedStatementImpl::~PostgresPreparedStatementImpl ( )

overridenoexcept

References free(), paramTypes, paramValues, result, and strings.

Member Function Documentation

◆ executeQuery()

sese::db::ResultSet::Ptr sese::db::impl::PostgresPreparedStatementImpl::executeQuery ( )

overridevirtualnoexcept

Execute query.

Returns: Query result set

Return values

nullptr Query failed

Implements sese::db::PreparedStatement.

References count().

◆ executeUpdate()

int64_t sese::db::impl::PostgresPreparedStatementImpl::executeUpdate ( )

overridevirtualnoexcept

Execute update.

Returns: Number of rows affected

Return values

-1	Update failed

Implements sese::db::PreparedStatement.

References count().

◆ getColumnSize()

int64_t sese::db::impl::PostgresPreparedStatementImpl::getColumnSize ( uint32_t index )

nodiscardoverridevirtualnoexcept

Get result set column size. This interface is usually only effective when the type is binary or string, and the unit is bytes.

Parameters

index Index value

Returns: Returns -1 if failed

Implements sese::db::PreparedStatement.

◆ getColumnType()

bool sese::db::impl::PostgresPreparedStatementImpl::getColumnType	(	uint32_t	index,
		MetadataType &	type )

nodiscardoverridevirtualnoexcept

Get result set column type.

Parameters

index	Index value
type	Column type

Returns: Whether the retrieval was successful

Implements sese::db::PreparedStatement.

References sese::db::BOOLEAN, BOOLOID, CHAROID, sese::db::DATE, sese::db::DATE_TIME, DATEOID, sese::db::DOUBLE, sese::db::FLOAT, FLOAT4OID, FLOAT8OID, INT2OID, INT4OID, INT8OID, sese::db::INTEGER, sese::db::LONG, sese::db::SHORT, sese::db::TEXT, TEXTOID, sese::db::TIME, TIMEOID, TIMESTAMPOID, TIMESTAMPTZOID, sese::db::UNKNOWN, and VARCHAROID.

◆ getLastError()

int sese::db::impl::PostgresPreparedStatementImpl::getLastError ( ) const

nodiscardoverridevirtualnoexcept

Get the error code for the corresponding driver of the instance.

Returns: Error code

Implements sese::db::PreparedStatement.

◆ getLastErrorMessage()

const char * sese::db::impl::PostgresPreparedStatementImpl::getLastErrorMessage ( ) const

nodiscardoverridevirtualnoexcept

Get the error message for the corresponding driver of the instance. Need to check for null.

Return values

nullptr Failed to get error message

Returns: Error message

Implements sese::db::PreparedStatement.

◆ setDateTime()

bool sese::db::impl::PostgresPreparedStatementImpl::setDateTime	(	uint32_t	index,
		const sese::DateTime &	value )

nodiscardoverridevirtualnoexcept

Set to dateTime.

Parameters

index	Index
value	Date

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count(), sese::text::DateTimeFormatter::format(), and TIMESTAMPOID.

◆ setDouble()

bool sese::db::impl::PostgresPreparedStatementImpl::setDouble	(	uint32_t	index,
		const double &	value )

nodiscardoverridevirtualnoexcept

Set double-precision floating-point value.

Parameters

index	Index
value	Value

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count(), and FLOAT8OID.

◆ setFloat()

bool sese::db::impl::PostgresPreparedStatementImpl::setFloat	(	uint32_t	index,
		const float &	value )

nodiscardoverridevirtualnoexcept

Set single-precision floating-point value.

Parameters

index	Index
value	Value

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count(), and FLOAT4OID.

◆ setInteger()

bool sese::db::impl::PostgresPreparedStatementImpl::setInteger	(	uint32_t	index,
		const int32_t &	value )

nodiscardoverridevirtualnoexcept

Set integer value.

Parameters

index	Index
value	Value

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count(), and INT4OID.

◆ setLong()

bool sese::db::impl::PostgresPreparedStatementImpl::setLong	(	uint32_t	index,
		const int64_t &	value )

nodiscardoverridevirtualnoexcept

Set long integer value.

Parameters

index	Index
value	Value

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count(), and INT8OID.

◆ setNull()

bool sese::db::impl::PostgresPreparedStatementImpl::setNull ( uint32_t index )

nodiscardoverridevirtualnoexcept

Set to NULL.

Parameters

index Index

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count().

◆ setText()

bool sese::db::impl::PostgresPreparedStatementImpl::setText	(	uint32_t	index,
		const char *	value )

nodiscardoverridevirtualnoexcept

Set text value.

Parameters

index	Index
value	Value

Returns: Whether the setting was successful

Implements sese::db::PreparedStatement.

References count(), and TEXTOID.

Member Data Documentation

◆ conn

PGconn* sese::db::impl::PostgresPreparedStatementImpl::conn

protected

◆ count

uint32_t sese::db::impl::PostgresPreparedStatementImpl::count

protected

◆ error

int sese::db::impl::PostgresPreparedStatementImpl::error = 0

protected

◆ paramTypes

Oid* sese::db::impl::PostgresPreparedStatementImpl::paramTypes

protected

Referenced by ~PostgresPreparedStatementImpl().

◆ paramValues

const char** sese::db::impl::PostgresPreparedStatementImpl::paramValues

protected

Referenced by ~PostgresPreparedStatementImpl().

◆ result

PGresult* sese::db::impl::PostgresPreparedStatementImpl::result

protected

Referenced by ~PostgresPreparedStatementImpl().

◆ stmtName

std::string sese::db::impl::PostgresPreparedStatementImpl::stmtName

protected

◆ stmtString

std::string sese::db::impl::PostgresPreparedStatementImpl::stmtString

protected

◆ strings

std::string* sese::db::impl::PostgresPreparedStatementImpl::strings

protected

Referenced by ~PostgresPreparedStatementImpl().

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

sese/internal/db/pgsql/PostgresPreparedStatementImpl.h
sese/internal/db/pgsql/PostgresPreparedStatementImpl.cpp

Public Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ PostgresPreparedStatementImpl()

◆ ~PostgresPreparedStatementImpl()

Member Function Documentation

◆ executeQuery()

◆ executeUpdate()

◆ getColumnSize()

◆ getColumnType()

◆ getLastError()

◆ getLastErrorMessage()

◆ setDateTime()

◆ setDouble()

◆ setFloat()

◆ setInteger()

◆ setLong()

◆ setNull()

◆ setText()

Member Data Documentation

◆ conn

◆ count

◆ error

◆ paramTypes

◆ paramValues

◆ result

◆ stmtName

◆ stmtString

◆ strings