/*
 *openPilotLog - A FOSS Pilot Logbook Application
 *Copyright (C) 2020-2022 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 DBSETUP_H
#define DBSETUP_H

#include <QCoreApplication>
#include <QStringBuilder>
#include <QEventLoop>

#define DATABASE_REVISION 17

const auto TEMPLATE_URL = QStringLiteral("https://raw.githubusercontent.com/fiffty-50/openpilotlog/develop/assets/database/templates/");


/*!
 * \brief The DataBaseSetup class is responsible for the inital setup of the database when
 * the application is first launched. It creates the database in the specified default
 * location and creates all required tables and views. It can also be used to reset the
 * database currently used
 */
class DataBaseSetup
{
public:
    static void debug();

    static bool createDatabase();

    static bool downloadTemplates();

    static bool backupOldData();

    static bool fillTemplates();

    static bool importDefaultData(bool use_local_data);

    static bool resetToDefault();

    static bool commitData(QVector<QStringList> from_csv, const QString &table_name);

    /*!
     * \brief commitDataJson Commits data read from a JSON array to the database.
     * \param json_arr
     * \param table_name The table that will be written to
     */
    static bool commitDataJson(const QJsonArray &json_arr, const QString &table_name);

private:

    static bool createSchemata(const QStringList &statements);


};

#endif // DBSETUP_H