Fix crash on load entries

- TODO format time properly
- TODO add Purchases table visualization

1 files changed, 55 insertions, 0 deletions

diff --git a/core/src/Model/TransactionsModel.hpp b/core/src/Model/TransactionsModel.hpp
new file mode 100644
index 0000000..beed663
--- /dev/null
+++ b/core/src/Model/TransactionsModel.hpp
@@ -0,0 +1,55 @@
+#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(TransactionModel& db);
+};
+
+class PurchasesTable {
+public:
+	PurchasesTable(TransactionModel& db);
+};
+
+class DeliveryTable {
+public:
+	DeliveryTable(TransactionModel& db);
+};
+
+// TODO fuck SQLite::Statement has move ctor but not move assignment operator
+class TransactionModel {
+private:
+	class DatabaseWrapper {
+	public:
+		SQLite::Database mSqlite;
+		DatabaseWrapper(TransactionModel& self);
+	};
+
+	Project* mProject;
+	DatabaseWrapper mDbWrapper;
+	SalesTable mSales;
+	PurchasesTable mPurchases;
+	DeliveryTable mDeliveries;
+
+public:
+	TransactionModel(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();
+};