From e84caf3f9fbdf69e31b4dd7df3ca512108816d5d Mon Sep 17 00:00:00 2001
From: Maze Winther <mazewinther@gmail.com>
Date: Sun, 22 Jun 2025 14:25:19 +0200
Subject: feat: add waitlist signup count

---
 apps/web/src/lib/waitlist.ts | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 apps/web/src/lib/waitlist.ts

(limited to 'apps/web/src/lib')

diff --git a/apps/web/src/lib/waitlist.ts b/apps/web/src/lib/waitlist.ts
new file mode 100644
index 00000000..c397109d
--- /dev/null
+++ b/apps/web/src/lib/waitlist.ts
@@ -0,0 +1,15 @@
+import { db } from "@/lib/db";
+import { waitlist } from "@/lib/db/schema";
+import { sql } from "drizzle-orm";
+
+export async function getWaitlistCount() {
+  try {
+    const result = await db
+      .select({ count: sql<number>`count(*)` })
+      .from(waitlist);
+    return result[0]?.count || 0;
+  } catch (error) {
+    console.error("Failed to fetch waitlist count:", error);
+    return 0;
+  }
+}
-- 
cgit v1.3.1