Orbit Framework 2.0.0
A high-performance asynchronous C++20 HTTP server framework.
Loading...
Searching...
No Matches
MysqlClient.hpp
Go to the documentation of this file.
1#pragma once
3#include <mysql.h>
4#include <string>
5#include <memory>
6#include <coroutine>
7#include <vector>
8#include <stdexcept>
9#include <functional>
12
13namespace orbit::database {
14
19public:
23 struct Config {
24 std::string host;
25 int port{3306};
26 std::string user;
27 std::string password;
28 std::string dbname;
29 };
30
31
32
41
42 // Delete copy semantics
43 MysqlClient(const MysqlClient&) = delete;
45
46 // Awaiter for connecting
49 MYSQL* ret_ptr{nullptr};
50 int status{0};
51 std::coroutine_handle<> coro;
52
53 bool await_ready() const { return false; }
54 void await_suspend(std::coroutine_handle<> h);
57 };
58
59 // Awaiter for executing a query
60 struct QueryAwaiter {
62 std::string query;
63 int err{0};
64 int status{0};
65 std::coroutine_handle<> coro;
67
68 bool await_ready() const { return false; }
69 void await_suspend(std::coroutine_handle<> h);
74
75 MYSQL_RES* res{nullptr};
76 };
77
84
95 QueryAwaiter query_async(std::string query);
96
100 void close();
101
107
112 MYSQL* get_mysql() { return mysql_; }
113
118 std::string escape(const std::string& value);
119
120private:
123 MYSQL* mysql_{nullptr};
124 bool connected_{false};
125
126 void wait_for_status(int status, std::function<void()> callback);
127};
128
129} // namespace database
An asynchronous MySQL client using coroutines and a network Proactor.
Definition MysqlClient.hpp:18
void wait_for_status(int status, std::function< void()> callback)
Config config_
Definition MysqlClient.hpp:122
MysqlClient & operator=(const MysqlClient &)=delete
bool connected_
Definition MysqlClient.hpp:124
ConnectAwaiter connect_async()
Connects to the MySQL database asynchronously.
MYSQL * mysql_
Definition MysqlClient.hpp:123
MYSQL * get_mysql()
Gets the underlying MySQL connection object.
Definition MysqlClient.hpp:112
network::Proactor & get_proactor()
Gets the associated network proactor.
Definition MysqlClient.hpp:106
network::Proactor & proactor_
Definition MysqlClient.hpp:121
std::string escape(const std::string &value)
Escapes value for use inside a single-quoted SQL literal, using the connection's character set (mysql...
MysqlClient(const MysqlClient &)=delete
MysqlClient(network::Proactor &proactor, const Config &config)
Constructs a new MysqlClient.
void close()
Closes the MySQL connection.
QueryAwaiter query_async(std::string query)
Executes a query asynchronously.
Represents a generic, unified result set from a database query.
Definition ResultSet.hpp:197
Definition Proactor.hpp:9
Definition Config.hpp:8
Definition ConnectionPool.hpp:14
Configuration options for the MySQL client.
Definition MysqlClient.hpp:23
std::string dbname
Definition MysqlClient.hpp:28
std::string user
Definition MysqlClient.hpp:26
std::string host
Definition MysqlClient.hpp:24
std::string password
Definition MysqlClient.hpp:27
int port
Definition MysqlClient.hpp:25
std::coroutine_handle coro
Definition MysqlClient.hpp:51
MysqlClient & client
Definition MysqlClient.hpp:48
int status
Definition MysqlClient.hpp:50
bool await_ready() const
Definition MysqlClient.hpp:53
void await_suspend(std::coroutine_handle<> h)
MYSQL * ret_ptr
Definition MysqlClient.hpp:49
Definition MysqlClient.hpp:60
MYSQL_RES * res
Definition MysqlClient.hpp:75
std::string query
Definition MysqlClient.hpp:62
MysqlClient & client
Definition MysqlClient.hpp:61
bool await_ready() const
Definition MysqlClient.hpp:68
std::coroutine_handle coro
Definition MysqlClient.hpp:65
int status
Definition MysqlClient.hpp:64
void await_suspend(std::coroutine_handle<> h)
ResultSet result
Definition MysqlClient.hpp:66
int err
Definition MysqlClient.hpp:63