22 explicit command(std::string_view connection)
24 env_ = alloc<SQL_HANDLE_ENV>(env_);
27 env_.get(), SQL_ATTR_ODBC_VERSION, SQLPOINTER(SQL_OV_ODBC3), 0),
29 dbc_ = alloc<SQL_HANDLE_DBC>(env_);
33 SQL_ATTR_LOGIN_TIMEOUT,
34 SQLPOINTER(std::chrono::seconds{timeout}.count()),
42 unicode::utf<SQLWCHAR>(connection).data(),
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));
56 auto stop = std::stop_callback{tok, [&] { SQLCancel(stmt_.get()); }};
57 check(SQLFreeStmt(stmt_.get(), SQL_RESET_PARAMS), stmt_);
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);
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]);
71 SQL_ATTR_QUERY_TIMEOUT,
72 SQLPOINTER(std::chrono::seconds{timeout}.count()),
75 auto ec = SQLExecute(stmt_.get());
76 for (; SQL_NO_DATA != ec; ec = SQLMoreResults(stmt_.get())) {
80 check(SQLNumResultCols(stmt_.get(), &cols), stmt_);
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())) {
87 auto& row = ret.rows.emplace_back(cols);
88 for (
int i{}; i < cols; ++i)
89 row[i] = get_data(stmt_, i + 1);
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_);