StormByte::Database::Postgres::Postgres Class Reference

PostgreSQL backend. More...

#include <StormByte/database/postgres/postgres.hxx>

Inheritance diagram for StormByte::Database::Postgres::Postgres:

Collaboration diagram for StormByte::Database::Postgres::Postgres:

Public Member Functions
	Postgres (const Postgres &db)=delete
	Copy constructor (deleted).
	Postgres (Postgres &&db) noexcept
	Move constructor that transfers the database connection.
Postgres &	operator= (const Postgres &db)=delete
	Copy assignment (deleted).
Postgres &	operator= (Postgres &&db) noexcept
	Move assignment that transfers the database connection.
	~Postgres () noexcept override
	Destructor.
ExpectedRows	Query (std::string_view query) noexcept override
	Execute a query that returns rows.
bool	SilentQuery (std::string_view query) noexcept override
	Execute a query that does not return rows.
Public Member Functions inherited from StormByte::Database::Database
	Database (const StormByte::Shared< Logger::Log > &logger)
	Construct with an optional logger.
	Database (const Database &)=delete
	Copy constructor (deleted).
	Database (Database &&other) noexcept
	Move constructor.
Database &	operator= (const Database &)=delete
	Copy assignment (deleted).
Database &	operator= (Database &&other) noexcept
	Move assignment.
virtual	~Database () noexcept
	Destructor.
StormByte::Shared< Telemetry >	GetTelemetry () const noexcept
	Obtain the cumulative connection telemetry handle.
bool	Connect () noexcept
	Connect.
void	Disconnect () noexcept
	Disconnect.
bool	IsConnected () const noexcept
	Whether the connection is open.
void	SetSslMode (SslMode mode) noexcept
	TLS policy for the next Connect().
SslMode	GetSslMode () const noexcept
	Current TLS policy.
template<typename... Args>
ExpectedRows	ExecuteSTMT (std::string_view name, Args &&...args)
	Execute a prepared statement by name.
Expected< Transaction, TransactionError >	BeginTransaction (IsolationLevel level=IsolationLevel::Default)
	Begin a transaction.
void	CommitTransaction ()
	Commit the current transaction.
void	RollbackTransaction ()
	Roll back the current transaction.

Protected Member Functions
	Postgres (std::string_view host, std::string_view user, std::string_view password, std::string_view db_name, const StormByte::Shared< Logger::Log > &logger)
	Copy connection parameters into the backend.
bool	DoSilentQuery (std::string_view query) noexcept override
	Internal silent query.
Protected Member Functions inherited from StormByte::Database::Database
void	SetTelemetry (StormByte::Shared< Telemetry > telemetry) noexcept
	Replace the telemetry implementation, normally in a concrete backend constructor.
void	RecordBackendEvent (BackendEvent event) noexcept
	Record a categorized event reported by the active backend.
Telemetry::OperationScope	TrackOperation (Operation operation) const noexcept
	Start timing a Database operation without invoking user callbacks.
void	ClearPreparedSTMTs () noexcept
	Destroy all registered statements inside the Database module.
void	PrepareSTMT (std::string_view name, std::string_view query) noexcept
	Register a prepared statement under name.
void	DoPrepareSTMT (std::string_view name, std::string_view query) noexcept
	Same as PrepareSTMT; kept for hook symmetry.
virtual void	DoPreConnect () noexcept
	Pre-connect hook.
virtual void	DoPostConnect () noexcept
	Post-connect hook.
virtual void	DoPostDisconnect () noexcept
	Post-disconnect hook.

Additional Inherited Members
Protected Attributes inherited from StormByte::Database::Database
StormByte::Shared< std::recursive_mutex >	m_operation_mutex
	DLL-safe owner of the connection mutex.
StormByte::Shared< Telemetry >	m_telemetry
	Shared cumulative counters for this connection.
bool	m_connected
	Connection state.
SslMode	m_ssl_mode
	TLS policy for network backends.
StormByte::Shared< Logger::Log >	m_logger
	Shared logger, safe across the DLL boundary.

Detailed Description

PostgreSQL backend.

@note Built-in connection operations are serialized. Transactions must stay on their creating thread.

Note

Inheritance-oriented. Constructors are protected. SetSslMode() before Connect() if needed.

Constructor & Destructor Documentation

Postgres() [1/3]

StormByte::Database::Postgres::Postgres::Postgres ( const Postgres &  db )

delete

Copy constructor (deleted).

Postgres() [2/3]

StormByte::Database::Postgres::Postgres::Postgres ( Postgres &&  db )

noexcept

Move constructor that transfers the database connection.

Parameters

db	Database to move from.

~Postgres()

StormByte::Database::Postgres::Postgres::~Postgres ( )

overridenoexcept

Destructor.

Postgres() [3/3]

StormByte::Database::Postgres::Postgres::Postgres ( std::string_view  host, std::string_view  user, std::string_view  password, std::string_view  db_name, const StormByte::Shared< Logger::Log > &  logger  )

protected

Copy connection parameters into the backend.

Parameters

host	Host name or address.
user	User name.
password	Password.
db_name	Database name.
logger	Logger instance.

Member Function Documentation

DoSilentQuery()

bool StormByte::Database::Postgres::Postgres::DoSilentQuery ( std::string_view  query )

overrideprotectedvirtualnoexcept

Internal silent query.

Parameters

query

SQL text.

Returns

true on success.

Implements StormByte::Database::Database.

operator=() [1/2]

Postgres & StormByte::Database::Postgres::Postgres::operator= ( const Postgres &  db )

delete

Copy assignment (deleted).

operator=() [2/2]

Postgres & StormByte::Database::Postgres::Postgres::operator= ( Postgres &&  db )

noexcept

Move assignment that transfers the database connection.

Parameters

db	Database to move from.

Returns

Reference to this database.

Query()

ExpectedRows StormByte::Database::Postgres::Postgres::Query ( std::string_view  query )

overridevirtualnoexcept

Execute a query that returns rows.

Parameters

query

SQL text.

Returns

Result rows or an error.

Implements StormByte::Database::Database.

SilentQuery()

bool StormByte::Database::Postgres::Postgres::SilentQuery ( std::string_view  query )

overridevirtualnoexcept

Execute a query that does not return rows.

Parameters

query

SQL text.

Returns

true on success.

Implements StormByte::Database::Database.

---

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

• lib/optional/StormByte/database/postgres/postgres.hxx