Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/openstatusHQ/openstatus. 🫖 Status page with uptime monitoring & API monitoring as code 🫖 openstatus.dev
bun drizzle-orm monitoring monitoring-as-code nextjs observability on-call open-source shadcn-ui status-page statuspage synthetic-monitoring tinybird turso uptime uptime-checker uptime-monitor
Something went wrong. Try again.
627 B · 25 lines
TypeScript
at main
1234567891011121314151617181920212223242526import { and, db as defaultDb, gte, isNull, sql } from "@openstatus/db";import { invitation } from "@openstatus/db/src/schema";
import type { DB } from "../context";
export async function hasPendingInvitation(args: { email: string; db?: DB;}): Promise<boolean> { const db = args.db ?? defaultDb;
const row = await db .select({ id: invitation.id }) .from(invitation) .where( and( sql`lower(${invitation.email}) = ${args.email.trim().toLowerCase()}`, isNull(invitation.acceptedAt), gte(invitation.expiresAt, new Date()), ), ) .get();
return Boolean(row);}