From 25b748f04911262826d0a0bc9609e03ee47c3232 Mon Sep 17 00:00:00 2001
From: winter
Date: Tue, 14 Jan 2025 18:13:57 +0000
Subject: add interaction counters

---
 Digitigrade/Model.php | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'Digitigrade/Model.php')

diff --git a/Digitigrade/Model.php b/Digitigrade/Model.php
index 4a206a6..be664cb 100644
--- a/Digitigrade/Model.php
+++ b/Digitigrade/Model.php
@@ -183,6 +183,22 @@ abstract class Model {
         return static::findAllWhere('1 = 1', []);
     }
 
+    public static function countWhere(string $whereClause, array $parameters): int {
+        $classNameParts = explode('\\', static::class);
+        $className = $classNameParts[count($classNameParts) - 1];
+        $tableName = self::mangleName($className);
+
+        $query = "SELECT count(*) FROM $tableName WHERE $whereClause";
+        $stmt = Db::getInstance()->getPdo()->prepare($query);
+        $stmt->execute($parameters);
+        return $stmt->fetchColumn(0);
+    }
+
+    public static function count(): int {
+        // FIXME
+        return static::countWhere('1 = 1', []);
+    }
+
     public static function find(int $id): ?static {
         return static::findWhere('id = ?', [$id]);
     }
-- 
cgit v1.3