[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_423":424,"_425":426},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":52,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",45,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/twitter-media-test.http.ts","latestPath","fileId","84232f08-8a7c-11f0-9716-0224a6c84d84","name","twitter-media-test.http.ts","fileType","http","content","import { initializeTwitterClient } from \"./twitter-api.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport { getPostById, getRecentPosts } from \"./database/queries.ts\";\nimport { TwitterMediaExtractor } from \"./twitter-media.ts\";\n\n/**\n * HTTP endpoint to test Twitter media extraction functionality\n * This endpoint allows testing and validation of the media extraction features\n */\nexport default async function (req: Request): Promise {\n // Check for basic auth\n const authHeader = req.headers.get(\"Authorization\");\n if (!authHeader || !authHeader.startsWith(\"Basic \")) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: { \"WWW-Authenticate\": \"Basic\" },\n });\n }\n\n const base64Credentials = authHeader.split(\" \")[1];\n const credentials = atob(base64Credentials);\n const [username, password] = credentials.split(\":\");\n\n const expectedUsername = Deno.env.get(\"AUTH_USERNAME\");\n const expectedPassword = Deno.env.get(\"AUTH_PASSWORD\");\n\n if (username !== expectedUsername || password !== expectedPassword) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: { \"WWW-Authenticate\": \"Basic\" },\n });\n }\n\n // Process the request\n try {\n const url = new URL(req.url);\n const action = url.searchParams.get(\"action\") || \"status\";\n\n // Initialize database\n await initializeDatabase();\n\n let responseData: any = {\n status: \"ok\",\n timestamp: new Date().toISOString(),\n };\n\n if (action === \"fetch-media\") {\n // Fetch tweets with media from Twitter API\n const twitterClient = initializeTwitterClient();\n const rawTweets = await twitterClient.fetchHomeTimeline(20);\n\n // Filter to only tweets with media\n const tweetsWithMedia = rawTweets.filter((tweet) =>\n tweet.media && tweet.media.length > 0\n );\n\n responseData = {\n ...responseData,\n action: \"fetch-media\",\n totalFetched: rawTweets.length,\n withMediaCount: tweetsWithMedia.length,\n mediaItems: tweetsWithMedia.map((tweet) => ({\n tweetId: tweet.external_id,\n author: tweet.author_username,\n mediaCount: tweet.media?.length || 0,\n media: tweet.media,\n })),\n };\n } else if (action === \"media-stats\") {\n // Get media statistics from database\n const limit = parseInt(url.searchParams.get(\"limit\") || \"50\", 10);\n const recentPosts = await getRecentPosts(limit);\n\n // Count media types\n const mediaStats = {\n totalPosts: recentPosts.length,\n postsWithMedia: 0,\n mediaTypes: {} as Record,\n totalMediaItems: 0,\n };\n\n for (const post of recentPosts) {\n if (post.media && post.media.length > 0) {\n mediaStats.postsWithMedia++;\n mediaStats.totalMediaItems += post.media.length;\n\n for (const media of post.media) {\n const type = media.media_type || \"unknown\";\n mediaStats.mediaTypes[type] = (mediaStats.mediaTypes[type] || 0) +\n 1;\n }\n }\n }\n\n responseData = {\n ...responseData,\n action: \"media-stats\",\n stats: mediaStats,\n };\n } else if (action === \"post-media\") {\n // Get media for a specific post\n const postId = parseInt(url.searchParams.get(\"id\") || \"0\", 10);\n\n if (!postId) {\n return new Response(\n JSON.stringify(\n {\n status: \"error\",\n message: \"Missing post ID parameter\",\n },\n null,\n 2,\n ),\n {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n const post = await getPostById(postId);\n\n if (!post) {\n return new Response(\n JSON.stringify(\n {\n status: \"error\",\n message: \"Post not found\",\n },\n null,\n 2,\n ),\n {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n responseData = {\n ...responseData,\n action: \"post-media\",\n post: {\n id: post.id,\n external_id: post.external_id,\n author: post.author_username,\n content: post.content.substring(0, 50) +\n (post.content.length > 50 ? \"...\" : \"\"),\n url: post.url,\n },\n mediaCount: post.media?.length || 0,\n media: post.media,\n };\n }\n\n return new Response(JSON.stringify(responseData, null, 2), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error: unknown) {\n console.error(\"Error in Twitter media test endpoint:\", error);\n\n return new Response(\n JSON.stringify(\n {\n status: \"error\",\n message: error instanceof Error ? error instanceof Error ? error.message : String(error) : String(error),\n timestamp: new Date().toISOString(),\n },\n null,\n 2,\n ),\n {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n}\n","createdAt",["D",1757092784576],"branchVersion","branchId","a93670de-55f2-11f0-8cdc-f69ea79377d9","id","a93616c0-55f2-11f0-8cdc-f69ea79377d9","offx",["D",1751316115780],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","da7efaa0-3a43-11f0-b284-7173a8a6f515","pinnedFileId","26935614-55f3-11f0-ab57-f69ea79377d9","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","f1d76965-949f-4699-906d-07e921194179","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",98,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jpd3v","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeGRlTk9ERTV0VzdNb2FqR0NxOGRuM0NlaTEifQ","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":419,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":420,"_80":421,"_82":422,"_84":24},"tree",[193,206,218,219,220,221,222],"files",[193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222],"counts",{"_183":139,"_184":62,"_185":139,"_186":187,"_188":189},"contents",[125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":177,"_31":178,"_29":179,"_135":-5,"_40":41,"_39":180,"_137":58,"_37":181,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_26":182},{"_42":172,"_31":173,"_29":174,"_135":-5,"_40":41,"_39":62,"_137":58,"_37":175,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_26":176},{"_42":165,"_31":166,"_29":167,"_135":-5,"_40":41,"_39":168,"_137":58,"_37":169,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_26":171},{"_42":158,"_31":159,"_29":160,"_135":-5,"_40":41,"_39":161,"_137":24,"_37":162,"_13":62,"_33":20,"_35":163,"_23":24,"_142":-5,"_26":164},{"_42":151,"_31":152,"_29":153,"_135":-5,"_40":41,"_39":154,"_137":24,"_37":155,"_13":139,"_33":20,"_35":156,"_23":24,"_142":-5,"_26":157},{"_42":144,"_31":145,"_29":146,"_135":-5,"_40":41,"_39":147,"_137":24,"_37":148,"_13":62,"_33":20,"_35":149,"_23":24,"_142":-5,"_26":150},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":138,"_13":139,"_33":140,"_35":141,"_23":24,"_142":-5,"_26":143},"269667fa-55f3-11f0-83aa-f69ea79377d9","setup-env.ts","2696689a-55f3-11f0-83aa-f69ea79377d9","parentId",8,"latest",["D",1751316326043],0,"script","// This script helps document the required environment variables for the OffX application\n// To set environment variables in Val Town, use the web interface or the Val Town CLI\n\nconsole.log(\"OffX Environment Variables Setup Guide\");\nconsole.log(\"======================================\");\nconsole.log(\n \"\\nThe following environment variables need to be set in Val Town:\",\n);\nconsole.log(\"\\n1. Twitter API credentials:\");\nconsole.log(\" - TWITTER_BEARER_TOKEN: Your Twitter API bearer token\");\nconsole.log(\"\\n2. OpenAI API credentials:\");\nconsole.log(\" - OPENAI_API_KEY: Your OpenAI API key\");\nconsole.log(\"\\n3. Dashboard authentication:\");\nconsole.log(\" - AUTH_USERNAME: Username for dashboard authentication\");\nconsole.log(\" - AUTH_PASSWORD: Password for dashboard authentication\");\nconsole.log(\"\\n4. Email configuration (optional):\");\nconsole.log(\" - EMAIL_TO: Email address to send summaries to\");\nconsole.log(\"\\n5. Discord configuration (optional):\");\nconsole.log(\n \" - DISCORD_WEBHOOK_URL: Discord webhook URL for sending summaries\",\n);\nconsole.log(\"\\nTo set these environment variables in Val Town:\");\nconsole.log(\"1. Go to your Val Town dashboard\");\nconsole.log(\"2. Navigate to the OffX val\");\nconsole.log(\"3. Click on 'Settings'\");\nconsole.log(\"4. Add each environment variable under 'Environment Variables'\");\nconsole.log(\n \"\\nAlternatively, you can use the Val Town CLI to set environment variables.\",\n);\n\n// Function to check if environment variables are set\nexport async function checkEnvironmentVariables() {\n const requiredVars = [\n \"TWITTER_BEARER_TOKEN\",\n \"OPENAI_API_KEY\",\n \"AUTH_USERNAME\",\n \"AUTH_PASSWORD\",\n ];\n const optionalVars = [\"EMAIL_TO\", \"DISCORD_WEBHOOK_URL\"];\n\n console.log(\"\\nChecking environment variables...\");\n\n // Check required variables\n console.log(\"\\nRequired variables:\");\n for (const varName of requiredVars) {\n const value = Deno.env.get(varName);\n if (value) {\n console.log(`✅ ${varName} is set`);\n } else {\n console.log(`❌ ${varName} is NOT set`);\n }\n }\n\n // Check optional variables\n console.log(\"\\nOptional variables:\");\n for (const varName of optionalVars) {\n const value = Deno.env.get(varName);\n if (value) {\n console.log(`✅ ${varName} is set`);\n } else {\n console.log(`⚠️ ${varName} is NOT set (optional)`);\n }\n }\n}\n\n// Run the check if this script is executed directly\nif (import.meta.main) {\n await checkEnvironmentVariables();\n}\n\nexport default { checkEnvironmentVariables };\n","label",[133],"fdfb29fa-56bc-11f0-9175-f69ea79377d9","deno.json","268f5456-55f3-11f0-9719-f69ea79377d9",29,["D",1751403016301],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"esnext\",\n \"deno.ns\"\n ],\n \"jsx\": \"react-jsx\",\n \"jsxImportSource\": \"https://esm.sh/react@18.2.0\"\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n },\n \"imports\": {\n \"react\": \"https://esm.sh/react@18.2.0\",\n \"react-dom\": \"https://esm.sh/react-dom@18.2.0\",\n \"react-router-dom\": \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\"\n }\n}",[145],"268c2e2a-55f3-11f0-a3d9-f69ea79377d9","README.md","268c2ede-55f3-11f0-a3d9-f69ea79377d9",5,["D",1751316326042],"# OffX - Twitter Feed Summarizer\n\nA Val Town application that summarizes your Twitter feed using AI.\n\n## Features\n\n- Fetch tweets from your Twitter home feed\n- Organize tweets by user-defined topics\n- Generate AI-powered summaries using OpenAI\n- Deliver summaries via email or Discord\n- Web dashboard for configuration and viewing summaries\n\n## Setup Instructions\n\n### Prerequisites\n\n- [Deno](https://deno.com/) installed\n- Val Town CLI installed: `deno install -grAf jsr:@valtown/vt`\n- Val Town account\n\n### Local Development\n\n1. Clone this repository:\n ```\n vt clone @yourusername/offx\n ```\n\n2. Navigate to the project directory:\n ```\n cd offx\n ```\n\n3. Make changes to the code as needed\n\n4. Push changes to Val Town:\n ```\n vt push\n ```\n\n### Environment Variables\n\nThe following environment variables need to be set in Val Town:\n\n- `TWITTER_BEARER_TOKEN`: Your Twitter API bearer token\n- `OPENAI_API_KEY`: Your OpenAI API key\n- `AUTH_USERNAME`: Username for dashboard authentication\n- `AUTH_PASSWORD`: Password for dashboard authentication\n\n## Project Structure\n\n```\noffx/\n├── backend/\n│ ├── database/ # SQLite database operations\n│ └── routes/ # API route handlers\n├── frontend/ # Frontend HTML, CSS, and JavaScript\n├── shared/ # Shared code between frontend and backend\n├── index.ts # Main entry point\n└── README.md # This file\n```\n\n## Deployment\n\nThis project is designed to run on Val Town. After pushing your code with `vt push`, you can access the application at:\n\n```\nhttps://val.town/v/yourusername/offx\n```\n\n## Development Commands\n\n- `vt push`: Push local changes to Val Town\n- `vt pull`: Pull the latest changes from Val Town\n- `vt status`: Show working tree status\n- `vt browse`: Open the Val in a web browser\n\n## License\n\nMIT ",[152],"06bfa4ee-55f5-11f0-ae75-f69ea79377d9",".vtignore","269ae6e0-55f3-11f0-aaf2-f69ea79377d9",13,["D",1751317131694],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor\n.taskmaster\n.roo\n.windsurfrules\n.cursor\n.gitignore\n.roomodes\nscripts\n.env.example",[159],"267864c6-55f3-11f0-ab57-f69ea79377d9","shared","267865ac-55f3-11f0-ab57-f69ea79377d9",3,["D",1751316325925],"directory",[166],"265c7ee6-55f3-11f0-894e-f69ea79377d9","frontend","265c7fb8-55f3-11f0-894e-f69ea79377d9",["D",1751316325744],[173],"266ad7e8-55f3-11f0-9719-f69ea79377d9","backend","266ad892-55f3-11f0-9719-f69ea79377d9",2,["D",1751316325838],[178],"pulls","branches","forks","envVars",{"_190":136,"_192":139},"connections",{"_190":139,"_191":139},"count","unfilledCount","emptyCount",{"_42":177,"_31":178,"_29":179,"_135":-5,"_40":41,"_39":180,"_137":58,"_37":416,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":417,"_26":418},{"_42":411,"_31":380,"_29":374,"_135":179,"_40":41,"_39":412,"_137":58,"_37":413,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":414,"_26":415},{"_42":404,"_31":152,"_29":405,"_135":374,"_40":41,"_39":406,"_137":58,"_37":407,"_13":139,"_33":20,"_35":408,"_23":24,"_142":-5,"_224":409,"_26":410},{"_42":396,"_31":397,"_29":398,"_135":374,"_40":41,"_39":399,"_137":58,"_37":400,"_13":139,"_33":140,"_35":401,"_23":24,"_142":-5,"_224":402,"_26":403},{"_42":389,"_31":351,"_29":390,"_135":374,"_40":41,"_39":391,"_137":58,"_37":392,"_13":139,"_33":140,"_35":393,"_23":24,"_142":-5,"_224":394,"_26":395},{"_42":381,"_31":382,"_29":383,"_135":374,"_40":41,"_39":384,"_137":58,"_37":385,"_13":139,"_33":140,"_35":386,"_23":24,"_142":-5,"_224":387,"_26":388},{"_42":371,"_31":372,"_29":373,"_135":374,"_40":41,"_39":375,"_137":58,"_37":376,"_13":139,"_33":140,"_35":377,"_23":24,"_142":-5,"_224":378,"_26":379},{"_42":364,"_31":365,"_29":366,"_135":179,"_40":41,"_39":367,"_137":58,"_37":368,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":369,"_26":370},{"_42":357,"_31":358,"_29":359,"_135":179,"_40":41,"_39":360,"_137":58,"_37":361,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":362,"_26":363},{"_42":350,"_31":351,"_29":56,"_135":179,"_40":41,"_39":352,"_137":24,"_37":353,"_13":322,"_33":34,"_35":354,"_23":24,"_142":-5,"_224":355,"_26":356},{"_42":342,"_31":343,"_29":344,"_135":179,"_40":41,"_39":345,"_137":58,"_37":346,"_13":139,"_33":34,"_35":347,"_23":24,"_142":-5,"_224":348,"_26":349},{"_42":338,"_31":32,"_29":30,"_135":179,"_40":41,"_39":14,"_137":58,"_37":339,"_13":139,"_33":34,"_35":36,"_23":24,"_142":-5,"_224":340,"_26":341},{"_42":329,"_31":330,"_29":331,"_135":179,"_40":41,"_39":332,"_137":58,"_37":333,"_13":139,"_33":334,"_35":335,"_23":24,"_142":-5,"_224":336,"_26":337},{"_42":172,"_31":173,"_29":174,"_135":-5,"_40":41,"_39":62,"_137":58,"_37":326,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":327,"_26":328},{"_42":321,"_31":264,"_29":258,"_135":174,"_40":41,"_39":322,"_137":58,"_37":323,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":324,"_26":325},{"_42":313,"_31":314,"_29":315,"_135":258,"_40":41,"_39":316,"_137":24,"_37":317,"_13":139,"_33":140,"_35":318,"_23":24,"_142":-5,"_224":319,"_26":320},{"_42":305,"_31":306,"_29":307,"_135":258,"_40":41,"_39":308,"_137":58,"_37":309,"_13":139,"_33":140,"_35":310,"_23":24,"_142":-5,"_224":311,"_26":312},{"_42":297,"_31":298,"_29":299,"_135":258,"_40":41,"_39":300,"_137":24,"_37":301,"_13":139,"_33":140,"_35":302,"_23":24,"_142":-5,"_224":303,"_26":304},{"_42":289,"_31":290,"_29":291,"_135":258,"_40":41,"_39":292,"_137":24,"_37":293,"_13":139,"_33":140,"_35":294,"_23":24,"_142":-5,"_224":295,"_26":296},{"_42":281,"_31":282,"_29":283,"_135":258,"_40":41,"_39":284,"_137":58,"_37":285,"_13":139,"_33":140,"_35":286,"_23":24,"_142":-5,"_224":287,"_26":288},{"_42":273,"_31":274,"_29":275,"_135":258,"_40":41,"_39":276,"_137":24,"_37":277,"_13":139,"_33":140,"_35":278,"_23":24,"_142":-5,"_224":279,"_26":280},{"_42":265,"_31":266,"_29":267,"_135":258,"_40":41,"_39":268,"_137":24,"_37":269,"_13":139,"_33":140,"_35":270,"_23":24,"_142":-5,"_224":271,"_26":272},{"_42":255,"_31":256,"_29":257,"_135":258,"_40":41,"_39":259,"_137":24,"_37":260,"_13":139,"_33":140,"_35":261,"_23":24,"_142":-5,"_224":262,"_26":263},{"_42":247,"_31":248,"_29":249,"_135":174,"_40":41,"_39":250,"_137":58,"_37":251,"_13":168,"_33":20,"_35":252,"_23":24,"_142":-5,"_224":253,"_26":254},{"_42":239,"_31":240,"_29":241,"_135":174,"_40":41,"_39":242,"_137":24,"_37":243,"_13":139,"_33":140,"_35":244,"_23":24,"_142":-5,"_224":245,"_26":246},{"_42":165,"_31":166,"_29":167,"_135":-5,"_40":41,"_39":168,"_137":58,"_37":236,"_13":139,"_33":170,"_35":-5,"_23":24,"_142":-5,"_224":237,"_26":238},{"_42":158,"_31":159,"_29":160,"_135":-5,"_40":41,"_39":161,"_137":24,"_37":233,"_13":62,"_33":20,"_35":163,"_23":24,"_142":-5,"_224":234,"_26":235},{"_42":151,"_31":152,"_29":153,"_135":-5,"_40":41,"_39":154,"_137":24,"_37":230,"_13":139,"_33":20,"_35":156,"_23":24,"_142":-5,"_224":231,"_26":232},{"_42":144,"_31":145,"_29":146,"_135":-5,"_40":41,"_39":147,"_137":24,"_37":227,"_13":62,"_33":20,"_35":149,"_23":24,"_142":-5,"_224":228,"_26":229},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":223,"_13":139,"_33":140,"_35":141,"_23":24,"_142":-5,"_224":225,"_26":226},["D",1751316326043],"children",[],[133],["D",1751403016301],[],[145],["D",1751316326042],[],[152],["D",1751317131694],[],[159],["D",1751316325925],[],[166],"fde87d96-56bc-11f0-b92d-f69ea79377d9","index.tsx","fde87e54-56bc-11f0-b92d-f69ea79377d9",26,["D",1751403016174],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n BrowserRouter,\n Navigate,\n Route,\n Routes,\n} from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\nimport App from \"./components/App.tsx\";\nimport LoginPage from \"./components/LoginPage.tsx\";\nimport Dashboard from \"./components/Dashboard.tsx\";\nimport { AuthProvider, RequireAuth } from \"./components/AuthContext.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\n\nroot.render(\n \n \n \n \n }>\n } />\n \n \n \n }\n />\n } />\n \n \n \n \n ,\n);\n",[],[173,240],"fdecd9b8-56bc-11f0-b053-f69ea79377d9","index.html","268930b2-55f3-11f0-a013-f69ea79377d9",27,["D",1751403016237],"\n\n\n \n \n OffX - Twitter Feed Summarizer\n \n \n\n\n

\n \n\n ",[],[173,248],"83e53360-8a7c-11f0-81bc-0224a6c84d84","TopicManagement.tsx","83e5340a-8a7c-11f0-81bc-0224a6c84d84","069859e8-55f5-11f0-9cfc-f69ea79377d9",36,["D",1757092784144],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { useQuery, useMutation, useQueryClient } from \"https://esm.sh/@tanstack/react-query@4.29.5\";\n\n// Types\ninterface Topic {\n id: number;\n title: string;\n description?: string;\n created_at: string;\n updated_at: string;\n}\n\ninterface CreateTopicData {\n title: string;\n description?: string;\n}\n\ninterface UpdateTopicData {\n title?: string;\n description?: string;\n}\n\n// API functions\nconst API_BASE = \"/api\";\n\nconst fetchTopics = async (): Promise => {\n const response = await fetch(`${API_BASE}/topics`);\n if (!response.ok) {\n throw new Error(\"Failed to fetch topics\");\n }\n return response.json();\n};\n\nconst createTopic = async (data: CreateTopicData): Promise => {\n const response = await fetch(`${API_BASE}/topics`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(data),\n });\n if (!response.ok) {\n throw new Error(\"Failed to create topic\");\n }\n return response.json();\n};\n\nconst updateTopic = async (id: number, data: UpdateTopicData): Promise => {\n const response = await fetch(`${API_BASE}/topics/${id}`, {\n method: \"PUT\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(data),\n });\n if (!response.ok) {\n throw new Error(\"Failed to update topic\");\n }\n return response.json();\n};\n\nconst deleteTopic = async (id: number): Promise => {\n const response = await fetch(`${API_BASE}/topics/${id}`, {\n method: \"DELETE\",\n });\n if (!response.ok) {\n throw new Error(\"Failed to delete topic\");\n }\n};\n\nexport default function TopicManagement() {\n const queryClient = useQueryClient();\n const [showCreateForm, setShowCreateForm] = useState(false);\n const [editingTopic, setEditingTopic] = useState(null);\n const [deleteConfirm, setDeleteConfirm] = useState(null);\n\n // Query for topics\n const {\n data: topics = [],\n isLoading,\n error,\n } = useQuery({\n queryKey: [\"topics\"],\n queryFn: fetchTopics,\n });\n\n // Mutations\n const createMutation = useMutation({\n mutationFn: createTopic,\n onSuccess: () => {\n queryClient.invalidateQueries({ queryKey: [\"topics\"] });\n setShowCreateForm(false);\n },\n });\n\n const updateMutation = useMutation({\n mutationFn: ({ id, data }: { id: number; data: UpdateTopicData }) =>\n updateTopic(id, data),\n onSuccess: () => {\n queryClient.invalidateQueries({ queryKey: [\"topics\"] });\n setEditingTopic(null);\n },\n });\n\n const deleteMutation = useMutation({\n mutationFn: deleteTopic,\n onSuccess: () => {\n queryClient.invalidateQueries({ queryKey: [\"topics\"] });\n setDeleteConfirm(null);\n },\n });\n\n // Form handlers\n const handleCreateSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n const formData = new FormData(e.currentTarget);\n const title = formData.get(\"title\") as string;\n const description = formData.get(\"description\") as string;\n\n if (!title.trim()) return;\n\n createMutation.mutate({\n title: title.trim(),\n description: description.trim() || undefined,\n });\n };\n\n const handleUpdateSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (!editingTopic) return;\n\n const formData = new FormData(e.currentTarget);\n const title = formData.get(\"title\") as string;\n const description = formData.get(\"description\") as string;\n\n updateMutation.mutate({\n id: editingTopic.id,\n data: {\n title: title.trim(),\n description: description.trim() || undefined,\n },\n });\n };\n\n const handleDelete = (id: number) => {\n deleteMutation.mutate(id);\n };\n\n if (isLoading) {\n return (\n

\n );\n }\n\n if (error) {\n return (\n

Error Loading Topics

{error instanceof Error ? error.message : \"Unknown error occurred\"}

\n );\n }\n\n return (\n

Topic Management

\n setShowCreateForm(true)}\n className=\"bg-blue-500 hover:bg-blue-600 text-white px-4 py-2 rounded-lg transition-colors\"\n >\n Add Topic\n \n

\n\n {/* Create Form Modal */}\n {showCreateForm && (\n

Create New Topic

\n \n {createMutation.error && (\n

\n Error: {createMutation.error.message || \"Failed to create topic\"}\n

\n )}\n

\n )}\n\n {/* Edit Form Modal */}\n {editingTopic && (\n

Edit Topic

\n \n {updateMutation.error && (\n

\n Error: {updateMutation.error.message || \"Failed to update topic\"}\n

\n )}\n

\n )}\n\n {/* Delete Confirmation Modal */}\n {deleteConfirm && (\n

Confirm Delete

Are you sure you want to delete this topic? This action cannot be undone.

\n handleDelete(deleteConfirm)}\n disabled={deleteMutation.isLoading}\n className=\"flex-1 bg-red-500 hover:bg-red-600 disabled:bg-red-300 text-white py-2 rounded-md transition-colors\"\n >\n {deleteMutation.isLoading ? \"Deleting...\" : \"Delete\"}\n \n setDeleteConfirm(null)}\n className=\"flex-1 bg-gray-300 hover:bg-gray-400 text-gray-800 py-2 rounded-md transition-colors\"\n >\n Cancel\n \n

\n {deleteMutation.error && (\n

\n Error: {deleteMutation.error.message || \"Failed to delete topic\"}\n

\n )}\n

\n )}\n\n {/* Topics List */}\n {topics.length === 0 ? (\n

No topics created yet

Get started by creating your first topic!

\n ) : (\n

\n {topics.map((topic) => (\n

{topic.title}

\n #{topic.id}\n

\n \n {topic.description && (\n

{topic.description}

\n )}\n \n

\n Created: {new Date(topic.created_at).toLocaleDateString()}\n {topic.updated_at !== topic.created_at && (\n <>\n
\n Updated: {new Date(topic.updated_at).toLocaleDateString()}\n \n )}\n

\n \n

\n setEditingTopic(topic)}\n className=\"text-blue-500 hover:text-blue-700 text-sm font-medium transition-colors\"\n >\n Edit\n \n setDeleteConfirm(topic.id)}\n className=\"text-red-500 hover:text-red-700 text-sm font-medium transition-colors\"\n >\n Delete\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[173,264,256],"components","83d4e1d6-8a7c-11f0-9d13-0224a6c84d84","SummaryDetailView.tsx","83d4e280-8a7c-11f0-9d13-0224a6c84d84",34,["D",1757092784074],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport {\n useNavigate,\n useParams,\n} from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\nimport {\n useQuery,\n useQueryClient,\n} from \"https://esm.sh/@tanstack/react-query@4.29.5\";\nimport ReactMarkdown from \"https://esm.sh/react-markdown@8.0.7\";\n\ninterface Summarization {\n id: number;\n topic_id: number;\n content: string;\n prompt: string;\n post_count: number;\n created_at: string;\n time_period_start: string;\n time_period_end: string;\n topic_title?: string;\n}\n\ninterface SummarizationResponse {\n data: Summarization;\n}\n\nconst API_BASE = \"/api\";\n\nexport default function SummaryDetailView() {\n const { id } = useParams<{ id: string }>();\n const navigate = useNavigate();\n const queryClient = useQueryClient();\n const [isRegenerating, setIsRegenerating] = useState(false);\n const [regenerateMessage, setRegenerateMessage] = useState(\n null,\n );\n\n // Fetch the specific summarization\n const { data: summarizationData, isLoading, error } = useQuery<\n SummarizationResponse\n >({\n queryKey: [\"summarization\", id],\n queryFn: async () => {\n if (!id) {\n throw new Error(\"No summarization ID provided\");\n }\n\n const response = await fetch(`${API_BASE}/summarizations/${id}`, {\n headers: {\n \"Authorization\": `Basic ${\n btoa(\n `${localStorage.getItem(\"auth_username\")}:${\n localStorage.getItem(\"auth_password\")\n }`,\n )\n }`,\n },\n });\n\n if (!response.ok) {\n if (response.status === 404) {\n throw new Error(\"Summarization not found\");\n }\n throw new Error(\"Failed to fetch summarization\");\n }\n\n return response.json();\n },\n enabled: !!id, // Only run the query if we have an ID\n });\n\n const handleBack = () => {\n navigate(\"/dashboard\");\n };\n\n const handleRegenerate = async () => {\n if (!summarizationData?.data?.id) {\n setRegenerateMessage(\"Cannot regenerate: summarization ID not available\");\n return;\n }\n\n setIsRegenerating(true);\n setRegenerateMessage(null);\n\n try {\n const response = await fetch(\n `${API_BASE}/summarizations/${summarizationData.data.id}/regenerate`,\n {\n method: \"POST\",\n headers: {\n \"Authorization\": `Basic ${\n btoa(\n `${localStorage.getItem(\"auth_username\")}:${\n localStorage.getItem(\"auth_password\")\n }`,\n )\n }`,\n \"Content-Type\": \"application/json\",\n },\n },\n );\n\n const result = await response.json();\n\n if (!response.ok) {\n throw new Error(result.message || \"Failed to regenerate summary\");\n }\n\n if (result.status === \"success\") {\n setRegenerateMessage(\n \"✅ Summary regenerated successfully! Refreshing...\",\n );\n\n // Invalidate queries to refetch updated data\n await queryClient.invalidateQueries([\"summarization\", id]);\n await queryClient.invalidateQueries([\"summarizations\"]);\n\n setTimeout(() => {\n setRegenerateMessage(null);\n }, 3000);\n } else if (result.status === \"no_data\") {\n setRegenerateMessage(\n \"⚠️ No recent posts found to regenerate summary from\",\n );\n } else {\n setRegenerateMessage(\n `❌ ${result.message || \"Failed to regenerate summary\"}`,\n );\n }\n } catch (error) {\n console.error(\"Error regenerating summary:\", error);\n setRegenerateMessage(\n `❌ Error: ${\n error instanceof Error ? error.message : \"Unknown error occurred\"\n }`,\n );\n } finally {\n setIsRegenerating(false);\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n };\n\n if (isLoading) {\n return (\n

\n );\n }\n\n if (error) {\n return (\n

\n \n ← Back to Summaries\n \n

\n\n

Error loading summarization

\n {error instanceof Error ? error.message : \"Unknown error occurred\"}\n

\n );\n }\n\n if (!summarizationData) {\n return (\n

\n \n ← Back to Summaries\n \n

\n\n

No summarization found.

\n );\n }\n\n const summarization = summarizationData.data;\n\n return (\n

\n {/* Navigation */}\n

\n \n ← Back to Summaries\n \n

\n\n {/* Header */}\n

\n {summarization.topic_title || `Topic ${summarization.topic_id}`}\n

\n\n

\n Created: {formatDate(summarization.created_at)}\n Posts: {summarization.post_count}\n \n Period: {formatDate(summarization.time_period_start)} -{\" \"}\n {formatDate(summarization.time_period_end)}\n \n

\n\n {/* Content */}\n

Summary Content

\n {summarization.content\n ? (\n (\n

\n {children}\n

\n ),\n h2: ({ children }) => (\n

\n {children}\n

\n ),\n h3: ({ children }) => (\n

\n {children}\n

\n ),\n p: ({ children }) => (\n

\n {children}\n

\n ),\n ul: ({ children }) => (\n

\n {children}\n \n ),\n ol: ({ children }) => (\n

\n {children}\n \n ),\n li: ({ children }) =>

{children}

,\n a: ({ href, children }) => (\n \n {children}\n \n ),\n img: ({ src, alt }) => (\n

\n {\n const target = e.target as HTMLImageElement;\n target.style.display = \"none\";\n const errorDiv = document.createElement(\"div\");\n errorDiv.className =\n \"text-gray-500 italic text-sm border border-gray-200 p-3 rounded\";\n errorDiv.textContent = `Failed to load image: ${\n alt || src\n }`;\n target.parentNode?.insertBefore(errorDiv, target);\n }}\n />\n

\n ),\n blockquote: ({ children }) => (\n

\n {children}\n

\n ),\n code: ({ children, inline }) => (\n inline\n ? (\n \n {children}\n \n )\n : (\n \n {children}\n \n )\n ),\n }}\n >\n {summarization.content}\n \n )\n :

No content available

}\n

\n\n {/* Additional media support for embedded tweets, videos, etc. */}\n

\n {/* Look for tweet URLs and render them with appropriate styling */}\n {summarization.content &&\n /https:\\/\\/(?:x|twitter)\\.com\\/\\w+\\/status\\/\\d+/.test(\n summarization.content,\n ) && (\n

🐦 Twitter Links Detected

\n This summary contains Twitter/X post links. Click the links\n above to view the original posts.\n

\n )}\n\n {/* Look for YouTube URLs */}\n {summarization.content &&\n /https:\\/\\/(?:www\\.)?(?:youtube\\.com\\/watch\\?v=|youtu\\.be\\/)[\\w-]+/\n .test(summarization.content) &&\n (\n

📺 YouTube Links Detected

\n This summary contains YouTube video links. Click the links\n above to view the videos.\n

\n )}\n\n {/* Look for image URLs */}\n {summarization.content &&\n /https?:\\/\\/[^\\s]+\\.(?:jpg|jpeg|png|gif|webp)/i.test(\n summarization.content,\n ) && (\n

🖼️ Images Detected

\n This summary contains image links that should be displayed\n above.\n

\n )}\n

\n\n {/* Actions */}\n

\n {regenerateMessage && (\n \n {regenerateMessage}\n

\n )}\n\n

\n \n {isRegenerating\n ? (\n \n \n \n \n \n \n \n Regenerating...\n \n )\n : (\n \"Re-run Summarization\"\n )}\n \n

\n \n );\n}\n",[],[173,264,266],"83fee1ca-8a7c-11f0-b5d4-0224a6c84d84","SummarizationsList.tsx","83fee2ce-8a7c-11f0-b5d4-0224a6c84d84",39,["D",1757092784182],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { useQuery } from \"https://esm.sh/@tanstack/react-query@4.29.5\";\nimport { useNavigate } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\nimport ReactPaginate from \"https://esm.sh/react-paginate@8.2.0\";\n\ninterface Summarization {\n id: number;\n topic_id: number;\n content: string;\n prompt: string;\n post_count: number;\n created_at: string;\n time_period_start: string;\n time_period_end: string;\n topic_title?: string;\n}\n\ninterface PaginationInfo {\n page: number;\n limit: number;\n totalCount: number;\n totalPages: number;\n hasNext: boolean;\n hasPrev: boolean;\n}\n\ninterface SummarizationsResponse {\n data: Summarization[];\n pagination: PaginationInfo;\n}\n\nconst API_BASE = \"/api\";\n\nexport default function SummarizationsList() {\n const [currentPage, setCurrentPage] = useState(1);\n const [searchTerm, setSearchTerm] = useState(\"\");\n const [selectedTopicId, setSelectedTopicId] = useState(\"\");\n const navigate = useNavigate();\n const itemsPerPage = 10;\n\n // Fetch summarizations with pagination\n const { data: summarizationsData, isLoading, error } = useQuery({\n queryKey: [\"summarizations\", currentPage, selectedTopicId, searchTerm],\n queryFn: async () => {\n const params = new URLSearchParams({\n page: currentPage.toString(),\n limit: itemsPerPage.toString(),\n });\n \n if (selectedTopicId) {\n params.append(\"topic_id\", selectedTopicId);\n }\n \n if (searchTerm) {\n params.append(\"search\", searchTerm);\n }\n\n const response = await fetch(`${API_BASE}/summarizations?${params}`, {\n headers: {\n 'Authorization': `Basic ${btoa(`${localStorage.getItem('auth_username')}:${localStorage.getItem('auth_password')}`)}`,\n },\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to fetch summarizations\");\n }\n \n return response.json();\n },\n });\n\n // Fetch topics for filter dropdown\n const { data: topicsData } = useQuery({\n queryKey: [\"topics\"],\n queryFn: async () => {\n const response = await fetch(`${API_BASE}/topics`, {\n headers: {\n 'Authorization': `Basic ${btoa(`${localStorage.getItem('auth_username')}:${localStorage.getItem('auth_password')}`)}`,\n },\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to fetch topics\");\n }\n \n return response.json();\n },\n });\n\n const handlePageChange = (selectedItem: { selected: number }) => {\n setCurrentPage(selectedItem.selected + 1);\n };\n\n const handleSearchChange = (e: React.ChangeEvent) => {\n setSearchTerm(e.target.value);\n setCurrentPage(1); // Reset to first page when searching\n };\n\n const handleTopicFilterChange = (e: React.ChangeEvent) => {\n setSelectedTopicId(e.target.value);\n setCurrentPage(1); // Reset to first page when filtering\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString(\"en-US\", {\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n });\n };\n\n const getExcerpt = (content: string, maxLength: number = 150) => {\n if (content.length <= maxLength) return content;\n return content.substring(0, maxLength) + \"...\";\n };\n\n const handleViewDetails = (summarizationId: number) => {\n navigate(`/summary/${summarizationId}`);\n };\n\n if (isLoading) {\n return (\n

\n {[...Array(5)].map((_, i) => (\n

\n ))}\n

\n );\n }\n\n if (error) {\n return (\n

Error loading summarizations

{error instanceof Error ? error.message : \"Unknown error occurred\"}

\n );\n }\n\n const summarizations = summarizationsData?.data || [];\n const pagination = summarizationsData?.pagination;\n\n return (\n

Summarizations

\n \n {/* Search and Filter Controls */}\n

\n \n

\n \n \n {topicsData?.data?.map((topic: any) => (\n \n ))}\n \n

\n\n {/* Summarizations List */}\n {summarizations.length === 0 ? (\n

No summarizations found.

\n {(searchTerm || selectedTopicId) && (\n {\n setSearchTerm(\"\");\n setSelectedTopicId(\"\");\n setCurrentPage(1);\n }}\n className=\"mt-2 text-blue-600 hover:text-blue-800\"\n >\n Clear filters\n \n )}\n

\n ) : (\n

\n {summarizations.map((summarization) => (\n \n

\n {summarization.topic_title || `Topic ${summarization.topic_id}`}\n

\n {formatDate(summarization.created_at)} • {summarization.post_count} posts\n

\n handleViewDetails(summarization.id)}\n className=\"bg-blue-500 hover:bg-blue-600 text-white px-3 py-1 rounded text-sm\"\n >\n View Details\n \n

\n \n

\n {getExcerpt(summarization.content)}\n

\n \n

\n Period: {formatDate(summarization.time_period_start)} - {formatDate(summarization.time_period_end)}\n

\n ))}\n

\n )}\n\n {/* Pagination */}\n {pagination && pagination.totalPages > 1 && (\n

\n \n

\n )}\n\n {/* Results Summary */}\n {pagination && (\n

\n Showing {Math.min((currentPage - 1) * itemsPerPage + 1, pagination.totalCount)} to{\" \"}\n {Math.min(currentPage * itemsPerPage, pagination.totalCount)} of {pagination.totalCount} results\n

\n )}\n \n );\n}",[],[173,264,274],"fe22a7c8-56bc-11f0-8697-f69ea79377d9","LoginPage.tsx","fe22a8ea-56bc-11f0-8697-f69ea79377d9",30,["D",1751403016145],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport {\n useLocation,\n useNavigate,\n} from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\nimport { useAuth } from \"./AuthContext.tsx\";\n\ninterface LocationState {\n from?: {\n pathname: string;\n };\n}\n\nexport default function LoginPage() {\n const navigate = useNavigate();\n const location = useLocation();\n const auth = useAuth();\n\n const [username, setUsername] = useState(\"\");\n const [password, setPassword] = useState(\"\");\n const [error, setError] = useState(\"\");\n const [loading, setLoading] = useState(false);\n\n const locationState = location.state as LocationState;\n const from = locationState?.from?.pathname || \"/dashboard\";\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n setLoading(true);\n\n try {\n const result = await auth.signin(username, password);\n\n if (result) {\n // Send them back to the page they tried to visit when they were\n // redirected to the login page. Use { replace: true } so we don't create\n // another entry in the history stack for the login page.\n navigate(from, { replace: true });\n } else {\n setError(\"Invalid username or password\");\n }\n } catch (error) {\n setError(\"An unexpected error occurred. Please try again.\");\n console.error(\"Login error:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n // If user is already logged in, redirect to dashboard\n React.useEffect(() => {\n if (auth.user) {\n navigate(\"/dashboard\", { replace: true });\n }\n }, [auth.user, navigate]);\n\n return (\n

Welcome to OffX

\n This application helps you summarize your Twitter feed using AI.\n

\n\n

Dashboard Access

\n Login to access your dashboard and manage your summaries.\n

\n\n \n

\n );\n}\n",[],[173,264,282],"fde197e2-56bc-11f0-b7ab-f69ea79377d9","Dashboard.tsx","fde198a0-56bc-11f0-b7ab-f69ea79377d9",24,["D",1751403016132],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { useAuth } from \"./AuthContext.tsx\";\nimport { useNavigate } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\n\nexport default function Dashboard() {\n const auth = useAuth();\n const navigate = useNavigate();\n\n const handleLogout = () => {\n auth.signout();\n navigate(\"/\");\n };\n\n return (\n

Dashboard

Welcome, {auth.user}!

\n \n

\n\n

Dashboard

\n Welcome to the protected dashboard area. This page is only accessible\n with valid credentials.\n

You've successfully authenticated!

\n\n

Recent Summaries

No summaries generated yet.

\n\n

Topics

No topics created yet.

\n );\n}\n",[],[173,264,290],"83dde2a4-8a7c-11f0-af15-0224a6c84d84","Configuration.tsx","83dde36c-8a7c-11f0-af15-0224a6c84d84",35,["D",1757092784133],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { useQuery } from \"https://esm.sh/@tanstack/react-query@4.29.5\";\n\n// Types\ninterface AppConfiguration {\n email: {\n enabled: boolean;\n recipientEmail: string | null;\n frequency: string;\n maxSummaries: number;\n jobNotifications: boolean;\n adminEmail: string | null;\n };\n twitter: {\n summarization: {\n timeWindowHours: number;\n maxTweets: number;\n includeMedia: boolean;\n includeSentiment: boolean;\n emailNotifications: boolean;\n };\n filtering: {\n keywords: string[];\n excludeKeywords: string[];\n };\n };\n\n system: {\n environment: string;\n lastUpdated: string;\n };\n}\n\ninterface SystemStatus {\n services: {\n database: { status: string; message: string };\n email: { status: string; message: string };\n twitter: { status: string; message: string };\n };\n configuration: {\n requiredEnvVars: { [key: string]: boolean };\n optionalEnvVars: { [key: string]: boolean };\n };\n lastChecked: string;\n}\n\n// API functions\nconst API_BASE = \"/api\";\n\nconst fetchConfiguration = async (): Promise => {\n const response = await fetch(`${API_BASE}/config`);\n if (!response.ok) {\n throw new Error(\"Failed to fetch configuration\");\n }\n return response.json();\n};\n\nconst fetchSystemStatus = async (): Promise => {\n const response = await fetch(`${API_BASE}/config/status`);\n if (!response.ok) {\n throw new Error(\"Failed to fetch system status\");\n }\n return response.json();\n};\n\n// Helper components\nconst StatusBadge: React.FC<{ status: string }> = ({ status }) => {\n const getStatusColor = (status: string) => {\n switch (status.toLowerCase()) {\n case \"healthy\":\n case \"configured\":\n return \"bg-green-100 text-green-800\";\n case \"disabled\":\n return \"bg-yellow-100 text-yellow-800\";\n case \"unhealthy\":\n case \"misconfigured\":\n return \"bg-red-100 text-red-800\";\n default:\n return \"bg-gray-100 text-gray-800\";\n }\n };\n\n return (\n \n {status}\n \n );\n};\n\nconst ConfigSection: React.FC<{ title: string; children: React.ReactNode }> = ({ title, children }) => (\n

{title}

\n {children}\n

\n);\n\nconst ConfigRow: React.FC<{ label: string; value: React.ReactNode; description?: string }> = ({ \n label, \n value, \n description \n}) => (\n

{label}

\n {description &&

{description}

}\n

{value}

\n);\n\nexport default function Configuration() {\n const {\n data: config,\n isLoading: configLoading,\n error: configError,\n } = useQuery({\n queryKey: [\"configuration\"],\n queryFn: fetchConfiguration,\n refetchInterval: 30000, // Refresh every 30 seconds\n });\n\n const {\n data: status,\n isLoading: statusLoading,\n error: statusError,\n } = useQuery({\n queryKey: [\"system-status\"],\n queryFn: fetchSystemStatus,\n refetchInterval: 30000, // Refresh every 30 seconds\n });\n\n if (configLoading || statusLoading) {\n return (\n

\n {[1, 2, 3, 4].map((i) => (\n

\n ))}\n

\n );\n }\n\n if (configError || statusError) {\n return (\n

Error Loading Configuration

{configError?.message || statusError?.message || \"Unknown error occurred\"}

\n );\n }\n\n if (!config || !status) {\n return (\n

No configuration data available

\n );\n }\n\n return (\n

\n {/* Header */}\n

System Configuration

\n Current application settings and system status\n

\n Last updated: {new Date(config.system.lastUpdated).toLocaleString()}\n

\n Environment: {config.system.environment}\n

\n\n {/* System Status */}\n \n

\n }\n description={status.services.database.message}\n />\n }\n description={status.services.email.message}\n />\n }\n description={status.services.twitter.message}\n />\n \n \n\n {/* Email Configuration */}\n \n

\n \n \n \n \n \n \n \n \n\n {/* Twitter & Summarization */}\n \n

\n \n \n \n \n \n \n \n\n {/* Filtering */}\n \n

\n 0\n ? config.twitter.filtering.keywords.join(\", \")\n : \"None\"\n }\n description=\"Only process tweets containing these keywords\"\n />\n 0\n ? config.twitter.filtering.excludeKeywords.join(\", \")\n : \"None\"\n }\n description=\"Skip tweets containing these keywords\"\n />\n \n \n\n\n {/* Environment Variables Status */}\n \n

Required Variables

{key}: \n \n {configured ? \"Set\" : \"Missing\"}\n \n

Optional Variables

{key}: \n \n {configured ? \"Set\" : \"Default\"}\n \n

\n \n\n {/* Help Text */}\n

\n \n

Configuration Management

\n To modify these settings, update the environment variables in Val Town's interface. \n Changes will be reflected here after the next restart or refresh.\n

\n );\n}",[],[173,264,298],"fde4fd38-56bc-11f0-aabd-f69ea79377d9","AuthContext.tsx","fde4fdec-56bc-11f0-aabd-f69ea79377d9",25,["D",1751403016176],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, {\n createContext,\n useContext,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport {\n Navigate,\n useLocation,\n} from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\n\ninterface AuthContextType {\n user: string | null;\n signin: (username: string, password: string) => Promise;\n signout: () => void;\n}\n\nconst AuthContext = createContext(null!);\n\nexport function AuthProvider({ children }: { children: React.ReactNode }) {\n const [user, setUser] = useState(null);\n\n const signin = async (username: string, password: string) => {\n try {\n // Create basic auth header\n const authHeader = \"Basic \" + btoa(username + \":\" + password);\n\n const response = await fetch(\"/api/login\", {\n headers: {\n \"Authorization\": authHeader,\n },\n });\n\n if (response.ok) {\n setUser(username);\n // Store auth in sessionStorage for persistence\n sessionStorage.setItem(\"auth\", authHeader);\n return true;\n } else {\n return false;\n }\n } catch (error) {\n console.error(\"Login error:\", error);\n return false;\n }\n };\n\n const signout = () => {\n setUser(null);\n sessionStorage.removeItem(\"auth\");\n };\n\n // Check if we have auth in sessionStorage on mount\n React.useEffect(() => {\n const auth = sessionStorage.getItem(\"auth\");\n if (auth) {\n // Verify the auth is still valid\n fetch(\"/api/login\", {\n headers: {\n \"Authorization\": auth,\n },\n }).then((response) => {\n if (response.ok) {\n // Extract username from Basic auth\n try {\n const decoded = atob(auth.replace(\"Basic \", \"\"));\n const username = decoded.split(\":\")[0];\n setUser(username);\n } catch (e) {\n console.error(\"Failed to decode auth\", e);\n sessionStorage.removeItem(\"auth\");\n }\n } else {\n sessionStorage.removeItem(\"auth\");\n }\n }).catch(() => {\n sessionStorage.removeItem(\"auth\");\n });\n }\n }, []);\n\n const value = { user, signin, signout };\n\n return {children};\n}\n\nexport function useAuth() {\n return useContext(AuthContext);\n}\n\nexport function RequireAuth({ children }: { children: JSX.Element }) {\n const auth = useAuth();\n const location = useLocation();\n\n if (!auth.user) {\n // Redirect to the login page but save the current location\n return ;\n }\n\n return children;\n}\n",[],[173,264,306],"fddc1736-56bc-11f0-824f-f69ea79377d9","App.tsx","fddc183a-56bc-11f0-824f-f69ea79377d9",23,["D",1751403016131],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Outlet } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\n\nexport default function App() {\n return (\n

OffX

Twitter Feed Summarizer

\n\n

\n \n

\n\n \n

\n );\n}\n",[],[173,264,314],"0698589e-55f5-11f0-9cfc-f69ea79377d9",10,["D",1751317131440],[208,209,210,211,212,213,214,215],[173,264],["D",1751316325744],[207,216,217],[173],"83f47b4a-8a7c-11f0-a88e-0224a6c84d84","twitter-summarization-job.cron.ts","83f47c12-8a7c-11f0-a88e-0224a6c84d84",38,["D",1757092784206],"interval","/**\n * Scheduled job for generating AI-powered summaries of tweets grouped by topics\n * This cron job runs periodically to analyze recent tweets and generate summaries\n * \n * Configure this in Val Town's interface to run at your desired interval\n * Recommended: Every 6 hours or daily\n */\n\nimport { TwitterSummarizationService } from \"./twitter-summarization.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport default async function (): Promise {\n const startTime = Date.now();\n console.log(\"🤖 Starting scheduled summarization job...\");\n\n try {\n // Initialize database\n await initializeDatabase();\n\n // Initialize the summarization service\n const summarizationService = new TwitterSummarizationService();\n\n // Configure summarization options\n const options = {\n timeWindowHours: parseInt(Deno.env.get(\"TWITTER_SUMMARIZATION_TIME_WINDOW\") || \"24\"),\n maxTweets: parseInt(Deno.env.get(\"TWITTER_SUMMARIZATION_MAX_TWEETS\") || \"50\"),\n includeMedia: Deno.env.get(\"TWITTER_SUMMARIZATION_INCLUDE_MEDIA\") !== \"false\",\n includeSentiment: Deno.env.get(\"TWITTER_SUMMARIZATION_INCLUDE_SENTIMENT\") !== \"false\",\n };\n\n console.log(\"📊 Summarization options:\", options);\n\n // Generate and store summaries\n const result = await summarizationService.generateAndStoreSummaries(options);\n\n // Calculate execution time\n const executionTime = Date.now() - startTime;\n\n // Log results\n console.log(\"📊 Summarization job completed:\");\n console.log(` - Generated: ${result.generated} summaries`);\n console.log(` - Stored: ${result.stored} summaries`);\n console.log(` - Errors: ${result.errors.length}`);\n console.log(` - Execution time: ${executionTime}ms`);\n\n if (result.errors.length > 0) {\n console.error(\"❌ Errors encountered:\");\n result.errors.forEach(error => console.error(` - ${error}`));\n }\n\n // Send email notification with results\n const shouldSendEmail = Deno.env.get(\"TWITTER_SUMMARIZATION_EMAIL_NOTIFICATIONS\") === \"true\";\n const userEmail = Deno.env.get(\"USER_EMAIL\");\n\n if (shouldSendEmail && userEmail) {\n try {\n await sendSummarizationEmail(result, executionTime, userEmail);\n console.log(\"📧 Email notification sent successfully\");\n } catch (emailError) {\n console.error(\"📧 Failed to send email notification:\", emailError);\n }\n }\n\n console.log(\"✅ Summarization job completed successfully\");\n\n } catch (error: unknown) {\n const executionTime = Date.now() - startTime;\n const errorMessage = `Summarization job failed: ${error}`;\n \n console.error(\"❌ Summarization job failed:\", error);\n\n // Try to send error notification email\n const shouldSendEmail = Deno.env.get(\"TWITTER_SUMMARIZATION_EMAIL_NOTIFICATIONS\") === \"true\";\n const userEmail = Deno.env.get(\"USER_EMAIL\");\n\n if (shouldSendEmail && userEmail) {\n try {\n await sendErrorEmail(error, executionTime, userEmail);\n console.log(\"📧 Error notification email sent\");\n } catch (emailError) {\n console.error(\"📧 Failed to send error notification email:\", emailError);\n }\n }\n\n throw error; // Re-throw to mark job as failed\n }\n}\n\n/**\n * Send email notification with summarization results\n */\nasync function sendSummarizationEmail(\n result: any,\n executionTime: number,\n recipientEmail: string,\n): Promise {\n const subject = `OffX: Summarization Report - ${result.generated} summaries generated`;\n \n const summariesList = result.summaries\n .map((s: any) => \n `• ${s.topicTitle}: ${s.tweetCount} tweets (${s.overallSentiment.sentiment} sentiment)`\n )\n .join('\\n');\n\n const html = `\n

🤖 Twitter Summarization Report

\n \n

📊 Summary

Generated: ${result.generated} summaries
Stored: ${result.stored} summaries
Execution time: ${(executionTime / 1000).toFixed(2)}s
Status: ${result.success ? '✅ Success' : '❌ Partial failure'}

\n\n ${result.summaries.length > 0 ? `\n

📝 Generated Summaries

${summariesList}

\n ` : ''}\n\n ${result.errors.length > 0 ? `\n

❌ Errors (${result.errors.length})

${error}

\n ` : ''}\n\n

Generated at ${new Date().toISOString()}

This is an automated report from your Twitter Summarization service.

To disable these notifications, set TWITTER_SUMMARIZATION_EMAIL_NOTIFICATIONS=false

\n `;\n\n const text = `\nTwitter Summarization Report\n\nGenerated: ${result.generated} summaries\nStored: ${result.stored} summaries\nExecution time: ${(executionTime / 1000).toFixed(2)}s\nStatus: ${result.success ? 'Success' : 'Partial failure'}\n\n${result.summaries.length > 0 ? `\nGenerated Summaries:\n${summariesList}\n` : ''}\n\n${result.errors.length > 0 ? `\nErrors (${result.errors.length}):\n${result.errors.map((error: string) => `- ${error}`).join('\\n')}\n` : ''}\n\nGenerated at ${new Date().toISOString()}\n `;\n\n await email({\n to: recipientEmail,\n subject,\n html,\n text,\n });\n}\n\n/**\n * Send error notification email\n */\nasync function sendErrorEmail(\n error: any,\n executionTime: number,\n recipientEmail: string,\n): Promise {\n const subject = \"OffX: Summarization Job Failed\";\n \n const html = `\n

❌ Summarization Job Failed

\n \n

Error Details

Error: ${error instanceof Error ? error.message : String(error) || error}

Execution time: ${(executionTime / 1000).toFixed(2)}s

Timestamp: ${new Date().toISOString()}

\n\n

Please check the logs for more details and consider investigating the issue.

You may want to check your OpenAI API key and quota limits.

\n `;\n\n const text = `\nSummarization Job Failed\n\nError: ${error instanceof Error ? error.message : String(error) || error}\nExecution time: ${(executionTime / 1000).toFixed(2)}s\nTimestamp: ${new Date().toISOString()}\n\nPlease check the logs for more details and consider investigating the issue.\n `;\n\n await email({\n to: recipientEmail,\n subject,\n html,\n text,\n });\n}",[],[178,330],"84232e40-8a7c-11f0-9716-0224a6c84d84",["D",1757092784576],[],[178,32],"841d63de-8a7c-11f0-abb7-0224a6c84d84","topic-api-test.http.ts","841d64b0-8a7c-11f0-abb7-0224a6c84d84",44,["D",1757092784549],"/**\n * Topic Management API Test Endpoints\n * This file provides HTTP endpoints to test the Topic Management API functionality\n */\nexport default async function (req: Request): Promise {\n // Check for basic auth\n const authHeader = req.headers.get(\"Authorization\");\n if (!authHeader || !authHeader.startsWith(\"Basic \")) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: { \"WWW-Authenticate\": \"Basic\" },\n });\n }\n\n const base64Credentials = authHeader.split(\" \")[1];\n const credentials = atob(base64Credentials);\n const [username, password] = credentials.split(\":\");\n\n // Simple hard-coded auth for testing\n const validUsername = Deno.env.get(\"AUTH_USERNAME\") || \"admin\";\n const validPassword = Deno.env.get(\"AUTH_PASSWORD\") || \"password\";\n\n if (username !== validUsername || password !== validPassword) {\n return new Response(\"Unauthorized\", {\n status: 401,\n headers: { \"WWW-Authenticate\": \"Basic\" },\n });\n }\n\n // Parse URL to get action\n const url = new URL(req.url);\n const action = url.searchParams.get(\"action\") || \"help\";\n\n // Import necessary modules\n const { initializeDatabase } = await import(\"./database/migrations.ts\");\n const {\n createTopic,\n getAllTopics,\n getTopicById,\n updateTopic,\n deleteTopic,\n } = await import(\"./database/queries.ts\");\n\n // Initialize database\n await initializeDatabase();\n\n // Process actions\n switch (action) {\n case \"list\":\n // List all topics\n const topics = await getAllTopics();\n return new Response(\n JSON.stringify({ action: \"list\", topics }, null, 2),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"get\":\n // Get a specific topic\n const id = parseInt(url.searchParams.get(\"id\") || \"0\");\n if (isNaN(id) || id <= 0) {\n return new Response(\n JSON.stringify({ error: \"Invalid topic ID\" }, null, 2),\n {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n const topic = await getTopicById(id);\n if (!topic) {\n return new Response(\n JSON.stringify({ error: \"Topic not found\" }, null, 2),\n {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n return new Response(\n JSON.stringify({ action: \"get\", topic }, null, 2),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"create\":\n // Create a new topic\n const title = url.searchParams.get(\"title\");\n const description = url.searchParams.get(\"description\");\n\n if (!title) {\n return new Response(\n JSON.stringify({ error: \"Title is required\" }, null, 2),\n {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n const newTopicId = await createTopic({\n title,\n description: description || undefined,\n });\n\n const newTopic = await getTopicById(newTopicId);\n return new Response(\n JSON.stringify({ action: \"create\", topic: newTopic }, null, 2),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"update\":\n // Update a topic\n const updateId = parseInt(url.searchParams.get(\"id\") || \"0\");\n const updateTitle = url.searchParams.get(\"title\");\n const updateDescription = url.searchParams.get(\"description\");\n\n if (isNaN(updateId) || updateId <= 0) {\n return new Response(\n JSON.stringify({ error: \"Invalid topic ID\" }, null, 2),\n {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n if (!updateTitle && updateDescription === null) {\n return new Response(\n JSON.stringify(\n { error: \"At least one field must be provided for update\" },\n null,\n 2,\n ),\n {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Check if topic exists\n const existingTopic = await getTopicById(updateId);\n if (!existingTopic) {\n return new Response(\n JSON.stringify({ error: \"Topic not found\" }, null, 2),\n {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Update the topic\n await updateTopic({\n id: updateId,\n title: updateTitle || existingTopic.title,\n description: updateDescription !== null\n ? updateDescription\n : existingTopic.description,\n });\n\n const updatedTopic = await getTopicById(updateId);\n return new Response(\n JSON.stringify({ action: \"update\", topic: updatedTopic }, null, 2),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"delete\":\n // Delete a topic\n const deleteId = parseInt(url.searchParams.get(\"id\") || \"0\");\n\n if (isNaN(deleteId) || deleteId <= 0) {\n return new Response(\n JSON.stringify({ error: \"Invalid topic ID\" }, null, 2),\n {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Check if topic exists\n const topicToDelete = await getTopicById(deleteId);\n if (!topicToDelete) {\n return new Response(\n JSON.stringify({ error: \"Topic not found\" }, null, 2),\n {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n // Delete the topic\n await deleteTopic(deleteId);\n return new Response(\n JSON.stringify(\n {\n action: \"delete\",\n message: \"Topic deleted successfully\",\n topicId: deleteId,\n },\n null,\n 2,\n ),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n\n case \"help\":\n default:\n // Show help information\n return new Response(\n JSON.stringify(\n {\n message: \"Topic Management API Test\",\n availableActions: {\n list: \"List all topics - ?action=list\",\n get: \"Get a specific topic - ?action=get&id=1\",\n create:\n \"Create a new topic - ?action=create&title=NewTopic&description=Description\",\n update:\n \"Update a topic - ?action=update&id=1&title=UpdatedTitle&description=UpdatedDescription\",\n delete: \"Delete a topic - ?action=delete&id=1\",\n },\n examples: {\n list: \"/api/topic-test?action=list\",\n get: \"/api/topic-test?action=get&id=1\",\n create:\n \"/api/topic-test?action=create&title=Tech News&description=Latest tech updates\",\n update:\n \"/api/topic-test?action=update&id=1&title=Updated Tech News\",\n delete: \"/api/topic-test?action=delete&id=1\",\n },\n },\n null,\n 2,\n ),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n}\n",[],[178,343],"e7bb6cc6-56bd-11f0-ad3b-f69ea79377d9","index.ts",32,["D",1751403408491],"import { Hono } from \"https://esm.sh/hono@4.8.3\";\nimport { basicAuth } from \"https://esm.sh/hono@4.8.3/basic-auth\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Basic authentication middleware\nconst auth = basicAuth({\n username: Deno.env.get(\"AUTH_USERNAME\") || \"admin\",\n password: Deno.env.get(\"AUTH_PASSWORD\") || \"password\",\n // This is just a placeholder - in production, always use environment variables\n});\n\n// Public routes\napp.get(\"/api/health\", (c) => {\n return c.json({ status: \"ok\", timestamp: new Date().toISOString() });\n});\n\n// Login route that returns success message on correct credentials\napp.get(\"/api/login\", auth, (c) => {\n return c.json({\n success: true,\n message: \"Authentication successful\",\n user: c.req.header(\"Authorization\")?.split(\" \")[1]?.split(\":\")[0]\n || \"user\",\n });\n});\n\n// Protected API routes\napp.get(\"/api/dashboard\", auth, (c) => {\n return c.json({\n message: \"Protected dashboard data\",\n data: {\n summaries: [],\n topics: [],\n },\n });\n});\n\n// Serve static files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// For SPA routing, serve index.html for all other routes\napp.get(\"*\", async (c) => {\n try {\n // Try to serve the requested file first\n return await serveFile(c.req.path, import.meta.url);\n } catch {\n // If file not found, serve the index.html for client-side routing\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n }\n});\n\n// Export the fetch handler for HTTP vals\nexport default app.fetch;",[],[178,351],"83c566ac-8a7c-11f0-85b0-0224a6c84d84","security","83c567a6-8a7c-11f0-85b0-0224a6c84d84",33,["D",1757092783975],[],[178,358],"06b1146a-55f5-11f0-918b-f69ea79377d9","routes","06b11500-55f5-11f0-918b-f69ea79377d9",12,["D",1751317131604],[],[178,365],"83f066f4-8a7c-11f0-bfd7-0224a6c84d84","run-benchmark.ts","83f067c6-8a7c-11f0-bfd7-0224a6c84d84","06a4dc18-55f5-11f0-9d32-f69ea79377d9",37,["D",1757092784200],"import { runBenchmarks } from \"./benchmark.ts\";\n\n/**\n * This script runs the database benchmarks and outputs the results\n * Run with: deno run --allow-net backend/database/run-benchmark.ts\n */\n\nconsole.log(\"Starting database performance benchmarking...\");\nconsole.log(\n \"This will create test data in the database to measure performance.\",\n);\nconsole.log(\"Press Ctrl+C to cancel or wait for benchmarks to complete.\");\n\n// Small delay to allow user to cancel if needed\nsetTimeout(async () => {\n try {\n await runBenchmarks();\n } catch (error: unknown) {\n console.error(\"Benchmark failed:\", error);\n }\n}, 2000);\n",[],[178,380,372],"database","840547ea-8a7c-11f0-81bc-0224a6c84d84","migrations.ts","8405489e-8a7c-11f0-81bc-0224a6c84d84",40,["D",1757092784357],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning to handle schema changes\nexport const TABLES = {\n TOPICS: \"topics_v1\",\n POSTS: \"posts_v1\",\n POST_MEDIA: \"post_media_v1\",\n SUMMARIZATIONS: \"summarizations_v1\",\n TOPIC_POSTS: \"topic_posts_v1\", // Junction table for many-to-many relationship\n POST_SENTIMENT: \"post_sentiment_v1\", // New table for sentiment analysis\n};\n\n/**\n * Creates all database tables if they don't exist\n */\nexport async function createTables() {\n // Create topics table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.TOPICS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create posts table (for tweets or other social media content)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.POSTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n external_id TEXT UNIQUE, -- Twitter/X tweet ID or other platform ID\n content TEXT NOT NULL,\n author TEXT NOT NULL,\n author_username TEXT NOT NULL,\n platform TEXT NOT NULL, -- 'twitter', 'mastodon', etc.\n created_at TIMESTAMP NOT NULL,\n fetched_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n url TEXT\n )\n `);\n\n // Create post_media table for media attached to posts\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.POST_MEDIA} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n media_url TEXT NOT NULL,\n media_type TEXT NOT NULL, -- 'image', 'video', etc.\n alt_text TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (post_id) REFERENCES ${TABLES.POSTS}(id) ON DELETE CASCADE\n )\n `);\n\n // Create junction table for many-to-many relationship between topics and posts\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.TOPIC_POSTS} (\n topic_id INTEGER NOT NULL,\n post_id INTEGER NOT NULL,\n added_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (topic_id, post_id),\n FOREIGN KEY (topic_id) REFERENCES ${TABLES.TOPICS}(id) ON DELETE CASCADE,\n FOREIGN KEY (post_id) REFERENCES ${TABLES.POSTS}(id) ON DELETE CASCADE\n )\n `);\n\n // Create summarizations table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.SUMMARIZATIONS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n topic_id INTEGER NOT NULL,\n content TEXT NOT NULL,\n prompt TEXT NOT NULL, -- Store the prompt used to generate the summary\n post_count INTEGER NOT NULL, -- Number of posts included in this summary\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n time_period_start TIMESTAMP NOT NULL, -- Start of the time period covered\n time_period_end TIMESTAMP NOT NULL, -- End of the time period covered\n FOREIGN KEY (topic_id) REFERENCES ${TABLES.TOPICS}(id) ON DELETE CASCADE\n )\n `);\n\n // Create post sentiment table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.POST_SENTIMENT} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n sentiment TEXT NOT NULL, -- 'positive', 'negative', 'neutral'\n score REAL NOT NULL, -- -1.0 to 1.0\n confidence REAL NOT NULL, -- 0.0 to 1.0\n keywords TEXT, -- JSON array of keywords\n entities TEXT, -- JSON array of entities (optional)\n analyzed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (post_id) REFERENCES ${TABLES.POSTS}(id) ON DELETE CASCADE,\n UNIQUE(post_id) -- Only one sentiment analysis per post\n )\n `);\n\n // Create indexes for performance\n await createIndexes();\n}\n\n/**\n * Creates indexes for optimizing query performance\n */\nasync function createIndexes() {\n // Indexes for posts table\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_external_id ON ${TABLES.POSTS}(external_id)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_author ON ${TABLES.POSTS}(author)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_created_at ON ${TABLES.POSTS}(created_at)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_platform ON ${TABLES.POSTS}(platform)`,\n );\n\n // Indexes for topic_posts junction table\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_topic_posts_topic_id ON ${TABLES.TOPIC_POSTS}(topic_id)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_topic_posts_post_id ON ${TABLES.TOPIC_POSTS}(post_id)`,\n );\n\n // Indexes for summarizations table\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_summarizations_topic_id ON ${TABLES.SUMMARIZATIONS}(topic_id)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_summarizations_created_at ON ${TABLES.SUMMARIZATIONS}(created_at)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_summarizations_time_period ON ${TABLES.SUMMARIZATIONS}(time_period_start, time_period_end)`,\n );\n\n // Indexes for post sentiment table\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_post_sentiment_post_id ON ${TABLES.POST_SENTIMENT}(post_id)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_post_sentiment_sentiment ON ${TABLES.POST_SENTIMENT}(sentiment)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_post_sentiment_score ON ${TABLES.POST_SENTIMENT}(score)`,\n );\n}\n\n/**\n * Initialize the database with all required tables and indexes\n */\nexport async function initializeDatabase() {\n try {\n await createTables();\n console.log(\"Database initialized successfully\");\n return true;\n } catch (error: unknown) {\n console.error(\"Error initializing database:\", error);\n throw error;\n }\n}\n\n/**\n * Schema Change Utilities\n *\n * Val Town's SQLite implementation has limited support for ALTER TABLE operations.\n * Instead, we follow the recommended approach of creating new tables with updated\n * schemas and migrating data from old tables.\n */\n\n/**\n * Check if a table exists in the database\n * @param tableName The name of the table to check\n * @returns True if the table exists, false otherwise\n */\nexport async function tableExists(tableName: string): Promise {\n const result = await sqlite.execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name=?`,\n [tableName],\n );\n return result.rows.length > 0;\n}\n\n/**\n * Get the column information for a table\n * @param tableName The name of the table to get column info for\n * @returns Array of column information objects\n */\nexport async function getTableColumns(\n tableName: string,\n): Promise<{ name: string; type: string }[]> {\n const result = await sqlite.execute(`PRAGMA table_info(${tableName})`);\n return result.rows.map((row: any) => ({\n name: row.name,\n type: row.type,\n }));\n}\n\n/**\n * Create a new table version with an updated schema\n * @param oldTableName The name of the old table\n * @param newTableName The name of the new table\n * @param createTableSql The SQL statement to create the new table\n * @param columnMappings Mapping of old column names to new column names\n */\nexport async function migrateTable(\n oldTableName: string,\n newTableName: string,\n createTableSql: string,\n columnMappings: { [oldCol: string]: string } = {},\n): Promise {\n // Check if old table exists\n const oldTableExists = await tableExists(oldTableName);\n if (!oldTableExists) {\n console.log(\n `Old table ${oldTableName} does not exist. Creating new table ${newTableName} without migration.`,\n );\n await sqlite.execute(createTableSql);\n return;\n }\n\n // Create the new table\n await sqlite.execute(createTableSql);\n\n // Get columns from old table\n const oldColumns = await getTableColumns(oldTableName);\n const oldColumnNames = oldColumns.map((col) => col.name);\n\n // Get columns from new table\n const newColumns = await getTableColumns(newTableName);\n const newColumnNames = newColumns.map((col) => col.name);\n\n // Build column mapping for the migration\n const columnsToCopy: string[] = [];\n\n oldColumnNames.forEach((oldCol) => {\n const mappedCol = columnMappings[oldCol] || oldCol;\n if (newColumnNames.includes(mappedCol)) {\n columnsToCopy.push(`${oldCol} AS ${mappedCol}`);\n }\n });\n\n if (columnsToCopy.length === 0) {\n console.log(\n `No matching columns between ${oldTableName} and ${newTableName}. Skipping data migration.`,\n );\n return;\n }\n\n // Copy data from old table to new table\n try {\n await sqlite.execute(\n `INSERT INTO ${newTableName} SELECT ${\n columnsToCopy.join(\", \")\n } FROM ${oldTableName}`,\n );\n console.log(\n `Successfully migrated data from ${oldTableName} to ${newTableName}`,\n );\n } catch (error: unknown) {\n console.error(\n `Error migrating data from ${oldTableName} to ${newTableName}:`,\n error,\n );\n throw error;\n }\n}\n\n/**\n * Example schema change function for topics table\n * This shows how to migrate from topics_v1 to topics_v2 with a new column\n */\nexport async function upgradeTopicsToV2(): Promise {\n const oldTable = \"topics_v1\";\n const newTable = \"topics_v2\";\n\n // Define the new table schema\n const createTableSql = `\n CREATE TABLE IF NOT EXISTS ${newTable} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n is_active BOOLEAN DEFAULT 1, -- New column added in v2\n color TEXT DEFAULT '#3498db' -- New column added in v2\n )\n `;\n\n // Define column mappings (only needed if column names change)\n const columnMappings = {\n // No renamed columns in this example\n };\n\n // Migrate the table\n await migrateTable(oldTable, newTable, createTableSql, columnMappings);\n\n // Update the TABLES constant to point to the new version\n // Note: In a real application, you would update the constant in the code\n // and redeploy. This is just for demonstration.\n console.log(\"Migration complete. Update the TABLES constant to:\");\n console.log(`TOPICS: \"${newTable}\"`);\n}\n\n/**\n * Example schema change function for posts table\n * This shows how to migrate from posts_v1 to posts_v2 with renamed columns\n */\nexport async function upgradePostsToV2(): Promise {\n const oldTable = \"posts_v1\";\n const newTable = \"posts_v2\";\n\n // Define the new table schema\n const createTableSql = `\n CREATE TABLE IF NOT EXISTS ${newTable} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n external_id TEXT UNIQUE,\n content TEXT NOT NULL,\n author_name TEXT NOT NULL, -- Renamed from 'author'\n author_username TEXT NOT NULL,\n source TEXT NOT NULL, -- Renamed from 'platform'\n published_at TIMESTAMP NOT NULL, -- Renamed from 'created_at'\n fetched_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n url TEXT,\n engagement_count INTEGER DEFAULT 0 -- New column\n )\n `;\n\n // Define column mappings for renamed columns\n const columnMappings = {\n \"author\": \"author_name\",\n \"platform\": \"source\",\n \"created_at\": \"published_at\",\n };\n\n // Migrate the table\n await migrateTable(oldTable, newTable, createTableSql, columnMappings);\n\n // Update the TABLES constant to point to the new version\n console.log(\"Migration complete. Update the TABLES constant to:\");\n console.log(`POSTS: \"${newTable}\"`);\n\n // Create indexes for the new table\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_external_id ON ${newTable}(external_id)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_author_name ON ${newTable}(author_name)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_published_at ON ${newTable}(published_at)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_posts_source ON ${newTable}(source)`,\n );\n}\n",[],[178,380,382],"84146bda-8a7c-11f0-a4f1-0224a6c84d84","84146c84-8a7c-11f0-a4f1-0224a6c84d84",42,["D",1757092784417],"import { initializeDatabase, TABLES } from \"./migrations.ts\";\nimport * as queries from \"./queries.ts\";\n\nexport { initializeDatabase, queries, TABLES };\n\n// Re-export interfaces for convenience\nexport type {\n Post,\n PostMedia,\n Summarization,\n Topic,\n TopicPost,\n} from \"./queries.ts\";\n\n// Initialize the database when this module is imported\n// Comment this out in production if you want to initialize manually\n// for better performance in serverless environments\ninitializeDatabase().catch(console.error);\n",[],[178,380,351],"8410d740-8a7c-11f0-af15-0224a6c84d84","benchmark.ts","8410d7fe-8a7c-11f0-af15-0224a6c84d84",41,["D",1757092784458],"import { initializeDatabase } from \"./migrations.ts\";\nimport * as queries from \"./queries.ts\";\nimport { Post, PostMedia } from \"./queries.ts\";\n\n/**\n * Simple benchmarking utility for database operations\n * This helps identify performance bottlenecks in the data access layer\n */\n\n// Helper function to measure execution time\nasync function measureTime(\n name: string,\n fn: () => Promise,\n iterations: number = 1,\n): Promise<{ result: T; avgTime: number }> {\n console.log(`Running benchmark: ${name} (${iterations} iterations)`);\n\n const times: number[] = [];\n let result: T = null as unknown as T;\n\n for (let i = 0; i < iterations; i++) {\n const start = performance.now();\n result = await fn();\n const end = performance.now();\n const time = end - start;\n times.push(time);\n\n if (iterations > 1) {\n console.log(` Iteration ${i + 1}: ${time.toFixed(2)}ms`);\n }\n }\n\n const avgTime = times.reduce((sum, time) => sum + time, 0) / times.length;\n console.log(` Average time: ${avgTime.toFixed(2)}ms`);\n\n return { result, avgTime };\n}\n\n// Sample data generation\nfunction generateSampleTopic(index: number) {\n return {\n title: `Test Topic ${index}`,\n description: `This is a test topic ${index} for benchmarking purposes.`,\n };\n}\n\nfunction generateSamplePost(index: number): Omit {\n return {\n external_id: `test-${index}`,\n content:\n `This is test post content ${index} with some additional text to make it more realistic. #testing #benchmark`,\n author: `Test Author ${index % 10}`,\n author_username: `testuser${index % 10}`,\n platform: index % 2 === 0 ? \"twitter\" : \"mastodon\",\n created_at: new Date(Date.now() - index * 3600000).toISOString(),\n url: `https://example.com/post/${index}`,\n };\n}\n\nfunction generateSampleMedia(\n postId: number,\n index: number,\n): Omit {\n return {\n post_id: postId,\n media_url: `https://example.com/media/${postId}-${index}.jpg`,\n media_type: \"image\",\n alt_text: `Sample image ${index} for post ${postId}`,\n };\n}\n\nfunction generateSampleSummarization(topicId: number, index: number) {\n const endDate = new Date();\n const startDate = new Date(endDate.getTime() - (24 * 3600000)); // 24 hours before\n\n return {\n topic_id: topicId,\n content:\n `This is a sample summarization ${index} for topic ${topicId}. It contains multiple sentences to simulate a realistic summary. The key points discussed were testing, benchmarking, and performance optimization.`,\n prompt: \"Summarize the latest posts about this topic\",\n post_count: 25,\n time_period_start: startDate.toISOString(),\n time_period_end: endDate.toISOString(),\n };\n}\n\n// Benchmark scenarios\nasync function benchmarkTopicOperations(count: number = 10) {\n console.log(\"\\n=== Benchmarking Topic Operations ===\");\n\n // Create topics\n const topicIds: number[] = [];\n await measureTime(\"Create topics\", async () => {\n for (let i = 0; i < count; i++) {\n const topic = generateSampleTopic(i);\n const id = await queries.createTopic(topic);\n topicIds.push(id);\n }\n });\n\n // Get all topics\n await measureTime(\"Get all topics\", async () => {\n return await queries.getAllTopics();\n });\n\n // Get individual topics\n await measureTime(\"Get topic by ID\", async () => {\n for (const id of topicIds.slice(0, Math.min(count, 5))) {\n await queries.getTopicById(id);\n }\n });\n\n // Update topics\n await measureTime(\"Update topics\", async () => {\n for (const id of topicIds.slice(0, Math.min(count, 5))) {\n await queries.updateTopic({\n id,\n title: `Updated Topic ${id}`,\n description: `This topic was updated during benchmarking.`,\n });\n }\n });\n\n return topicIds;\n}\n\nasync function benchmarkPostOperations(\n count: number = 20,\n topicIds: number[] = [],\n) {\n console.log(\"\\n=== Benchmarking Post Operations ===\");\n\n // Create posts\n const postIds: number[] = [];\n await measureTime(\"Create posts\", async () => {\n for (let i = 0; i < count; i++) {\n const post = generateSamplePost(i) as Post;\n // Add media to some posts\n if (i % 3 === 0) {\n post.media = [\n generateSampleMedia(0, 1),\n generateSampleMedia(0, 2),\n ];\n }\n const id = await queries.createPost(post);\n postIds.push(id);\n }\n });\n\n // Get posts by ID\n await measureTime(\"Get posts by ID\", async () => {\n for (const id of postIds.slice(0, Math.min(count, 5))) {\n await queries.getPostById(id);\n }\n });\n\n // Get posts by external ID\n await measureTime(\"Get posts by external ID\", async () => {\n for (let i = 0; i < Math.min(count, 5); i++) {\n await queries.getPostByExternalId(`test-${i}`);\n }\n });\n\n // Get recent posts\n await measureTime(\"Get recent posts\", async () => {\n return await queries.getRecentPosts(10);\n });\n\n // Add posts to topics\n if (topicIds.length > 0) {\n await measureTime(\"Add posts to topics\", async () => {\n for (const postId of postIds) {\n // Add each post to 1-3 random topics\n const numTopics = Math.floor(Math.random() * 3) + 1;\n for (let i = 0; i < numTopics; i++) {\n const randomTopicIndex = Math.floor(Math.random() * topicIds.length);\n await queries.addPostToTopic(topicIds[randomTopicIndex], postId);\n }\n }\n });\n\n // Get posts for topics\n await measureTime(\"Get posts for topic\", async () => {\n for (const topicId of topicIds.slice(0, Math.min(topicIds.length, 3))) {\n await queries.getPostsForTopic(topicId, 10);\n }\n });\n }\n\n return postIds;\n}\n\nasync function benchmarkSummarizationOperations(\n count: number = 5,\n topicIds: number[] = [],\n) {\n console.log(\"\\n=== Benchmarking Summarization Operations ===\");\n\n if (topicIds.length === 0) {\n console.log(\"No topics available for summarization benchmarking\");\n return [];\n }\n\n // Create summarizations\n const summaryIds: number[] = [];\n await measureTime(\"Create summarizations\", async () => {\n for (let i = 0; i < count; i++) {\n // Distribute summarizations across available topics\n const topicId = topicIds[i % topicIds.length];\n const summarization = generateSampleSummarization(topicId, i);\n const id = await queries.createSummarization(summarization);\n summaryIds.push(id);\n }\n });\n\n // Get summarizations by ID\n await measureTime(\"Get summarization by ID\", async () => {\n for (const id of summaryIds.slice(0, Math.min(count, 3))) {\n await queries.getSummarizationById(id);\n }\n });\n\n // Get summarizations for topic\n await measureTime(\"Get summarizations for topic\", async () => {\n for (const topicId of topicIds.slice(0, Math.min(topicIds.length, 3))) {\n await queries.getSummarizationsForTopic(topicId, 5);\n }\n });\n\n // Get recent summarizations\n await measureTime(\"Get recent summarizations\", async () => {\n return await queries.getRecentSummarizations(5);\n });\n\n return summaryIds;\n}\n\n// Main benchmark function\nexport async function runBenchmarks() {\n console.log(\"Starting database benchmarks...\");\n\n try {\n // Initialize the database\n await initializeDatabase();\n\n // Run benchmarks\n const topicIds = await benchmarkTopicOperations(10);\n const postIds = await benchmarkPostOperations(20, topicIds);\n await benchmarkSummarizationOperations(5, topicIds);\n\n // Clean up test data if needed\n // Uncomment this section to delete test data after benchmarking\n /*\n console.log(\"\\n=== Cleaning up test data ===\");\n for (const id of postIds) {\n await queries.deletePost(id);\n }\n for (const id of topicIds) {\n await queries.deleteTopic(id);\n }\n */\n\n console.log(\"\\nBenchmarks completed successfully!\");\n } catch (error: unknown) {\n console.error(\"Error during benchmarking:\", error);\n }\n}\n\n// Run benchmarks if this file is executed directly\n// Comment out this check for now as we'll run it manually\n// if (import.meta.url === Deno.mainModule) {\n// runBenchmarks();\n// }\n",[],[178,380,397],"8418f8b2-8a7c-11f0-be41-0224a6c84d84","8418f948-8a7c-11f0-be41-0224a6c84d84",43,["D",1757092784365],"# Database Module\n\nThis module handles all database operations for the OffX application using Val Town's SQLite module.\n\n## Schema Design\n\nThe database schema follows a normalized design (up to 3NF) with the following tables:\n\n### Tables\n\n1. **topics_v1**\n - Stores user-defined topics for categorizing and summarizing posts\n - Fields: id, title, description, created_at, updated_at\n\n2. **posts_v1**\n - Stores posts from various platforms (Twitter/X, etc.)\n - Fields: id, external_id, content, author, author_username, platform, created_at, fetched_at, url\n\n3. **post_media_v1**\n - Stores media attachments for posts\n - Fields: id, post_id, media_url, media_type, alt_text, created_at\n - Foreign key: post_id references posts_v1(id)\n\n4. **topic_posts_v1**\n - Junction table for many-to-many relationship between topics and posts\n - Fields: topic_id, post_id, added_at\n - Foreign keys: topic_id references topics_v1(id), post_id references posts_v1(id)\n\n5. **summarizations_v1**\n - Stores AI-generated summaries of posts for a topic\n - Fields: id, topic_id, content, prompt, post_count, created_at, time_period_start, time_period_end\n - Foreign key: topic_id references topics_v1(id)\n\n## Indexes\n\nThe following indexes are created to optimize query performance:\n\n1. **Posts table indexes**\n - idx_posts_external_id: For fast lookups by external platform ID\n - idx_posts_author: For filtering/searching posts by author\n - idx_posts_created_at: For time-based queries and sorting\n - idx_posts_platform: For filtering posts by platform\n\n2. **Topic-Posts junction table indexes**\n - idx_topic_posts_topic_id: For finding all posts related to a specific topic\n - idx_topic_posts_post_id: For finding all topics a post belongs to\n\n3. **Summarizations table indexes**\n - idx_summarizations_topic_id: For retrieving summaries for a specific topic\n - idx_summarizations_created_at: For time-based sorting of summaries\n - idx_summarizations_time_period: Compound index for efficient time range queries\n\n## Schema Change Strategy\n\nVal Town's SQLite implementation has limited support for ALTER TABLE operations. Instead of traditional migration frameworks, we use a table versioning approach for schema changes.\n\n### Table Versioning Approach\n\n1. **Version Suffix in Table Names**\n - All tables include a version suffix (e.g., `topics_v1`)\n - When schema changes are needed, create a new table with an incremented version (e.g., `topics_v2`)\n\n2. **Data Migration Process**\n - Create the new table with the updated schema\n - Copy data from the old table to the new table, mapping columns as needed\n - Update the `TABLES` constant in `migrations.ts` to point to the new table versions\n - Deploy the updated code\n\n3. **Utility Functions**\n - `tableExists(tableName)`: Check if a table exists in the database\n - `getTableColumns(tableName)`: Get column information for a table\n - `migrateTable(oldTableName, newTableName, createTableSql, columnMappings)`: Migrate data between tables\n\n### Example Schema Change\n\nTo add new columns to the topics table:\n\n```typescript\n// 1. Create a migration function\nasync function upgradeTopicsToV2() {\n const oldTable = \"topics_v1\";\n const newTable = \"topics_v2\";\n \n // Define the new table schema with additional columns\n const createTableSql = `\n CREATE TABLE IF NOT EXISTS ${newTable} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n is_active BOOLEAN DEFAULT 1, -- New column added in v2\n color TEXT DEFAULT '#3498db' -- New column added in v2\n )\n `;\n \n // Migrate the table\n await migrateTable(oldTable, newTable, createTableSql);\n}\n\n// 2. Update the TABLES constant after migration\nexport const TABLES = {\n TOPICS: \"topics_v2\", // Updated to v2\n POSTS: \"posts_v1\",\n // ...other tables\n};\n```\n\n### Handling Column Renames\n\nWhen renaming columns, provide a mapping in the migration function:\n\n```typescript\n// Column mappings for renamed columns\nconst columnMappings = {\n \"author\": \"author_name\",\n \"platform\": \"source\",\n \"created_at\": \"published_at\"\n};\n\n// Use the mappings in the migration function\nawait migrateTable(oldTable, newTable, createTableSql, columnMappings);\n```\n\n### Best Practices\n\n1. **Always increment version numbers** - Never reuse a table name for a different schema\n2. **Test migrations thoroughly** - Verify data integrity after migration\n3. **Deploy schema changes separately** from application logic changes when possible\n4. **Document schema changes** in code comments and commit messages\n5. **Update all affected queries** when changing table or column names\n6. **Create appropriate indexes** for new tables and columns\n\n## Usage\n\nThe database module is automatically initialized when imported. For production deployments, you may want to comment out the auto-initialization for better performance in serverless environments:\n\n```typescript\n// Comment this out in production if you want to initialize manually\n// for better performance in serverless environments\ninitializeDatabase().catch(console.error);\n```",[],[178,380,152],"06a4db3c-55f5-11f0-9d32-f69ea79377d9",11,["D",1751317131524],[195,196,197,198,199],[178,380],["D",1751316325838],[194,200,201,202,203,204,205],[178],["D",1751316115780],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_122":456,"_457":458,"_459":460,"_461":24,"_462":24,"_463":24,"_464":58,"_465":-5,"_466":-7,"_467":-7,"_468":139,"_469":24,"_470":24,"_471":-5,"_472":24,"_473":24,"_474":24,"_475":-5},"ENV",{"_427":428,"_429":430,"_431":86,"_432":433,"_434":435,"_436":437,"_438":439,"_440":441,"_442":443,"_444":445,"_446":447,"_448":449,"_450":451,"_452":453,"_454":455},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v45