Implement new Repository and Entity classes

This commit adds new Repository and Entity classes which are better
abstracted from the rest of the application. They dont know anymore
about configuration options or how to parse to HTML because this is
not the job for the ORM but for other parts of the application.

The previous commits were a preparation for this big change.

An entity now represents just a single record from a specific table
of the database – nothing more. The repositories job is it to fetch
or update records of the database and instantiate the entities.

Another problem that was solved is the high amount of database queries
that was needed before. For example, on the blogs home page first were
all 10 latest post IDs fetched from the database and then another query
was executed with "WHERE id = :id" for *each* single post?! ...

This problem is solved with the new repository classes; they now use a
single query to fetch and build the entities of the 10 latest posts.

This change also solves the problem with database queries spread across
the application and limits the exzessive use of try/catch blocks which
were used before. The new classes make the whole code much cleaner. :)

5 files changed, 141 insertions, 128 deletions

diff --git a/admin/page/delete.php b/admin/page/delete.php
index e1c95f0..2465f62 100644
--- a/admin/page/delete.php
+++ b/admin/page/delete.php
@@ -11,46 +11,46 @@ define('AUTHENTICATION', TRUE);
 require '../../core/application.php';
 
 #===============================================================================
-# TRY: Page\Exception
+# Get repositories
 #===============================================================================
-try {
-	$Page = Page\Factory::build(HTTP::GET('id'));
-	$Attribute = $Page->getAttribute();
+$PageRepository = Application::getRepository('Page');
 
-	if(HTTP::issetPOST(['token' => Application::getSecurityToken()], 'delete')) {
-		try {
-			if($Attribute->delete($Database)) {
-				HTTP::redirect(Application::getAdminURL('page/'));
-			}
-		} catch(PDOException $Exception) {
-			$messages[] = $Exception->getMessage();
+#===============================================================================
+# Throw 404 error if page could not be found
+#===============================================================================
+if(!$Page = $PageRepository->find(HTTP::GET('id'))) {
+	Application::error404();
+}
+
+#===============================================================================
+# Check for delete request
+#===============================================================================
+if(HTTP::issetPOST(['token' => Application::getSecurityToken()], 'delete')) {
+	try {
+		if($PageRepository->delete($Page)) {
+			HTTP::redirect(Application::getAdminURL('page/'));
 		}
+	} catch(PDOException $Exception) {
+		$messages[] = $Exception->getMessage();
 	}
-
-	#===============================================================================
-	# Build document
-	#===============================================================================
-	$FormTemplate = Template\Factory::build('page/form');
-	$FormTemplate->set('HTML', parseEntityContent($Page));
-	$FormTemplate->set('FORM', [
-		'TYPE' => 'DELETE',
-		'INFO' => $messages ?? [],
-		'DATA' => array_change_key_case($Attribute->getAll(), CASE_UPPER),
-		'TOKEN' => Application::getSecurityToken()
-	]);
-
-	$DeleteTemplate = Template\Factory::build('page/delete');
-	$DeleteTemplate->set('HTML', $FormTemplate);
-
-	$MainTemplate = Template\Factory::build('main');
-	$MainTemplate->set('NAME', $Language->text('title_page_delete'));
-	$MainTemplate->set('HTML', $DeleteTemplate);
-	echo $MainTemplate;
 }
 
 #===============================================================================
-# CATCH: Page\Exception
+# Build document
 #===============================================================================
-catch(Page\Exception $Exception) {
-	Application::error404();
-}
+$FormTemplate = Template\Factory::build('page/form');
+$FormTemplate->set('HTML', parseEntityContent($Page));
+$FormTemplate->set('FORM', [
+	'TYPE' => 'DELETE',
+	'INFO' => $messages ?? [],
+	'DATA' => array_change_key_case($Page->getAll(), CASE_UPPER),
+	'TOKEN' => Application::getSecurityToken()
+]);
+
+$DeleteTemplate = Template\Factory::build('page/delete');
+$DeleteTemplate->set('HTML', $FormTemplate);
+
+$MainTemplate = Template\Factory::build('main');
+$MainTemplate->set('NAME', $Language->text('title_page_delete'));
+$MainTemplate->set('HTML', $DeleteTemplate);
+echo $MainTemplate;
diff --git a/admin/page/index.php b/admin/page/index.php
index 7527afa..63839a9 100644
--- a/admin/page/index.php
+++ b/admin/page/index.php
@@ -11,12 +11,19 @@ define('AUTHENTICATION', TRUE);
 require '../../core/application.php';
 
 #===============================================================================
+# Get repositories
+#===============================================================================
+$PageRepository = Application::getRepository('Page');
+$UserRepository = Application::getRepository('User');
+
+#===============================================================================
 # Pagination
 #===============================================================================
 $site_size = Application::get('ADMIN.PAGE.LIST_SIZE');
 $site_sort = Application::get('ADMIN.PAGE.LIST_SORT');
 
-$lastSite = ceil($Database->query(sprintf('SELECT COUNT(id) FROM %s', Page\Attribute::TABLE))->fetchColumn() / $site_size);
+$count = $PageRepository->getCount();
+$lastSite = ceil($count / $site_size);
 
 $currentSite = HTTP::GET('site') ?? 1;
 $currentSite = intval($currentSite);
@@ -26,19 +33,17 @@ if($currentSite < 1 OR ($currentSite > $lastSite AND $lastSite > 0)) {
 }
 
 #===============================================================================
-# Fetch page IDs from database
+# Get paginated page list
 #===============================================================================
-$execSQL = "SELECT id FROM %s ORDER BY {$site_sort} LIMIT ".(($currentSite-1) * $site_size).", {$site_size}";
-$pageIDs = $Database->query(sprintf($execSQL, Page\Attribute::TABLE))->fetchAll($Database::FETCH_COLUMN);
+$pages = $PageRepository->getPaginated(
+	$site_sort,
+	$site_size,
+	($currentSite-1) * $site_size
+);
 
-foreach($pageIDs as $pageID) {
-	try {
-		$Page = Page\Factory::build($pageID);
-		$User = User\Factory::build($Page->get('user'));
-		$templates[] = generatePageItemTemplate($Page, $User);
-	}
-	catch(Page\Exception $Exception){}
-	catch(User\Exception $Exception){}
+foreach($pages as $Page) {
+	$User = $UserRepository->find($Page->get('user'));
+	$templates[] = generatePageItemTemplate($Page, $User);
 }
 
 #===============================================================================
diff --git a/admin/page/insert.php b/admin/page/insert.php
index 1f9d391..6acfcfb 100644
--- a/admin/page/insert.php
+++ b/admin/page/insert.php
@@ -10,20 +10,32 @@ define('AUTHENTICATION', TRUE);
 #===============================================================================
 require '../../core/application.php';
 
-$Attribute = new Page\Attribute();
+#===============================================================================
+# Get repositories
+#===============================================================================
+$PageRepository = Application::getRepository('Page');
+$UserRepository = Application::getRepository('User');
+
+#===============================================================================
+# Instantiate new Page entity
+#===============================================================================
+$Page = new Page\Entity;
 
+#===============================================================================
+# Check for insert request
+#===============================================================================
 if(HTTP::issetPOST('user', 'slug', 'name', 'body', 'argv', 'time_insert', 'time_update', 'insert')) {
-	$Attribute->set('user', HTTP::POST('user'));
-	$Attribute->set('slug', HTTP::POST('slug') ? HTTP::POST('slug') : generateSlug(HTTP::POST('name')));
-	$Attribute->set('name', HTTP::POST('name') ? HTTP::POST('name') : NULL);
-	$Attribute->set('body', HTTP::POST('body') ? HTTP::POST('body') : NULL);
-	$Attribute->set('argv', HTTP::POST('argv') ? HTTP::POST('argv') : NULL);
-	$Attribute->set('time_insert', HTTP::POST('time_insert') ?: date('Y-m-d H:i:s'));
-	$Attribute->set('time_update', HTTP::POST('time_update') ?: date('Y-m-d H:i:s'));
+	$Page->set('user', HTTP::POST('user'));
+	$Page->set('slug', HTTP::POST('slug') ? HTTP::POST('slug') : generateSlug(HTTP::POST('name')));
+	$Page->set('name', HTTP::POST('name') ? HTTP::POST('name') : NULL);
+	$Page->set('body', HTTP::POST('body') ? HTTP::POST('body') : NULL);
+	$Page->set('argv', HTTP::POST('argv') ? HTTP::POST('argv') : NULL);
+	$Page->set('time_insert', HTTP::POST('time_insert') ?: date('Y-m-d H:i:s'));
+	$Page->set('time_update', HTTP::POST('time_update') ?: date('Y-m-d H:i:s'));
 
 	if(HTTP::issetPOST(['token' => Application::getSecurityToken()])) {
 		try {
-			if($Attribute->insert($Database)) {
+			if($PageRepository->insert($Page)) {
 				HTTP::redirect(Application::getAdminURL('page/'));
 			}
 		} catch(PDOException $Exception) {
@@ -36,12 +48,12 @@ if(HTTP::issetPOST('user', 'slug', 'name', 'body', 'argv', 'time_insert', 'time_
 	}
 }
 
-$userIDs = $Database->query(sprintf('SELECT id FROM %s ORDER BY fullname ASC', User\Attribute::TABLE));
-
-foreach($userIDs->fetchAll($Database::FETCH_COLUMN) as $userID) {
-	$User = User\Factory::build($userID);
-	$userAttributes[] = [
-		'ID' => $User->get('id'),
+#===============================================================================
+# Generate user list
+#===============================================================================
+foreach($UserRepository->getAll([], 'fullname ASC') as $User) {
+	$userList[] = [
+		'ID' => $User->getID(),
 		'FULLNAME' => $User->get('fullname'),
 		'USERNAME' => $User->get('username'),
 	];
@@ -54,8 +66,8 @@ $FormTemplate = Template\Factory::build('page/form');
 $FormTemplate->set('FORM', [
 	'TYPE' => 'INSERT',
 	'INFO' => $messages ?? [],
-	'DATA' => array_change_key_case($Attribute->getAll(), CASE_UPPER),
-	'USER_LIST' => $userAttributes ??  [],
+	'DATA' => array_change_key_case($Page->getAll(), CASE_UPPER),
+	'USER_LIST' => $userList ??  [],
 	'TOKEN' => Application::getSecurityToken()
 ]);
 
diff --git a/admin/page/search.php b/admin/page/search.php
index 7d879f4..b74615f 100644
--- a/admin/page/search.php
+++ b/admin/page/search.php
@@ -11,20 +11,15 @@ define('AUTHENTICATION', TRUE);
 require '../../core/application.php';
 
 #===============================================================================
-# IF: Handle search request
+# Check for search request
 #===============================================================================
 if($search = HTTP::GET('q')) {
-	if($pageIDs = Page\Item::getSearchResultIDs($search, $Database)) {
-		foreach($pageIDs as $pageID) {
-			try {
-				$Page = Page\Factory::build($pageID);
-				$User = User\Factory::build($Page->get('user'));
+	$PageRepository = Application::getRepository('Page');
+	$UserRepository = Application::getRepository('User');
 
-				$templates[] = generatePageItemTemplate($Page, $User);
-			}
-			catch(Page\Exception $Exception){}
-			catch(User\Exception $Exception){}
-		}
+	foreach($PageRepository->search($search) as $Page) {
+		$User = $UserRepository->find($Page->get('user'));
+		$templates[] = generatePageItemTemplate($Page, $User);
 	}
 }
 
diff --git a/admin/page/update.php b/admin/page/update.php
index 5e54b03..2db0bc1 100644
--- a/admin/page/update.php
+++ b/admin/page/update.php
@@ -11,69 +11,70 @@ define('AUTHENTICATION', TRUE);
 require '../../core/application.php';
 
 #===============================================================================
-# TRY: Page\Exception
+# Get repositories
 #===============================================================================
-try {
-	$Page = Page\Factory::build(HTTP::GET('id'));
-	$Attribute = $Page->getAttribute();
+$PageRepository = Application::getRepository('Page');
+$UserRepository = Application::getRepository('User');
 
-	if(HTTP::issetPOST('user', 'slug', 'name', 'body', 'argv', 'time_insert', 'time_update', 'update')) {
-		$Attribute->set('user', HTTP::POST('user'));
-		$Attribute->set('slug', HTTP::POST('slug') ? HTTP::POST('slug') : generateSlug(HTTP::POST('name')));
-		$Attribute->set('name', HTTP::POST('name') ? HTTP::POST('name') : NULL);
-		$Attribute->set('body', HTTP::POST('body') ? HTTP::POST('body') : NULL);
-		$Attribute->set('argv', HTTP::POST('argv') ? HTTP::POST('argv') : NULL);
-		$Attribute->set('time_insert', HTTP::POST('time_insert') ?: date('Y-m-d H:i:s'));
-		$Attribute->set('time_update', HTTP::POST('time_update') ?: date('Y-m-d H:i:s'));
+#===============================================================================
+# Throw 404 error if page could not be found
+#===============================================================================
+if(!$Page = $PageRepository->find(HTTP::GET('id'))) {
+	Application::error404();
+}
 
-		if(HTTP::issetPOST(['token' => Application::getSecurityToken()])) {
-			try {
-				$Attribute->update($Database);
-			} catch(PDOException $Exception) {
-				$messages[] = $Exception->getMessage();
-			}
-		}
+#===============================================================================
+# Check for update request
+#===============================================================================
+if(HTTP::issetPOST('user', 'slug', 'name', 'body', 'argv', 'time_insert', 'time_update', 'update')) {
+	$Page->set('user', HTTP::POST('user'));
+	$Page->set('slug', HTTP::POST('slug') ? HTTP::POST('slug') : generateSlug(HTTP::POST('name')));
+	$Page->set('name', HTTP::POST('name') ? HTTP::POST('name') : NULL);
+	$Page->set('body', HTTP::POST('body') ? HTTP::POST('body') : NULL);
+	$Page->set('argv', HTTP::POST('argv') ? HTTP::POST('argv') : NULL);
+	$Page->set('time_insert', HTTP::POST('time_insert') ?: date('Y-m-d H:i:s'));
+	$Page->set('time_update', HTTP::POST('time_update') ?: date('Y-m-d H:i:s'));
 
-		else {
-			$messages[] = $Language->text('error_security_csrf');
+	if(HTTP::issetPOST(['token' => Application::getSecurityToken()])) {
+		try {
+			$PageRepository->update($Page);
+		} catch(PDOException $Exception) {
+			$messages[] = $Exception->getMessage();
 		}
 	}
 
-	$userIDs = $Database->query(sprintf('SELECT id FROM %s ORDER BY fullname ASC', User\Attribute::TABLE));
-
-	foreach($userIDs->fetchAll($Database::FETCH_COLUMN) as $userID) {
-		$User = User\Factory::build($userID);
-		$userAttributes[] = [
-			'ID' => $User->get('id'),
-			'FULLNAME' => $User->get('fullname'),
-			'USERNAME' => $User->get('username'),
-		];
+	else {
+		$messages[] = $Language->text('error_security_csrf');
 	}
-
-	#===============================================================================
-	# Build document
-	#===============================================================================
-	$FormTemplate = Template\Factory::build('page/form');
-	$FormTemplate->set('FORM', [
-		'TYPE' => 'UPDATE',
-		'INFO' => $messages ?? [],
-		'DATA' => array_change_key_case($Attribute->getAll(), CASE_UPPER),
-		'USER_LIST' => $userAttributes ??  [],
-		'TOKEN' => Application::getSecurityToken()
-	]);
-
-	$PageUpdateTemplate = Template\Factory::build('page/update');
-	$PageUpdateTemplate->set('HTML', $FormTemplate);
-
-	$MainTemplate = Template\Factory::build('main');
-	$MainTemplate->set('NAME', $Language->text('title_page_update'));
-	$MainTemplate->set('HTML', $PageUpdateTemplate);
-	echo $MainTemplate;
 }
 
 #===============================================================================
-# CATCH: Page\Exception
+# Generate user list
 #===============================================================================
-catch(Page\Exception $Exception) {
-	Application::error404();
+foreach($UserRepository->getAll([], 'fullname ASC') as $User) {
+	$userList[] = [
+		'ID' => $User->getID(),
+		'FULLNAME' => $User->get('fullname'),
+		'USERNAME' => $User->get('username'),
+	];
 }
+
+#===============================================================================
+# Build document
+#===============================================================================
+$FormTemplate = Template\Factory::build('page/form');
+$FormTemplate->set('FORM', [
+	'TYPE' => 'UPDATE',
+	'INFO' => $messages ?? [],
+	'DATA' => array_change_key_case($Page->getAll(), CASE_UPPER),
+	'USER_LIST' => $userList ??  [],
+	'TOKEN' => Application::getSecurityToken()
+]);
+
+$PageUpdateTemplate = Template\Factory::build('page/update');
+$PageUpdateTemplate->set('HTML', $FormTemplate);
+
+$MainTemplate = Template\Factory::build('main');
+$MainTemplate->set('NAME', $Language->text('title_page_update'));
+$MainTemplate->set('HTML', $PageUpdateTemplate);
+echo $MainTemplate;