From 59392e460020447720089976b83139ad59d275fe Mon Sep 17 00:00:00 2001
From: Thomas Lange <code@nerdmind.de>
Date: Thu, 22 Jul 2021 14:00:12 +0200
Subject: Rename: Append "Repository" to repository classes

Rename the repository classes and append the name with "Repository" to
prevent naming confusions with the entity classes.
---
 core/namespace/ORM/Repositories/UserRepository.php | 35 ++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 core/namespace/ORM/Repositories/UserRepository.php

(limited to 'core/namespace/ORM/Repositories/UserRepository.php')

diff --git a/core/namespace/ORM/Repositories/UserRepository.php b/core/namespace/ORM/Repositories/UserRepository.php
new file mode 100644
index 0000000..a0e58c6
--- /dev/null
+++ b/core/namespace/ORM/Repositories/UserRepository.php
@@ -0,0 +1,35 @@
+<?php
+namespace ORM\Repositories;
+use ORM\Repository;
+use ORM\Entities\User;
+
+class UserRepository extends Repository {
+	public static function getTableName(): string { return 'user'; }
+	public static function getClassName(): string { return 'ORM\Entities\User'; }
+
+	#===============================================================================
+	# Get number of *pages* assigned to $User
+	#===============================================================================
+	public function getNumberOfPages(User $User): int {
+		$query = 'SELECT COUNT(id) FROM %s WHERE user = ?';
+		$query = sprintf($query, PageRepository::getTableName());
+
+		$Statement = $this->Database->prepare($query);
+		$Statement->execute([$User->getID()]);
+
+		return $Statement->fetchColumn();
+	}
+
+	#===============================================================================
+	# Get number of *posts* assigned to $User
+	#===============================================================================
+	public function getNumberOfPosts(User $User): int {
+		$query = 'SELECT COUNT(id) FROM %s WHERE user = ?';
+		$query = sprintf($query, PostRepository::getTableName());
+
+		$Statement = $this->Database->prepare($query);
+		$Statement->execute([$User->getID()]);
+
+		return $Statement->fetchColumn();
+	}
+}
-- 
cgit v1.2.3