[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":36,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":25,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","7edd5fda-277d-11f0-b46e-569c3dd06744","name","fileType","script","content","","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\n// Utility function to format date\nfunction formatDate(dateString) {\n return new Date(dateString).toLocaleString(\"ar-EG\", {\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n}\n\nfunction TweetDashboard() {\n const [tweets, setTweets] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n // Fetch tweets from server\n async function fetchTweets() {\n try {\n const response = await fetch(\"/tweets\");\n if (!response.ok) throw new Error(\"Failed to fetch tweets\");\n const data = await response.json();\n setTweets(data);\n setLoading(false);\n } catch (err) {\n setError(err.message);\n setLoading(false);\n }\n }\n\n // Trigger CSV download\n async function downloadCSV() {\n try {\n const response = await fetch(\"/export-csv\");\n const blob = await response.blob();\n const url = window.URL.createObjectURL(blob);\n const a = document.createElement(\"a\");\n a.style.display = \"none\";\n a.href = url;\n a.download = `sudanese_tweets_${new Date().toISOString().split(\"T\")[0]}.csv`;\n document.body.appendChild(a);\n a.click();\n window.URL.revokeObjectURL(url);\n } catch (err) {\n alert(\"Error downloading CSV: \" + err.message);\n }\n }\n\n useEffect(() => {\n fetchTweets();\n }, []);\n\n if (loading) return

Loading tweets...

;\n if (error) return

Error: {error}

;\n\n return (\n

🇸🇩 Sudanese Tweet Tracker

\n \n \n \n \n \n \n \n \n \n \n \n {tweets.map(tweet => (\n \n \n \n \n \n \n ))}\n \n

Username	Tweet Content	Date	Link
@{tweet.username}	{tweet.content}	{formatDate(tweet.created_at)}	\n \n 🔗 View Tweet\n \n

\n );\n}\n\nfunction App() {\n return ;\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"Twitter_Traker\";\n\n // Handle tweet fetching - NOW LIMITED TO 50 TWEETS\n if (new URL(request.url).pathname === \"/tweets\") {\n const results = await sqlite.execute(`SELECT * FROM ${KEY}_tweets ORDER BY created_at DESC LIMIT 50`);\n return new Response(JSON.stringify(results.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Handle CSV export\n if (new URL(request.url).pathname === \"/export-csv\") {\n const csvContent = await sqlite.execute(`SELECT * FROM ${KEY}_tweets ORDER BY created_at DESC LIMIT 50`);\n\n const csvHeader = \"ID,Content,Username,Created At,Link,Language\\n\";\n const csvRows = csvContent.rows.map(row =>\n `\"${row.id}\",\"${\n row.content.replace(/\"/g, \"\\\"\\\"\")\n }\",\"${row.username}\",\"${row.created_at}\",\"${row.link}\",\"${row.language}\"`\n ).join(\"\\n\");\n\n return new Response(csvHeader + csvRows, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": `attachment; filename=sudanese_tweets_${new Date().toISOString().split(\"T\")[0]}.csv`,\n },\n });\n }\n\n // Main page render\n return new Response(\n `\n \n \n Sudanese Tweet Tracker\n \n \n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}","createdAt",["D",1745873602245],"branchVersion","branchId","7edb49fc-277d-11f0-b46e-569c3dd06744","id","7edafc18-277d-11f0-b46e-569c3dd06744","Twitter_Traker",["D",1746208040114],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","868a74d0-23bc-11f0-9b13-dfe0c265f9b2","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","27564b47-0300-4649-a05d-e512f0629456","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",3,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","HajerOmer","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3S2ZkS0tiQTM0Tkc0VHZ4ZDVQYkpZc2luciJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":147,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":148,"_79":149,"_81":150,"_83":25},"tree",[142],"files",[142],"counts",{"_132":61,"_133":129,"_134":61,"_135":136,"_137":138},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"7ee3f200-277d-11f0-b46e-569c3dd06744","parentId","latest",["D",1745873602245],1,"label",[28],"pulls","branches","forks","envVars",{"_139":61,"_141":61},"connections",{"_139":61,"_140":61},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":143,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_144":145,"_27":146},["D",1745873602245],"children",[],[28],["D",1746208040114],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_121":184,"_185":186,"_187":188,"_189":25,"_190":25,"_191":25,"_192":57,"_193":-5,"_194":-7,"_195":-7,"_196":61,"_197":25,"_198":25,"_199":-5,"_200":25,"_201":25,"_202":25,"_203":-5},"ENV",{"_155":156,"_157":158,"_159":85,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"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 · v2