db.h

/*
 *openPilot Log - A FOSS Pilot Logbook Application
 *Copyright (C) 2020  Felix Turowsky
 *
 *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 <https://www.gnu.org/licenses/>.
 */
#ifndef DB_H
#define DB_H
 
#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlDriver>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QSqlField>
#include <QDir>
#include <QDebug>
 
class Db
{
    public:
        static Db& get()
        {
            static Db instance;
 
            return instance;
        }
        enum editRole {createNew, editExisting};
        enum matchType {exactMatch, partialMatch};       
        static void             connect(){get().iconnect();}
        static void             disconnect(){get().idisconnect();}
 
        static QSqlDatabase     Database(){return get().iDatabase();}
 
        static bool             exists(QString column, QString table, QString checkColumn,
                                       QString value, Db::matchType match)
        {
            return get().iexists(column, table, checkColumn, value, match);
        }
        static bool             singleUpdate(QString table, QString column, QString value,
                                             QString checkColumn, QString checkvalue, Db::matchType match){
            return get().isingleUpdate(table,column,value,checkColumn,checkvalue,match);
        }
        static QString          singleSelect(QString column, QString table, QString checkColumn,
                                             QString value, Db::matchType match){
            return get().isingleSelect(column,table,checkColumn,value,match);
        }
        static QVector<QString> multiSelect(QVector<QString> columns, QString table,
                                            QString checkColumn, QString value, Db::matchType match){
            return get().imultiSelect(columns,table,checkColumn,value,match);
        }
        static QVector<QString> multiSelect(QVector<QString> columns, QString table){
            return get().imultiSelect(columns, table);
        }
        static QVector<QString> customQuery(QString query, int returnValues){
            return get().icustomQuery(query, returnValues);
        }
 
    private:
        Db() {}
        void             iconnect();
        void             idisconnect();
        QSqlDatabase     iDatabase();
        bool             iexists(QString column, QString table, QString checkColumn,
                                       QString value, Db::matchType match);
        bool             isingleUpdate(QString table, QString column, QString value,
                                             QString checkColumn, QString checkvalue, Db::matchType match);
        QString          isingleSelect(QString column, QString table, QString checkColumn,
                                             QString value, Db::matchType match);
        QVector<QString> imultiSelect(QVector<QString> columns, QString table,
                                            QString checkColumn, QString value, Db::matchType match);
        QVector<QString> imultiSelect(QVector<QString> columns, QString table);
        QVector<QString> icustomQuery(QString query, int returnValues);
 
    public:
        // [George]: Why delete these in particular?
        Db(Db const&)              = delete;
        void operator=(Db const&)  = delete;
};
 
#endif // DB_H