[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","5aae8c594f4ceb0bfd0f0c6fa62a207a75f96ff1","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_172":173,"_174":-5},"handle","fevy","name","CHATBOT","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","644f85a6-3fb2-11f0-bbda-76b3cceeab13","createdAt",["D",1748869586812],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c7e72160-3fb1-11f0-b6e9-ab0b2f88b858","pinnedFileId","171cfa8c-3fb4-11f0-80a7-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","27e0e1a6-9b0f-4018-bf94-8537eba7a5e5","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eEFFTXMxMHFTb1FPUjF6VkVpenA0aVcyRCJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",11,"6451115a-3fb2-11f0-bbda-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"c5688d0a-3fb3-11f0-a2f9-76b3cceeab13","queries.ts","fileId","c5688e2c-3fb3-11f0-a2f9-76b3cceeab13","parentId","65d7989e-8990-4852-9785-2eaa5603bfff","branchId","branchVersion",4,"latest",["D",1748870179207],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Course, Student, Inquiry, ChatMessage } from \"../../shared/types.ts\";\n\n// Student operations\nexport async function createOrUpdateStudent(telegramUser: any): Promise {\n const { id, first_name, last_name, username } = telegramUser;\n \n // Try to update existing student\n await sqlite.execute(`\n INSERT OR REPLACE INTO students (telegram_id, first_name, last_name, username, joined_at, is_active)\n VALUES (?, ?, ?, ?, COALESCE((SELECT joined_at FROM students WHERE telegram_id = ?), CURRENT_TIMESTAMP), 1)\n `, [id, first_name, last_name || null, username || null, id]);\n\n const result = await sqlite.execute(`\n SELECT * FROM students WHERE telegram_id = ?\n `, [id]);\n\n return result.rows[0] as Student;\n}\n\nexport async function getStudentByTelegramId(telegramId: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM students WHERE telegram_id = ? AND is_active = 1\n `, [telegramId]);\n\n return result.rows[0] as Student || null;\n}\n\nexport async function getAllActiveStudents(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM students WHERE is_active = 1 ORDER BY joined_at DESC\n `);\n\n return result.rows as Student[];\n}\n\n// Course operations\nexport async function getAllActiveCourses(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM courses WHERE is_active = 1 ORDER BY category, name\n `);\n\n return result.rows as Course[];\n}\n\nexport async function getCoursesByCategory(category: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM courses WHERE category = ? AND is_active = 1 ORDER BY name\n `, [category]);\n\n return result.rows as Course[];\n}\n\nexport async function getCourseById(courseId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM courses WHERE id = ? AND is_active = 1\n `, [courseId]);\n\n return result.rows[0] as Course || null;\n}\n\nexport async function getCourseCategories(): Promise {\n const result = await sqlite.execute(`\n SELECT DISTINCT category FROM courses WHERE is_active = 1 ORDER BY category\n `);\n\n return result.rows.map(row => row.category as string);\n}\n\n// Inquiry operations\nexport async function createInquiry(studentId: number, message: string, category: string): Promise {\n const result = await sqlite.execute(`\n INSERT INTO inquiries (student_id, message, category, status, created_at)\n VALUES (?, ?, ?, 'pending', CURRENT_TIMESTAMP)\n `, [studentId, message, category]);\n\n return result.lastInsertRowId as number;\n}\n\nexport async function getInquiriesByStudent(studentId: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM inquiries WHERE student_id = ? ORDER BY created_at DESC\n `, [studentId]);\n\n return result.rows as Inquiry[];\n}\n\nexport async function getPendingInquiries(): Promise {\n const result = await sqlite.execute(`\n SELECT i.*, s.first_name, s.last_name, s.username \n FROM inquiries i \n JOIN students s ON i.student_id = s.id \n WHERE i.status = 'pending' \n ORDER BY i.created_at ASC\n `);\n\n return result.rows as Inquiry[];\n}\n\nexport async function answerInquiry(inquiryId: number, answer: string): Promise {\n await sqlite.execute(`\n UPDATE inquiries \n SET answer = ?, answered_at = CURRENT_TIMESTAMP, status = 'answered'\n WHERE id = ?\n `, [answer, inquiryId]);\n}\n\n// Chat message operations\nexport async function createChatMessage(studentId: number, message: string, messageType: string = 'text'): Promise {\n const result = await sqlite.execute(`\n INSERT INTO chat_messages (student_id, message, message_type, created_at, is_moderated)\n VALUES (?, ?, ?, CURRENT_TIMESTAMP, 0)\n `, [studentId, message, messageType]);\n\n return result.lastInsertRowId as number;\n}\n\nexport async function getRecentChatMessages(limit: number = 50): Promise {\n const result = await sqlite.execute(`\n SELECT cm.*, s.first_name, s.username \n FROM chat_messages cm \n JOIN students s ON cm.student_id = s.id \n WHERE cm.is_moderated = 0 \n ORDER BY cm.created_at DESC \n LIMIT ?\n `, [limit]);\n\n return result.rows as ChatMessage[];\n}\n\nexport async function moderateChatMessage(messageId: number): Promise {\n await sqlite.execute(`\n UPDATE chat_messages SET is_moderated = 1 WHERE id = ?\n `, [messageId]);\n}\n\n// Statistics\nexport async function getStudentCount(): Promise {\n const result = await sqlite.execute(`\n SELECT COUNT(*) as count FROM students WHERE is_active = 1\n `);\n\n return result.rows[0].count as number;\n}\n\nexport async function getInquiryStats(): Promise<{ pending: number; answered: number; total: number }> {\n const result = await sqlite.execute(`\n SELECT \n SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending,\n SUM(CASE WHEN status = 'answered' THEN 1 ELSE 0 END) as answered,\n COUNT(*) as total\n FROM inquiries\n `);\n\n const row = result.rows[0];\n return {\n pending: row.pending as number || 0,\n answered: row.answered as number || 0,\n total: row.total as number || 0\n };\n}","deleted","label",[170,171,153],"backend","database","permalink","https://www.val.town/x/fevy/CHATBOT/code/backend/database/queries.ts","extension","actionData","errors"]