3#ifndef BOAT_SQL_LIBMYSQL_COMMAND_HPP
4#define BOAT_SQL_LIBMYSQL_COMMAND_HPP
7#include <boat/detail/config.hpp>
8#include <boat/sql/libmysql/detail/fetch.hpp>
13 unique_ptr<MYSQL, mysql_close> dbc_;
14 unique_ptr<MYSQL_STMT, mysql_stmt_close> stmt_;
15 std::string prepared_;
26 static_cast<unsigned>(std::chrono::seconds{timeout}.count());
27 dbc_.reset(mysql_init(0));
30 {MYSQL_OPT_CONNECT_TIMEOUT,
31 MYSQL_OPT_READ_TIMEOUT,
32 MYSQL_OPT_WRITE_TIMEOUT})
33 check(!mysql_options(dbc_.get(), opt, &seconds), dbc_);
43 CLIENT_MULTI_STATEMENTS) == dbc_.get(),
45 check(!mysql_set_character_set(dbc_.get(),
"utf8"), dbc_);
46 check(!mysql_query(dbc_.get(),
"set time_zone = '+00:00'"), dbc_);
52 auto txt = qry.
text(
'`',
"?");
53 auto ps = qry.
params() | std::views::transform(to_bind) |
54 std::ranges::to<std::vector>();
58 check(!mysql_query(dbc_.get(), txt.data()), dbc_);
59 for (
int ec{}; ec >= 0; ec = mysql_next_result(dbc_.get())) {
61 ret = fetch(dbc_.get());
65 if (prepared_ != txt) {
66 stmt_.reset(mysql_stmt_init(dbc_.get()));
72 static_cast<unsigned long>(txt.size())),
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())) {
80 ret =
fetch(stmt_.get());
89 check(!mysql_rollback(dbc_.get()), dbc_);
90 check(!mysql_autocommit(dbc_.get(), on), dbc_);
93 void commit()
override { check(!mysql_commit(dbc_.get()), dbc_); }
94 std::string
dbms()
override {
return "mysql"; }
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