[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_166":167,"_168":169},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_125":-5,"_20":126,"_22":127,"_128":129,"_130":131,"_25":132,"_24":-5,"_133":-5,"_134":-5,"_135":54,"_136":137,"_138":45,"_139":-5,"_140":-5,"_141":142},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","g","name","csvViewer","branchName","main","version","path","","project",{"_34":72,"_13":14,"_46":73,"_74":-5,"_75":45,"_76":77,"_78":77,"_79":-5,"_80":-5,"_81":82,"_83":38,"_84":45,"_85":-5,"_86":-5,"_87":48,"_88":89,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":95,"_96":95,"_97":98,"_99":98,"_100":98,"_101":95,"_102":95,"_103":104,"_105":106,"_107":108,"_109":54},"tree",[63,64],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":60,"_17":48,"_49":24,"_51":61,"_53":54,"_55":-5,"_18":62},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","4639c746-2781-11f0-b46e-569c3dd06744","main.tsx","fileId","4639c7e6-2781-11f0-b46e-569c3dd06744","parentId","branchId","46372504-2781-11f0-b46e-569c3dd06744","branchVersion",1,"latest",true,"createdAt",["D",1724834742222],0,"fileType","http","content","/**\n * This application creates a CSV viewer using a Hono app that serves a client-side application.\n * It allows users to upload a CSV file, view its contents in a table format, and provides basic sorting functionality.\n * \n * The approach:\n * 1. Create a server-side Hono app to handle file uploads and serve the HTML, CSS, and JavaScript.\n * 2. Implement client-side JavaScript to handle file reading, parsing CSV, and displaying the data in a table.\n * 3. Add sorting functionality to allow users to sort the table by clicking on column headers.\n * \n * Libraries used:\n * - Hono for the server-side application\n * - Papa Parse (via esm.sh) for parsing CSV on the client-side\n */\n\nimport { serve } from 'https://esm.town/v/g/serveUtils';\nimport { Hono } from 'npm:hono';\n\nfunction html() {\n /*\n\n\n\n \n \n CSV Viewer\n \n \n\n\n

CSV Viewer

\n \n

\n\n\n */\n}\n\nfunction css() {\n /*\nbody {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n margin: 0;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.container {\n max-width: 800px;\n margin: 0 auto;\n background-color: #fff;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);\n}\n\nh1 {\n text-align: center;\n color: #333;\n}\n\ninput[type=\"file\"] {\n display: block;\n margin: 20px auto;\n}\n\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n}\n\nth, td {\n padding: 12px;\n text-align: left;\n border-bottom: 1px solid #ddd;\n}\n\nth {\n background-color: #f2f2f2;\n font-weight: bold;\n cursor: pointer;\n}\n\nth:hover {\n background-color: #e6e6e6;\n}\n\ntr:nth-child(even) {\n background-color: #f8f8f8;\n}\n\ntr:hover {\n background-color: #f0f0f0;\n}\n */\n}\n\nfunction js() {\n /*\nimport Papa from 'https://esm.sh/papaparse@5.4.1';\n\nconst fileInput = document.getElementById('csvFile');\nconst tableContainer = document.getElementById('tableContainer');\n\nlet currentData = [];\nlet currentHeaders = [];\n\nfileInput.addEventListener('change', handleFileUpload);\n\nfunction handleFileUpload(event) {\n const file = event.target.files[0];\n if (file) {\n Papa.parse(file, {\n complete: function(results) {\n currentData = results.data;\n currentHeaders = currentData[0];\n displayTable(currentData);\n }\n });\n }\n}\n\nfunction displayTable(data) {\n if (data.length === 0) return;\n\n const headers = data[0];\n const rows = data.slice(1);\n\n let tableHTML = '';\n headers.forEach(header => {\n tableHTML += ``;\n });\n tableHTML += '';\n\n rows.forEach(row => {\n tableHTML += '';\n row.forEach(cell => {\n tableHTML += ``;\n });\n tableHTML += '';\n });\n\n tableHTML += '

${header}
${cell}

';\n tableContainer.innerHTML = tableHTML;\n\n document.querySelectorAll('th').forEach(th => {\n th.addEventListener('click', () => sortTable(th.dataset.column));\n });\n}\n\nfunction sortTable(column) {\n const columnIndex = currentHeaders.indexOf(column);\n if (columnIndex === -1) return;\n\n const rows = currentData.slice(1);\n rows.sort((a, b) => {\n if (a[columnIndex] < b[columnIndex]) return -1;\n if (a[columnIndex] > b[columnIndex]) return 1;\n return 0;\n });\n\n displayTable([currentHeaders, ...rows]);\n}\n */\n}\n\nconst app = new Hono();\napp.get('/', serve(html, 'text/html'));\napp.get('/styles.css', serve(css, 'text/css'));\napp.get('/main.js', serve(js, 'text/javascript'));\n\nexport default app.fetch;","deleted",false,"label",[36],"4639f0c2-2781-11f0-b46e-569c3dd06744","README.md","4639f144-2781-11f0-b46e-569c3dd06744",["D",1724834742222],"client side csv viewer\n\nMigrated from folder: Apps/csvViewer",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":69,"_17":48,"_49":24,"_51":61,"_53":54,"_55":-5,"_66":70,"_18":71},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":65,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_66":67,"_18":68},["D",1724834742222],"children",[],[36],["D",1724834742222],[],[58],"4636d27a-2781-11f0-b46e-569c3dd06744",["D",1746209663072],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","8d6857d3-cf1c-4e98-a094-0e379c10badf","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","4f4797d6-1767-45ca-8dc5-5113174ca1c1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_124":120},"org",{"_11":12,"_118":-5,"_119":120,"_81":82,"_121":122,"_123":54},"branch",{"_17":43,"_13":16,"_34":41,"_110":72,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":14,"_117":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJqRlBqSjdFTUlTVmVORmpObmFqZmJLVWh5VCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":72,"_13":14,"_46":162,"_74":-5,"_75":45,"_76":77,"_78":77,"_79":-5,"_80":-5,"_81":82,"_83":38,"_84":45,"_85":-5,"_86":-5,"_87":48,"_88":89,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":95,"_96":95,"_97":98,"_99":98,"_100":98,"_101":95,"_102":95,"_103":163,"_105":164,"_107":165,"_109":54},[156,157],"files",[156,157],"counts",{"_147":48,"_148":43,"_149":48,"_31":150,"_151":152},[143,144],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":60,"_17":48,"_49":24,"_51":61,"_53":54,"_55":-5,"_18":146},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":145},[36],[58],"pulls","branches","forks",{"_153":48,"_155":48},"connections",{"_153":48,"_154":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":69,"_17":48,"_49":24,"_51":61,"_53":54,"_55":-5,"_66":160,"_18":161},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":65,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_66":158,"_18":159},[],[36],[],[58],["D",1746209663072],{"_11":12,"_124":120},{"_11":12,"_118":-5,"_119":120,"_81":82,"_121":122,"_123":54},{"_17":43,"_13":16,"_34":41,"_110":72,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":-5,"_116":14,"_117":12},"ctx",{"_103":-5,"_140":199,"_200":201,"_202":203,"_204":54,"_205":54,"_206":54,"_207":45,"_208":-5,"_209":-7,"_210":-7,"_211":48,"_212":54,"_213":54,"_214":-5,"_215":54,"_216":54,"_217":54,"_218":-5},"ENV",{"_170":171,"_172":173,"_174":16,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Code