openPilotLog/dbpilots.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 DBPILOTS_H
#define DBPILOTS_H

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

/*!
 * \brief The dbPilots class class provides a databank interface for actions related to the
 * pilots table.
 */
class dbPilots
{
public:

    static QString retreivePilotNameFromID(QString pilotID);

    static QString retreivePilotIdFromString(QString lastname, QString firstname);

    static QStringList retreivePilotNameFromString(QString searchstring);

    static QStringList newPicGetString(QString searchstring); //deprecated

    static QStringList retreivePilotList();

    static QString newPicGetId(QString name);
};

#endif // DBPILOTS_H