import type { Member, MembersPage } from '@admin/actions/team/types' import { teamCacheTags } from '@admin/actions/team/types' import db from '@admin/db' import { user } from '@admin/db/schema' import { ADMIN_ACCESS_ROLES } from '@admin/types/auth' import { inArray } from 'drizzle-orm' import { cacheLife, cacheTag } from 'next/cache' export async function getCachedMembers(): Promise { 'use cache' cacheLife('max') cacheTag(teamCacheTags.all) try { const rows = await db .select({ id: user.id, email: user.email, name: user.name, emailVerified: user.emailVerified, createdAt: user.createdAt, updatedAt: user.updatedAt, role: user.role }) .from(user) .where(inArray(user.role, [...ADMIN_ACCESS_ROLES])) .orderBy(user.createdAt) const members: Member[] = rows.map((row) => ({ id: row.id, email: row.email, name: row.name, emailVerified: row.emailVerified, createdAt: row.createdAt.toISOString(), updatedAt: row.updatedAt.toISOString(), role: row.role })) return { members, total: members.length } } catch { return { members: [], total: 0 } } }