QGCSqlHelper.h

Go to the documentation of this file.

#pragma once
 
#include <QtCore/QString>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
 
#include <atomic>
 
namespace QGCSqlHelper {
 
// ── LIKE wildcard escaping ─────────────────────────────────────────────
[[nodiscard]] QString escapeLikePattern(const QString& text);
 
// ── SQLite PRAGMA helpers ──────────────────────────────────────────────
void applySqlitePragmas(QSqlDatabase& db);
 
// ── Scoped connection RAII ─────────────────────────────────────────────
class ScopedConnection
{
public:
    explicit ScopedConnection(const QString& dbPath, bool readOnly = false);
    ~ScopedConnection();
 
    ScopedConnection(const ScopedConnection&) = delete;
    ScopedConnection& operator=(const ScopedConnection&) = delete;
 
    [[nodiscard]] bool isValid() const { return _valid; }
    [[nodiscard]] QSqlDatabase database() const;
 
private:
    QString _connName;
    bool _valid = false;
 
    static std::atomic<int> s_connId;
};
 
} // namespace QGCSqlHelper