#pragma once

#include "cplt_fwd.hpp"

#include <SQLiteCpp/Database.h>
#include <SQLiteCpp/Statement.h>
#include <cstdint>

class SalesTable {
public:
	SQLite::Statement GetRowsStatement;
	SQLite::Statement FilterRowsStatement;

public:
	SalesTable(TransactionDatabase& db);

	int GetEntryCont() const;
};

class PurchasesTable {
public:
	PurchasesTable(TransactionDatabase& db);
};

class DeliveryTable {
public:
	DeliveryTable(TransactionDatabase& db);
};

class TransactionDatabase {
private:
	Project* mProject;
	SQLite::Database mDb;
	SalesTable mSales;
	PurchasesTable mPurchases;
	DeliveryTable mDeliveries;

public:
	TransactionDatabase(Project& project);

	const SQLite::Database& GetSQLite() const;
	SQLite::Database& GetSQLite();

	const SalesTable& GetSales() const;
	SalesTable& GetSales();
	const PurchasesTable& GetPurchases() const;
	PurchasesTable& GetPurchases();
	const DeliveryTable& GetDeliveries() const;
	DeliveryTable& GetDeliveries()
};