Orbit Framework 2.0.0
A high-performance asynchronous C++20 HTTP server framework.
Loading...
Searching...
No Matches
PostgresClient.hpp
Go to the documentation of this file.
1#pragma once
3#include <string>
4#include <memory>
5#include <functional>
6#include <optional>
7#include <vector>
8#include <chrono>
9#include <unordered_map>
10#include <libpq-fe.h>
13
14namespace orbit::database {
15
19class PostgresClient : public std::enable_shared_from_this<PostgresClient> {
20public:
27 PostgresClient(network::Proactor* proactor, const std::string& conninfo);
29
36 void connect(std::function<void(bool success)> callback);
37
44 void query(const std::string& sql, std::function<void(const ResultSet& res)> callback);
45
52 void query(const std::string& sql, const std::vector<std::optional<std::string>>& params,
53 std::function<void(const ResultSet& res)> callback);
54
63 void execute(const std::string& sql, const std::vector<std::optional<std::string>>& params,
64 std::function<void(const ResultSet& res)> callback);
65
67 void begin(std::function<void(const ResultSet& res)> callback);
70 void commit(std::function<void(const ResultSet& res)> callback);
72 void rollback(std::function<void(const ResultSet& res)> callback);
74 bool in_transaction() const;
75
84 void set_statement_timeout(std::chrono::milliseconds timeout) { statement_timeout_ = timeout; }
85
87 bool is_healthy() const;
89 void reconnect(std::function<void(bool success)> callback);
90
92 size_t max_prepared_statements() const { return max_prepared_; }
93 size_t prepared_statement_count() const { return prepared_.size(); }
94
95private:
96 void handle_connect(std::function<void(bool)> callback);
97 void handle_query(std::function<void(const ResultSet&)> callback);
98 void finish_connect(std::function<void(bool)> callback);
100
102 std::string conninfo_;
103 PGconn* conn_{nullptr};
104 bool connected_{false};
105 std::chrono::milliseconds statement_timeout_{0};
106 std::unordered_map<std::string, std::string> prepared_; // SQL -> statement name
107 size_t next_statement_ = 0;
108 size_t max_prepared_ = 256;
109};
110
111} // namespace database
An asynchronous PostgreSQL client using libpq and a network Proactor.
Definition PostgresClient.hpp:19
void set_statement_timeout(std::chrono::milliseconds timeout)
Server-side limit on each statement's run time; zero = none.
Definition PostgresClient.hpp:84
void finish_connect(std::function< void(bool)> callback)
PostgresClient(network::Proactor *proactor, const std::string &conninfo)
Constructs a new PostgresClient.
size_t max_prepared_statements() const
Definition PostgresClient.hpp:92
std::chrono::milliseconds statement_timeout_
Definition PostgresClient.hpp:105
void rollback(std::function< void(const ResultSet &res)> callback)
Rolls back the current transaction (ROLLBACK).
void handle_query(std::function< void(const ResultSet &)> callback)
bool is_healthy() const
True if connected and libpq reports the connection usable.
std::unordered_map< std::string, std::string > prepared_
Definition PostgresClient.hpp:106
void execute(const std::string &sql, const std::vector< std::optional< std::string > > &params, std::function< void(const ResultSet &res)> callback)
Like the parameterized query(), but prepares sql once per connection and reuses the plan on later cal...
void set_max_prepared_statements(size_t n)
Definition PostgresClient.hpp:91
void query(const std::string &sql, const std::vector< std::optional< std::string > > &params, std::function< void(const ResultSet &res)> callback)
Executes a statement with $1, $2, ... placeholders bound to params (text format; std::nullopt binds S...
void begin(std::function< void(const ResultSet &res)> callback)
Starts a transaction (BEGIN).
std::string conninfo_
Definition PostgresClient.hpp:102
size_t next_statement_
Definition PostgresClient.hpp:107
void connect(std::function< void(bool success)> callback)
Connects to the PostgreSQL database asynchronously. Called on a connected client, it drops that conne...
size_t prepared_statement_count() const
Definition PostgresClient.hpp:93
void query(const std::string &sql, std::function< void(const ResultSet &res)> callback)
Executes a query asynchronously.
bool in_transaction() const
True inside a transaction block (including one that has failed).
void commit(std::function< void(const ResultSet &res)> callback)
PGconn * conn_
Definition PostgresClient.hpp:103
void handle_connect(std::function< void(bool)> callback)
bool connected_
Definition PostgresClient.hpp:104
network::Proactor * proactor_
Definition PostgresClient.hpp:101
void reconnect(std::function< void(bool success)> callback)
Drops the current connection (if any) and connects again.
size_t max_prepared_
Definition PostgresClient.hpp:108
Represents a generic, unified result set from a database query.
Definition ResultSet.hpp:197
Definition Proactor.hpp:9
Definition ConnectionPool.hpp:14