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.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263import { and, eq, gt, isNull } from "@openstatus/db";import { oauthClient, oauthGrant, user } from "@openstatus/db/src/schema";import type { Scope } from "@openstatus/db/src/schema/api-keys/constants";
import { type ServiceContext, getReadDb } from "../context";
export type ConnectedApp = { id: number; clientId: string; clientName: string; scope: Scope[]; userId: number; user: { id: number; email: string | null; firstName: string | null; lastName: string | null; } | null; createdAt: Date | null; lastUsedAt: Date | null;};
/** Live grants for the workspace, joined with client and consenting user. Hashes never leave the row. */export async function listGrants(args: { ctx: ServiceContext; now?: Date;}): Promise<ConnectedApp[]> { const { ctx } = args; const db = getReadDb(ctx); const now = args.now ?? new Date();
const rows = await db .select({ id: oauthGrant.id, clientId: oauthGrant.clientId, clientName: oauthClient.name, scope: oauthGrant.scope, userId: oauthGrant.userId, createdAt: oauthGrant.createdAt, lastUsedAt: oauthGrant.lastUsedAt, user: { id: user.id, email: user.email, firstName: user.firstName, lastName: user.lastName, }, }) .from(oauthGrant) .innerJoin(oauthClient, eq(oauthClient.clientId, oauthGrant.clientId)) .leftJoin(user, eq(user.id, oauthGrant.userId)) .where( and( eq(oauthGrant.workspaceId, ctx.workspace.id), isNull(oauthGrant.revokedAt), gt(oauthGrant.refreshTokenExpiresAt, now), ), ) .orderBy(oauthGrant.createdAt) .all();
return rows.map((row) => ({ ...row, user: row.user?.id ? row.user : null }));}