QGCSqlHelper.h

Go to the documentation of this file.

#pragma once
 
#include <QtCore/QString>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
 
#include <atomic>
#include <optional>
 
namespace QGCSqlHelper {
 
// ── LIKE wildcard escaping ─────────────────────────────────────────────
[[nodiscard]] QString escapeLikePattern(const QString& text);
 
// ── Bound-parameter placeholders ───────────────────────────────────────
[[nodiscard]] QString placeholders(int n);
 
// ── SQLite PRAGMA helpers ──────────────────────────────────────────────
void applySqlitePragmas(QSqlDatabase& db);
 
[[nodiscard]] std::optional<int> userVersion(QSqlDatabase& db);
[[nodiscard]] bool setUserVersion(QSqlDatabase& db, int v);
 
// ── Scoped connection RAII ─────────────────────────────────────────────
class ScopedConnection
{
public:
    explicit ScopedConnection(const QString& dbPath, bool readOnly = false,
                              const QString& prefix = QStringLiteral("QGCSql"));
    ~ScopedConnection();
 
    ScopedConnection(const ScopedConnection&) = delete;
    ScopedConnection& operator=(const ScopedConnection&) = delete;
    ScopedConnection(ScopedConnection&&) = delete;
    ScopedConnection& operator=(ScopedConnection&&) = delete;
 
    [[nodiscard]] bool isValid() const { return _valid; }
    [[nodiscard]] QSqlDatabase database() const;
 
private:
    QString _connName;
    bool _valid = false;
 
    static std::atomic<int> s_connId;
};
 
// ── Transaction RAII ───────────────────────────────────────────────────
class Transaction
{
public:
    explicit Transaction(QSqlDatabase db);
    ~Transaction();
 
    Transaction(const Transaction&) = delete;
    Transaction& operator=(const Transaction&) = delete;
    Transaction(Transaction&&) = delete;
    Transaction& operator=(Transaction&&) = delete;
 
    [[nodiscard]] bool ok() const { return _active; }
    bool commit();
 
private:
    QSqlDatabase _db;
    bool _active = false;
    bool _committed = false;
};
 
} // namespace QGCSqlHelper