humbledb.h

#ifndef HUMBLEDB_H
#define HUMBLEDB_H

#include <QObject>
#include <QSqlDatabase>
#include <QSqlDriver>
#include "db/purchase.h"
#include "db/product.h"
#include "db/download.h"
#include "db/file.h"
#include <QList>
#include "db/customquerymodel.h"
#include <QSortFilterProxyModel>

class HumbleDB : public QObject
{
    Q_OBJECT
public:
    explicit HumbleDB(QObject *parent = nullptr);
    const QString databaseName = "qhumble";
    void clearDB();
    int addPurchase(Purchase purchase);
    int addProduct(Product product);
    int addDownload(Download download);
    int addFile(File file);
    void updatePurchase(Purchase purchase);
    void updateProduct(Product product);
    void updateDownload(Download download);
    int getPurchaseCount();
    int purchaseExists(Purchase purchase);
    int productExists(Product product);
    int downloadExists(Download download);
    void eraseFilesForDownload(int download);
    QSqlQueryModel *getPurchaseModel();
    QSqlQueryModel *getProductModel(int purchaseId);
    QSqlQueryModel *getProductPlatforms(int product);
    QSqlQueryModel *getDownloadModel(int product);
    QSqlQueryModel *getFileModel(int download);
    QSortFilterProxyModel *getFilterablePurchaseModel();

signals:
    void dbCleared();
    void newDBEntry();
public slots:

private:
};

#endif // HUMBLEDB_H