Function select

apps/cloud/src/auth/member-directory.ts:57–73

()

  // One projection for every read, so the seam's row shape is built in exactly
  // one place. `membershipId` is non-null by the `known` predicate below.
  const select = () =>
    db
      .select({
        accountId: memberships.accountId,
        membershipId: memberships.membershipId,
        organizationId: memberships.organizationId,
        role: memberships.role,
        status: memberships.status,
        email: accounts.email,
        firstName: accounts.firstName,
        lastName: accounts.lastName,
        avatarUrl: accounts.avatarUrl,
        lastSignInAt: accounts.lastSignInAt,
      })
      .from(memberships)
      .innerJoin(accounts, eq(accounts.id, memberships.accountId))
      .$dynamic();

  type Row = Awaited<ReturnType<typeof select>>[number];