openPilotLog/dbstat.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 DBSTAT_H
#define DBSTAT_H

#include <QCoreApplication>
#include <QDate>
#include <QSqlQuery>
#include <QSqlError>
#include <QDebug>


/*!
 * \brief The dbStat class provides functionality for retreiving various statistics
 * from the database. In general, most values are provided as either QString or
 * QVector<QString>.
 *
 */
class dbStat
{
public:

    static QString retreiveTotalTime();

    static QString retreiveTotalTimeThisCalendarYear();

    static QString retreiveTotalTimeRollingYear();

    static QVector<QString> retreiveCurrencyTakeoffLanding();
};

#endif // DBSTAT_H