blob: 7d6509b25a4c269b1a2f0532e391a3ed91ede98e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
#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();
};
|
