feat: add org resources query

brettkolodny · brettkolodny · commit 2711ded5409e · 2025-03-21T19:18:42.000Z
diff --git a/coderd/database/queries/organizations.sql b/coderd/database/queries/organizations.sql
@@ -66,6 +66,14 @@ WHERE
             user_id = $1
     );
 
+-- name: GetOrganizationResourceCountByID :one
+SELECT
+    (SELECT COUNT(*) FROM workspaces WHERE workspaces.organization_id = $1 AND workspaces.deleted = false) AS workspace_count,
+    (SELECT COUNT(*) FROM groups WHERE groups.organization_id = $1) AS group_count,
+    (SELECT COUNT(*) FROM templates WHERE templates.organization_id = $1 AND templates.deleted = false) AS template_count,
+    (SELECT COUNT(*) FROM organization_members WHERE organization_members.organization_id = $1) AS member_count,
+    (SELECT COUNT(*) FROM provisioner_keys WHERE provisioner_keys.organization_id = $1) AS provisioner_key_count;
+
 -- name: InsertOrganization :one
 INSERT INTO
     organizations (id, "name", display_name, description, icon, created_at, updated_at, is_default)
