implement notes

7 files changed, 201 insertions, 10 deletions

diff --git a/WpfTest/Model.php b/WpfTest/Model.php
index 26a7b49..c006ffd 100644
--- a/WpfTest/Model.php
+++ b/WpfTest/Model.php
@@ -3,8 +3,6 @@ namespace WpfTest;
 
 abstract class Model {
     private static function mangleName(string $name): string {
-        if ($name == 'self')
-            return 'uri';
         $chars = str_split($name);
         $chars[0] = strtolower($chars[0]);
         for ($i = 0; $i < count($chars); $i++) {
@@ -17,8 +15,6 @@ abstract class Model {
     }
 
     private static function unmangleName(string $name): string {
-        if ($name == 'uri')
-            return 'self';
         $chars = str_split($name);
         for ($i = 0; $i < count($chars); $i++) {
             if ($chars[$i] == '_') {
@@ -41,32 +37,68 @@ abstract class Model {
     public static function fromDbRow(array|false $columns): ?static {
         if ($columns === false)
             return null;
+        // create the model
         $obj = new static();
         $refl = new \ReflectionObject($obj);
+        // for each field of the db row ...
         foreach (array_keys($columns) as $name) {
             $value = $columns[$name];
-            $name = self::unmangleName($name);
+            $name = self::unmangleName($name); // guess the appropriate field in the model
             try {
+                // try to assign it directly (works for simple values)
                 $obj->{$name} = $value;
             } catch (\TypeError $e) {
+                // if it's not the right type we have to try to wrangle it into the right one
+                // there's a few strategies for this
                 $type = $refl->getProperty($name)->getType();
                 if ($type == null || !is_a($type, \ReflectionNamedType::class))
                     throw $e;
-                $obj->{$name} = new ($type->getName())($value);
+                $typeClass = $type->getName();
+                if (enum_exists($typeClass)) {
+                    // if it's an enum we can find the enum case with the same name
+                    $obj->{$name} = (new \ReflectionEnum($typeClass))->getCase($value)->getValue();
+                } elseif (is_subclass_of($typeClass, Model::class) && is_int($value)) {
+                    // if it's another model we can try to look it up by id automatically
+                    $obj->{$name} = $typeClass::find($value);
+                } else {
+                    // otherwise try to instantiate the correct class and pass it the simple value
+                    $obj->{$name} = new $typeClass($value);
+                }
             }
         }
+        // set up any extra-complicated fields if needed
+        $obj->hydrate($columns);
         return $obj;
     }
 
+    /**
+     * Initialises fields of the model that contain more complex objects
+     * @param array $row the row of the database
+     * @return void
+     */
+    protected function hydrate(array $row) {
+    }
+
     public static function findWhere(string $whereClause, array $parameters): ?static {
         $classNameParts = explode('\\', static::class);
         $className = $classNameParts[count($classNameParts) - 1];
         $tableName = self::mangleName($className);
-        $stmt = Db::getInstance()->getPdo()->prepare("SELECT * FROM $tableName WHERE $whereClause");
+        $stmt = Db::getInstance()->getPdo()->prepare("SELECT * FROM $tableName WHERE $whereClause LIMIT 1");
         $stmt->execute($parameters);
         return static::fromDbRow($stmt->fetch(\PDO::FETCH_ASSOC));
     }
 
+    public static function findAllWhere(string $whereClause, array $parameters): array {
+        $classNameParts = explode('\\', static::class);
+        $className = $classNameParts[count($classNameParts) - 1];
+        $tableName = self::mangleName($className);
+        $stmt = Db::getInstance()->getPdo()->prepare("SELECT * FROM $tableName WHERE $whereClause");
+        $stmt->execute($parameters);
+        return array_map(function ($row) {
+            return static::fromDbRow($row);
+        }, $stmt->fetchAll(\PDO::FETCH_ASSOC));
+    }
+
     public static function find(int $id): ?static {
         return static::findWhere('id = ?', [$id]);
     }
diff --git a/WpfTest/Model/Actor.php b/WpfTest/Model/Actor.php
index cf8d7ca..eaef99c 100644
--- a/WpfTest/Model/Actor.php
+++ b/WpfTest/Model/Actor.php
@@ -3,9 +3,9 @@ namespace WpfTest\Model;
 
 use WpfTest\Model;
 
-class Actor extends Model {
-    public int $id;
-    public string $self;
+class Actor extends Model implements \JsonSerializable {
+    public ?int $id;
+    public string $uri;
     public bool $isLocal = false;
     public \DateTimeImmutable $created;
     public ?\DateTimeImmutable $modified;
@@ -23,4 +23,23 @@ class Actor extends Model {
     public static function findLocalByHandle(string $handle): ?self {
         return self::findWhere('is_local = true AND handle = ?', [$handle]);
     }
+
+    public function jsonSerialize(): array {
+        return [
+            'type' => 'actor',
+            'self' => path_to_uri("/user/$this->handle"),
+            'created' => $this->created?->format('c'),
+            'modified' => $this->modified?->format('c'),
+            'homepage' => path_to_uri("/$this->handle"),
+            'handle' => $this->handle,
+            'displayName' => $this->displayName,
+            'bio' => $this->bio,
+            'pronouns' => $this->pronouns,
+            'automated' => $this->automated,
+            'endpoints' => [
+                'basicFeed' => path_to_uri("/user/$this->handle/basicFeed"),
+                'fullFeed' => path_to_uri("/user/$this->handle/fullFeed")
+            ]
+        ];
+    }
 }
\ No newline at end of file
diff --git a/WpfTest/Model/Note.php b/WpfTest/Model/Note.php
new file mode 100644
index 0000000..85b3567
--- /dev/null
+++ b/WpfTest/Model/Note.php
@@ -0,0 +1,95 @@
+<?php
+namespace WpfTest\Model;
+
+use WpfTest\Db;
+use WpfTest\Model;
+
+class Note extends Model implements \JsonSerializable {
+    public ?int $id;
+    public string $uri;
+    public \DateTimeImmutable $created;
+    public ?\DateTimeImmutable $modified;
+    public Actor $author;
+    public ?string $summary;
+    public string $plainContent;
+    /**
+     * @var array<string, string>
+     */
+    public array $formattedContent = [];
+    public string $language;
+    /**
+     * @var Actor[]
+     */
+    public array $mentions = [];
+    public ?Note $inReplyTo;
+    public ?Note $threadApex;
+    public NotePrivacy $privacy;
+    /**
+     * @var NoteAttachment[]
+     */
+    public array $attachments = [];
+    public array $extensions = [];
+
+    protected function hydrate(array $row) {
+        $this->privacy = NotePrivacy::findWhere('note_id = ?', [$this->id]);
+        $this->formattedContent = $this->findFormattedContents();
+        $this->mentions = $this->findMentions();
+        $this->attachments = NoteAttachment::findAllWhere('note_id = ?', [$this->id]);
+    }
+
+    private function findFormattedContents(): array {
+        $pdo = Db::getInstance()->getPdo();
+        $stmt = $pdo->prepare('SELECT mimetype, body FROM note_formatted_content WHERE note_id = ?');
+        $stmt->execute([$this->id]);
+        return $stmt->fetchAll(\PDO::FETCH_ASSOC);
+    }
+
+    private function findMentions(): array {
+        $pdo = Db::getInstance()->getPdo();
+        $stmt = $pdo->prepare('SELECT actor_id FROM note_mention WHERE note_id = ?');
+        $stmt->execute([$this->id]);
+        $actors = array_map(function ($actorId) {
+            return Actor::find($actorId);
+        }, $stmt->fetchAll(\PDO::FETCH_COLUMN, 0));
+        return $actors;
+    }
+
+    public static function findAllWithAuthor(Actor $author): array {
+        return self::findAllWhere('author = ?', [$author->id]);
+    }
+
+    public function jsonSerialize(): array {
+        return [
+            'type' => 'note',
+            'self' => path_to_uri("/post/$this->id"),
+            'created' => $this->created->format('c'),
+            'modified' => $this->modified?->format('c'),
+            'author' => $this->author->uri,
+            'summary' => $this->summary,
+            'plainContent' => $this->plainContent,
+            'formattedContent' => $this->formattedContent,
+            'language' => $this->language,
+            'mentions' => array_map(function (Actor $actor) {
+                return $actor->uri;
+            }, $this->mentions),
+            'inReplyTo' => $this->inReplyTo?->uri,
+            'threadApex' => $this->threadApex?->uri,
+            'privacy' => [
+                'scope' => $this->privacy->scope->name,
+                'alsoVisibleTo' => $this->privacy->alsoVisibleTo,
+                'indexable' => $this->privacy->indexable,
+                'canReshare' => $this->privacy->canReshare->name,
+                'canReply' => $this->privacy->canReply->name,
+                'canOtherInteract' => $this->privacy->canOtherInteract->name
+            ],
+            'attachments' => array_map(function (NoteAttachment $attachment) {
+                return [
+                    'type' => $attachment->type,
+                    'href' => $attachment->href,
+                    'description' => $attachment->description
+                ];
+            }, $this->attachments),
+            //'extensions' => []
+        ];
+    }
+}
\ No newline at end of file
diff --git a/WpfTest/Model/NoteAttachment.php b/WpfTest/Model/NoteAttachment.php
new file mode 100644
index 0000000..b07d595
--- /dev/null
+++ b/WpfTest/Model/NoteAttachment.php
@@ -0,0 +1,11 @@
+<?php
+namespace WpfTest\Model;
+
+use WpfTest\Model;
+
+class NoteAttachment extends Model {
+    public int $index;
+    public string $type;
+    public string $href;
+    public ?string $description;
+}
\ No newline at end of file
diff --git a/WpfTest/Model/NotePrivacy.php b/WpfTest/Model/NotePrivacy.php
new file mode 100644
index 0000000..b7ed58a
--- /dev/null
+++ b/WpfTest/Model/NotePrivacy.php
@@ -0,0 +1,16 @@
+<?php
+namespace WpfTest\Model;
+
+use WpfTest\Model;
+
+class NotePrivacy extends Model {
+    public NotePrivacyScope $scope;
+    /**
+     * @var Actor[]
+     */
+    public array $alsoVisibleTo = [];
+    public bool $indexable;
+    public NotePrivacyInteractors $canReshare = NotePrivacyInteractors::all;
+    public NotePrivacyInteractors $canReply = NotePrivacyInteractors::all;
+    public NotePrivacyInteractors $canOtherInteract = NotePrivacyInteractors::all;
+}
\ No newline at end of file
diff --git a/WpfTest/Model/NotePrivacyInteractors.php b/WpfTest/Model/NotePrivacyInteractors.php
new file mode 100644
index 0000000..ff4d7fa
--- /dev/null
+++ b/WpfTest/Model/NotePrivacyInteractors.php
@@ -0,0 +1,9 @@
+<?php
+namespace WpfTest\Model;
+
+enum NotePrivacyInteractors {
+    case all;
+    case followers;
+    case mutuals;
+    case none;
+}
\ No newline at end of file
diff --git a/WpfTest/Model/NotePrivacyScope.php b/WpfTest/Model/NotePrivacyScope.php
new file mode 100644
index 0000000..3134c26
--- /dev/null
+++ b/WpfTest/Model/NotePrivacyScope.php
@@ -0,0 +1,9 @@
+<?php
+namespace WpfTest\Model;
+
+enum NotePrivacyScope {
+    case public;
+    case followers;
+    case mutuals;
+    case none;
+}
\ No newline at end of file