[{"_1":2,"_177":-5,"_178":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","notificationCount",0,"flagDenols","ENV",{"_36":37,"_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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","8e9ab478faef4805babde6d59c528a1818a04d96","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_150":151,"_174":175,"_176":-5},"handle","DevHub","name","C_TuTor","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_149":20},"id","5d16532e-337c-11f0-bcc4-9e149126039e","createdAt",["D",1747526967912],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","3f200630-337c-11f0-b519-ff88f6bc2fe6","pinnedFileId","pinPreview","screenshotVersion","likeCount","5d61df7e-4cd9-496c-9b56-790cd60acc67","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4RkhUUHl5QXgxZUU5em1DajRjb1B2bWRZRyJ9","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":146,"_147":96,"_148":94},"version",8,"5d17f4d6-337c-11f0-bcc4-9e149126039e","projectId","forkedBranchId","b33bef56-3373-11f0-8bc5-9e149126039e","forkedBranchVersion",27,"forkedProjectPrivacy","forkedProjectId","b33a78e2-3373-11f0-8bc5-9e149126039e","forkedProjectOrgId","b137018b-54d5-4527-83fa-aa4585f89a8e","projectName","userHandle","isOwned","file",{"_101":152,"_95":153,"_154":155,"_156":157,"_158":136,"_159":160,"_161":162,"_103":163,"_134":164,"_165":166,"_167":168,"_169":20,"_170":-5,"_97":171},"101552f4-337d-11f0-b447-9e149126039e","queries.ts","fileId","8683a53e-0f80-4d73-a1fb-7a5e46e29b4b","parentId","9e32ac6e-7ebc-4d4b-97f2-cabe52d49114","branchId","branchVersion",7,"latest",true,["D",1747527268219],3,"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\n\n// Types\nexport interface User {\n id: number;\n username: string;\n display_name: string;\n created_at: number;\n}\n\nexport interface Lesson {\n id: number;\n title: string;\n slug: string;\n description: string;\n content: string;\n order_index: number;\n difficulty: string;\n created_at: number;\n}\n\nexport interface Exercise {\n id: number;\n lesson_id: number;\n title: string;\n description: string;\n starter_code: string;\n solution_code: string;\n test_cases: string;\n order_index: number;\n difficulty: string;\n created_at: number;\n}\n\nexport interface UserProgress {\n id: number;\n user_id: number;\n lesson_id: number;\n completed: boolean;\n last_accessed: number;\n}\n\nexport interface UserSolution {\n id: number;\n user_id: number;\n exercise_id: number;\n code: string;\n is_correct: boolean;\n submitted_at: number;\n}\n\n// User queries\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USERS} WHERE username = ?`,\n [username]\n );\n return result.rows && result.rows.length > 0 ? result.rows[0] : null;\n}\n\nexport async function createUser(username: string, displayName: string): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (username, display_name) VALUES (?, ?)`,\n [username, displayName]\n );\n return getUserByUsername(username);\n}\n\n// Lesson queries\nexport async function getAllLessons(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.LESSONS} ORDER BY order_index ASC`\n );\n return result.rows || [];\n}\n\nexport async function getLessonBySlug(slug: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.LESSONS} WHERE slug = ?`,\n [slug]\n );\n return result.rows && result.rows.length > 0 ? result.rows[0] : null;\n}\n\n// Exercise queries\nexport async function getExercisesByLessonId(lessonId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.EXERCISES} WHERE lesson_id = ? ORDER BY order_index ASC`,\n [lessonId]\n );\n return result.rows || [];\n}\n\nexport async function getExerciseById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.EXERCISES} WHERE id = ?`,\n [id]\n );\n return result.rows && result.rows.length > 0 ? result.rows[0] : null;\n}\n\n// User progress queries\nexport async function getUserProgress(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USER_PROGRESS} WHERE user_id = ?`,\n [userId]\n );\n return result.rows || [];\n}\n\nexport async function updateUserProgress(\n userId: number,\n lessonId: number,\n completed: boolean\n): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USER_PROGRESS} (user_id, lesson_id, completed, last_accessed)\n VALUES (?, ?, ?, unixepoch())\n ON CONFLICT(user_id, lesson_id) \n DO UPDATE SET completed = ?, last_accessed = unixepoch()`,\n [userId, lessonId, completed ? 1 : 0, completed ? 1 : 0]\n );\n}\n\n// User solution queries\nexport async function saveUserSolution(\n userId: number,\n exerciseId: number,\n code: string,\n isCorrect: boolean\n): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USER_SOLUTIONS} (user_id, exercise_id, code, is_correct)\n VALUES (?, ?, ?, ?)`,\n [userId, exerciseId, code, isCorrect ? 1 : 0]\n );\n}\n\nexport async function getUserSolutions(userId: number, exerciseId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USER_SOLUTIONS} \n WHERE user_id = ? AND exercise_id = ?\n ORDER BY submitted_at DESC`,\n [userId, exerciseId]\n );\n return result.rows || [];\n}\n\n// Get learning path with progress\nexport async function getLearningPathWithProgress(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT \n l.*,\n COALESCE(up.completed, 0) as completed,\n COALESCE(up.last_accessed, 0) as last_accessed,\n (SELECT COUNT(*) FROM ${TABLES.EXERCISES} WHERE lesson_id = l.id) as exercise_count,\n (SELECT COUNT(*) FROM ${TABLES.USER_SOLUTIONS} us\n JOIN ${TABLES.EXERCISES} e ON us.exercise_id = e.id\n WHERE us.user_id = ? AND e.lesson_id = l.id AND us.is_correct = 1) as completed_exercises\n FROM ${TABLES.LESSONS} l\n LEFT JOIN ${TABLES.USER_PROGRESS} up ON l.id = up.lesson_id AND up.user_id = ?\n ORDER BY l.order_index ASC`,\n [userId, userId]\n );\n return result.rows || [];\n}","deleted","label",[172,173,153],"backend","database","permalink","https://www.val.town/x/DevHub/C_TuTor/code/backend/database/queries.ts","extension","actionData","errors"]