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_ODBC_COMMAND_HPP
4#define BOAT_SQL_ODBC_COMMAND_HPP
5
6#include <boat/db/command.hpp>
7#include <boat/detail/config.hpp>
8#include <boat/sql/odbc/detail/get_data.hpp>
9#include <boat/sql/odbc/detail/params.hpp>
10
11namespace boat::sql::odbc {
12
13class command : public db::command {
14 env_ptr env_;
15 dbc_ptr dbc_;
16 stmt_ptr stmt_;
17 char id_quote_;
18 std::string dbms_;
19 std::basic_string<SQLWCHAR> prepared_;
20
21public:
22 explicit command(std::string_view connection)
23 {
24 env_ = alloc<SQL_HANDLE_ENV>(env_);
25 check(
26 SQLSetEnvAttr(
27 env_.get(), SQL_ATTR_ODBC_VERSION, SQLPOINTER(SQL_OV_ODBC3), 0),
28 env_);
29 dbc_ = alloc<SQL_HANDLE_DBC>(env_);
30 check(
31 SQLSetConnectAttr(
32 dbc_.get(),
33 SQL_ATTR_LOGIN_TIMEOUT,
34 SQLPOINTER(std::chrono::seconds{timeout}.count()),
35 0),
36 dbc_);
37 SQLSMALLINT len;
38 check(
39 SQLDriverConnectW(
40 dbc_.get(),
41 0,
42 unicode::utf<SQLWCHAR>(connection).data(),
43 SQL_NTS,
44 0,
45 0,
46 &len,
47 SQL_DRIVER_NOPROMPT),
48 dbc_);
49 stmt_ = alloc<SQL_HANDLE_STMT>(dbc_);
50 id_quote_ = info(dbc_, SQL_IDENTIFIER_QUOTE_CHAR).at(0);
51 dbms_ = to_lower(info(dbc_, SQL_DBMS_NAME));
52 }
53
54 db::rowset exec(db::query const& qry, std::stop_token tok = {}) override
55 {
56 auto stop = std::stop_callback{tok, [&] { SQLCancel(stmt_.get()); }};
57 check(SQLFreeStmt(stmt_.get(), SQL_RESET_PARAMS), stmt_);
58 auto ret = db::rowset{};
59 auto txt = qry.text(id_quote_, "?") | unicode::utf<SQLWCHAR>;
60 if (txt != prepared_) {
61 check(SQLPrepareW(stmt_.get(), txt.data(), SQL_NTS), stmt_);
62 prepared_ = std::move(txt);
63 }
64 auto ps = qry.params() | std::views::transform(params::make) |
65 std::ranges::to<std::vector>();
66 for (size_t i{}; i < ps.size(); ++i)
67 params::bind(stmt_, SQLUSMALLINT(i + 1), ps[i]);
68 check(
69 SQLSetStmtAttr(
70 stmt_.get(),
71 SQL_ATTR_QUERY_TIMEOUT,
72 SQLPOINTER(std::chrono::seconds{timeout}.count()),
73 0),
74 stmt_);
75 auto ec = SQLExecute(stmt_.get());
76 for (; SQL_NO_DATA != ec; ec = SQLMoreResults(stmt_.get())) {
77 check(ec, stmt_);
78 ret = {};
79 SQLSMALLINT cols;
80 check(SQLNumResultCols(stmt_.get(), &cols), stmt_);
81 if (cols) {
82 for (int i{}; i < cols; ++i)
83 ret.columns.push_back(name(stmt_, i + 1));
84 ec = SQLFetch(stmt_.get());
85 for (; SQL_NO_DATA != ec; ec = SQLFetch(stmt_.get())) {
86 check(ec, stmt_);
87 auto& row = ret.rows.emplace_back(cols);
88 for (int i{}; i < cols; ++i)
89 row[i] = get_data(stmt_, i + 1);
90 }
91 }
92 }
93 return ret;
94 }
95
96 void set_autocommit(bool on) override
97 {
98 if (on)
99 check(SQLEndTran(SQL_HANDLE_DBC, dbc_.get(), SQL_ROLLBACK), dbc_);
100 auto val = SQLPOINTER(on ? SQL_AUTOCOMMIT_ON : SQL_AUTOCOMMIT_OFF);
101 check(SQLSetConnectAttr(dbc_.get(), SQL_ATTR_AUTOCOMMIT, val, 0), dbc_);
102 }
103
104 void commit() override
105 {
106 check(SQLEndTran(SQL_HANDLE_DBC, dbc_.get(), SQL_COMMIT), dbc_);
107 }
108
109 std::string dbms() override { return dbms_; }
110};
111
112} // namespace boat::sql::odbc
113
114#endif // BOAT_SQL_ODBC_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
db::rowset exec(db::query const &qry, std::stop_token tok={}) override
Definition command.hpp:54
void commit() override
Definition command.hpp:104
std::string dbms() override
Lowercase.
Definition command.hpp:109
command(std::string_view connection)
Definition command.hpp:22
void set_autocommit(bool on) override
Definition command.hpp:96
Definition command.hpp:11
Definition command.hpp:12
Definition rowset.hpp:13