// Existing plain TypeScript, as it is often written: it type-checks under strict, and every// line ending in a `finding` marker is something `tsus audit` lists. The audit only reads.type D1 = { prepare(q: string): { bind(...v: unknown[]): { all<T>(): Promise<{ results: T[] }> } }; batch(s: unknown[]): Promise<unknown[]> };type Env = { DB: D1; KV: { put(k: string, v: string): Promise<void> } };type Role = "owner" | "member" | "guest";const requireMember = async (env: Env, user: string, org: string): Promise<boolean> => { const { results } = await env.DB.prepare("SELECT 1 FROM members WHERE user_id = ? AND org_id = ?").bind(user, org).all(); return results.length > 0;};// Checked: the membership test runs before the query.export const orgRepos = async (env: Env, user: string, org: string) => { if (!(await requireMember(env, user, org))) return []; return (await env.DB.prepare("SELECT name FROM repos WHERE org_id = ?").bind(org).all<{ name: string }>()).results;};// Not checked, and the sort column is pasted in.export const orgMembers = async (env: Env, org: string, sort: string) => (await env.DB.prepare(`SELECT user_id FROM members WHERE org_id = ? ORDER BY ${sort}`).bind(org).all()).results; // finding unchecked-permission string-built-sqlexport const roleLabel = (r: Role): string => { switch (r) { // finding non-exhaustive-switch case "owner": return "Owner"; case "member": return "Member"; } return "";};export const remember = (env: Env, key: string, value: string): void => { env.KV.put(key, value); // finding ignored-promise};export const parseConfig = (raw: string): Record<string, unknown> => { try { return JSON.parse(raw) as Record<string, unknown>; // finding cast } catch {} // finding swallowed-error return {};};export const firstName = (full: string): string => full.split(" ")[0].trim(); // finding implicit-nullexport const greet = (nick: string | undefined): string => (nick ? `hi ${nick}` : "hi"); // finding implicit-nullexport const owner = (m: Map<string, string>, org: string): string => m.get(org)!; // finding implicit-null