LCOV - code coverage report
Current view: top level - src/wallet - sqlite.cpp (source / functions) Coverage Total Hit
Test: test_bitcoin_coverage.info Lines: 73.8 % 408 301
Test Date: 2025-10-04 04:34:28 Functions: 91.9 % 37 34
Branches: 39.3 % 496 195

             Branch data     Line data    Source code
       1                 :             : // Copyright (c) 2020-present The Bitcoin Core developers
       2                 :             : // Distributed under the MIT software license, see the accompanying
       3                 :             : // file COPYING or http://www.opensource.org/licenses/mit-license.php.
       4                 :             : 
       5                 :             : #include <bitcoin-build-config.h> // IWYU pragma: keep
       6                 :             : 
       7                 :             : #include <wallet/sqlite.h>
       8                 :             : 
       9                 :             : #include <chainparams.h>
      10                 :             : #include <crypto/common.h>
      11                 :             : #include <logging.h>
      12                 :             : #include <sync.h>
      13                 :             : #include <util/check.h>
      14                 :             : #include <util/fs_helpers.h>
      15                 :             : #include <util/strencodings.h>
      16                 :             : #include <util/translation.h>
      17                 :             : #include <wallet/db.h>
      18                 :             : 
      19                 :             : #include <sqlite3.h>
      20                 :             : 
      21                 :             : #include <cstdint>
      22                 :             : #include <optional>
      23                 :             : #include <utility>
      24                 :             : #include <vector>
      25                 :             : 
      26                 :             : namespace wallet {
      27                 :             : static constexpr int32_t WALLET_SCHEMA_VERSION = 0;
      28                 :             : 
      29                 :         383 : static std::span<const std::byte> SpanFromBlob(sqlite3_stmt* stmt, int col)
      30                 :             : {
      31                 :         383 :     return {reinterpret_cast<const std::byte*>(sqlite3_column_blob(stmt, col)),
      32                 :         383 :             static_cast<size_t>(sqlite3_column_bytes(stmt, col))};
      33                 :             : }
      34                 :             : 
      35                 :           1 : static void ErrorLogCallback(void* arg, int code, const char* msg)
      36                 :             : {
      37                 :             :     // From sqlite3_config() documentation for the SQLITE_CONFIG_LOG option:
      38                 :             :     // "The void pointer that is the second argument to SQLITE_CONFIG_LOG is passed through as
      39                 :             :     // the first parameter to the application-defined logger function whenever that function is
      40                 :             :     // invoked."
      41                 :             :     // Assert that this is the case:
      42         [ -  + ]:           1 :     assert(arg == nullptr);
      43                 :           1 :     LogPrintf("SQLite Error. Code: %d. Message: %s\n", code, msg);
      44                 :           1 : }
      45                 :             : 
      46                 :         898 : static int TraceSqlCallback(unsigned code, void* context, void* param1, void* param2)
      47                 :             : {
      48                 :         898 :     auto* db = static_cast<SQLiteDatabase*>(context);
      49         [ +  - ]:         898 :     if (code == SQLITE_TRACE_STMT) {
      50                 :         898 :         auto* stmt = static_cast<sqlite3_stmt*>(param1);
      51                 :             :         // To be conservative and avoid leaking potentially secret information
      52                 :             :         // in the log file, only expand statements that query the database, not
      53                 :             :         // statements that update the database.
      54         [ +  + ]:         898 :         char* expanded{sqlite3_stmt_readonly(stmt) ? sqlite3_expanded_sql(stmt) : nullptr};
      55   [ +  -  +  +  :        1796 :         LogTrace(BCLog::WALLETDB, "[%s] SQLite Statement: %s\n", db->Filename(), expanded ? expanded : sqlite3_sql(stmt));
                   +  - ]
      56         [ +  + ]:         898 :         if (expanded) sqlite3_free(expanded);
      57                 :             :     }
      58                 :         898 :     return SQLITE_OK;
      59                 :             : }
      60                 :             : 
      61                 :        1214 : static bool BindBlobToStatement(sqlite3_stmt* stmt,
      62                 :             :                                 int index,
      63                 :             :                                 std::span<const std::byte> blob,
      64                 :             :                                 const std::string& description)
      65                 :             : {
      66                 :             :     // Pass a pointer to the empty string "" below instead of passing the
      67                 :             :     // blob.data() pointer if the blob.data() pointer is null. Passing a null
      68                 :             :     // data pointer to bind_blob would cause sqlite to bind the SQL NULL value
      69                 :             :     // instead of the empty blob value X'', which would mess up SQL comparisons.
      70         [ +  + ]:        1214 :     int res = sqlite3_bind_blob(stmt, index, blob.data() ? static_cast<const void*>(blob.data()) : "", blob.size(), SQLITE_STATIC);
      71         [ -  + ]:        1214 :     if (res != SQLITE_OK) {
      72                 :           0 :         LogPrintf("Unable to bind %s to statement: %s\n", description, sqlite3_errstr(res));
      73                 :           0 :         sqlite3_clear_bindings(stmt);
      74                 :           0 :         sqlite3_reset(stmt);
      75                 :           0 :         return false;
      76                 :             :     }
      77                 :             : 
      78                 :             :     return true;
      79                 :             : }
      80                 :             : 
      81                 :          28 : static std::optional<int> ReadPragmaInteger(sqlite3* db, const std::string& key, const std::string& description, bilingual_str& error)
      82                 :             : {
      83                 :          28 :     std::string stmt_text = strprintf("PRAGMA %s", key);
      84                 :          28 :     sqlite3_stmt* pragma_read_stmt{nullptr};
      85         [ +  - ]:          28 :     int ret = sqlite3_prepare_v2(db, stmt_text.c_str(), -1, &pragma_read_stmt, nullptr);
      86         [ -  + ]:          28 :     if (ret != SQLITE_OK) {
      87         [ #  # ]:           0 :         sqlite3_finalize(pragma_read_stmt);
      88   [ #  #  #  #  :           0 :         error = Untranslated(strprintf("SQLiteDatabase: Failed to prepare the statement to fetch %s: %s", description, sqlite3_errstr(ret)));
                   #  # ]
      89                 :           0 :         return std::nullopt;
      90                 :             :     }
      91         [ +  - ]:          28 :     ret = sqlite3_step(pragma_read_stmt);
      92         [ -  + ]:          28 :     if (ret != SQLITE_ROW) {
      93         [ #  # ]:           0 :         sqlite3_finalize(pragma_read_stmt);
      94   [ #  #  #  #  :           0 :         error = Untranslated(strprintf("SQLiteDatabase: Failed to fetch %s: %s", description, sqlite3_errstr(ret)));
                   #  # ]
      95                 :           0 :         return std::nullopt;
      96                 :             :     }
      97         [ +  - ]:          28 :     int result = sqlite3_column_int(pragma_read_stmt, 0);
      98         [ +  - ]:          28 :     sqlite3_finalize(pragma_read_stmt);
      99                 :          28 :     return result;
     100                 :          28 : }
     101                 :             : 
     102                 :          50 : static void SetPragma(sqlite3* db, const std::string& key, const std::string& value, const std::string& err_msg)
     103                 :             : {
     104                 :          50 :     std::string stmt_text = strprintf("PRAGMA %s = %s", key, value);
     105         [ +  - ]:          50 :     int ret = sqlite3_exec(db, stmt_text.c_str(), nullptr, nullptr, nullptr);
     106         [ -  + ]:          50 :     if (ret != SQLITE_OK) {
     107   [ #  #  #  #  :           0 :         throw std::runtime_error(strprintf("SQLiteDatabase: %s: %s\n", err_msg, sqlite3_errstr(ret)));
                   #  # ]
     108                 :             :     }
     109                 :          50 : }
     110                 :             : 
     111                 :             : Mutex SQLiteDatabase::g_sqlite_mutex;
     112                 :             : int SQLiteDatabase::g_sqlite_count = 0;
     113                 :             : 
     114                 :          14 : SQLiteDatabase::SQLiteDatabase(const fs::path& dir_path, const fs::path& file_path, const DatabaseOptions& options, bool mock)
     115   [ +  -  -  +  :          28 :     : WalletDatabase(), m_mock(mock), m_dir_path(dir_path), m_file_path(fs::PathToString(file_path)), m_write_semaphore(1), m_use_unsafe_sync(options.use_unsafe_sync)
                   +  - ]
     116                 :             : {
     117                 :          14 :     {
     118         [ +  - ]:          14 :         LOCK(g_sqlite_mutex);
     119         [ +  - ]:          14 :         if (++g_sqlite_count == 1) {
     120                 :             :             // Setup logging
     121         [ +  - ]:          14 :             int ret = sqlite3_config(SQLITE_CONFIG_LOG, ErrorLogCallback, nullptr);
     122         [ -  + ]:          14 :             if (ret != SQLITE_OK) {
     123   [ #  #  #  #  :           0 :                 throw std::runtime_error(strprintf("SQLiteDatabase: Failed to setup error log: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     124                 :             :             }
     125                 :             :             // Force serialized threading mode
     126         [ +  - ]:          14 :             ret = sqlite3_config(SQLITE_CONFIG_SERIALIZED);
     127         [ -  + ]:          14 :             if (ret != SQLITE_OK) {
     128   [ #  #  #  #  :           0 :                 throw std::runtime_error(strprintf("SQLiteDatabase: Failed to configure serialized threading mode: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     129                 :             :             }
     130                 :             :         }
     131         [ +  - ]:          14 :         int ret = sqlite3_initialize(); // This is a no-op if sqlite3 is already initialized
     132         [ -  + ]:          14 :         if (ret != SQLITE_OK) {
     133   [ #  #  #  #  :           0 :             throw std::runtime_error(strprintf("SQLiteDatabase: Failed to initialize SQLite: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     134                 :             :         }
     135                 :           0 :     }
     136                 :             : 
     137                 :          14 :     try {
     138         [ +  - ]:          14 :         Open();
     139         [ -  - ]:           0 :     } catch (const std::runtime_error&) {
     140                 :             :         // If open fails, cleanup this object and rethrow the exception
     141                 :           0 :         Cleanup();
     142                 :           0 :         throw;
     143                 :           0 :     }
     144                 :          14 : }
     145                 :             : 
     146                 :         111 : void SQLiteBatch::SetupSQLStatements()
     147                 :             : {
     148                 :         111 :     const std::vector<std::pair<sqlite3_stmt**, const char*>> statements{
     149                 :         111 :         {&m_read_stmt, "SELECT value FROM main WHERE key = ?"},
     150                 :         111 :         {&m_insert_stmt, "INSERT INTO main VALUES(?, ?)"},
     151                 :         111 :         {&m_overwrite_stmt, "INSERT or REPLACE into main values(?, ?)"},
     152                 :         111 :         {&m_delete_stmt, "DELETE FROM main WHERE key = ?"},
     153                 :         111 :         {&m_delete_prefix_stmt, "DELETE FROM main WHERE instr(key, ?) = 1"},
     154                 :         111 :     };
     155                 :             : 
     156   [ +  -  +  + ]:         666 :     for (const auto& [stmt_prepared, stmt_text] : statements) {
     157         [ +  - ]:         555 :         if (*stmt_prepared == nullptr) {
     158         [ +  - ]:         555 :             int res = sqlite3_prepare_v2(m_database.m_db, stmt_text, -1, stmt_prepared, nullptr);
     159         [ -  + ]:         555 :             if (res != SQLITE_OK) {
     160                 :           0 :                 throw std::runtime_error(strprintf(
     161   [ #  #  #  #  :           0 :                     "SQLiteDatabase: Failed to setup SQL statements: %s\n", sqlite3_errstr(res)));
                   #  # ]
     162                 :             :             }
     163                 :             :         }
     164                 :             :     }
     165                 :         111 : }
     166                 :             : 
     167                 :          28 : SQLiteDatabase::~SQLiteDatabase()
     168                 :             : {
     169                 :          14 :     Cleanup();
     170                 :          28 : }
     171                 :             : 
     172                 :          14 : void SQLiteDatabase::Cleanup() noexcept
     173                 :             : {
     174                 :          14 :     AssertLockNotHeld(g_sqlite_mutex);
     175                 :             : 
     176                 :          14 :     Close();
     177                 :             : 
     178                 :          14 :     LOCK(g_sqlite_mutex);
     179         [ +  - ]:          14 :     if (--g_sqlite_count == 0) {
     180                 :          14 :         int ret = sqlite3_shutdown();
     181         [ -  + ]:          14 :         if (ret != SQLITE_OK) {
     182                 :           0 :             LogPrintf("SQLiteDatabase: Failed to shutdown SQLite: %s\n", sqlite3_errstr(ret));
     183                 :             :         }
     184                 :             :     }
     185                 :          14 : }
     186                 :             : 
     187                 :          14 : bool SQLiteDatabase::Verify(bilingual_str& error)
     188                 :             : {
     189         [ -  + ]:          14 :     assert(m_db);
     190                 :             : 
     191                 :             :     // Check the application ID matches our network magic
     192   [ +  -  +  - ]:          28 :     auto read_result = ReadPragmaInteger(m_db, "application_id", "the application id", error);
     193         [ +  - ]:          14 :     if (!read_result.has_value()) return false;
     194                 :          14 :     uint32_t app_id = static_cast<uint32_t>(read_result.value());
     195         [ -  + ]:          14 :     uint32_t net_magic = ReadBE32(Params().MessageStart().data());
     196         [ -  + ]:          14 :     if (app_id != net_magic) {
     197                 :           0 :         error = strprintf(_("SQLiteDatabase: Unexpected application id. Expected %u, got %u"), net_magic, app_id);
     198                 :           0 :         return false;
     199                 :             :     }
     200                 :             : 
     201                 :             :     // Check our schema version
     202   [ +  -  +  - ]:          28 :     read_result = ReadPragmaInteger(m_db, "user_version", "sqlite wallet schema version", error);
     203         [ +  - ]:          14 :     if (!read_result.has_value()) return false;
     204         [ -  + ]:          14 :     int32_t user_ver = read_result.value();
     205         [ -  + ]:          14 :     if (user_ver != WALLET_SCHEMA_VERSION) {
     206                 :           0 :         error = strprintf(_("SQLiteDatabase: Unknown sqlite wallet schema version %d. Only version %d is supported"), user_ver, WALLET_SCHEMA_VERSION);
     207                 :           0 :         return false;
     208                 :             :     }
     209                 :             : 
     210                 :          14 :     sqlite3_stmt* stmt{nullptr};
     211                 :          14 :     int ret = sqlite3_prepare_v2(m_db, "PRAGMA integrity_check", -1, &stmt, nullptr);
     212         [ -  + ]:          14 :     if (ret != SQLITE_OK) {
     213                 :           0 :         sqlite3_finalize(stmt);
     214                 :           0 :         error = strprintf(_("SQLiteDatabase: Failed to prepare statement to verify database: %s"), sqlite3_errstr(ret));
     215                 :           0 :         return false;
     216                 :             :     }
     217                 :          28 :     while (true) {
     218                 :          28 :         ret = sqlite3_step(stmt);
     219         [ +  + ]:          28 :         if (ret == SQLITE_DONE) {
     220                 :             :             break;
     221                 :             :         }
     222         [ -  + ]:          14 :         if (ret != SQLITE_ROW) {
     223                 :           0 :             error = strprintf(_("SQLiteDatabase: Failed to execute statement to verify database: %s"), sqlite3_errstr(ret));
     224                 :           0 :             break;
     225                 :             :         }
     226                 :          14 :         const char* msg = (const char*)sqlite3_column_text(stmt, 0);
     227         [ -  + ]:          14 :         if (!msg) {
     228                 :           0 :             error = strprintf(_("SQLiteDatabase: Failed to read database verification error: %s"), sqlite3_errstr(ret));
     229                 :           0 :             break;
     230                 :             :         }
     231                 :          14 :         std::string str_msg(msg);
     232         [ +  - ]:          14 :         if (str_msg == "ok") {
     233                 :          14 :             continue;
     234                 :             :         }
     235         [ #  # ]:           0 :         if (error.empty()) {
     236   [ #  #  #  #  :           0 :             error = _("Failed to verify database") + Untranslated("\n");
                   #  # ]
     237                 :             :         }
     238   [ #  #  #  #  :           0 :         error += Untranslated(strprintf("%s\n", str_msg));
                   #  # ]
     239                 :          14 :     }
     240                 :          14 :     sqlite3_finalize(stmt);
     241                 :          14 :     return error.empty();
     242                 :             : }
     243                 :             : 
     244                 :          15 : void SQLiteDatabase::Open()
     245                 :             : {
     246                 :          15 :     int flags = SQLITE_OPEN_FULLMUTEX | SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE;
     247         [ -  + ]:          15 :     if (m_mock) {
     248                 :           0 :         flags |= SQLITE_OPEN_MEMORY; // In memory database for mock db
     249                 :             :     }
     250                 :             : 
     251         [ +  - ]:          15 :     if (m_db == nullptr) {
     252         [ +  - ]:          15 :         if (!m_mock) {
     253                 :          15 :             TryCreateDirectories(m_dir_path);
     254                 :             :         }
     255                 :          15 :         int ret = sqlite3_open_v2(m_file_path.c_str(), &m_db, flags, nullptr);
     256         [ -  + ]:          15 :         if (ret != SQLITE_OK) {
     257   [ #  #  #  #  :           0 :             throw std::runtime_error(strprintf("SQLiteDatabase: Failed to open database: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     258                 :             :         }
     259                 :          15 :         ret = sqlite3_extended_result_codes(m_db, 1);
     260         [ -  + ]:          15 :         if (ret != SQLITE_OK) {
     261   [ #  #  #  #  :           0 :             throw std::runtime_error(strprintf("SQLiteDatabase: Failed to enable extended result codes: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     262                 :             :         }
     263                 :             :         // Trace SQL statements if tracing is enabled with -debug=walletdb -loglevel=walletdb:trace
     264         [ +  - ]:          15 :         if (LogAcceptCategory(BCLog::WALLETDB, BCLog::Level::Trace)) {
     265                 :          15 :            ret = sqlite3_trace_v2(m_db, SQLITE_TRACE_STMT, TraceSqlCallback, this);
     266         [ -  + ]:          15 :            if (ret != SQLITE_OK) {
     267         [ #  # ]:           0 :                LogPrintf("Failed to enable SQL tracing for %s\n", Filename());
     268                 :             :            }
     269                 :             :         }
     270                 :             :     }
     271                 :             : 
     272         [ -  + ]:          15 :     if (sqlite3_db_readonly(m_db, "main") != 0) {
     273         [ #  # ]:           0 :         throw std::runtime_error("SQLiteDatabase: Database opened in readonly mode but read-write permissions are needed");
     274                 :             :     }
     275                 :             : 
     276                 :             :     // Acquire an exclusive lock on the database
     277                 :             :     // First change the locking mode to exclusive
     278   [ +  -  +  -  :          30 :     SetPragma(m_db, "locking_mode", "exclusive", "Unable to change database locking mode to exclusive");
                   +  - ]
     279                 :             :     // Now begin a transaction to acquire the exclusive lock. This lock won't be released until we close because of the exclusive locking mode.
     280                 :          15 :     int ret = sqlite3_exec(m_db, "BEGIN EXCLUSIVE TRANSACTION", nullptr, nullptr, nullptr);
     281         [ -  + ]:          15 :     if (ret != SQLITE_OK) {
     282         [ #  # ]:           0 :         throw std::runtime_error("SQLiteDatabase: Unable to obtain an exclusive lock on the database, is it being used by another instance of " CLIENT_NAME "?\n");
     283                 :             :     }
     284                 :          15 :     ret = sqlite3_exec(m_db, "COMMIT", nullptr, nullptr, nullptr);
     285         [ -  + ]:          15 :     if (ret != SQLITE_OK) {
     286   [ #  #  #  #  :           0 :         throw std::runtime_error(strprintf("SQLiteDatabase: Unable to end exclusive lock transaction: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     287                 :             :     }
     288                 :             : 
     289                 :             :     // Enable fullfsync for the platforms that use it
     290   [ +  -  +  -  :          30 :     SetPragma(m_db, "fullfsync", "true", "Failed to enable fullfsync");
                   +  - ]
     291                 :             : 
     292         [ -  + ]:          15 :     if (m_use_unsafe_sync) {
     293                 :             :         // Use normal synchronous mode for the journal
     294                 :           0 :         LogPrintf("WARNING SQLite is configured to not wait for data to be flushed to disk. Data loss and corruption may occur.\n");
     295   [ #  #  #  #  :           0 :         SetPragma(m_db, "synchronous", "OFF", "Failed to set synchronous mode to OFF");
                   #  # ]
     296                 :             :     }
     297                 :             : 
     298                 :             :     // Make the table for our key-value pairs
     299                 :             :     // First check that the main table exists
     300                 :          15 :     sqlite3_stmt* check_main_stmt{nullptr};
     301                 :          15 :     ret = sqlite3_prepare_v2(m_db, "SELECT name FROM sqlite_master WHERE type='table' AND name='main'", -1, &check_main_stmt, nullptr);
     302         [ -  + ]:          15 :     if (ret != SQLITE_OK) {
     303   [ #  #  #  #  :           0 :         throw std::runtime_error(strprintf("SQLiteDatabase: Failed to prepare statement to check table existence: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     304                 :             :     }
     305                 :          15 :     ret = sqlite3_step(check_main_stmt);
     306         [ -  + ]:          15 :     if (sqlite3_finalize(check_main_stmt) != SQLITE_OK) {
     307   [ #  #  #  #  :           0 :         throw std::runtime_error(strprintf("SQLiteDatabase: Failed to finalize statement checking table existence: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     308                 :             :     }
     309                 :          15 :     bool table_exists;
     310         [ +  + ]:          15 :     if (ret == SQLITE_DONE) {
     311                 :             :         table_exists = false;
     312         [ -  + ]:           5 :     } else if (ret == SQLITE_ROW) {
     313                 :             :         table_exists = true;
     314                 :             :     } else {
     315   [ #  #  #  #  :           0 :         throw std::runtime_error(strprintf("SQLiteDatabase: Failed to execute statement to check table existence: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     316                 :             :     }
     317                 :             : 
     318                 :             :     // Do the db setup things because the table doesn't exist only when we are creating a new wallet
     319                 :          10 :     if (!table_exists) {
     320                 :          10 :         ret = sqlite3_exec(m_db, "CREATE TABLE main(key BLOB PRIMARY KEY NOT NULL, value BLOB NOT NULL)", nullptr, nullptr, nullptr);
     321         [ -  + ]:          10 :         if (ret != SQLITE_OK) {
     322   [ #  #  #  #  :           0 :             throw std::runtime_error(strprintf("SQLiteDatabase: Failed to create new database: %s\n", sqlite3_errstr(ret)));
                   #  # ]
     323                 :             :         }
     324                 :             : 
     325                 :             :         // Set the application id
     326                 :          10 :         uint32_t app_id = ReadBE32(Params().MessageStart().data());
     327   [ +  -  +  -  :          20 :         SetPragma(m_db, "application_id", strprintf("%d", static_cast<int32_t>(app_id)),
                   +  - ]
     328                 :          10 :                   "Failed to set the application id");
     329                 :             : 
     330                 :             :         // Set the user version
     331   [ +  -  +  -  :          20 :         SetPragma(m_db, "user_version", strprintf("%d", WALLET_SCHEMA_VERSION),
                   +  - ]
     332                 :          20 :                   "Failed to set the wallet schema version");
     333                 :             :     }
     334                 :          15 : }
     335                 :             : 
     336                 :           0 : bool SQLiteDatabase::Rewrite()
     337                 :             : {
     338                 :             :     // Rewrite the database using the VACUUM command: https://sqlite.org/lang_vacuum.html
     339                 :           0 :     int ret = sqlite3_exec(m_db, "VACUUM", nullptr, nullptr, nullptr);
     340                 :           0 :     return ret == SQLITE_OK;
     341                 :             : }
     342                 :             : 
     343                 :           0 : bool SQLiteDatabase::Backup(const std::string& dest) const
     344                 :             : {
     345                 :           0 :     sqlite3* db_copy;
     346                 :           0 :     int res = sqlite3_open(dest.c_str(), &db_copy);
     347         [ #  # ]:           0 :     if (res != SQLITE_OK) {
     348                 :           0 :         sqlite3_close(db_copy);
     349                 :           0 :         return false;
     350                 :             :     }
     351                 :           0 :     sqlite3_backup* backup = sqlite3_backup_init(db_copy, "main", m_db, "main");
     352         [ #  # ]:           0 :     if (!backup) {
     353                 :           0 :         LogPrintf("%s: Unable to begin backup: %s\n", __func__, sqlite3_errmsg(m_db));
     354                 :           0 :         sqlite3_close(db_copy);
     355                 :           0 :         return false;
     356                 :             :     }
     357                 :             :     // Specifying -1 will copy all of the pages
     358                 :           0 :     res = sqlite3_backup_step(backup, -1);
     359         [ #  # ]:           0 :     if (res != SQLITE_DONE) {
     360                 :           0 :         LogPrintf("%s: Unable to backup: %s\n", __func__, sqlite3_errstr(res));
     361                 :           0 :         sqlite3_backup_finish(backup);
     362                 :           0 :         sqlite3_close(db_copy);
     363                 :           0 :         return false;
     364                 :             :     }
     365                 :           0 :     res = sqlite3_backup_finish(backup);
     366                 :           0 :     sqlite3_close(db_copy);
     367                 :           0 :     return res == SQLITE_OK;
     368                 :             : }
     369                 :             : 
     370                 :          17 : void SQLiteDatabase::Close()
     371                 :             : {
     372                 :          17 :     int res = sqlite3_close(m_db);
     373         [ -  + ]:          17 :     if (res != SQLITE_OK) {
     374   [ #  #  #  #  :           0 :         throw std::runtime_error(strprintf("SQLiteDatabase: Failed to close database: %s\n", sqlite3_errstr(res)));
                   #  # ]
     375                 :             :     }
     376                 :          17 :     m_db = nullptr;
     377                 :          17 : }
     378                 :             : 
     379                 :         121 : bool SQLiteDatabase::HasActiveTxn()
     380                 :             : {
     381                 :             :     // 'sqlite3_get_autocommit' returns true by default, and false if a transaction has begun and not been committed or rolled back.
     382   [ +  -  +  + ]:         121 :     return m_db && sqlite3_get_autocommit(m_db) == 0;
     383                 :             : }
     384                 :             : 
     385                 :         119 : int SQliteExecHandler::Exec(SQLiteDatabase& database, const std::string& statement)
     386                 :             : {
     387                 :         119 :     return sqlite3_exec(database.m_db, statement.data(), nullptr, nullptr, nullptr);
     388                 :             : }
     389                 :             : 
     390                 :         109 : std::unique_ptr<DatabaseBatch> SQLiteDatabase::MakeBatch()
     391                 :             : {
     392                 :             :     // We ignore flush_on_close because we don't do manual flushing for SQLite
     393                 :         109 :     return std::make_unique<SQLiteBatch>(*this);
     394                 :             : }
     395                 :             : 
     396                 :         111 : SQLiteBatch::SQLiteBatch(SQLiteDatabase& database)
     397         [ +  - ]:         111 :     : m_database(database)
     398                 :             : {
     399                 :             :     // Make sure we have a db handle
     400         [ -  + ]:         111 :     assert(m_database.m_db);
     401                 :             : 
     402         [ +  - ]:         111 :     SetupSQLStatements();
     403                 :         111 : }
     404                 :             : 
     405                 :         111 : void SQLiteBatch::Close()
     406                 :             : {
     407                 :         111 :     bool force_conn_refresh = false;
     408                 :             : 
     409                 :             :     // If we began a transaction, and it wasn't committed, abort the transaction in progress
     410         [ +  + ]:         111 :     if (m_txn) {
     411         [ -  + ]:           1 :         if (TxnAbort()) {
     412                 :           0 :             LogPrintf("SQLiteBatch: Batch closed unexpectedly without the transaction being explicitly committed or aborted\n");
     413                 :             :         } else {
     414                 :             :             // If transaction cannot be aborted, it means there is a bug or there has been data corruption. Try to recover in this case
     415                 :             :             // by closing and reopening the database. Closing the database should also ensure that any changes made since the transaction
     416                 :             :             // was opened will be rolled back and future transactions can succeed without committing old data.
     417                 :           1 :             force_conn_refresh = true;
     418                 :           1 :             LogPrintf("SQLiteBatch: Batch closed and failed to abort transaction, resetting db connection..\n");
     419                 :             :         }
     420                 :             :     }
     421                 :             : 
     422                 :             :     // Free all of the prepared statements
     423                 :         111 :     const std::vector<std::pair<sqlite3_stmt**, const char*>> statements{
     424                 :         111 :         {&m_read_stmt, "read"},
     425                 :         111 :         {&m_insert_stmt, "insert"},
     426                 :         111 :         {&m_overwrite_stmt, "overwrite"},
     427                 :         111 :         {&m_delete_stmt, "delete"},
     428                 :         111 :         {&m_delete_prefix_stmt, "delete prefix"},
     429                 :         111 :     };
     430                 :             : 
     431   [ +  -  +  + ]:         666 :     for (const auto& [stmt_prepared, stmt_description] : statements) {
     432         [ +  - ]:         555 :         int res = sqlite3_finalize(*stmt_prepared);
     433         [ -  + ]:         555 :         if (res != SQLITE_OK) {
     434   [ #  #  #  # ]:           0 :             LogPrintf("SQLiteBatch: Batch closed but could not finalize %s statement: %s\n",
     435                 :             :                       stmt_description, sqlite3_errstr(res));
     436                 :             :         }
     437                 :         555 :         *stmt_prepared = nullptr;
     438                 :             :     }
     439                 :             : 
     440         [ +  + ]:         111 :     if (force_conn_refresh) {
     441         [ +  - ]:           1 :         m_database.Close();
     442                 :           1 :         try {
     443         [ +  - ]:           1 :             m_database.Open();
     444                 :             :             // If TxnAbort failed and we refreshed the connection, the semaphore was not released, so release it here to avoid deadlocks on future writes.
     445                 :           1 :             m_database.m_write_semaphore.release();
     446         [ -  - ]:           0 :         } catch (const std::runtime_error&) {
     447                 :             :             // If open fails, cleanup this object and rethrow the exception
     448         [ -  - ]:           0 :             m_database.Close();
     449                 :           0 :             throw;
     450                 :           0 :         }
     451                 :             :     }
     452                 :         111 : }
     453                 :             : 
     454                 :          35 : bool SQLiteBatch::ReadKey(DataStream&& key, DataStream& value)
     455                 :             : {
     456         [ +  - ]:          35 :     if (!m_database.m_db) return false;
     457         [ -  + ]:          35 :     assert(m_read_stmt);
     458                 :             : 
     459                 :             :     // Bind: leftmost parameter in statement is index 1
     460   [ +  -  +  - ]:          70 :     if (!BindBlobToStatement(m_read_stmt, 1, key, "key")) return false;
     461                 :          35 :     int res = sqlite3_step(m_read_stmt);
     462         [ +  + ]:          35 :     if (res != SQLITE_ROW) {
     463         [ -  + ]:          10 :         if (res != SQLITE_DONE) {
     464                 :             :             // SQLITE_DONE means "not found", don't log an error in that case.
     465                 :           0 :             LogPrintf("%s: Unable to execute statement: %s\n", __func__, sqlite3_errstr(res));
     466                 :             :         }
     467                 :          10 :         sqlite3_clear_bindings(m_read_stmt);
     468                 :          10 :         sqlite3_reset(m_read_stmt);
     469                 :          10 :         return false;
     470                 :             :     }
     471                 :             :     // Leftmost column in result is index 0
     472         [ -  + ]:          25 :     value.clear();
     473                 :          25 :     value.write(SpanFromBlob(m_read_stmt, 0));
     474                 :             : 
     475                 :          25 :     sqlite3_clear_bindings(m_read_stmt);
     476                 :          25 :     sqlite3_reset(m_read_stmt);
     477                 :          25 :     return true;
     478                 :             : }
     479                 :             : 
     480                 :         349 : bool SQLiteBatch::WriteKey(DataStream&& key, DataStream&& value, bool overwrite)
     481                 :             : {
     482         [ +  - ]:         349 :     if (!m_database.m_db) return false;
     483   [ +  -  -  + ]:         349 :     assert(m_insert_stmt && m_overwrite_stmt);
     484                 :             : 
     485                 :         349 :     sqlite3_stmt* stmt;
     486         [ +  + ]:         349 :     if (overwrite) {
     487                 :             :         stmt = m_overwrite_stmt;
     488                 :             :     } else {
     489                 :          27 :         stmt = m_insert_stmt;
     490                 :             :     }
     491                 :             : 
     492                 :             :     // Bind: leftmost parameter in statement is index 1
     493                 :             :     // Insert index 1 is key, 2 is value
     494   [ +  -  +  - ]:         698 :     if (!BindBlobToStatement(stmt, 1, key, "key")) return false;
     495   [ +  -  +  - ]:         698 :     if (!BindBlobToStatement(stmt, 2, value, "value")) return false;
     496                 :             : 
     497                 :             :     // Acquire semaphore if not previously acquired when creating a transaction.
     498         [ +  + ]:         349 :     if (!m_txn) m_database.m_write_semaphore.acquire();
     499                 :             : 
     500                 :             :     // Execute
     501                 :         349 :     int res = sqlite3_step(stmt);
     502                 :         349 :     sqlite3_clear_bindings(stmt);
     503                 :         349 :     sqlite3_reset(stmt);
     504         [ +  + ]:         349 :     if (res != SQLITE_DONE) {
     505                 :           1 :         LogPrintf("%s: Unable to execute statement: %s\n", __func__, sqlite3_errstr(res));
     506                 :             :     }
     507                 :             : 
     508         [ +  + ]:         349 :     if (!m_txn) m_database.m_write_semaphore.release();
     509                 :             : 
     510                 :         349 :     return res == SQLITE_DONE;
     511                 :             : }
     512                 :             : 
     513                 :           5 : bool SQLiteBatch::ExecStatement(sqlite3_stmt* stmt, std::span<const std::byte> blob)
     514                 :             : {
     515         [ +  - ]:           5 :     if (!m_database.m_db) return false;
     516         [ -  + ]:           5 :     assert(stmt);
     517                 :             : 
     518                 :             :     // Bind: leftmost parameter in statement is index 1
     519   [ +  -  +  - ]:           5 :     if (!BindBlobToStatement(stmt, 1, blob, "key")) return false;
     520                 :             : 
     521                 :             :     // Acquire semaphore if not previously acquired when creating a transaction.
     522         [ +  + ]:           5 :     if (!m_txn) m_database.m_write_semaphore.acquire();
     523                 :             : 
     524                 :             :     // Execute
     525                 :           5 :     int res = sqlite3_step(stmt);
     526                 :           5 :     sqlite3_clear_bindings(stmt);
     527                 :           5 :     sqlite3_reset(stmt);
     528         [ -  + ]:           5 :     if (res != SQLITE_DONE) {
     529                 :           0 :         LogPrintf("%s: Unable to execute statement: %s\n", __func__, sqlite3_errstr(res));
     530                 :             :     }
     531                 :             : 
     532         [ +  + ]:           5 :     if (!m_txn) m_database.m_write_semaphore.release();
     533                 :             : 
     534                 :           5 :     return res == SQLITE_DONE;
     535                 :             : }
     536                 :             : 
     537                 :           3 : bool SQLiteBatch::EraseKey(DataStream&& key)
     538                 :             : {
     539         [ -  + ]:           3 :     return ExecStatement(m_delete_stmt, key);
     540                 :             : }
     541                 :             : 
     542                 :           2 : bool SQLiteBatch::ErasePrefix(std::span<const std::byte> prefix)
     543                 :             : {
     544                 :           2 :     return ExecStatement(m_delete_prefix_stmt, prefix);
     545                 :             : }
     546                 :             : 
     547                 :           7 : bool SQLiteBatch::HasKey(DataStream&& key)
     548                 :             : {
     549         [ +  - ]:           7 :     if (!m_database.m_db) return false;
     550         [ -  + ]:           7 :     assert(m_read_stmt);
     551                 :             : 
     552                 :             :     // Bind: leftmost parameter in statement is index 1
     553   [ +  -  +  - ]:          14 :     if (!BindBlobToStatement(m_read_stmt, 1, key, "key")) return false;
     554                 :           7 :     int res = sqlite3_step(m_read_stmt);
     555                 :           7 :     sqlite3_clear_bindings(m_read_stmt);
     556                 :           7 :     sqlite3_reset(m_read_stmt);
     557                 :           7 :     return res == SQLITE_ROW;
     558                 :             : }
     559                 :             : 
     560                 :         415 : DatabaseCursor::Status SQLiteCursor::Next(DataStream& key, DataStream& value)
     561                 :             : {
     562                 :         415 :     int res = sqlite3_step(m_cursor_stmt);
     563         [ +  + ]:         415 :     if (res == SQLITE_DONE) {
     564                 :             :         return Status::DONE;
     565                 :             :     }
     566         [ -  + ]:         179 :     if (res != SQLITE_ROW) {
     567                 :           0 :         LogPrintf("%s: Unable to execute cursor step: %s\n", __func__, sqlite3_errstr(res));
     568                 :           0 :         return Status::FAIL;
     569                 :             :     }
     570                 :             : 
     571         [ -  + ]:         179 :     key.clear();
     572         [ -  + ]:         179 :     value.clear();
     573                 :             : 
     574                 :             :     // Leftmost column in result is index 0
     575                 :         179 :     key.write(SpanFromBlob(m_cursor_stmt, 0));
     576                 :         179 :     value.write(SpanFromBlob(m_cursor_stmt, 1));
     577                 :         179 :     return Status::MORE;
     578                 :             : }
     579                 :             : 
     580                 :         472 : SQLiteCursor::~SQLiteCursor()
     581                 :             : {
     582                 :         236 :     sqlite3_clear_bindings(m_cursor_stmt);
     583                 :         236 :     sqlite3_reset(m_cursor_stmt);
     584                 :         236 :     int res = sqlite3_finalize(m_cursor_stmt);
     585         [ -  + ]:         236 :     if (res != SQLITE_OK) {
     586                 :           0 :         LogPrintf("%s: cursor closed but could not finalize cursor statement: %s\n",
     587                 :             :                   __func__, sqlite3_errstr(res));
     588                 :             :     }
     589                 :         472 : }
     590                 :             : 
     591                 :           0 : std::unique_ptr<DatabaseCursor> SQLiteBatch::GetNewCursor()
     592                 :             : {
     593         [ #  # ]:           0 :     if (!m_database.m_db) return nullptr;
     594                 :           0 :     auto cursor = std::make_unique<SQLiteCursor>();
     595                 :             : 
     596                 :           0 :     const char* stmt_text = "SELECT key, value FROM main";
     597         [ #  # ]:           0 :     int res = sqlite3_prepare_v2(m_database.m_db, stmt_text, -1, &cursor->m_cursor_stmt, nullptr);
     598         [ #  # ]:           0 :     if (res != SQLITE_OK) {
     599                 :           0 :         throw std::runtime_error(strprintf(
     600   [ #  #  #  #  :           0 :             "%s: Failed to setup cursor SQL statement: %s\n", __func__, sqlite3_errstr(res)));
                   #  # ]
     601                 :             :     }
     602                 :             : 
     603                 :           0 :     return cursor;
     604                 :           0 : }
     605                 :             : 
     606                 :         236 : std::unique_ptr<DatabaseCursor> SQLiteBatch::GetNewPrefixCursor(std::span<const std::byte> prefix)
     607                 :             : {
     608         [ -  + ]:         236 :     if (!m_database.m_db) return nullptr;
     609                 :             : 
     610                 :             :     // To get just the records we want, the SQL statement does a comparison of the binary data
     611                 :             :     // where the data must be greater than or equal to the prefix, and less than
     612                 :             :     // the prefix incremented by one (when interpreted as an integer)
     613                 :         236 :     std::vector<std::byte> start_range(prefix.begin(), prefix.end());
     614         [ +  - ]:         236 :     std::vector<std::byte> end_range(prefix.begin(), prefix.end());
     615                 :         236 :     auto it = end_range.rbegin();
     616         [ +  + ]:         242 :     for (; it != end_range.rend(); ++it) {
     617         [ +  + ]:         239 :         if (*it == std::byte(std::numeric_limits<unsigned char>::max())) {
     618                 :           6 :             *it = std::byte(0);
     619                 :           6 :             continue;
     620                 :             :         }
     621                 :         233 :         *it = std::byte(std::to_integer<unsigned char>(*it) + 1);
     622                 :         233 :         break;
     623                 :             :     }
     624         [ +  + ]:         236 :     if (it == end_range.rend()) {
     625                 :             :         // If the prefix is all 0xff bytes, clear end_range as we won't need it
     626         [ +  + ]:           3 :         end_range.clear();
     627                 :             :     }
     628                 :             : 
     629         [ +  - ]:         236 :     auto cursor = std::make_unique<SQLiteCursor>(start_range, end_range);
     630         [ -  + ]:         236 :     if (!cursor) return nullptr;
     631                 :             : 
     632         [ +  + ]:         236 :     const char* stmt_text = end_range.empty() ? "SELECT key, value FROM main WHERE key >= ?" :
     633                 :         233 :                             "SELECT key, value FROM main WHERE key >= ? AND key < ?";
     634         [ +  - ]:         236 :     int res = sqlite3_prepare_v2(m_database.m_db, stmt_text, -1, &cursor->m_cursor_stmt, nullptr);
     635         [ -  + ]:         236 :     if (res != SQLITE_OK) {
     636                 :           0 :         throw std::runtime_error(strprintf(
     637   [ #  #  #  #  :           0 :             "SQLiteDatabase: Failed to setup cursor SQL statement: %s\n", sqlite3_errstr(res)));
                   #  # ]
     638                 :             :     }
     639                 :             : 
     640   [ +  -  -  +  :         236 :     if (!BindBlobToStatement(cursor->m_cursor_stmt, 1, cursor->m_prefix_range_start, "prefix_start")) return nullptr;
             +  -  -  + ]
     641         [ +  + ]:         236 :     if (!end_range.empty()) {
     642   [ +  -  -  +  :         233 :         if (!BindBlobToStatement(cursor->m_cursor_stmt, 2, cursor->m_prefix_range_end, "prefix_end")) return nullptr;
             +  -  -  + ]
     643                 :             :     }
     644                 :             : 
     645                 :         236 :     return cursor;
     646                 :         236 : }
     647                 :             : 
     648                 :          60 : bool SQLiteBatch::TxnBegin()
     649                 :             : {
     650   [ +  -  +  - ]:          60 :     if (!m_database.m_db || m_txn) return false;
     651                 :          60 :     m_database.m_write_semaphore.acquire();
     652                 :          60 :     Assert(!m_database.HasActiveTxn());
     653         [ +  - ]:          60 :     int res = Assert(m_exec_handler)->Exec(m_database, "BEGIN TRANSACTION");
     654         [ -  + ]:          60 :     if (res != SQLITE_OK) {
     655                 :           0 :         LogPrintf("SQLiteBatch: Failed to begin the transaction\n");
     656                 :           0 :         m_database.m_write_semaphore.release();
     657                 :             :     } else {
     658                 :          60 :         m_txn = true;
     659                 :             :     }
     660                 :          60 :     return res == SQLITE_OK;
     661                 :             : }
     662                 :             : 
     663                 :          60 : bool SQLiteBatch::TxnCommit()
     664                 :             : {
     665   [ +  -  +  + ]:          60 :     if (!m_database.m_db || !m_txn) return false;
     666                 :          59 :     Assert(m_database.HasActiveTxn());
     667         [ +  - ]:          59 :     int res = Assert(m_exec_handler)->Exec(m_database, "COMMIT TRANSACTION");
     668         [ -  + ]:          59 :     if (res != SQLITE_OK) {
     669                 :           0 :         LogPrintf("SQLiteBatch: Failed to commit the transaction\n");
     670                 :             :     } else {
     671                 :          59 :         m_txn = false;
     672                 :          59 :         m_database.m_write_semaphore.release();
     673                 :             :     }
     674                 :          59 :     return res == SQLITE_OK;
     675                 :             : }
     676                 :             : 
     677                 :           2 : bool SQLiteBatch::TxnAbort()
     678                 :             : {
     679   [ +  -  +  + ]:           2 :     if (!m_database.m_db || !m_txn) return false;
     680                 :           1 :     Assert(m_database.HasActiveTxn());
     681         [ +  - ]:           1 :     int res = Assert(m_exec_handler)->Exec(m_database, "ROLLBACK TRANSACTION");
     682         [ +  - ]:           1 :     if (res != SQLITE_OK) {
     683                 :           1 :         LogPrintf("SQLiteBatch: Failed to abort the transaction\n");
     684                 :             :     } else {
     685                 :           0 :         m_txn = false;
     686                 :           0 :         m_database.m_write_semaphore.release();
     687                 :             :     }
     688                 :           1 :     return res == SQLITE_OK;
     689                 :             : }
     690                 :             : 
     691                 :          14 : std::unique_ptr<SQLiteDatabase> MakeSQLiteDatabase(const fs::path& path, const DatabaseOptions& options, DatabaseStatus& status, bilingual_str& error)
     692                 :             : {
     693                 :          14 :     try {
     694         [ +  - ]:          14 :         fs::path data_file = SQLiteDataFile(path);
     695   [ +  -  +  - ]:          14 :         auto db = std::make_unique<SQLiteDatabase>(data_file.parent_path(), data_file, options);
     696   [ +  -  +  -  :          14 :         if (options.verify && !db->Verify(error)) {
                   -  + ]
     697                 :           0 :             status = DatabaseStatus::FAILED_VERIFY;
     698                 :           0 :             return nullptr;
     699                 :             :         }
     700                 :          14 :         status = DatabaseStatus::SUCCESS;
     701                 :          14 :         return db;
     702         [ -  - ]:          28 :     } catch (const std::runtime_error& e) {
     703                 :           0 :         status = DatabaseStatus::FAILED_LOAD;
     704   [ -  -  -  - ]:           0 :         error = Untranslated(e.what());
     705                 :           0 :         return nullptr;
     706                 :           0 :     }
     707                 :             : }
     708                 :             : 
     709                 :           5 : std::string SQLiteDatabaseVersion()
     710                 :             : {
     711                 :           5 :     return std::string(sqlite3_libversion());
     712                 :             : }
     713                 :             : } // namespace wallet
        

Generated by: LCOV version 2.0-1