2 files changed, 10 insertions, 2 deletions
diff --git a/core/src/Model/TransactionsModel.cpp b/core/src/Model/TransactionsModel.cpp
index 968f0c0..914191d 100644
--- a/core/src/Model/TransactionsModel.cpp
+++ b/core/src/Model/TransactionsModel.cpp
@@ -18,10 +18,14 @@ SalesTable::SalesTable(TransactionModel& db)
 )""") {
 }
 
-DeliveryTable::DeliveryTable(TransactionModel& db) {
+PurchasesTable::PurchasesTable(TransactionModel& db)
+	// language=SQLite
+	: GetRowCountStatement(db.GetSQLite(), "SELECT Count(*) FROM Purchases")
+	// language=SQLite
+	, GetRowsStatement(db.GetSQLite(), "SELECT * FROM Purchases WHERE rowid >= ? AND rowid < ?") {
 }
 
-PurchasesTable::PurchasesTable(TransactionModel& db) {
+DeliveryTable::DeliveryTable(TransactionModel& db) {
 }
 
 static std::string GetDatabaseFilePath(const Project& project) {
diff --git a/core/src/Model/TransactionsModel.hpp b/core/src/Model/TransactionsModel.hpp
index 117c27a..7a71fca 100644
--- a/core/src/Model/TransactionsModel.hpp
+++ b/core/src/Model/TransactionsModel.hpp
@@ -18,6 +18,10 @@ public:
 
 class PurchasesTable {
 public:
+	SQLite::Statement GetRowCountStatement;
+	SQLite::Statement GetRowsStatement;
+
+public:
 	PurchasesTable(TransactionModel& db);
 };