[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_190":191,"_192":193},"routes/_app.x.$handle.$name",{"_104":103,"_32":51,"_112":94,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_21":-5,"_124":-5,"_125":-5,"_126":25,"_127":128,"_129":25,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_36":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":42,"_64":42,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":25},"version",6,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":42,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","backend","latestPath","fileId","ae5aeae1-0739-4af5-abf0-3f5a4237bd65","name","fileType","directory","content","createdAt",["D",1762948366897],"branchVersion","branchId","59cc29d8-bfbc-11f0-aada-42dde27851f2",{"_30":44,"_32":45,"_33":46,"_35":47,"_36":48,"_38":14,"_39":40,"_24":25},true,"backend/index.ts","1b2bf742-bfbe-11f0-88ff-42dde27851f2","index.ts","script","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Database setup\nconst TIMESLOTS_TABLE = 'project_timeslots';\nconst PROJECTS_TABLE = 'project_options';\nconst RESPONSES_TABLE = 'student_responses';\n\n// Initialize database tables\nasync function initDatabase() {\n // Create timeslots table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TIMESLOTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n time_description TEXT NOT NULL,\n order_index INTEGER NOT NULL,\n active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create projects table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PROJECTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timeslot_id INTEGER,\n project_name TEXT NOT NULL,\n project_description TEXT,\n active BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id)\n )`);\n\n // Create responses table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${RESPONSES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n student_name TEXT NOT NULL,\n timeslot_id INTEGER,\n first_choice TEXT,\n second_choice TEXT,\n third_choice TEXT,\n submitted_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (timeslot_id) REFERENCES ${TIMESLOTS_TABLE} (id)\n )`);\n\n // Insert default data if tables are empty\n const { rows: timeslotCount } = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TIMESLOTS_TABLE}`);\n if (timeslotCount[0].count === 0) {\n await insertDefaultData();\n }\n}\n\nasync function insertDefaultData() {\n // Insert default timeslots\n const timeslots = [\n { title: \"1. Dienstag 9:00-10:30 Uhr\", time_description: \"Dienstag 9:00-10:30 Uhr\", order_index: 1 },\n { title: \"2. Dienstag 10:45-12:15 Uhr\", time_description: \"Dienstag 10:45-12:15 Uhr\", order_index: 2 },\n { title: \"3. Dienstag 12:45-13:30 Uhr\", time_description: \"Dienstag 12:45-13:30 Uhr\", order_index: 3 }\n ];\n\n for (const timeslot of timeslots) {\n const result = await sqlite.execute(\n `INSERT INTO ${TIMESLOTS_TABLE} (title, time_description, order_index) VALUES (?, ?, ?)`,\n [timeslot.title, timeslot.time_description, timeslot.order_index]\n );\n \n const timeslotId = result.lastInsertRowId;\n \n // Insert default projects for each timeslot\n const projects = ['Projekt A', 'Projekt B', 'Projekt C', 'Projekt D', 'Projekt E', 'Projekt F', 'Projekt G', 'Projekt H'];\n \n for (const projectName of projects) {\n await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name) VALUES (?, ?)`,\n [timeslotId, projectName]\n );\n }\n }\n}\n\n// API Routes\napp.get('/api/timeslots', async (c) => {\n const { rows: timeslots } = await sqlite.execute(\n `SELECT * FROM ${TIMESLOTS_TABLE} WHERE active = 1 ORDER BY order_index`\n );\n\n const timelotData = [];\n \n for (const timeslot of timeslots) {\n const { rows: projects } = await sqlite.execute(\n `SELECT * FROM ${PROJECTS_TABLE} WHERE timeslot_id = ? AND active = 1`,\n [timeslot.id]\n );\n \n timelotData.push({\n id: timeslot.id,\n title: timeslot.title,\n timeDescription: timeslot.time_description,\n orderIndex: timeslot.order_index,\n projects: projects.map(p => ({\n id: p.id,\n name: p.project_name,\n description: p.project_description\n }))\n });\n }\n\n return c.json(timelotData);\n});\n\napp.post('/api/responses', async (c) => {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.name || !data.responses || !Array.isArray(data.responses)) {\n return c.json({ error: 'Invalid data format' }, 400);\n }\n\n try {\n // Insert each response\n for (const response of data.responses) {\n if (response.rankings && response.rankings.length >= 3) {\n // Find timeslot ID by title\n const { rows: timeslots } = await sqlite.execute(\n `SELECT id FROM ${TIMESLOTS_TABLE} WHERE title = ?`,\n [response.question]\n );\n \n if (timeslots.length > 0) {\n await sqlite.execute(\n `INSERT INTO ${RESPONSES_TABLE} (student_name, timeslot_id, first_choice, second_choice, third_choice) \n VALUES (?, ?, ?, ?, ?)`,\n [\n data.name,\n timeslots[0].id,\n response.rankings[0] || null,\n response.rankings[1] || null,\n response.rankings[2] || null\n ]\n );\n }\n }\n }\n\n return c.json({ success: true, message: 'Responses saved successfully' });\n } catch (error) {\n console.error('Error saving responses:', error);\n return c.json({ error: 'Failed to save responses' }, 500);\n }\n});\n\n// Serve the main HTML file\napp.get('/', async (c) => {\n let html = await readFile(\"/schueler.html\", import.meta.url);\n \n // Inject the API endpoint for dynamic loading\n const scriptInjection = `\n \n `;\n \n html = html.replace('', `${scriptInjection}`);\n return c.html(html);\n});\n\n// Initialize database on startup\nawait initDatabase();\n\nexport default app.fetch;",["D",1762948366897],"id","59cbb624-bfbc-11f0-aada-42dde27851f2","Projektwoche",["D",1762947612971],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","2c69940e-198d-46d6-824e-0d8c150b63e9","pinnedFileId","e6d56768-bfc1-11f0-974b-42dde27851f2","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","917c516d-7013-4878-8604-9bac537fcbe3","tursoName","59cbb624bfbc11f0aada42dde27851f2","tursoHostname","59cbb624bfbc11f0aada42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789529498250],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_111":107},"org",{"_104":103,"_105":-5,"_106":107,"_18":60,"_108":109,"_110":25},"branch",{"_13":93,"_32":94,"_49":40,"_95":50,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":51,"_102":103},"isOwned",210,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","chriseidhof","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yckc5VFZOUXljZTRkWjJ6T2lPUVRseEtYa3YifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_36":185,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":42,"_64":42,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":186,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":187,"_88":188,"_90":189,"_92":25},"tree",[167,169,170],"files",[167,168,169,170],"counts",{"_157":67,"_158":151,"_159":144,"_160":161,"_162":163},"contents",[134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":154,"_32":28,"_30":31,"_140":-5,"_39":40,"_38":14,"_142":42,"_36":155,"_13":67,"_33":34,"_35":-5,"_24":25,"_146":-5,"_27":156},{"_49":148,"_32":149,"_30":150,"_140":-5,"_39":40,"_38":151,"_142":42,"_36":152,"_13":67,"_33":46,"_35":113,"_24":25,"_146":-5,"_27":153},{"_49":137,"_32":138,"_30":139,"_140":-5,"_39":40,"_38":141,"_142":25,"_36":143,"_13":144,"_33":21,"_35":145,"_24":25,"_146":-5,"_27":147},"cd1da7da-bfbd-11f0-a7fb-42dde27851f2","schueler.html","b8f786c2-bfbd-11f0-8d12-42dde27851f2","parentId",5,"latest",["D",1762948235935],3,"\n\n \n \n \n Projektauswahl\n \n \n \n

Projektauswahl

Wähle deine Top 3 Favoriten für jede Zeitspanne

\n\n

\n Dein Name:\n \n

\n\n \n

1. Dienstag 9:00-10:30 Uhr

\n 1. Wahl:\n

\n 2. Wahl:\n

\n 3. Wahl:\n

\n Projekt A\n

\n Projekt B\n

\n Projekt C\n

\n Projekt D\n

\n Projekt E\n

\n Projekt F\n

\n Projekt G\n

\n Projekt H\n

\n\n \n

2. Dienstag 10:45-12:15 Uhr

\n 1. Wahl:\n

\n 2. Wahl:\n

\n 3. Wahl:\n

\n Projekt A\n

\n Projekt B\n

\n Projekt C\n

\n Projekt D\n

\n Projekt E\n

\n Projekt F\n

\n Projekt G\n

\n Projekt H\n

\n\n \n

3. Dienstag 12:45-13:30 Uhr

\n 1. Wahl:\n

\n 2. Wahl:\n

\n 3. Wahl:\n

\n Projekt A\n

\n Projekt B\n

\n Projekt C\n

\n Projekt D\n

\n Projekt E\n

\n Projekt F\n

\n Projekt G\n

\n Projekt H\n

\n\n

\n \n

\n Vielen Dank! Deine Auswahl wurde gespeichert.\n

\n\n \n \n","label",[138],"59cdf628-bfbc-11f0-aada-42dde27851f2","main.ts","59cdf6d2-bfbc-11f0-aada-42dde27851f2",1,["D",1762947612985],[149],"1b2c0ca0-bfbe-11f0-88ff-42dde27851f2",["D",1762948366897],[28],"pulls","branches","forks","envVars",{"_164":67,"_166":67},"connections",{"_164":67,"_165":67},"count","unfilledCount","emptyCount",{"_49":154,"_32":28,"_30":31,"_140":-5,"_39":40,"_38":14,"_142":42,"_36":182,"_13":67,"_33":34,"_35":-5,"_24":25,"_146":-5,"_172":183,"_27":184},{"_49":178,"_32":45,"_30":44,"_140":31,"_39":40,"_38":14,"_142":25,"_36":179,"_13":67,"_33":46,"_35":47,"_24":25,"_146":-5,"_172":180,"_27":181},{"_49":148,"_32":149,"_30":150,"_140":-5,"_39":40,"_38":151,"_142":42,"_36":175,"_13":67,"_33":46,"_35":113,"_24":25,"_146":-5,"_172":176,"_27":177},{"_49":137,"_32":138,"_30":139,"_140":-5,"_39":40,"_38":141,"_142":25,"_36":171,"_13":144,"_33":21,"_35":145,"_24":25,"_146":-5,"_172":173,"_27":174},["D",1762948235935],"children",[],[138],["D",1762947612985],[],[149],"1b2bf698-bfbe-11f0-88ff-42dde27851f2",["D",1762948366897],[],[28,45],["D",1762948366897],[168],[28],["D",1762947612971],["D",1789529498250],{"_104":103,"_111":107},{"_104":103,"_105":-5,"_106":107,"_18":60,"_108":109,"_110":25},{"_13":93,"_32":94,"_49":40,"_95":50,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":51,"_102":103},"ctx",{"_86":-5,"_131":223,"_224":225,"_226":227,"_228":25,"_229":25,"_230":25,"_231":42,"_232":-5,"_233":-7,"_234":-7,"_235":67,"_236":25,"_237":25,"_238":-5,"_239":25,"_240":25,"_241":25,"_242":-5},"ENV",{"_194":195,"_196":197,"_198":94,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6