[{"_1":2,"_178":-5,"_179":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","6050acf0705e6826bb1b68e27572c5b8979c5bd9","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_155":156,"_175":176,"_177":-5},"handle","glacador","name","iqunlocked","path","iq-unlocked-item-analysis.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":-5,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":33,"_14":119,"_120":121,"_122":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_154":20},"id","0b90011a-ffcf-11f0-9521-42dde27851f2","createdAt",["D",1769992516575],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019b2fa0-8cd2-7233-9d9e-779b04475582","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019b2fa0-8cd2-7233-9d9e-788defd15540","tursoName","0b90011affcf11f0952142dde27851f2","tursoHostname","0b90011affcf11f0952142dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zNzBDVDJVeE9UeVhIQzJmdFMxc1M2d3JyM3IifQ","org",{"_95":96,"_138":135,"_12":113,"_139":140},"avatar","tier","free","branch",{"_143":144,"_97":45,"_103":145,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},"version",41,"0b90b880-ffcf-11f0-9521-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":157,"_97":100,"_158":159,"_160":-5,"_161":145,"_162":163,"_164":165,"_105":166,"_143":167,"_168":169,"_170":171,"_172":20,"_173":-5,"_99":174},"cadc1590-03c1-11f1-9a64-42dde27851f2","fileId","a13b0cd6-ffd0-11f0-bea7-42dde27851f2","parentId","branchId","branchVersion",40,"latest",true,["D",1770426629182],4,"fileType","http","content","// =============================================================================\n// VAL: iq-unlocked-item-analysis\n// PURPOSE: Calculate psychometric item statistics\n// =============================================================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function handler(req: Request): Promise {\n const headers = {\n 'Access-Control-Allow-Origin': '*',\n 'Content-Type': 'application/json',\n };\n\n const url = new URL(req.url);\n const quizType = url.searchParams.get('quiz_type') || 'iq';\n const action = url.searchParams.get('action') || 'get';\n\n if (action === 'calculate') {\n await calculateItemStats(quizType);\n return new Response(JSON.stringify({ success: true, message: 'Statistics calculated' }), { headers });\n }\n\n // Get current statistics\n const stats = await sqlite.execute(`\n SELECT * FROM item_statistics\n WHERE quiz_type = ?\n ORDER BY discrimination_index ASC\n `, [quizType]);\n\n // Get flagged items\n const flagged = stats.rows.filter((item: any) => {\n const difficulty = item.difficulty_index;\n const discrimination = item.discrimination_index;\n return difficulty > 0.85 || difficulty < 0.15 || discrimination < 0.2;\n });\n\n // Summary statistics\n const avgDifficulty = stats.rows.reduce((sum: number, item: any) => sum + (item.difficulty_index || 0), 0) / stats.rows.length;\n const avgDiscrimination = stats.rows.reduce((sum: number, item: any) => sum + (item.discrimination_index || 0), 0) / stats.rows.length;\n\n return new Response(JSON.stringify({\n quiz_type: quizType,\n total_items: stats.rows.length,\n flagged_count: flagged.length,\n healthy_count: stats.rows.length - flagged.length,\n average_difficulty: avgDifficulty.toFixed(3),\n average_discrimination: avgDiscrimination.toFixed(3),\n target_difficulty_range: '0.30 - 0.70',\n target_discrimination: '> 0.30',\n flagged_items: flagged.map((item: any) => ({\n question_id: item.question_id,\n difficulty: item.difficulty_index?.toFixed(3),\n discrimination: item.discrimination_index?.toFixed(3),\n attempts: item.total_attempts,\n flags: [\n item.difficulty_index > 0.85 ? 'TOO_EASY' : null,\n item.difficulty_index < 0.15 ? 'TOO_HARD' : null,\n item.discrimination_index < 0.2 ? 'POOR_DISCRIMINATION' : null,\n ].filter(Boolean),\n })),\n all_items: stats.rows,\n }), { headers });\n}\n\nasync function calculateItemStats(quizType: string): Promise {\n // Get all question responses\n const responses = await sqlite.execute(`\n SELECT \n JSON_EXTRACT(payload, '$.question_id') as question_id,\n JSON_EXTRACT(payload, '$.answer') as answer,\n JSON_EXTRACT(payload, '$.is_correct') as is_correct,\n JSON_EXTRACT(payload, '$.time_spent_ms') as time_ms,\n session_id\n FROM quiz_events\n WHERE event_type = 'question_answered'\n AND quiz_type = ?\n `, [quizType]);\n\n // Get total scores per session\n const sessionScores = await sqlite.execute(`\n SELECT \n session_id,\n JSON_EXTRACT(payload, '$.percentile') as percentile\n FROM quiz_events\n WHERE event_type = 'quiz_completed'\n AND quiz_type = ?\n `, [quizType]);\n\n // Build score lookup\n const scoreMap = new Map();\n for (const row of sessionScores.rows as any[]) {\n scoreMap.set(row.session_id, row.percentile);\n }\n\n // Group by question\n const questionStats = new Map();\n \n for (const row of responses.rows as any[]) {\n const qId = row.question_id;\n if (!qId) continue;\n \n if (!questionStats.has(qId)) {\n questionStats.set(qId, {\n question_id: qId,\n attempts: 0,\n correct: 0,\n times: [],\n answers: {} as Record,\n highScorerCorrect: 0,\n highScorerTotal: 0,\n lowScorerCorrect: 0,\n lowScorerTotal: 0,\n });\n }\n \n const stats = questionStats.get(qId);\n stats.attempts++;\n if (row.is_correct) stats.correct++;\n if (row.time_ms) stats.times.push(row.time_ms);\n \n // Track answer distribution\n const ans = row.answer || 'null';\n stats.answers[ans] = (stats.answers[ans] || 0) + 1;\n \n // Track discrimination (top 27% vs bottom 27%)\n const percentile = scoreMap.get(row.session_id);\n if (percentile !== undefined) {\n if (percentile >= 73) {\n stats.highScorerTotal++;\n if (row.is_correct) stats.highScorerCorrect++;\n } else if (percentile <= 27) {\n stats.lowScorerTotal++;\n if (row.is_correct) stats.lowScorerCorrect++;\n }\n }\n }\n\n // Calculate and store statistics\n const now = new Date().toISOString();\n \n for (const [qId, stats] of questionStats) {\n const difficulty = stats.attempts > 0 ? stats.correct / stats.attempts : 0;\n \n const highPct = stats.highScorerTotal > 0 ? stats.highScorerCorrect / stats.highScorerTotal : 0;\n const lowPct = stats.lowScorerTotal > 0 ? stats.lowScorerCorrect / stats.lowScorerTotal : 0;\n const discrimination = highPct - lowPct;\n \n const meanTime = stats.times.length > 0 \n ? stats.times.reduce((a: number, b: number) => a + b, 0) / stats.times.length \n : 0;\n\n await sqlite.execute(`\n INSERT INTO item_statistics (\n quiz_type, question_id, total_attempts, correct_count,\n difficulty_index, high_scorers_correct, high_scorers_total,\n low_scorers_correct, low_scorers_total, discrimination_index,\n mean_time_ms, answer_distribution, last_calculated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(quiz_type, question_id) DO UPDATE SET\n total_attempts = excluded.total_attempts,\n correct_count = excluded.correct_count,\n difficulty_index = excluded.difficulty_index,\n high_scorers_correct = excluded.high_scorers_correct,\n high_scorers_total = excluded.high_scorers_total,\n low_scorers_correct = excluded.low_scorers_correct,\n low_scorers_total = excluded.low_scorers_total,\n discrimination_index = excluded.discrimination_index,\n mean_time_ms = excluded.mean_time_ms,\n answer_distribution = excluded.answer_distribution,\n last_calculated_at = excluded.last_calculated_at\n `, [\n quizType,\n qId,\n stats.attempts,\n stats.correct,\n difficulty,\n stats.highScorerCorrect,\n stats.highScorerTotal,\n stats.lowScorerCorrect,\n stats.lowScorerTotal,\n discrimination,\n Math.round(meanTime),\n JSON.stringify(stats.answers),\n now,\n ]);\n }\n}","deleted","label",[100],"permalink","https://www.val.town/x/glacador/iqunlocked/code/iq-unlocked-item-analysis.ts","extension","actionData","errors"]