FlightLogStorage.h

/***************************************************************************
 *   Copyright (C) 2026 by Stefan Kebekus                                  *
 *   stefan.kebekus@gmail.com                                              *
 *                                                                         *
 *   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, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/
 
#pragma once
 
#include <QObject>
#include <QSqlQuery>
#include <QStandardPaths>
 
#include "flightlog/Flight.h"
 
using namespace Qt::Literals::StringLiterals;
 
namespace Flightlog {

class FlightLogStorage : public QObject
{
    Q_OBJECT
 
public:
    explicit FlightLogStorage(QObject* parent);

    ~FlightLogStorage() override;

    [[nodiscard]] auto loadAll() -> QList<Flight>;

    bool upsert(const Flight& flight);

    bool upsertMany(const QList<Flight>& flights);

    bool remove(const QUuid& uuid);

    bool removeMany(const QList<QUuid>& uuids);

    bool removeAll();
 
signals:
    void saveError(const QString& message);
 
private:
    Q_DISABLE_COPY_MOVE(FlightLogStorage)
 
    // Open the database connection and ensure the schema exists
    void openDatabase();
 
    // Rename a corrupt file aside with a timestamp suffix and report the error
    void quarantineFile(const QString& fileName, const QString& reason);
 
    // Emit saveError() via a queued connection, safe to call from the constructor.
    // Const so it can also be called from loadAll(); emitting a signal doesn't
    // change any observable state of this object.
    void reportError(const QString& message);
 
    // Bind all fields of a flight to a prepared INSERT query, in column order
    static void bindFlight(QSqlQuery& query, const Flight& flight);
 
    QString m_databaseConnectionName;
 
    const QString m_dbFileName {QStandardPaths::writableLocation(QStandardPaths::AppDataLocation) + u"/userdata.db"_s};
};
 
} // namespace Flightlog