sqlitedatabase.h

Go to the documentation of this file.

/*
 * LibrePCB - Professional EDA for everyone!
 * Copyright (C) 2013 LibrePCB Developers, see AUTHORS.md for contributors.
 * https://librepcb.org/
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

#ifndef LIBREPCB_CORE_SQLITEDATABASE_H
#define LIBREPCB_CORE_SQLITEDATABASE_H

/*******************************************************************************
 *  Includes
 ******************************************************************************/
#include "fileio/filepath.h"

#include <QtCore>
#include <QtSql>

/*******************************************************************************
 *  Namespace / Forward Declarations
 ******************************************************************************/
namespace librepcb {

/*******************************************************************************
 *  Class SQLiteDatabase
 ******************************************************************************/

class SQLiteDatabase final : public QObject {
  Q_OBJECT

public:
  // Types
  typedef QVector<std::pair<QString, QString>> Replacements;
  class TransactionScopeGuard final {
  public:
    TransactionScopeGuard() = delete;
    TransactionScopeGuard(const TransactionScopeGuard& other) = delete;
    TransactionScopeGuard(SQLiteDatabase& db);
    ~TransactionScopeGuard() noexcept;
    void commit();
    TransactionScopeGuard& operator=(const TransactionScopeGuard& rhs) = delete;

  private:
    SQLiteDatabase& mDb;
    bool mIsCommited;
  };

  // Constructors / Destructor
  SQLiteDatabase() = delete;
  SQLiteDatabase(const SQLiteDatabase& other) = delete;
  SQLiteDatabase(const FilePath& filepath, QObject* parent = nullptr);
  ~SQLiteDatabase() noexcept;

  // SQL Commands
  void beginTransaction();
  void commitTransaction();
  void rollbackTransaction();
  void clearTable(const QString& table);

  // General Methods
  QSqlQuery prepareQuery(QString query,
                         const Replacements& replacements = {}) const;
  int count(QSqlQuery& query);
  int insert(QSqlQuery& query);
  void exec(QSqlQuery& query);
  void exec(const QString& query);

  // Operator Overloadings
  SQLiteDatabase& operator=(const SQLiteDatabase& rhs) = delete;

private:  // Methods
  void enableSqliteWriteAheadLogging();

  QHash<QString, QString> getSqliteCompileOptions();

private:  // Data
  QSqlDatabase mDb;
};

/*******************************************************************************
 *  End of File
 ******************************************************************************/

}  // namespace librepcb

#endif