boat
C++23 geospatial library
Loading...
Searching...
No Matches
command.hpp
Go to the documentation of this file.
1// Andrew Naplavkov
2
3#ifndef BOAT_SQL_LIBMYSQL_COMMAND_HPP
4#define BOAT_SQL_LIBMYSQL_COMMAND_HPP
5
6#include <boat/db/command.hpp>
7#include <boat/detail/config.hpp>
8#include <boat/sql/libmysql/detail/fetch.hpp>
9
11
12class command : public db::command {
13 unique_ptr<MYSQL, mysql_close> dbc_;
14 unique_ptr<MYSQL_STMT, mysql_stmt_close> stmt_;
15 std::string prepared_;
16
17public:
19 char const* user,
20 char const* password,
21 char const* host,
22 int port,
23 char const* database)
24 {
25 auto seconds =
26 static_cast<unsigned>(std::chrono::seconds{timeout}.count());
27 dbc_.reset(mysql_init(0));
28 check(!!dbc_, dbc_);
29 for (auto opt :
30 {MYSQL_OPT_CONNECT_TIMEOUT,
31 MYSQL_OPT_READ_TIMEOUT,
32 MYSQL_OPT_WRITE_TIMEOUT})
33 check(!mysql_options(dbc_.get(), opt, &seconds), dbc_);
34 check(
35 mysql_real_connect(
36 dbc_.get(),
37 host,
38 user,
39 password,
40 database,
41 port,
42 0,
43 CLIENT_MULTI_STATEMENTS) == dbc_.get(),
44 dbc_);
45 check(!mysql_set_character_set(dbc_.get(), "utf8"), dbc_);
46 check(!mysql_query(dbc_.get(), "set time_zone = '+00:00'"), dbc_);
47 }
48
49 db::rowset exec(db::query const& qry, std::stop_token = {}) override
50 {
51 auto ret = db::rowset{};
52 auto txt = qry.text('`', "?");
53 auto ps = qry.params() | std::views::transform(to_bind) |
54 std::ranges::to<std::vector>();
55 if (ps.empty()) {
56 stmt_.reset();
57 prepared_.clear();
58 check(!mysql_query(dbc_.get(), txt.data()), dbc_);
59 for (int ec{}; ec >= 0; ec = mysql_next_result(dbc_.get())) {
60 check(!ec, dbc_);
61 ret = fetch(dbc_.get());
62 }
63 }
64 else {
65 if (prepared_ != txt) {
66 stmt_.reset(mysql_stmt_init(dbc_.get()));
67 check(!!stmt_, dbc_);
68 check(
69 !mysql_stmt_prepare(
70 stmt_.get(),
71 txt.data(),
72 static_cast<unsigned long>(txt.size())),
73 stmt_);
74 prepared_ = txt;
75 }
76 check(!mysql_stmt_bind_param(stmt_.get(), ps.data()), stmt_);
77 check(!mysql_stmt_execute(stmt_.get()), stmt_);
78 for (int ec{}; ec >= 0; ec = mysql_stmt_next_result(stmt_.get())) {
79 check(!ec, stmt_);
80 ret = fetch(stmt_.get());
81 }
82 }
83 return ret;
84 }
85
86 void set_autocommit(bool on) override
87 {
88 if (on)
89 check(!mysql_rollback(dbc_.get()), dbc_);
90 check(!mysql_autocommit(dbc_.get(), on), dbc_);
91 }
92
93 void commit() override { check(!mysql_commit(dbc_.get()), dbc_); }
94 std::string dbms() override { return "mysql"; }
95};
96
97} // namespace boat::sql::libmysql
98
99#endif // BOAT_SQL_LIBMYSQL_COMMAND_HPP
Definition query.hpp:19
std::string text(char id_quote, std::string_view param_mark) const
"{}" in param_mark is replaced with the one-based parameter number.
Definition query.hpp:47
std::generator< variant const & > params() const
Definition query.hpp:73
void commit() override
Definition command.hpp:93
std::string dbms() override
Lowercase.
Definition command.hpp:94
db::rowset exec(db::query const &qry, std::stop_token={}) override
Definition command.hpp:49
void set_autocommit(bool on) override
Definition command.hpp:86
command(char const *user, char const *password, char const *host, int port, char const *database)
Definition command.hpp:18
std::generator< variant > fetch(layer_query const &q)
Definition fetch.hpp:111
Definition command.hpp:10
Definition command.hpp:12
Definition rowset.hpp:13