[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_191":192,"_193":194},"routes/_app.x.$handle.$name",{"_100":99,"_33":47,"_108":90,"_28":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":27,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_45":46,"_33":47,"_40":48,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":-5,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":25,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":27},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":34,"_35":36,"_37":39,"_40":41,"_42":14,"_43":44,"_24":27},"previous",{"_31":32,"_33":34,"_35":36,"_37":38},"deleted",true,"deletedHere",false,"path","backend/index.ts","latestPath","fileId","1b2bf742-bfbe-11f0-88ff-42dde27851f2","name","index.ts","fileType","http","content","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 console.log(`Inserted timeslot with ID: ${timeslotId}`);\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 const projectResult = await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name) VALUES (?, ?)`,\n [timeslotId, projectName]\n );\n console.log(`Inserted project ${projectName} for timeslot ${timeslotId}`);\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;","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 console.log(`Inserted timeslot with ID: ${timeslotId}`);\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 const projectResult = await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (timeslot_id, project_name) VALUES (?, ?)`,\n [timeslotId, projectName]\n );\n console.log(`Inserted project ${projectName} for timeslot ${timeslotId}`);\n }\n }\n}\n\n// API Routes\napp.get('/api/debug/reset', async (c) => {\n // Drop and recreate tables\n await sqlite.execute(`DROP TABLE IF EXISTS ${RESPONSES_TABLE}`);\n await sqlite.execute(`DROP TABLE IF EXISTS ${PROJECTS_TABLE}`);\n await sqlite.execute(`DROP TABLE IF EXISTS ${TIMESLOTS_TABLE}`);\n \n await initDatabase();\n return c.json({ message: 'Database reset complete' });\n});\n\napp.get('/api/debug/data', async (c) => {\n const { rows: timeslots } = await sqlite.execute(`SELECT * FROM ${TIMESLOTS_TABLE}`);\n const { rows: projects } = await sqlite.execute(`SELECT * FROM ${PROJECTS_TABLE}`);\n const { rows: responses } = await sqlite.execute(`SELECT * FROM ${RESPONSES_TABLE}`);\n \n return c.json({ timeslots, projects, responses });\n});\n\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;","createdAt",["D",1762948451309],"branchVersion","branchId","59cc29d8-bfbc-11f0-aada-42dde27851f2","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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":56,"_104":105,"_106":27},"branch",{"_13":89,"_33":90,"_45":44,"_91":46,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":47,"_98":99},"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",{"_45":46,"_33":47,"_40":186,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":-5,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":25,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":187,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":188,"_84":189,"_86":190,"_88":27},"tree",[168,170,171],"files",[168,169,170,171],"counts",{"_157":63,"_158":147,"_159":160,"_161":162,"_163":164},"contents",[130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":151,"_33":152,"_31":153,"_136":-5,"_43":44,"_42":140,"_138":25,"_40":154,"_13":63,"_35":155,"_37":-5,"_24":27,"_142":-5,"_28":156},{"_45":144,"_33":145,"_31":146,"_136":-5,"_43":44,"_42":147,"_138":25,"_40":148,"_13":63,"_35":149,"_37":109,"_24":27,"_142":-5,"_28":150},{"_45":133,"_33":134,"_31":135,"_136":-5,"_43":44,"_42":137,"_138":27,"_40":139,"_13":140,"_35":20,"_37":141,"_24":27,"_142":-5,"_28":143},"3981e83c-bfbe-11f0-988b-42dde27851f2","schueler.html","b8f786c2-bfbd-11f0-8d12-42dde27851f2","parentId",9,"latest",["D",1762948417790],6,"\n\n \n \n \n Projektauswahl\n \n \n \n

Projektauswahl

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

\n\n \n

\n\n \n \n","label",[134],"59cdf628-bfbc-11f0-aada-42dde27851f2","main.ts","59cdf6d2-bfbc-11f0-aada-42dde27851f2",1,["D",1762947612985],"script",[145],"1b2c0ca0-bfbe-11f0-88ff-42dde27851f2","backend","ae5aeae1-0739-4af5-abf0-3f5a4237bd65",["D",1762948366897],"directory",[152],"pulls","branches","forks",3,"envVars",{"_165":63,"_167":63},"connections",{"_165":63,"_166":63},"count","unfilledCount","emptyCount",{"_45":151,"_33":152,"_31":153,"_136":-5,"_43":44,"_42":140,"_138":25,"_40":183,"_13":63,"_35":155,"_37":-5,"_24":27,"_142":-5,"_173":184,"_28":185},{"_45":179,"_33":34,"_31":32,"_136":153,"_43":44,"_42":14,"_138":27,"_40":180,"_13":160,"_35":36,"_37":39,"_24":27,"_142":-5,"_173":181,"_28":182},{"_45":144,"_33":145,"_31":146,"_136":-5,"_43":44,"_42":147,"_138":25,"_40":176,"_13":63,"_35":149,"_37":109,"_24":27,"_142":-5,"_173":177,"_28":178},{"_45":133,"_33":134,"_31":135,"_136":-5,"_43":44,"_42":137,"_138":27,"_40":172,"_13":140,"_35":20,"_37":141,"_24":27,"_142":-5,"_173":174,"_28":175},["D",1762948417790],"children",[],[134],["D",1762947612985],[],[145],"4d7d3fda-bfbe-11f0-bd70-42dde27851f2",["D",1762948451309],[],[152,34],["D",1762948366897],[169],[152],["D",1762947612971],["D",1789529498250],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":56,"_104":105,"_106":27},{"_13":89,"_33":90,"_45":44,"_91":46,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":47,"_98":99},"ctx",{"_82":-5,"_127":224,"_225":226,"_227":228,"_229":27,"_230":27,"_231":27,"_232":25,"_233":-5,"_234":-7,"_235":-7,"_236":63,"_237":27,"_238":27,"_239":-5,"_240":27,"_241":27,"_242":27,"_243":-5},"ENV",{"_195":196,"_197":198,"_199":90,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v12