[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_159":160,"_161":162},"routes/_app.x.$handle.$name",{"_103":102,"_37":49,"_111":93,"_32":105,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":30,"_125":126,"_127":62,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",1,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","71f5b046-2694-4d96-bc55-b589663f1074","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","2cfc4b04-544f-11f1-92c7-ee650bb23af1","name","fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Initialize sample data\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS produkte (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n kategorie TEXT NOT NULL,\n preis REAL NOT NULL,\n bestand INTEGER NOT NULL,\n erstellt TEXT DEFAULT (date('now'))\n)`);\n\nconst count = await sqlite.execute(\"SELECT COUNT(*) as c FROM produkte\");\nif ((count.rows[0] as any).c === 0) {\n await sqlite.batch([\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Laptop Pro 15\", \"Elektronik\", 1299.99, 45] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Wireless Maus\", \"Elektronik\", 29.99, 230] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Schreibtischlampe\", \"Büro\", 49.95, 120] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Notizbuch A5\", \"Büro\", 8.50, 500] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Kaffeemaschine\", \"Küche\", 189.00, 35] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Wasserkocher\", \"Küche\", 39.99, 88] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"USB-C Kabel\", \"Elektronik\", 12.99, 400] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Bürostuhl Ergo\", \"Büro\", 399.00, 22] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Toaster\", \"Küche\", 34.50, 67] },\n { sql: \"INSERT INTO produkte (name, kategorie, preis, bestand) VALUES (?, ?, ?, ?)\", args: [\"Monitor 27 Zoll\", \"Elektronik\", 449.00, 18] },\n ]);\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // API endpoint for queries\n if (url.pathname === \"/api/query\") {\n const search = url.searchParams.get(\"search\") || \"\";\n const kategorie = url.searchParams.get(\"kategorie\") || \"\";\n const sortBy = url.searchParams.get(\"sort\") || \"name\";\n const order = url.searchParams.get(\"order\") || \"ASC\";\n const minPreis = url.searchParams.get(\"minPreis\") || \"\";\n const maxPreis = url.searchParams.get(\"maxPreis\") || \"\";\n\n let sql = \"SELECT * FROM produkte WHERE 1=1\";\n const args: any[] = [];\n\n if (search) {\n sql += \" AND name LIKE ?\";\n args.push(`%${search}%`);\n }\n if (kategorie) {\n sql += \" AND kategorie = ?\";\n args.push(kategorie);\n }\n if (minPreis) {\n sql += \" AND preis >= ?\";\n args.push(parseFloat(minPreis));\n }\n if (maxPreis) {\n sql += \" AND preis <= ?\";\n args.push(parseFloat(maxPreis));\n }\n\n const allowedCols = [\"name\", \"kategorie\", \"preis\", \"bestand\"];\n const col = allowedCols.includes(sortBy) ? sortBy : \"name\";\n const dir = order === \"DESC\" ? \"DESC\" : \"ASC\";\n sql += ` ORDER BY ${col} ${dir}`;\n\n const result = await sqlite.execute({ sql, args });\n\n const categories = await sqlite.execute(\"SELECT DISTINCT kategorie FROM produkte ORDER BY kategorie\");\n\n return Response.json({\n rows: result.rows,\n categories: categories.rows.map((r: any) => r.kategorie),\n total: result.rows.length,\n });\n }\n\n // Source redirect\n if (url.pathname === \"/source\") {\n return new Response(null, { status: 302, headers: { Location: parseVal().links.self.val } });\n }\n\n const html = `\n\n\n \n \n 🔍 Abfrage-Tool\n \n \n\n\n

🔍 Abfrage-Tool

Suche, filtere und sortiere Produktdaten in Echtzeit

\n\n \n

\n 🔎 Suche\n \n

\n 📁 Kategorie\n \n

\n 💰 Min. Preis (€)\n \n

\n 💰 Max. Preis (€)\n \n

\n ↕️ Sortieren nach\n \n

\n Reihenfolge\n \n

\n \n

\n\n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n

ID	Name	Kategorie	Preis	Bestand
Laden...

\n\n \n

\n\n \n\n`;\n\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n}\n","createdAt",["D",1779283445895],"branchVersion","branchId","13095692-544f-11f1-93be-ee650bb23af1","id","130882da-544f-11f1-93be-ee650bb23af1","abfrage-tool",["D",1779283402366],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Interaktives Abfrage-Tool zum Suchen und Filtern von Daten","imageUrl","1967e611-49ca-46d2-bfbc-3736b9dd8f76","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e458d-23e6-72fa-b847-06f5666b4cd9","tursoName","130882da544f11f193beee650bb23af1","tursoHostname","130882da544f11f193beee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789492855745],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":105},"org",{"_103":102,"_104":105,"_106":105,"_19":59,"_107":108,"_109":30},"branch",{"_13":92,"_37":93,"_47":46,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":49,"_101":102},"isOwned",10,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","doreentandetzki","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_47":48,"_37":49,"_42":154,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":155,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":156,"_87":157,"_89":158,"_91":30},"tree",[149],"files",[149],"counts",{"_139":66,"_140":14,"_141":66,"_142":143,"_144":145},"contents",[132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":133,"_37":33,"_35":36,"_134":-5,"_45":46,"_44":14,"_135":30,"_42":136,"_13":66,"_38":39,"_40":41,"_29":30,"_137":-5,"_32":138},"2cfc4a14-544f-11f1-92c7-ee650bb23af1","parentId","latest",["D",1779283445895],"label",[33],"pulls","branches","forks","envVars",{"_146":66,"_148":66},"connections",{"_146":66,"_147":66},"count","unfilledCount","emptyCount",{"_47":133,"_37":33,"_35":36,"_134":-5,"_45":46,"_44":14,"_135":30,"_42":150,"_13":66,"_38":39,"_40":41,"_29":30,"_137":-5,"_151":152,"_32":153},["D",1779283445895],"children",[],[33],["D",1779283402366],["D",1789492855745],{"_103":102,"_110":105},{"_103":102,"_104":105,"_106":105,"_19":59,"_107":108,"_109":30},{"_13":92,"_37":93,"_47":46,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":49,"_101":102},"ctx",{"_85":-5,"_129":192,"_193":194,"_195":196,"_197":30,"_198":30,"_199":30,"_200":62,"_201":-5,"_202":-7,"_203":-7,"_204":66,"_205":30,"_206":30,"_207":-5,"_208":30,"_209":30,"_210":30,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":93,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"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 · v1