sqlite3.hxx

Go to the documentation of this file.

/*
 * Copyright (C) 2024-2026 David C. Manuelda (StormBytePP)
 *
 * This file is part of StormByte-Database.
 *
 * StormByte-Database original source is dual-licensed:
 *
 * 1. GNU Lesser General Public License v3.0 (or later)
 *    You may redistribute and/or modify this file under the terms of the
 *    GNU Lesser General Public License as published by the Free Software
 *    Foundation, either version 3 of the License, or (at your option)
 *    any later version.
 *
 * 2. Commercial license
 *    Alternatively, this file may be used under the terms of a commercial
 *    license agreement with the copyright holder
 *    (David C. Manuelda <StormByte@gmail.com>).
 *
 * Both licenses apply only to original StormByte-Database source in this
 * repository. They do not cover other StormByte modules or any third-party
 * material shipped with this repository (including everything under
 * thirdparty/, and in particular the bundled StormByte-Logger tree and
 * the PostgreSQL, MariaDB and SQLite trees), which remain under their own
 * licenses.
 *
 * Neither license grants any patent rights. Any patent licenses required
 * to use this software or third-party components must be obtained separately
 * from the patent holders.
 *
 * StormByte-Database is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * version 3 along with StormByte-Database. If not, see
 * <https://www.gnu.org/licenses/lgpl-3.0.html>.
 *
 * SPDX-License-Identifier: LGPL-3.0-or-later OR LicenseRef-StormByte-Commercial
 */
 
#pragma once
 
#include <StormByte/database/database.hxx>
#include <StormByte/database/sqlite/prepared_stmt.hxx>
#include <StormByte/database/sqlite/telemetry.hxx>
 
#include <filesystem>
#include <memory>
#include <string_view>
 
struct sqlite3;
 
namespace StormByte {
    namespace Database {
        namespace SQLite {
            class STORMBYTE_DATABASE_PUBLIC SQLite3 : public Database {
                public:
                    SQLite3(const SQLite3 &db) = delete;
 
                    SQLite3(SQLite3 &&db) noexcept;
 
                    SQLite3 &operator=(const SQLite3 &db) = delete;
 
                    SQLite3 &operator=(SQLite3 &&db) noexcept;
 
                    ~SQLite3() noexcept override;
 
                    ExpectedRows Query(std::string_view query) noexcept override;
 
                    bool SilentQuery(std::string_view query) noexcept override;
 
                protected:
                    SQLite3(const StormByte::Shared<Logger::Log>& logger);
 
                    SQLite3(const std::filesystem::path &dbfile, const StormByte::Shared<Logger::Log>& logger);
 
                    SQLite3(std::filesystem::path &&dbfile, const StormByte::Shared<Logger::Log>& logger);
 
                    void EnableForeignKeys();
 
                    bool DoSilentQuery(std::string_view query) noexcept override;
 
                private:
                    std::filesystem::path m_database_file; 
                    sqlite3 *m_database;                   
 
                    bool DoConnect() noexcept override;
 
                    void DoPreDisconnect() noexcept override;
 
                    void DoDisconnect() noexcept override;
 
                    void DoPostDisconnect() noexcept override;
 
                    StormByte::Unique<StormByte::Database::PreparedSTMT> CreatePreparedSTMT(std::string_view name, std::string_view query) noexcept override;
 
                    void DoBeginTransaction(IsolationLevel level) override;
            };
        }   }}