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.
1.1 kB · 32 lines
TypeScript
at incident-api
123456789101112131415161718192021222324252627282930313233import { and, eq, isNull } from "@openstatus/db";import { user, usersToWorkspaces } from "@openstatus/db/src/schema";
import { displayName } from "../attribution";import { type ServiceContext, getReadDb } from "../context";import { GetMemberDisplayNameInput } from "./schemas";
/** The display name of a live member of this workspace, or `null`. */export async function getMemberDisplayName(args: { ctx: ServiceContext; input: GetMemberDisplayNameInput;}): Promise<string | null> { const input = GetMemberDisplayNameInput.parse(args.input); const row = await getReadDb(args.ctx) .select({ name: user.name, firstName: user.firstName, lastName: user.lastName, email: user.email, }) .from(usersToWorkspaces) .innerJoin(user, eq(user.id, usersToWorkspaces.userId)) .where( and( eq(usersToWorkspaces.workspaceId, args.ctx.workspace.id), eq(usersToWorkspaces.userId, input.userId), isNull(user.deletedAt), ), ) .get(); return row ? displayName(row) : null;}