Function isOrgMember

server/src/routes/certification.ts:25–37

* Check if a user belongs to an organization. * In dev mode, checks local DB. In production, calls WorkOS API.

(userId: string, orgId: string)

 * In dev mode, checks local DB. In production, calls WorkOS API.
 */
async function isOrgMember(userId: string, orgId: string): Promise<boolean> {
  if (isDevModeEnabled()) {
    const result = await query<{ count: string }>(
      `SELECT COUNT(*)::text AS count FROM organization_memberships
       WHERE workos_user_id = $1 AND workos_organization_id = $2`,
      [userId, orgId]
    );
    return parseInt(result.rows[0]?.count || '0') > 0;
  }
  if (!workos) return false;
  const memberships = await workos.userManagement.listOrganizationMemberships({ userId, organizationId: orgId });
  return memberships.data.length > 0;
}

/**
 * Create certification routes.