From 7fe47a9d5b1727a61dc724523b530762f6d6ba19 Mon Sep 17 00:00:00 2001
From: rtk0c <mail.tianyig@gmail.com>
Date: Thu, 30 Jun 2022 21:38:53 -0700
Subject: Restructure project

---
 app/source/Cplt/Model/Database.hpp | 79 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 79 insertions(+)
 create mode 100644 app/source/Cplt/Model/Database.hpp

(limited to 'app/source/Cplt/Model/Database.hpp')

diff --git a/app/source/Cplt/Model/Database.hpp b/app/source/Cplt/Model/Database.hpp
new file mode 100644
index 0000000..222e43d
--- /dev/null
+++ b/app/source/Cplt/Model/Database.hpp
@@ -0,0 +1,79 @@
+#pragma once
+
+#include <Cplt/fwd.hpp>
+
+#include <SQLiteCpp/Database.h>
+#include <SQLiteCpp/Statement.h>
+#include <cstdint>
+
+enum class TableKind
+{
+	Sales,
+	SalesItems,
+	Purchases,
+	PurchasesItems,
+	Deliveries,
+	DeliveriesItems,
+};
+
+class SalesTable
+{
+public:
+	SQLite::Statement GetRowCount;
+	SQLite::Statement GetRows;
+	SQLite::Statement GetItems;
+
+public:
+	SalesTable(MainDatabase& db);
+};
+
+class PurchasesTable
+{
+public:
+	SQLite::Statement GetRowCount;
+	SQLite::Statement GetRows;
+	SQLite::Statement GetItems;
+
+public:
+	PurchasesTable(MainDatabase& db);
+};
+
+class DeliveryTable
+{
+public:
+	SQLite::Statement FilterByTypeAndId;
+	SQLite::Statement GetItems;
+
+public:
+	DeliveryTable(MainDatabase& db);
+};
+
+class MainDatabase
+{
+private:
+	class DatabaseWrapper
+	{
+	public:
+		SQLite::Database mSqlite;
+		DatabaseWrapper(MainDatabase& self);
+	};
+
+	Project* mProject;
+	DatabaseWrapper mDbWrapper;
+	SalesTable mSales;
+	PurchasesTable mPurchases;
+	DeliveryTable mDeliveries;
+
+public:
+	MainDatabase(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();
+};
-- 
cgit v1.2.3-70-g09d2