From 18677f1e23ac097d859cde1030ce6149585f5574 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen@syndamia.com>
Date: Sun, 26 Jan 2025 18:52:57 +0200
Subject: feat(models): Implement model for ArchiveList

---
 models/archivelist.php | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 models/archivelist.php

(limited to 'models')

diff --git a/models/archivelist.php b/models/archivelist.php
new file mode 100644
index 0000000..3723419
--- /dev/null
+++ b/models/archivelist.php
@@ -0,0 +1,33 @@
+<?php
+namespace Database;
+use PDO;
+
+class ArchiveList extends Table {
+    public $LID;
+    public $AuthorUID;
+    public $Name;
+    public $Description;
+
+    static function create(int $AuthorUID, string $Name, string $Description) : int {
+        return Table::_create(
+            'ArchiveLists',
+            '(AuthorUID, Name, Description)',
+            "(\"$AuthorUID\", \"$Name\", \"$Description\")"
+        );
+    }
+
+    static function fromDB(int $LID) : ArchiveList {
+        return Table::_fromDB(
+            "SELECT * FROM ArchiveLists WHERE LID = \"$LID\"",
+            'Database\ArchiveLists'
+        );
+    }
+
+    static function allListsByUser(int $UID) : array {
+        return Table::_get_all(
+            'ArchiveLists',
+            'Database\ArchiveLists',
+            "WHERE AuthorUID = \"$UID\""
+        );
+    }
+}
-- 
cgit v1.2.3