add interaction counters

1 files changed, 16 insertions, 0 deletions

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]);
     }