StormByte-Database 3.0.0
C++26 database module of the StormByte suite
Loading...
Searching...
No Matches
mssql.hxx
Go to the documentation of this file.
1/*
2 * Copyright (C) 2024-2026 David C. Manuelda (StormBytePP)
3 *
4 * This file is part of StormByte-Database.
5 *
6 * StormByte-Database original source is dual-licensed:
7 *
8 * 1. GNU Lesser General Public License v3.0 (or later)
9 * You may redistribute and/or modify this file under the terms of the
10 * GNU Lesser General Public License as published by the Free Software
11 * Foundation, either version 3 of the License, or (at your option)
12 * any later version.
13 *
14 * 2. Commercial license
15 * Alternatively, this file may be used under the terms of a commercial
16 * license agreement with the copyright holder
17 * (David C. Manuelda <StormByte@gmail.com>).
18 *
19 * Both licenses apply only to original StormByte-Database source in this
20 * repository. They do not cover other StormByte modules or any third-party
21 * material shipped with this repository (including everything under
22 * thirdparty/, and in particular the bundled StormByte-Logger tree and
23 * the PostgreSQL, MariaDB and SQLite trees), which remain under their own
24 * licenses.
25 *
26 * Neither license grants any patent rights. Any patent licenses required
27 * to use this software or third-party components must be obtained separately
28 * from the patent holders.
29 *
30 * StormByte-Database is distributed in the hope that it will be useful,
31 * but WITHOUT ANY WARRANTY; without even the implied warranty of
32 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
33 * GNU Lesser General Public License for more details.
34 *
35 * You should have received a copy of the GNU Lesser General Public License
36 * version 3 along with StormByte-Database. If not, see
37 * <https://www.gnu.org/licenses/lgpl-3.0.html>.
38 *
39 * SPDX-License-Identifier: LGPL-3.0-or-later OR LicenseRef-StormByte-Commercial
40 */
41
42#pragma once
43
47#include <StormByte/safe/vector.hxx>
48
49#include <string_view>
50
55namespace StormByte {
60 namespace Database {
65 namespace MSSQL {
70 struct ConnectionHandle;
75 struct CallbackHandlers;
76
85 public:
87 MSSQL(const MSSQL&) = delete;
89 MSSQL(MSSQL&& other) noexcept;
91 MSSQL& operator=(const MSSQL&) = delete;
93 MSSQL& operator=(MSSQL&& other) noexcept;
95 ~MSSQL() noexcept override;
96
102 ExpectedRows Query(std::string_view query) noexcept override;
104 bool SilentQuery(std::string_view query) noexcept override;
105
106 protected:
116 MSSQL(std::string_view host, std::string_view user, std::string_view password,
117 std::string_view database, int port, const StormByte::Safe::Shared<Logger::Log>& logger);
118
120 bool DoSilentQuery(std::string_view query) noexcept override;
121
122 private:
123 friend class PreparedSTMT;
124 friend struct CallbackHandlers;
125 StormByte::Safe::String m_host;
126 StormByte::Safe::String m_user;
127 StormByte::Safe::String m_password;
128 StormByte::Safe::String m_database;
129 int m_port;
130 StormByte::Safe::Unique<ConnectionHandle> m_connection_handle;
131 StormByte::Safe::String m_last_error;
132
134 bool DoConnect() noexcept override;
136 void DoDisconnect() noexcept override;
138 void DoPreDisconnect() noexcept override;
140 StormByte::Safe::Unique<StormByte::Database::PreparedSTMT> CreatePreparedSTMT(
141 std::string_view name, std::string_view query) noexcept override;
143 void DoBeginTransaction(IsolationLevel level) override;
144
146 ExpectedRows ExecuteParameterized(std::string_view query, const StormByte::Safe::Vector<Value>& parameters);
147 };
148 }
149 }
150}
151
Abstract backend.
Definition database.hxx:73
Database(const StormByte::Safe::Shared< Logger::Log > &logger)
Construct with an optional logger.
Microsoft SQL Server backend.
Definition mssql.hxx:84
friend struct CallbackHandlers
Definition mssql.hxx:124
MSSQL & operator=(const MSSQL &)=delete
Deleted copy assignment.
friend class PreparedSTMT
Definition mssql.hxx:123
MSSQL & operator=(MSSQL &&other) noexcept
Move assignment.
bool DoSilentQuery(std::string_view query) noexcept override
Execute an internal no-result query.
~MSSQL() noexcept override
Disconnect and release the DB-Library process.
MSSQL(MSSQL &&other) noexcept
Move constructor.
ExpectedRows Query(std::string_view query) noexcept override
Execute a SQL batch and collect its first result set.
bool SilentQuery(std::string_view query) noexcept override
Execute a SQL batch without returning rows.
MSSQL(const MSSQL &)=delete
Deleted copy constructor.
Type-erased SQL value (NULL, integers, double, text, blob, bool).
Definition value.hxx:71
STORMBYTE_DECLARE_MAYBE_SAFE(StormByte::Logger::Exception)
Database module of the StormByte suite.
Expected< Rows, QueryException > ExpectedRows
Query result: Rows or QueryException.
Definition typedefs.hxx:81
IsolationLevel
Isolation for BeginTransaction().
Definition typedefs.hxx:98
Root namespace of the StormByte C++ suite.
STL namespace.
Source-private adapter for native DB-Library callbacks.
Private opaque holder for the native MariaDB connection.
#define STORMBYTE_DATABASE_PUBLIC
Definition visibility.h:54