[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_514":515,"_516":517},"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",55,"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-summarization.ts","latestPath","fileId","845e360c-8a7c-11f0-9d13-0224a6c84d84","name","twitter-summarization.ts","fileType","script","content","import { openai } from \"https://esm.town/v/valtown/openai\";\nimport {\n createSummarization,\n getAllTopics,\n getPostsForTopic,\n getSummarizationsForTopic,\n} from \"./database/queries.ts\";\nimport type { Post, Topic } from \"./database/queries.ts\";\nimport { TwitterSentimentAnalyzer } from \"./twitter-sentiment.ts\";\n\n/**\n * OpenAI-powered summarization service for grouped tweets\n * Extends the existing sentiment analysis to provide topic-based summaries\n */\n\nexport interface TopicSummary {\n topicId: number;\n topicTitle: string;\n summary: string;\n keyPoints: string[];\n tweetCount: number;\n timeWindow: string;\n overallSentiment: {\n sentiment: \"positive\" | \"negative\" | \"neutral\";\n confidence: number;\n score: number;\n };\n trendingKeywords: string[];\n influentialAuthors: string[];\n}\n\nexport interface SummarizationRequest {\n topicId?: number;\n timeWindowHours?: number;\n maxTweets?: number;\n includeMedia?: boolean;\n includeSentiment?: boolean;\n}\n\nexport interface SummarizationResult {\n success: boolean;\n generated: number;\n stored: number;\n errors: string[];\n summaries: TopicSummary[];\n}\n\n/**\n * Service class for generating AI-powered summaries of tweets grouped by topics\n */\nexport class TwitterSummarizationService {\n private sentimentAnalyzer: TwitterSentimentAnalyzer;\n\n constructor() {\n // Initialize sentiment analyzer with default config\n this.sentimentAnalyzer = new TwitterSentimentAnalyzer();\n }\n\n /**\n * Generate a comprehensive summary for a specific topic\n */\n async generateTopicSummary(\n topicId: number,\n options: Omit = {},\n ): Promise {\n try {\n const {\n timeWindowHours = 24,\n maxTweets = 50,\n includeMedia = false,\n includeSentiment = true,\n } = options;\n\n // Get the topic details\n const topics = await getAllTopics();\n const topic = topics.find((t) => t.id === topicId);\n if (!topic) {\n throw new Error(`Topic with ID ${topicId} not found`);\n }\n\n // Get recent posts for this topic\n const posts = await getPostsForTopic(topicId, maxTweets);\n \n if (posts.length === 0) {\n console.log(`No posts found for topic ${topicId}`);\n return null;\n }\n\n // Filter posts by time window\n const cutoffTime = new Date(Date.now() - timeWindowHours * 60 * 60 * 1000);\n const recentPosts = posts.filter(post => \n new Date(post.created_at) > cutoffTime\n );\n\n if (recentPosts.length === 0) {\n console.log(`No recent posts found for topic ${topicId} in the last ${timeWindowHours} hours`);\n return null;\n }\n\n // Analyze sentiment if requested\n let sentimentData: {\n sentiment: \"positive\" | \"negative\" | \"neutral\";\n confidence: number;\n score: number;\n } | null = null;\n if (includeSentiment) {\n try {\n const sentimentResults = await this.sentimentAnalyzer.analyzeBatch(recentPosts);\n sentimentData = this.aggregateSentiment(sentimentResults);\n } catch (error: unknown) {\n console.warn(\"Failed to analyze sentiment, continuing without it:\", error);\n sentimentData = {\n sentiment: \"neutral\" as const,\n confidence: 0.5,\n score: 0,\n };\n }\n }\n\n // Group and format posts for summarization\n const groupedData = this.groupPostsForSummarization(recentPosts);\n\n // Generate summary using OpenAI\n const summary = await this.generateSummaryWithAI(topic, groupedData, sentimentData);\n\n // Create the final topic summary\n const topicSummary: TopicSummary = {\n topicId,\n topicTitle: topic.title,\n summary: summary.mainSummary,\n keyPoints: summary.keyPoints,\n tweetCount: recentPosts.length,\n timeWindow: `${timeWindowHours} hours`,\n overallSentiment: sentimentData || {\n sentiment: \"neutral\",\n confidence: 0.5,\n score: 0,\n },\n trendingKeywords: summary.trendingKeywords,\n influentialAuthors: summary.influentialAuthors,\n };\n\n return topicSummary;\n } catch (error: unknown) {\n console.error(`Error generating summary for topic ${topicId}:`, error);\n throw error;\n }\n }\n\n /**\n * Generate summaries for all topics with recent activity\n */\n async generateAllTopicSummaries(\n options: Omit = {},\n ): Promise {\n try {\n const topics = await getAllTopics();\n const summaries: TopicSummary[] = [];\n\n console.log(`Generating summaries for ${topics.length} topics...`);\n\n for (const topic of topics) {\n try {\n console.log(`Processing topic: ${topic.title} (ID: ${topic.id})`);\n const summary = await this.generateTopicSummary(topic.id!, options);\n if (summary) {\n summaries.push(summary);\n console.log(`✓ Generated summary for topic: ${topic.title}`);\n } else {\n console.log(`- No recent activity for topic: ${topic.title}`);\n }\n } catch (error: unknown) {\n console.error(`Failed to generate summary for topic ${topic.id} (${topic.title}):`, error);\n // Continue with other topics\n }\n }\n\n console.log(`Generated ${summaries.length} summaries successfully`);\n return summaries;\n } catch (error: unknown) {\n console.error(\"Error generating all topic summaries:\", error);\n throw error;\n }\n }\n\n /**\n * Store a topic summary in the database\n */\n async storeTopicSummary(topicSummary: TopicSummary): Promise {\n try {\n const summaryContent = JSON.stringify({\n summary: topicSummary.summary,\n keyPoints: topicSummary.keyPoints,\n sentiment: topicSummary.overallSentiment,\n tweetCount: topicSummary.tweetCount,\n timeWindow: topicSummary.timeWindow,\n trendingKeywords: topicSummary.trendingKeywords,\n influentialAuthors: topicSummary.influentialAuthors,\n });\n\n // Parse the time window to extract start and end dates\n const [startDate, endDate] = topicSummary.timeWindow.split(\" to \");\n\n const summarizationId = await createSummarization({\n topic_id: topicSummary.topicId,\n content: summaryContent,\n prompt: \"Topic summary generated automatically\",\n post_count: topicSummary.tweetCount,\n time_period_start: startDate.trim(),\n time_period_end: endDate.trim(),\n });\n\n return summarizationId;\n } catch (error: unknown) {\n console.error(\"Error storing topic summary:\", error);\n return null;\n }\n }\n\n /**\n * Generate and store summaries for all topics\n */\n async generateAndStoreSummaries(\n options: Omit = {},\n ): Promise {\n const errors: string[] = [];\n let generated = 0;\n let stored = 0;\n const summaries: TopicSummary[] = [];\n\n try {\n const generatedSummaries = await this.generateAllTopicSummaries(options);\n generated = generatedSummaries.length;\n summaries.push(...generatedSummaries);\n\n for (const summary of generatedSummaries) {\n try {\n const summaryId = await this.storeTopicSummary(summary);\n if (summaryId) {\n stored++;\n console.log(`✓ Stored summary for topic: ${summary.topicTitle} (ID: ${summaryId})`);\n } else {\n const error = `Failed to store summary for topic ${summary.topicId} (${summary.topicTitle})`;\n errors.push(error);\n console.error(error);\n }\n } catch (error: unknown) {\n const errorMessage = `Error storing summary for topic ${summary.topicId} (${summary.topicTitle}): ${error}`;\n errors.push(errorMessage);\n console.error(errorMessage);\n }\n }\n\n return { \n success: errors.length === 0,\n generated, \n stored, \n errors,\n summaries,\n };\n } catch (error: unknown) {\n const errorMessage = `Error in generateAndStoreSummaries: ${error}`;\n errors.push(errorMessage);\n console.error(errorMessage);\n return { \n success: false,\n generated, \n stored, \n errors,\n summaries,\n };\n }\n }\n\n /**\n * Group posts for effective summarization\n */\n private groupPostsForSummarization(posts: Post[]): {\n authorCounts: Record;\n contentSample: string[];\n mediaCount: number;\n timeSpread: { earliest: string; latest: string };\n } {\n const authorCounts: Record = {};\n const contentSample: string[] = [];\n let mediaCount = 0;\n\n // Count authors and collect content\n for (const post of posts) {\n authorCounts[post.author] = (authorCounts[post.author] || 0) + 1;\n contentSample.push(`[@${post.author}]: ${post.content}`);\n \n // Count media (this would need to be enhanced based on actual media data structure)\n if (post.content.includes('http') || post.content.includes('pic.twitter.com')) {\n mediaCount++;\n }\n }\n\n // Calculate time spread\n const timestamps = posts.map(p => new Date(p.created_at).getTime()).sort();\n const timeSpread = {\n earliest: new Date(timestamps[0]).toISOString(),\n latest: new Date(timestamps[timestamps.length - 1]).toISOString(),\n };\n\n return {\n authorCounts,\n contentSample: contentSample.slice(0, 20), // Limit for token efficiency\n mediaCount,\n timeSpread,\n };\n }\n\n /**\n * Generate summary using OpenAI\n */\n private async generateSummaryWithAI(\n topic: Topic,\n groupedData: ReturnType,\n sentimentData: any,\n ): Promise<{\n mainSummary: string;\n keyPoints: string[];\n trendingKeywords: string[];\n influentialAuthors: string[];\n }> {\n const prompt = this.buildSummarizationPrompt(topic, groupedData, sentimentData);\n\n try {\n const response = await openai.chat.completions.create({\n model: \"gpt-3.5-turbo\",\n messages: [\n {\n role: \"system\",\n content: `You are an expert social media analyst specializing in Twitter content summarization. \n Provide concise, insightful summaries that capture the key themes, sentiment, and notable patterns in the conversation.\n Always respond with valid JSON in the exact format requested.`,\n },\n {\n role: \"user\",\n content: prompt,\n },\n ],\n max_tokens: 800,\n temperature: 0.7,\n response_format: { type: \"json_object\" },\n });\n\n const result = response.choices[0].message.content?.trim();\n if (!result) {\n throw new Error(\"No response from OpenAI\");\n }\n\n const summaryData = JSON.parse(result);\n \n // Validate response structure\n if (!summaryData.mainSummary || !Array.isArray(summaryData.keyPoints)) {\n throw new Error(\"Invalid response format from OpenAI\");\n }\n\n return {\n mainSummary: summaryData.mainSummary,\n keyPoints: summaryData.keyPoints || [],\n trendingKeywords: summaryData.trendingKeywords || [],\n influentialAuthors: summaryData.influentialAuthors || [],\n };\n } catch (error: unknown) {\n console.error(\"Error generating summary with AI:\", error);\n \n // Fallback to simple summary\n return this.generateFallbackSummary(topic, groupedData);\n }\n }\n\n /**\n * Build the summarization prompt for OpenAI\n */\n private buildSummarizationPrompt(\n topic: Topic,\n groupedData: ReturnType,\n sentimentData: any,\n ): string {\n const { authorCounts, contentSample, mediaCount, timeSpread } = groupedData;\n \n const topAuthors = Object.entries(authorCounts)\n .sort(([,a], [,b]) => b - a)\n .slice(0, 5)\n .map(([author, count]) => `${author} (${count} posts)`);\n\n const sentimentInfo = sentimentData \n ? `Overall sentiment: ${sentimentData.sentiment} (confidence: ${sentimentData.confidence.toFixed(2)}, score: ${sentimentData.score.toFixed(2)})`\n : \"Sentiment analysis not available\";\n\n return `\nAnalyze and summarize the following Twitter conversation about \"${topic.title}\":\n\nTOPIC DESCRIPTION: ${topic.description || \"No description provided\"}\n\nCONVERSATION DATA:\n- Total posts: ${contentSample.length}\n- Time range: ${timeSpread.earliest} to ${timeSpread.latest}\n- Posts with media: ${mediaCount}\n- ${sentimentInfo}\n\nTOP CONTRIBUTORS: ${topAuthors.join(\", \")}\n\nSAMPLE POSTS:\n${contentSample.join(\"\\n\\n\")}\n\nPlease provide a comprehensive analysis in the following JSON format:\n{\n \"mainSummary\": \"A 2-3 sentence overview of the main themes and discussion points\",\n \"keyPoints\": [\"Point 1\", \"Point 2\", \"Point 3\", \"Point 4\", \"Point 5\"],\n \"trendingKeywords\": [\"keyword1\", \"keyword2\", \"keyword3\", \"keyword4\", \"keyword5\"],\n \"influentialAuthors\": [\"author1\", \"author2\", \"author3\"]\n}\n\nFocus on:\n1. The main themes and topics being discussed\n2. Any notable trends, events, or developments mentioned\n3. The overall tone and sentiment of the conversation\n4. Key players or influencers in the discussion\n5. Important keywords that capture the essence of the conversation\n\nProvide only valid JSON, no additional text.\n`;\n }\n\n /**\n * Generate a simple fallback summary when AI fails\n */\n private generateFallbackSummary(\n topic: Topic,\n groupedData: ReturnType,\n ): {\n mainSummary: string;\n keyPoints: string[];\n trendingKeywords: string[];\n influentialAuthors: string[];\n } {\n const { authorCounts, contentSample, mediaCount } = groupedData;\n \n const topAuthors = Object.entries(authorCounts)\n .sort(([,a], [,b]) => b - a)\n .slice(0, 3)\n .map(([author]) => author);\n\n return {\n mainSummary: `Discussion about ${topic.title} with ${contentSample.length} posts from ${Object.keys(authorCounts).length} contributors. ${mediaCount} posts included media content.`,\n keyPoints: [\n `${contentSample.length} total posts analyzed`,\n `${Object.keys(authorCounts).length} unique contributors`,\n `${mediaCount} posts with media content`,\n `Most active contributor: ${topAuthors[0] || \"Unknown\"}`,\n \"Detailed analysis unavailable due to processing error\",\n ],\n trendingKeywords: [topic.title.toLowerCase()],\n influentialAuthors: topAuthors,\n };\n }\n\n /**\n * Aggregate sentiment analysis results\n */\n private aggregateSentiment(sentimentResults: any[]): {\n sentiment: \"positive\" | \"negative\" | \"neutral\";\n confidence: number;\n score: number;\n } {\n if (sentimentResults.length === 0) {\n return { sentiment: \"neutral\", confidence: 0.5, score: 0 };\n }\n\n // Calculate average sentiment score and confidence\n const avgScore = sentimentResults.reduce((sum, result) => sum + result.score, 0) / sentimentResults.length;\n const avgConfidence = sentimentResults.reduce((sum, result) => sum + result.confidence, 0) / sentimentResults.length;\n\n // Determine overall sentiment based on average score\n let sentiment: \"positive\" | \"negative\" | \"neutral\" = \"neutral\";\n if (avgScore > 0.1) {\n sentiment = \"positive\";\n } else if (avgScore < -0.1) {\n sentiment = \"negative\";\n }\n\n return {\n sentiment,\n confidence: avgConfidence,\n score: avgScore,\n };\n }\n\n /**\n * Get recent summaries for a topic (for checking if summarization is needed)\n */\n async getRecentSummaries(topicId: number, hoursBack: number = 24): Promise {\n try {\n return await getSummarizationsForTopic(topicId, 10); // Get up to 10 recent summaries\n } catch (error: unknown) {\n console.error(`Error getting recent summaries for topic ${topicId}:`, error);\n return [];\n }\n }\n}","createdAt",["D",1757092784975],"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":510,"_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":511,"_80":512,"_82":513,"_84":24},"tree",[192,215,227,228,229,230,231],"files",[192,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,223,224,225,226,227,228,229,230,231],"counts",{"_182":139,"_183":62,"_184":139,"_185":186,"_187":188},"contents",[125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":176,"_31":177,"_29":178,"_135":-5,"_40":41,"_39":179,"_137":58,"_37":180,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_26":181},{"_42":171,"_31":172,"_29":173,"_135":-5,"_40":41,"_39":62,"_137":58,"_37":174,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_26":175},{"_42":164,"_31":165,"_29":166,"_135":-5,"_40":41,"_39":167,"_137":58,"_37":168,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_26":170},{"_42":157,"_31":158,"_29":159,"_135":-5,"_40":41,"_39":160,"_137":24,"_37":161,"_13":62,"_33":20,"_35":162,"_23":24,"_141":-5,"_26":163},{"_42":150,"_31":151,"_29":152,"_135":-5,"_40":41,"_39":153,"_137":24,"_37":154,"_13":139,"_33":20,"_35":155,"_23":24,"_141":-5,"_26":156},{"_42":143,"_31":144,"_29":145,"_135":-5,"_40":41,"_39":146,"_137":24,"_37":147,"_13":62,"_33":20,"_35":148,"_23":24,"_141":-5,"_26":149},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":138,"_13":139,"_33":34,"_35":140,"_23":24,"_141":-5,"_26":142},"269667fa-55f3-11f0-83aa-f69ea79377d9","setup-env.ts","2696689a-55f3-11f0-83aa-f69ea79377d9","parentId",8,"latest",["D",1751316326043],0,"// 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}",[144],"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 ",[151],"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",[158],"267864c6-55f3-11f0-ab57-f69ea79377d9","shared","267865ac-55f3-11f0-ab57-f69ea79377d9",3,["D",1751316325925],"directory",[165],"265c7ee6-55f3-11f0-894e-f69ea79377d9","frontend","265c7fb8-55f3-11f0-894e-f69ea79377d9",["D",1751316325744],[172],"266ad7e8-55f3-11f0-9719-f69ea79377d9","backend","266ad892-55f3-11f0-9719-f69ea79377d9",2,["D",1751316325838],[177],"pulls","branches","forks","envVars",{"_189":136,"_191":139},"connections",{"_189":139,"_190":139},"count","unfilledCount","emptyCount",{"_42":176,"_31":177,"_29":178,"_135":-5,"_40":41,"_39":179,"_137":58,"_37":507,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":508,"_26":509},{"_42":502,"_31":471,"_29":465,"_135":178,"_40":41,"_39":503,"_137":58,"_37":504,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":505,"_26":506},{"_42":495,"_31":151,"_29":496,"_135":465,"_40":41,"_39":497,"_137":58,"_37":498,"_13":139,"_33":20,"_35":499,"_23":24,"_141":-5,"_233":500,"_26":501},{"_42":487,"_31":488,"_29":489,"_135":465,"_40":41,"_39":490,"_137":58,"_37":491,"_13":139,"_33":34,"_35":492,"_23":24,"_141":-5,"_233":493,"_26":494},{"_42":480,"_31":417,"_29":481,"_135":465,"_40":41,"_39":482,"_137":58,"_37":483,"_13":139,"_33":34,"_35":484,"_23":24,"_141":-5,"_233":485,"_26":486},{"_42":472,"_31":473,"_29":474,"_135":465,"_40":41,"_39":475,"_137":58,"_37":476,"_13":139,"_33":34,"_35":477,"_23":24,"_141":-5,"_233":478,"_26":479},{"_42":462,"_31":463,"_29":464,"_135":465,"_40":41,"_39":466,"_137":58,"_37":467,"_13":139,"_33":34,"_35":468,"_23":24,"_141":-5,"_233":469,"_26":470},{"_42":455,"_31":456,"_29":457,"_135":178,"_40":41,"_39":458,"_137":58,"_37":459,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":460,"_26":461},{"_42":450,"_31":449,"_29":443,"_135":178,"_40":41,"_39":451,"_137":58,"_37":452,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":453,"_26":454},{"_42":440,"_31":441,"_29":442,"_135":443,"_40":41,"_39":444,"_137":58,"_37":445,"_13":139,"_33":34,"_35":446,"_23":24,"_141":-5,"_233":447,"_26":448},{"_42":432,"_31":433,"_29":434,"_135":178,"_40":41,"_39":435,"_137":24,"_37":436,"_13":139,"_33":34,"_35":437,"_23":24,"_141":-5,"_233":438,"_26":439},{"_42":423,"_31":424,"_29":425,"_135":178,"_40":41,"_39":426,"_137":58,"_37":427,"_13":139,"_33":428,"_35":429,"_23":24,"_141":-5,"_233":430,"_26":431},{"_42":416,"_31":417,"_29":56,"_135":178,"_40":41,"_39":418,"_137":24,"_37":419,"_13":331,"_33":356,"_35":420,"_23":24,"_141":-5,"_233":421,"_26":422},{"_42":408,"_31":409,"_29":410,"_135":178,"_40":41,"_39":411,"_137":58,"_37":412,"_13":139,"_33":356,"_35":413,"_23":24,"_141":-5,"_233":414,"_26":415},{"_42":400,"_31":401,"_29":402,"_135":178,"_40":41,"_39":403,"_137":58,"_37":404,"_13":139,"_33":356,"_35":405,"_23":24,"_141":-5,"_233":406,"_26":407},{"_42":392,"_31":393,"_29":394,"_135":178,"_40":41,"_39":395,"_137":58,"_37":396,"_13":139,"_33":347,"_35":397,"_23":24,"_141":-5,"_233":398,"_26":399},{"_42":384,"_31":385,"_29":386,"_135":178,"_40":41,"_39":387,"_137":58,"_37":388,"_13":139,"_33":356,"_35":389,"_23":24,"_141":-5,"_233":390,"_26":391},{"_42":376,"_31":377,"_29":378,"_135":178,"_40":41,"_39":379,"_137":58,"_37":380,"_13":139,"_33":34,"_35":381,"_23":24,"_141":-5,"_233":382,"_26":383},{"_42":368,"_31":369,"_29":370,"_135":178,"_40":41,"_39":371,"_137":58,"_37":372,"_13":139,"_33":34,"_35":373,"_23":24,"_141":-5,"_233":374,"_26":375},{"_42":360,"_31":361,"_29":362,"_135":178,"_40":41,"_39":363,"_137":58,"_37":364,"_13":139,"_33":347,"_35":365,"_23":24,"_141":-5,"_233":366,"_26":367},{"_42":351,"_31":352,"_29":353,"_135":178,"_40":41,"_39":354,"_137":58,"_37":355,"_13":139,"_33":356,"_35":357,"_23":24,"_141":-5,"_233":358,"_26":359},{"_42":342,"_31":343,"_29":344,"_135":178,"_40":41,"_39":345,"_137":58,"_37":346,"_13":139,"_33":347,"_35":348,"_23":24,"_141":-5,"_233":349,"_26":350},{"_42":338,"_31":32,"_29":30,"_135":178,"_40":41,"_39":14,"_137":24,"_37":339,"_13":139,"_33":34,"_35":36,"_23":24,"_141":-5,"_233":340,"_26":341},{"_42":171,"_31":172,"_29":173,"_135":-5,"_40":41,"_39":62,"_137":58,"_37":335,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":336,"_26":337},{"_42":330,"_31":273,"_29":267,"_135":173,"_40":41,"_39":331,"_137":58,"_37":332,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":333,"_26":334},{"_42":322,"_31":323,"_29":324,"_135":267,"_40":41,"_39":325,"_137":24,"_37":326,"_13":139,"_33":34,"_35":327,"_23":24,"_141":-5,"_233":328,"_26":329},{"_42":314,"_31":315,"_29":316,"_135":267,"_40":41,"_39":317,"_137":58,"_37":318,"_13":139,"_33":34,"_35":319,"_23":24,"_141":-5,"_233":320,"_26":321},{"_42":306,"_31":307,"_29":308,"_135":267,"_40":41,"_39":309,"_137":24,"_37":310,"_13":139,"_33":34,"_35":311,"_23":24,"_141":-5,"_233":312,"_26":313},{"_42":298,"_31":299,"_29":300,"_135":267,"_40":41,"_39":301,"_137":24,"_37":302,"_13":139,"_33":34,"_35":303,"_23":24,"_141":-5,"_233":304,"_26":305},{"_42":290,"_31":291,"_29":292,"_135":267,"_40":41,"_39":293,"_137":58,"_37":294,"_13":139,"_33":34,"_35":295,"_23":24,"_141":-5,"_233":296,"_26":297},{"_42":282,"_31":283,"_29":284,"_135":267,"_40":41,"_39":285,"_137":24,"_37":286,"_13":139,"_33":34,"_35":287,"_23":24,"_141":-5,"_233":288,"_26":289},{"_42":274,"_31":275,"_29":276,"_135":267,"_40":41,"_39":277,"_137":24,"_37":278,"_13":139,"_33":34,"_35":279,"_23":24,"_141":-5,"_233":280,"_26":281},{"_42":264,"_31":265,"_29":266,"_135":267,"_40":41,"_39":268,"_137":24,"_37":269,"_13":139,"_33":34,"_35":270,"_23":24,"_141":-5,"_233":271,"_26":272},{"_42":256,"_31":257,"_29":258,"_135":173,"_40":41,"_39":259,"_137":58,"_37":260,"_13":167,"_33":20,"_35":261,"_23":24,"_141":-5,"_233":262,"_26":263},{"_42":248,"_31":249,"_29":250,"_135":173,"_40":41,"_39":251,"_137":24,"_37":252,"_13":139,"_33":34,"_35":253,"_23":24,"_141":-5,"_233":254,"_26":255},{"_42":164,"_31":165,"_29":166,"_135":-5,"_40":41,"_39":167,"_137":58,"_37":245,"_13":139,"_33":169,"_35":-5,"_23":24,"_141":-5,"_233":246,"_26":247},{"_42":157,"_31":158,"_29":159,"_135":-5,"_40":41,"_39":160,"_137":24,"_37":242,"_13":62,"_33":20,"_35":162,"_23":24,"_141":-5,"_233":243,"_26":244},{"_42":150,"_31":151,"_29":152,"_135":-5,"_40":41,"_39":153,"_137":24,"_37":239,"_13":139,"_33":20,"_35":155,"_23":24,"_141":-5,"_233":240,"_26":241},{"_42":143,"_31":144,"_29":145,"_135":-5,"_40":41,"_39":146,"_137":24,"_37":236,"_13":62,"_33":20,"_35":148,"_23":24,"_141":-5,"_233":237,"_26":238},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":232,"_13":139,"_33":34,"_35":140,"_23":24,"_141":-5,"_233":234,"_26":235},["D",1751316326043],"children",[],[133],["D",1751403016301],[],[144],["D",1751316326042],[],[151],["D",1751317131694],[],[158],["D",1751316325925],[],[165],"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",[],[172,249],"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 ",[],[172,257],"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}",[],[172,273,265],"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",[],[172,273,275],"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}",[],[172,273,283],"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",[],[172,273,291],"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",[],[172,273,299],"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}",[],[172,273,307],"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",[],[172,273,315],"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",[],[172,273,323],"0698589e-55f5-11f0-9cfc-f69ea79377d9",10,["D",1751317131440],[217,218,219,220,221,222,223,224],[172,273],["D",1751316325744],[216,225,226],[172],"845e3558-8a7c-11f0-9d13-0224a6c84d84",["D",1757092784975],[],[177,32],"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}",[],[177,343],"844d8262-8a7c-11f0-81bc-0224a6c84d84","twitter-summarization-api.http.ts","844d830c-8a7c-11f0-81bc-0224a6c84d84",52,["D",1757092784854],"http","/**\n * HTTP endpoint for testing and manually triggering Twitter summarization\n * This provides a way to test the summarization functionality and manually generate summaries\n */\n\nimport { TwitterSummarizationService } from \"./twitter-summarization.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport { getAllTopics, getSummarizationsForTopic } from \"./database/queries.ts\";\n\n/**\n * HTTP endpoint for tweet summarization operations\n */\nexport default async function (req: Request): Promise {\n // Set CORS headers for all responses\n const headers = new Headers({\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n \"Content-Type\": \"application/json\",\n });\n\n // Handle preflight OPTIONS request\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers, status: 204 });\n }\n\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 const summarizationService = new TwitterSummarizationService();\n\n if (action === \"test\") {\n // Test the summarization service with sample data\n console.log(\"🧪 Testing summarization service...\");\n \n const topics = await getAllTopics();\n \n if (topics.length === 0) {\n responseData = {\n ...responseData,\n action: \"test\",\n status: \"warning\",\n message: \"No topics found. Please create some topics first.\",\n topics: [],\n };\n } else {\n // Test with the first topic only (to avoid hitting rate limits during testing)\n const testTopic = topics[0];\n console.log(`Testing with topic: ${testTopic.title} (ID: ${testTopic.id})`);\n\n const startTime = Date.now();\n const summary = await summarizationService.generateTopicSummary(testTopic.id!, {\n timeWindowHours: 48, // Look back further for testing\n maxTweets: 20, // Fewer tweets for testing\n includeMedia: true,\n includeSentiment: true,\n });\n\n const executionTime = Date.now() - startTime;\n\n if (!summary) {\n responseData = {\n ...responseData,\n action: \"test\",\n status: \"no_data\",\n message: `No recent posts found for topic: ${testTopic.title}`,\n topicTested: testTopic,\n availableTopics: topics.map(t => ({ id: t.id, title: t.title })),\n executionTimeMs: executionTime,\n };\n } else {\n responseData = {\n ...responseData,\n action: \"test\",\n status: \"success\",\n message: \"Test summarization completed successfully\",\n testSummary: summary,\n availableTopics: topics.map(t => ({ id: t.id, title: t.title })),\n executionTimeMs: executionTime,\n };\n }\n }\n\n } else if (action === \"generate\") {\n // Generate summaries for all topics or specific topic\n const topicId = url.searchParams.get(\"topicId\");\n const timeWindowHours = parseInt(url.searchParams.get(\"timeWindowHours\") || \"24\");\n const maxTweets = parseInt(url.searchParams.get(\"maxTweets\") || \"50\");\n const includeMedia = url.searchParams.get(\"includeMedia\") !== \"false\";\n const includeSentiment = url.searchParams.get(\"includeSentiment\") !== \"false\";\n\n const options = {\n timeWindowHours,\n maxTweets,\n includeMedia,\n includeSentiment,\n };\n\n const startTime = Date.now();\n\n if (topicId) {\n // Generate summary for specific topic\n const topicIdNum = parseInt(topicId);\n if (isNaN(topicIdNum)) {\n return new Response(JSON.stringify({\n status: \"error\",\n message: \"Invalid topic ID\",\n }), { headers, status: 400 });\n }\n\n console.log(`🤖 Generating summary for topic ${topicIdNum} with options:`, options);\n\n const summary = await summarizationService.generateTopicSummary(topicIdNum, options);\n \n if (!summary) {\n responseData = {\n ...responseData,\n action: \"generate\",\n status: \"no_data\",\n message: `No recent posts found for topic ${topicIdNum}`,\n topicId: topicIdNum,\n };\n } else {\n // Store the summary in the database\n const summaryId = await summarizationService.storeTopicSummary(summary);\n const executionTime = Date.now() - startTime;\n\n responseData = {\n ...responseData,\n action: \"generate\",\n status: \"success\",\n message: \"Summary generated and stored successfully\",\n summary,\n summaryId,\n executionTimeMs: executionTime,\n };\n }\n } else {\n // Generate summaries for all topics\n console.log(\"🤖 Generating summaries for all topics with options:\", options);\n\n const result = await summarizationService.generateAndStoreSummaries(options);\n const executionTime = Date.now() - startTime;\n\n responseData = {\n ...responseData,\n action: \"generate\",\n status: result.success ? \"success\" : \"partial_success\",\n message: `Generated ${result.generated} summaries, stored ${result.stored}`,\n results: {\n generated: result.generated,\n stored: result.stored,\n errors: result.errors.length,\n },\n summaries: result.summaries.map(s => ({\n topicId: s.topicId,\n topicTitle: s.topicTitle,\n tweetCount: s.tweetCount,\n sentiment: s.overallSentiment.sentiment,\n keyPointsCount: s.keyPoints.length,\n })),\n errors: result.errors,\n executionTimeMs: executionTime,\n };\n }\n\n } else if (action === \"summaries\") {\n // Get stored summaries for a topic\n const topicId = url.searchParams.get(\"topicId\");\n if (!topicId) {\n return new Response(JSON.stringify({\n status: \"error\",\n message: \"topicId parameter is required for summaries action\",\n }), { headers, status: 400 });\n }\n\n const topicIdNum = parseInt(topicId);\n if (isNaN(topicIdNum)) {\n return new Response(JSON.stringify({\n status: \"error\",\n message: \"Invalid topic ID\",\n }), { headers, status: 400 });\n }\n\n const limit = parseInt(url.searchParams.get(\"limit\") || \"10\");\n const summaries = await getSummarizationsForTopic(topicIdNum, limit);\n\n responseData = {\n ...responseData,\n action: \"summaries\",\n topicId: topicIdNum,\n summaries: summaries.map(s => ({\n id: s.id,\n content: JSON.parse(s.content),\n created_at: s.created_at,\n time_period: `${s.time_period_start} to ${s.time_period_end}`,\n })),\n count: summaries.length,\n };\n\n } else if (action === \"topics\") {\n // List all available topics\n const topics = await getAllTopics();\n \n responseData = {\n ...responseData,\n action: \"topics\",\n topics: topics.map(t => ({\n id: t.id,\n title: t.title,\n description: t.description,\n })),\n count: topics.length,\n };\n\n } else {\n // Default status action\n responseData = {\n ...responseData,\n action: \"status\",\n message: \"Summarization API is running\",\n availableActions: [\n \"test - Test summarization with first available topic\",\n \"generate - Generate summaries (add ?topicId=X for specific topic)\",\n \"summaries - Get stored summaries (requires ?topicId=X)\",\n \"topics - List all available topics\",\n ],\n config: {\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 }\n\n return new Response(JSON.stringify(responseData, null, 2), { headers });\n\n } catch (error: unknown) {\n console.error(\"Error processing summarization request:\", error);\n\n return new Response(\n JSON.stringify({\n status: \"error\",\n message: error instanceof Error ? error.message : String(error),\n timestamp: new Date().toISOString(),\n }, null, 2),\n { headers, status: 500 },\n );\n }\n}",[],[177,352],"843f5bba-8a7c-11f0-b5e7-0224a6c84d84","twitter-sentiment-job.cron.ts","843f5c6e-8a7c-11f0-b5e7-0224a6c84d84",50,["D",1757092784738],"import { initializeDatabase } from \"./database/migrations.ts\";\nimport {\n createOrUpdatePostSentiment,\n getPostsWithoutSentimentAnalysis,\n} from \"./database/queries.ts\";\nimport { TwitterSentimentAnalyzer } from \"./twitter-sentiment.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\n\n/**\n * Cron job that runs on a schedule to analyze tweets for sentiment\n * Default schedule: Every 4 hours\n */\nexport default async function () {\n console.log(\"Starting scheduled sentiment analysis job\");\n\n try {\n // Initialize database\n await initializeDatabase();\n\n // Create sentiment analyzer with configuration from environment variables\n const analyzer = new TwitterSentimentAnalyzer(\n TwitterSentimentAnalyzer.loadConfigFromEnv(),\n );\n\n // Get batch size from environment or use default\n const batchSize = parseInt(\n Deno.env.get(\"TWITTER_SENTIMENT_JOB_BATCH_SIZE\") || \"50\",\n 10,\n );\n\n // Get unanalyzed posts\n const posts = await getPostsWithoutSentimentAnalysis(batchSize);\n\n if (posts.length === 0) {\n console.log(\"No unanalyzed posts found\");\n return;\n }\n\n console.log(`Analyzing sentiment for ${posts.length} posts`);\n\n // Analyze sentiment\n const sentimentResults = await analyzer.analyzeBatch(posts);\n\n // Store results in database\n let storedCount = 0;\n for (const result of sentimentResults) {\n await createOrUpdatePostSentiment(result);\n storedCount++;\n }\n\n console.log(`Completed sentiment analysis: ${storedCount} results stored`);\n\n // Send notification email if enabled\n const sendNotification =\n Deno.env.get(\"TWITTER_SENTIMENT_JOB_NOTIFY\") === \"true\";\n if (sendNotification && storedCount > 0) {\n const sentimentCounts = {\n positive: sentimentResults.filter((r) =>\n r.sentiment === \"positive\"\n ).length,\n negative: sentimentResults.filter((r) =>\n r.sentiment === \"negative\"\n ).length,\n neutral: sentimentResults.filter((r) =>\n r.sentiment === \"neutral\"\n ).length,\n };\n\n await email({\n subject: `OffX: Sentiment Analysis Complete (${storedCount} posts)`,\n text: `\nSentiment analysis job completed successfully.\n\nPosts analyzed: ${storedCount}\n- Positive: ${sentimentCounts.positive}\n- Negative: ${sentimentCounts.negative}\n- Neutral: ${sentimentCounts.neutral}\n\nJob completed at: ${new Date().toISOString()}\n `,\n html: `\n

Sentiment Analysis Job Complete

The scheduled sentiment analysis job has completed successfully.

\n\n

Summary

Posts analyzed: ${storedCount}
Positive: ${sentimentCounts.positive}
Negative: ${sentimentCounts.negative}
Neutral: ${sentimentCounts.neutral}

\n\n

Job completed at: ${new Date().toISOString()}

\n `,\n });\n }\n } catch (error: unknown) {\n console.error(\"Error in sentiment analysis job:\", error);\n\n const errorMessage = error instanceof Error ? error instanceof Error ? error.message : String(error) : String(error);\n\n // Send error notification\n try {\n await email({\n subject: \"OffX: Sentiment Analysis Job Failed\",\n text: `\nSentiment analysis job failed with error:\n${errorMessage}\n\nError occurred at: ${new Date().toISOString()}\n `,\n html: `\n

Sentiment Analysis Job Failed

The scheduled sentiment analysis job encountered an error.

\n\n

Error Details

${errorMessage}

\n\n

Error occurred at: ${new Date().toISOString()}

\n `,\n });\n } catch (emailError) {\n console.error(\"Failed to send error notification email:\", emailError);\n }\n\n throw error; // Re-throw to ensure the job is marked as failed\n }\n}\n",[],[177,361],"844a4570-8a7c-11f0-a4f1-0224a6c84d84","twitter-processor.ts","844a4642-8a7c-11f0-a4f1-0224a6c84d84",51,["D",1757092784812],"import { Post, PostMedia } from \"./database/queries.ts\";\n\n/**\n * Interface for filter configuration\n */\nexport interface TwitterFilterConfig {\n keywords?: string[];\n languages?: string[];\n excludeKeywords?: string[];\n excludeUsers?: string[];\n includeUsers?: string[];\n minFavoriteCount?: number;\n minRetweetCount?: number;\n includeRetweets?: boolean;\n includeReplies?: boolean;\n}\n\n/**\n * Default filter configuration\n */\nexport const DEFAULT_FILTER_CONFIG: TwitterFilterConfig = {\n languages: [\"en\"],\n includeRetweets: false,\n includeReplies: false,\n};\n\n/**\n * Twitter data processing pipeline\n */\nexport class TwitterProcessor {\n private filterConfig: TwitterFilterConfig;\n\n /**\n * Create a new TwitterProcessor with the specified filter configuration\n * @param config Filter configuration (optional, defaults to DEFAULT_FILTER_CONFIG)\n */\n constructor(config: TwitterFilterConfig = DEFAULT_FILTER_CONFIG) {\n this.filterConfig = {\n ...DEFAULT_FILTER_CONFIG,\n ...config,\n };\n }\n\n /**\n * Process a batch of tweets through the pipeline\n * @param tweets Array of tweets to process\n * @returns Filtered and processed tweets\n */\n processTweets(tweets: Post[]): Post[] {\n if (!tweets || !Array.isArray(tweets) || tweets.length === 0) {\n return [];\n }\n\n return tweets\n .filter((tweet) => this.applyFilters(tweet))\n .map((tweet) => this.transformTweet(tweet));\n }\n\n /**\n * Apply all configured filters to a tweet\n * @param tweet The tweet to filter\n * @returns True if the tweet passes all filters, false otherwise\n */\n private applyFilters(tweet: Post): boolean {\n // Filter by language\n if (this.filterConfig.languages && this.filterConfig.languages.length > 0) {\n // Note: Twitter API doesn't always provide language info in the response\n // This would need to be extended if language detection is critical\n // For now, we'll assume English if not specified\n const tweetLanguage = \"en\";\n if (!this.filterConfig.languages.includes(tweetLanguage)) {\n return false;\n }\n }\n\n // Filter retweets if configured\n if (\n !this.filterConfig.includeRetweets && tweet.content.startsWith(\"RT @\")\n ) {\n return false;\n }\n\n // Filter replies if configured\n if (!this.filterConfig.includeReplies && tweet.content.startsWith(\"@\")) {\n return false;\n }\n\n // Filter by keywords\n if (this.filterConfig.keywords && this.filterConfig.keywords.length > 0) {\n const tweetText = tweet.content.toLowerCase();\n const hasKeyword = this.filterConfig.keywords.some((keyword) =>\n tweetText.includes(keyword.toLowerCase())\n );\n\n if (!hasKeyword) {\n return false;\n }\n }\n\n // Filter by excluded keywords\n if (\n this.filterConfig.excludeKeywords &&\n this.filterConfig.excludeKeywords.length > 0\n ) {\n const tweetText = tweet.content.toLowerCase();\n const hasExcludedKeyword = this.filterConfig.excludeKeywords.some(\n (keyword) => tweetText.includes(keyword.toLowerCase()),\n );\n\n if (hasExcludedKeyword) {\n return false;\n }\n }\n\n // Filter by included users\n if (\n this.filterConfig.includeUsers &&\n this.filterConfig.includeUsers.length > 0\n ) {\n const username = tweet.author_username.toLowerCase();\n const isIncludedUser = this.filterConfig.includeUsers.some((user) =>\n username === user.toLowerCase()\n );\n\n if (!isIncludedUser) {\n return false;\n }\n }\n\n // Filter by excluded users\n if (\n this.filterConfig.excludeUsers &&\n this.filterConfig.excludeUsers.length > 0\n ) {\n const username = tweet.author_username.toLowerCase();\n const isExcludedUser = this.filterConfig.excludeUsers.some((user) =>\n username === user.toLowerCase()\n );\n\n if (isExcludedUser) {\n return false;\n }\n }\n\n return true;\n }\n\n /**\n * Transform a tweet for storage and processing\n * @param tweet The tweet to transform\n * @returns Transformed tweet\n */\n private transformTweet(tweet: Post): Post {\n // Create a copy of the tweet to avoid modifying the original\n const transformedTweet: Post = { ...tweet };\n\n // Clean up the content (e.g., remove excessive whitespace, normalize URLs)\n transformedTweet.content = this.cleanContent(transformedTweet.content);\n\n // Transform media if present\n if (transformedTweet.media && transformedTweet.media.length > 0) {\n transformedTweet.media = transformedTweet.media.map((media) =>\n this.transformMedia(media)\n );\n }\n\n return transformedTweet;\n }\n\n /**\n * Clean up tweet content\n * @param content The raw tweet content\n * @returns Cleaned content\n */\n private cleanContent(content: string): string {\n // Remove excessive whitespace\n let cleaned = content.replace(/\\s+/g, \" \").trim();\n\n // Normalize URLs (optional)\n // This is a simple example - could be expanded for more sophisticated URL normalization\n cleaned = cleaned.replace(/https:\\/\\/t\\.co\\/\\w+/g, (url) => url.trim());\n\n return cleaned;\n }\n\n /**\n * Transform media attachments\n * @param media The media to transform\n * @returns Transformed media\n */\n private transformMedia(media: PostMedia): PostMedia {\n // Create a copy to avoid modifying the original\n const transformedMedia: PostMedia = { ...media };\n\n // Ensure media URLs are properly formatted\n if (\n transformedMedia.media_url &&\n !transformedMedia.media_url.startsWith(\"http\")\n ) {\n transformedMedia.media_url = `https://${transformedMedia.media_url}`;\n }\n\n return transformedMedia;\n }\n\n /**\n * Load filter configuration from environment variables\n * @returns TwitterFilterConfig object based on environment variables\n */\n static loadConfigFromEnv(): TwitterFilterConfig {\n const config: TwitterFilterConfig = { ...DEFAULT_FILTER_CONFIG };\n\n // Keywords filter\n const keywordsEnv = Deno.env.get(\"TWITTER_FILTER_KEYWORDS\");\n if (keywordsEnv) {\n config.keywords = keywordsEnv.split(\",\").map((k) => k.trim());\n }\n\n // Excluded keywords\n const excludeKeywordsEnv = Deno.env.get(\"TWITTER_FILTER_EXCLUDE_KEYWORDS\");\n if (excludeKeywordsEnv) {\n config.excludeKeywords = excludeKeywordsEnv.split(\",\").map((k) =>\n k.trim()\n );\n }\n\n // Included users\n const includeUsersEnv = Deno.env.get(\"TWITTER_FILTER_INCLUDE_USERS\");\n if (includeUsersEnv) {\n config.includeUsers = includeUsersEnv.split(\",\").map((u) => u.trim());\n }\n\n // Excluded users\n const excludeUsersEnv = Deno.env.get(\"TWITTER_FILTER_EXCLUDE_USERS\");\n if (excludeUsersEnv) {\n config.excludeUsers = excludeUsersEnv.split(\",\").map((u) => u.trim());\n }\n\n // Languages\n const languagesEnv = Deno.env.get(\"TWITTER_FILTER_LANGUAGES\");\n if (languagesEnv) {\n config.languages = languagesEnv.split(\",\").map((l) => l.trim());\n }\n\n // Boolean flags\n const includeRetweetsEnv = Deno.env.get(\"TWITTER_FILTER_INCLUDE_RETWEETS\");\n if (includeRetweetsEnv) {\n config.includeRetweets = includeRetweetsEnv.toLowerCase() === \"true\";\n }\n\n const includeRepliesEnv = Deno.env.get(\"TWITTER_FILTER_INCLUDE_REPLIES\");\n if (includeRepliesEnv) {\n config.includeReplies = includeRepliesEnv.toLowerCase() === \"true\";\n }\n\n return config;\n }\n}\n",[],[177,369],"84540024-8a7c-11f0-931f-0224a6c84d84","twitter-media.ts","845400c4-8a7c-11f0-931f-0224a6c84d84",53,["D",1757092784793],"import {\n createPostMedia,\n getPostMediaByPostId,\n Post,\n PostMedia,\n} from \"./database/queries.ts\";\n\n/**\n * Media type enumeration\n */\nexport enum MediaType {\n PHOTO = \"photo\",\n VIDEO = \"video\",\n GIF = \"animated_gif\",\n UNKNOWN = \"unknown\",\n}\n\n/**\n * Extended media metadata interface\n */\nexport interface MediaMetadata {\n width?: number;\n height?: number;\n duration_ms?: number;\n preview_url?: string;\n alt_text?: string;\n variants?: MediaVariant[];\n}\n\n/**\n * Media variant interface (for videos with multiple formats/bitrates)\n */\nexport interface MediaVariant {\n content_type: string;\n url: string;\n bitrate?: number;\n}\n\n/**\n * Extended post media interface with metadata\n */\nexport interface ExtendedPostMedia extends PostMedia {\n metadata?: MediaMetadata;\n}\n\n/**\n * Twitter media extraction and processing class\n */\nexport class TwitterMediaExtractor {\n /**\n * Extract media from Twitter API response\n * @param timelineData Twitter API response data\n * @param tweetId ID of the tweet to extract media from\n * @returns Array of extracted media items\n */\n static extractMediaFromResponse(\n timelineData: any,\n tweetId: string,\n ): ExtendedPostMedia[] {\n const media: ExtendedPostMedia[] = [];\n\n // Find the tweet in the response\n const tweet = timelineData.data?.find((t: any) => t.id === tweetId);\n\n if (\n !tweet || !tweet.attachments?.media_keys || !timelineData.includes?.media\n ) {\n return media;\n }\n\n // Extract media items\n for (const mediaKey of tweet.attachments.media_keys) {\n const mediaItem = timelineData.includes.media.find(\n (m: any) => m.media_key === mediaKey,\n );\n\n if (mediaItem) {\n const mediaType = this.normalizeMediaType(mediaItem.type);\n\n // Extract metadata\n const metadata: MediaMetadata = {\n width: mediaItem.width,\n height: mediaItem.height,\n duration_ms: mediaItem.duration_ms,\n preview_url: mediaItem.preview_image_url,\n alt_text: mediaItem.alt_text,\n };\n\n // Extract variants for videos\n if (mediaItem.variants && Array.isArray(mediaItem.variants)) {\n metadata.variants = mediaItem.variants.map((v: any) => ({\n content_type: v.content_type,\n url: v.url,\n bitrate: v.bit_rate,\n }));\n }\n\n // Create media object\n const postMedia: ExtendedPostMedia = {\n post_id: 0, // This will be set after post creation\n media_url: this.getBestMediaUrl(mediaItem),\n media_type: mediaType,\n alt_text: mediaItem.alt_text,\n metadata,\n };\n\n media.push(postMedia);\n }\n }\n\n return media;\n }\n\n /**\n * Get the best media URL based on media type\n * @param mediaItem Twitter API media item\n * @returns Best URL for the media\n */\n private static getBestMediaUrl(mediaItem: any): string {\n // For photos, use the URL directly\n if (mediaItem.url) {\n return mediaItem.url;\n }\n\n // For videos and GIFs, try to get the best quality variant\n if (mediaItem.variants && Array.isArray(mediaItem.variants)) {\n // Sort variants by bitrate (highest first)\n const sortedVariants = [...mediaItem.variants].sort((a, b) =>\n (b.bit_rate || 0) - (a.bit_rate || 0)\n );\n\n // Get the highest quality variant\n if (sortedVariants.length > 0) {\n return sortedVariants[0].url;\n }\n }\n\n // Fallback to preview image\n if (mediaItem.preview_image_url) {\n return mediaItem.preview_image_url;\n }\n\n return \"\";\n }\n\n /**\n * Normalize media type from Twitter API\n * @param type Media type from Twitter API\n * @returns Normalized media type\n */\n private static normalizeMediaType(type: string): string {\n switch (type) {\n case \"photo\":\n return MediaType.PHOTO;\n case \"video\":\n return MediaType.VIDEO;\n case \"animated_gif\":\n return MediaType.GIF;\n default:\n return MediaType.UNKNOWN;\n }\n }\n\n /**\n * Store media items for a post\n * @param postId Database ID of the post\n * @param media Array of media items to store\n * @returns Number of media items stored\n */\n static async storePostMedia(\n postId: number,\n media: ExtendedPostMedia[],\n ): Promise {\n if (!postId || !media || media.length === 0) {\n return 0;\n }\n\n let storedCount = 0;\n\n // Check for existing media\n const existingMedia = await getPostMediaByPostId(postId);\n\n // If media already exists for this post, skip\n if (existingMedia && existingMedia.length > 0) {\n return 0;\n }\n\n // Store each media item\n for (const mediaItem of media) {\n // Set the post ID\n mediaItem.post_id = postId;\n\n // Store in database\n await createPostMedia(mediaItem);\n storedCount++;\n }\n\n return storedCount;\n }\n\n /**\n * Process and enhance media items\n * @param media Array of media items to process\n * @returns Processed media items\n */\n static processMedia(media: ExtendedPostMedia[]): ExtendedPostMedia[] {\n return media.map((item) => {\n // Create a copy to avoid modifying the original\n const processedItem = { ...item };\n\n // Ensure media URLs are properly formatted\n if (\n processedItem.media_url && !processedItem.media_url.startsWith(\"http\")\n ) {\n processedItem.media_url = `https://${processedItem.media_url}`;\n }\n\n // Process preview URLs in metadata\n if (\n processedItem.metadata?.preview_url &&\n !processedItem.metadata.preview_url.startsWith(\"http\")\n ) {\n processedItem.metadata.preview_url =\n `https://${processedItem.metadata.preview_url}`;\n }\n\n // Process variant URLs\n if (processedItem.metadata?.variants) {\n processedItem.metadata.variants = processedItem.metadata.variants.map(\n (variant) => {\n if (variant.url && !variant.url.startsWith(\"http\")) {\n return { ...variant, url: `https://${variant.url}` };\n }\n return variant;\n },\n );\n }\n\n return processedItem;\n });\n }\n}\n",[],[177,377],"84232e40-8a7c-11f0-9716-0224a6c84d84","twitter-media-test.http.ts","84232f08-8a7c-11f0-9716-0224a6c84d84",45,["D",1757092784576],"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",[],[177,385],"845a41a0-8a7c-11f0-be41-0224a6c84d84","twitter-fetch.cron.ts","845a4236-8a7c-11f0-be41-0224a6c84d84",54,["D",1757092784950],"import { initializeTwitterClient, storeTweets } from \"./twitter-api.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { TwitterProcessor } from \"./twitter-processor.ts\";\nimport {\n TwitterError,\n TwitterErrorType,\n withRetry,\n} from \"./twitter-error-handler.ts\";\n\n/**\n * Cron job to fetch tweets from Twitter API and store them in the database\n * This function runs on a schedule defined in Val Town\n */\nexport default async function fetchTwitterData() {\n console.log(\"Starting Twitter data fetch...\");\n\n try {\n // Initialize the database\n await initializeDatabase();\n\n // Initialize Twitter client\n const twitterClient = initializeTwitterClient();\n\n // Fetch tweets with retry mechanism already built into the client\n console.log(\"Fetching tweets from Twitter API...\");\n let rawTweets;\n try {\n rawTweets = await twitterClient.fetchHomeTimeline(100);\n console.log(`Fetched ${rawTweets.length} raw tweets from Twitter API`);\n } catch (error: unknown) {\n // Convert to TwitterError for better error handling\n const errorInstance = error instanceof Error ? error : new Error(String(error));\n const twitterError = error instanceof TwitterError\n ? error\n : new TwitterError(\n `Failed to fetch tweets: ${errorInstance.message}`,\n TwitterErrorType.Unknown,\n undefined,\n errorInstance,\n );\n\n // Handle different error types appropriately\n if (twitterError.type === TwitterErrorType.RateLimit) {\n const resetTime = twitterError.rateLimitReset;\n const resetMessage = resetTime\n ? `Rate limit will reset at ${resetTime.toLocaleString()}`\n : \"Rate limit exceeded\";\n\n throw new Error(`Twitter API rate limit exceeded. ${resetMessage}`);\n } else if (twitterError.type === TwitterErrorType.Authentication) {\n throw new Error(\n \"Twitter API authentication failed. Please check your API credentials.\",\n );\n } else {\n throw twitterError;\n }\n }\n\n // Initialize the processor with config from environment variables\n const processor = new TwitterProcessor(\n TwitterProcessor.loadConfigFromEnv(),\n );\n\n // Process tweets through the pipeline\n const processedTweets = processor.processTweets(rawTweets);\n console.log(`Processed ${processedTweets.length} tweets after filtering`);\n\n // Store tweets in the database with deduplication and built-in retry\n const newTweetsCount = await storeTweets(processedTweets);\n console.log(`Stored ${newTweetsCount} new tweets in the database`);\n\n // Send notification email if configured\n const emailTo = Deno.env.get(\"EMAIL_TO\");\n if (emailTo && newTweetsCount > 0) {\n await withRetry(async () => {\n await email({\n to: emailTo,\n subject: `OffX: Fetched ${newTweetsCount} new tweets`,\n text:\n `The OffX Twitter ingestion service has fetched ${rawTweets.length} tweets, processed ${processedTweets.length} after filtering, and stored ${newTweetsCount} new tweets.`,\n html: `

OffX Twitter Ingestion

The OffX Twitter ingestion service has:

Fetched ${rawTweets.length} tweets
Processed ${processedTweets.length} after filtering
Stored ${newTweetsCount} new tweets

`,\n });\n });\n }\n\n return {\n success: true,\n fetchedCount: rawTweets.length,\n processedCount: processedTweets.length,\n newCount: newTweetsCount,\n timestamp: new Date().toISOString(),\n };\n } catch (error: unknown) {\n console.error(\"Error in Twitter fetch cron job:\", error);\n\n // Extract useful error information\n const errorInstance = error instanceof Error ? error : new Error(String(error));\n const errorType = error instanceof TwitterError ? error.type : \"unknown\";\n const errorMessage = errorInstance.message || \"Unknown error\";\n const statusCode = error instanceof TwitterError\n ? error.statusCode\n : undefined;\n\n // Construct detailed error message\n const detailedError = `\n Type: ${errorType}\n Message: ${errorMessage}\n ${statusCode ? `Status Code: ${statusCode}` : \"\"}\n Time: ${new Date().toISOString()}\n `;\n\n // Send error notification with retry mechanism\n try {\n await withRetry(async () => {\n await email({\n subject: \"OffX: Twitter Fetch Error\",\n text: `Error in Twitter fetch cron job: ${detailedError}`,\n html: `

OffX Twitter Fetch Error

The following error occurred during the Twitter fetch cron job:

${detailedError}

Please check the logs for more details.

`,\n });\n });\n } catch (emailError) {\n console.error(\"Failed to send error notification email:\", emailError);\n }\n\n return {\n success: false,\n error: errorMessage,\n errorType,\n statusCode,\n timestamp: new Date().toISOString(),\n };\n }\n}\n",[],[177,393],"842891a0-8a7c-11f0-af15-0224a6c84d84","twitter-error-test.http.ts","84289240-8a7c-11f0-af15-0224a6c84d84",46,["D",1757092784592],"import { initializeTwitterClient } from \"./twitter-api.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\nimport {\n DEFAULT_RETRY_CONFIG,\n RetryConfig,\n TwitterError,\n TwitterErrorType,\n withRetry,\n} from \"./twitter-error-handler.ts\";\n\n/**\n * HTTP endpoint to test Twitter error handling and retry mechanisms\n * This endpoint allows testing and validation of the error handling 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 === \"test-retry\") {\n // Get retry configuration from query params or use defaults\n const maxRetries = parseInt(\n url.searchParams.get(\"max_retries\") || \"3\",\n 10,\n );\n const initialDelayMs = parseInt(\n url.searchParams.get(\"initial_delay\") || \"1000\",\n 10,\n );\n const maxDelayMs = parseInt(\n url.searchParams.get(\"max_delay\") || \"60000\",\n 10,\n );\n const backoffMultiplier = parseFloat(\n url.searchParams.get(\"backoff\") || \"2\",\n );\n const jitterFactor = parseFloat(url.searchParams.get(\"jitter\") || \"0.2\");\n\n // Create custom retry config for testing\n const retryConfig: RetryConfig = {\n ...DEFAULT_RETRY_CONFIG,\n maxRetries,\n initialDelayMs,\n maxDelayMs,\n backoffMultiplier,\n jitterFactor,\n };\n\n // Simulate a function that fails a certain number of times before succeeding\n const failCount = parseInt(url.searchParams.get(\"fail_count\") || \"2\", 10);\n let attemptCount = 0;\n\n const retryResult = await withRetry(async () => {\n attemptCount++;\n console.log(\n `Retry test attempt ${attemptCount} of ${failCount + 1} needed`,\n );\n\n if (attemptCount <= failCount) {\n throw new Error(`Simulated failure on attempt ${attemptCount}`);\n }\n\n return {\n message: \"Operation succeeded after retries\",\n attemptCount,\n };\n }, retryConfig);\n\n responseData = {\n ...responseData,\n action: \"test-retry\",\n retryConfig,\n retryResult,\n };\n } else if (action === \"test-error-types\") {\n // Test different error types\n const errorType = url.searchParams.get(\"type\") || \"rate_limit\";\n let error: TwitterError;\n\n switch (errorType) {\n case \"rate_limit\":\n error = new TwitterError(\n \"Twitter API rate limit exceeded\",\n TwitterErrorType.RateLimit,\n 429,\n );\n // Set rate limit reset time to 30 seconds from now\n error.rateLimitReset = new Date(Date.now() + 30000);\n break;\n\n case \"authentication\":\n error = new TwitterError(\n \"Twitter API authentication failed\",\n TwitterErrorType.Authentication,\n 401,\n );\n break;\n\n case \"server_error\":\n error = new TwitterError(\n \"Twitter server error\",\n TwitterErrorType.ServerError,\n 500,\n );\n break;\n\n case \"network_error\":\n error = new TwitterError(\n \"Network connection failed\",\n TwitterErrorType.NetworkError,\n );\n break;\n\n default:\n error = new TwitterError(\n \"Unknown error type\",\n TwitterErrorType.Unknown,\n );\n }\n\n responseData = {\n ...responseData,\n action: \"test-error-types\",\n errorType,\n error: {\n message: error instanceof Error ? error.message : String(error),\n type: error.type,\n statusCode: error.statusCode,\n isRetryable: error.isRetryable,\n rateLimitReset: error.rateLimitReset,\n },\n };\n } else if (action === \"test-live-retry\") {\n // Test retry mechanism with actual Twitter API\n // Get custom retry config\n const maxRetries = parseInt(\n url.searchParams.get(\"max_retries\") || \"3\",\n 10,\n );\n const initialDelayMs = parseInt(\n url.searchParams.get(\"initial_delay\") || \"1000\",\n 10,\n );\n\n const retryConfig: RetryConfig = {\n ...DEFAULT_RETRY_CONFIG,\n maxRetries,\n initialDelayMs,\n };\n\n // Initialize Twitter client with custom retry config\n const twitterClient = initializeTwitterClient();\n\n // Fetch tweets with retry mechanism\n const startTime = Date.now();\n const tweets = await twitterClient.fetchHomeTimeline(10);\n const endTime = Date.now();\n\n responseData = {\n ...responseData,\n action: \"test-live-retry\",\n retryConfig,\n tweetCount: tweets.length,\n executionTimeMs: endTime - startTime,\n tweetSample: tweets.slice(0, 2),\n };\n } else if (action === \"retry-config\") {\n // Show current retry configuration\n const config = DEFAULT_RETRY_CONFIG;\n\n // Get environment overrides\n const maxRetries = Deno.env.get(\"TWITTER_MAX_RETRIES\");\n const initialDelay = Deno.env.get(\"TWITTER_INITIAL_DELAY_MS\");\n const maxDelay = Deno.env.get(\"TWITTER_MAX_DELAY_MS\");\n const backoffMultiplier = Deno.env.get(\"TWITTER_BACKOFF_MULTIPLIER\");\n const jitterFactor = Deno.env.get(\"TWITTER_JITTER_FACTOR\");\n\n responseData = {\n ...responseData,\n action: \"retry-config\",\n defaultConfig: config,\n environmentOverrides: {\n maxRetries: maxRetries ? parseInt(maxRetries, 10) : undefined,\n initialDelayMs: initialDelay ? parseInt(initialDelay, 10) : undefined,\n maxDelayMs: maxDelay ? parseInt(maxDelay, 10) : undefined,\n backoffMultiplier: backoffMultiplier\n ? parseFloat(backoffMultiplier)\n : undefined,\n jitterFactor: jitterFactor ? parseFloat(jitterFactor) : undefined,\n },\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 error test endpoint:\", error);\n\n // Convert to TwitterError if needed\n const twitterError = error instanceof TwitterError\n ? error\n : TwitterError.fromError(error instanceof Error ? error : new Error(String(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 errorType: twitterError.type,\n isRetryable: twitterError.isRetryable,\n statusCode: twitterError.statusCode,\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",[],[177,401],"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",[],[177,409],"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;",[],[177,417],"84350570-8a7c-11f0-b5d4-0224a6c84d84","email-delivery.ts","8435062e-8a7c-11f0-b5d4-0224a6c84d84",48,["D",1757092784657],"email","/**\n * Email delivery service for sending AI-generated summaries to users\n * Provides user-friendly summary emails with rich formatting\n */\n\nimport { email } from \"https://esm.town/v/std/email\";\nimport { getRecentSummarizations } from \"./database/queries.ts\";\nimport type { TopicSummary } from \"./twitter-summarization.ts\";\n\nexport interface EmailDeliveryOptions {\n recipientEmail: string;\n subject?: string;\n includeLastHours?: number;\n maxSummaries?: number;\n includeMetrics?: boolean;\n}\n\nexport interface EmailSummaryData {\n id: number;\n topicTitle: string;\n content: {\n summary: string;\n keyPoints: string[];\n sentiment: {\n sentiment: \"positive\" | \"negative\" | \"neutral\";\n confidence: number;\n score: number;\n };\n tweetCount: number;\n timeWindow: string;\n trendingKeywords: string[];\n influentialAuthors: string[];\n };\n created_at: string;\n time_period: string;\n}\n\n/**\n * Main email delivery service class\n */\nexport class EmailDeliveryService {\n \n /**\n * Send latest summaries via email\n */\n async sendLatestSummaries(options: EmailDeliveryOptions): Promise<{\n success: boolean;\n sentCount: number;\n error?: string;\n }> {\n try {\n const {\n recipientEmail,\n subject = \"Your Twitter Feed Summary\",\n maxSummaries = 10,\n includeMetrics = true,\n } = options;\n\n console.log(`📧 Preparing to send summary email to ${recipientEmail}`);\n\n // Fetch recent summaries from database\n const summaries = await this.fetchRecentSummaries(maxSummaries);\n \n if (summaries.length === 0) {\n console.log(\"📧 No recent summaries found, skipping email\");\n return { success: true, sentCount: 0 };\n }\n\n // Generate email content\n const emailContent = this.generateEmailTemplate(summaries, includeMetrics);\n const finalSubject = this.generateSubject(subject, summaries.length);\n\n // Send email with retry logic\n await this.sendEmailWithRetry({\n to: recipientEmail,\n subject: finalSubject,\n html: emailContent.html,\n text: emailContent.text,\n });\n\n console.log(`📧 Successfully sent summary email with ${summaries.length} summaries`);\n return { success: true, sentCount: summaries.length };\n\n } catch (error: unknown) {\n console.error(\"📧 Failed to send summary email:\", error);\n return { \n success: false, \n sentCount: 0, \n error: error instanceof Error ? error instanceof Error ? error.message : String(error) : String(error)\n };\n }\n }\n\n /**\n * Fetch recent summaries from database and format them\n */\n private async fetchRecentSummaries(limit: number): Promise {\n try {\n const rawSummaries = await getRecentSummarizations(limit);\n \n return rawSummaries.map(summary => ({\n id: summary.id!,\n topicTitle: (summary as any).topic_title || \"Unknown Topic\",\n content: JSON.parse(summary.content),\n created_at: summary.created_at!,\n time_period: `${summary.time_period_start} to ${summary.time_period_end}`,\n }));\n } catch (error: unknown) {\n console.error(\"Error fetching summaries:\", error);\n return [];\n }\n }\n\n /**\n * Generate email subject line\n */\n private generateSubject(baseSubject: string, summaryCount: number): string {\n const timeStr = new Date().toLocaleDateString();\n return `${baseSubject} - ${summaryCount} topics (${timeStr})`;\n }\n\n /**\n * Generate complete email template with HTML and text versions\n */\n private generateEmailTemplate(summaries: EmailSummaryData[], includeMetrics: boolean): {\n html: string;\n text: string;\n } {\n const html = this.generateHtmlTemplate(summaries, includeMetrics);\n const text = this.generateTextTemplate(summaries, includeMetrics);\n \n return { html, text };\n }\n\n /**\n * Generate HTML email template\n */\n private generateHtmlTemplate(summaries: EmailSummaryData[], includeMetrics: boolean): string {\n const summaryCards = summaries.map(summary => this.generateSummaryCard(summary)).join('\\n');\n \n const metricsSection = includeMetrics ? `\n

📊 Summary Metrics

Topics covered: ${summaries.length}
Total tweets analyzed: ${summaries.reduce((sum, s) => sum + s.content.tweetCount, 0)}
Sentiment breakdown: ${this.getSentimentBreakdown(summaries)}
Generated: ${new Date().toLocaleString()}

\n ` : '';\n\n return `\n \n \n \n \n \n Your Twitter Feed Summary\n \n \n \n

🐦 Your Twitter Feed Summary

AI-powered insights from your social media

\n\n ${metricsSection}\n\n

📝 Topic Summaries

\n ${summaryCards}\n

\n\n

\n Generated by OffX AI Summary Service
\n This email contains AI-generated content based on your Twitter feed\n

\n \n \n \n `;\n }\n\n /**\n * Generate individual summary card HTML\n */\n private generateSummaryCard(summary: EmailSummaryData): string {\n const sentimentColor = {\n positive: '#28a745',\n negative: '#dc3545',\n neutral: '#6c757d'\n }[summary.content.sentiment.sentiment];\n\n const keyPointsList = summary.content.keyPoints\n .map(point => `

${point}

`)\n .join('');\n\n const keywords = summary.content.trendingKeywords.length > 0 \n ? summary.content.trendingKeywords.slice(0, 5).map(kw => \n `${kw}`\n ).join('')\n : 'No keywords identified';\n\n return `\n

\n \n

📌 ${summary.topicTitle}

🗣️ ${summary.content.tweetCount} tweets

\n ${summary.content.sentiment.sentiment.toUpperCase()}\n

\n\n

\n ${summary.content.summary}\n

\n\n ${summary.content.keyPoints.length > 0 ? `\n

🔑 Key Points:

\n ${keyPointsList}\n \n

\n ` : ''}\n\n

🏷️ Trending Keywords:

${keywords}

\n\n ${summary.content.influentialAuthors.length > 0 ? `\n

\n Notable voices: ${summary.content.influentialAuthors.slice(0, 3).join(', ')}\n

\n ` : ''}\n\n

\n Generated ${new Date(summary.created_at).toLocaleString()} • Time window: ${summary.time_period}\n

\n \n

\n `;\n }\n\n /**\n * Generate plain text email template\n */\n private generateTextTemplate(summaries: EmailSummaryData[], includeMetrics: boolean): string {\n const header = `\n🐦 YOUR TWITTER FEED SUMMARY\nAI-powered insights from your social media\n\n${new Date().toLocaleDateString()}\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n`;\n\n const metricsSection = includeMetrics ? `\n📊 SUMMARY METRICS\n• Topics covered: ${summaries.length}\n• Total tweets analyzed: ${summaries.reduce((sum, s) => sum + s.content.tweetCount, 0)}\n• Sentiment breakdown: ${this.getSentimentBreakdown(summaries)}\n• Generated: ${new Date().toLocaleString()}\n\n` : '';\n\n const summaryTexts = summaries.map(summary => `\n📌 ${summary.topicTitle.toUpperCase()}\n🗣️ ${summary.content.tweetCount} tweets • Sentiment: ${summary.content.sentiment.sentiment.toUpperCase()}\n\n${summary.content.summary}\n\n🔑 Key Points:\n${summary.content.keyPoints.map(point => `• ${point}`).join('\\n')}\n\n🏷️ Keywords: ${summary.content.trendingKeywords.slice(0, 5).join(', ') || 'None'}\n\n${summary.content.influentialAuthors.length > 0 ? `Notable voices: ${summary.content.influentialAuthors.slice(0, 3).join(', ')}` : ''}\n\nGenerated: ${new Date(summary.created_at).toLocaleString()} • Time window: ${summary.time_period}\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n`).join('\\n');\n\n const footer = `\nGenerated by OffX AI Summary Service\nThis email contains AI-generated content based on your Twitter feed\n`;\n\n return header + metricsSection + summaryTexts + footer;\n }\n\n /**\n * Get sentiment breakdown statistics\n */\n private getSentimentBreakdown(summaries: EmailSummaryData[]): string {\n const counts = summaries.reduce((acc, s) => {\n acc[s.content.sentiment.sentiment] = (acc[s.content.sentiment.sentiment] || 0) + 1;\n return acc;\n }, {} as Record);\n\n return Object.entries(counts)\n .map(([sentiment, count]) => `${count} ${sentiment}`)\n .join(', ');\n }\n\n /**\n * Send email with retry logic\n */\n private async sendEmailWithRetry(emailData: {\n to: string;\n subject: string;\n html: string;\n text: string;\n }, maxRetries: number = 3): Promise {\n let lastError: Error | null = null;\n\n for (let attempt = 1; attempt <= maxRetries; attempt++) {\n try {\n console.log(`📧 Sending email attempt ${attempt}/${maxRetries} to ${emailData.to}`);\n \n await email({\n to: emailData.to,\n subject: emailData.subject,\n html: emailData.html,\n text: emailData.text,\n });\n\n console.log(`📧 Email sent successfully on attempt ${attempt}`);\n return; // Success!\n\n } catch (error: unknown) {\n lastError = error instanceof Error ? error : new Error(String(error));\n console.warn(`📧 Email attempt ${attempt} failed:`, lastError.message);\n \n if (attempt < maxRetries) {\n // Wait before retrying (exponential backoff)\n const delay = Math.pow(2, attempt) * 1000; // 2s, 4s, 8s\n console.log(`📧 Retrying in ${delay}ms...`);\n await new Promise(resolve => setTimeout(resolve, delay));\n }\n }\n }\n\n // All attempts failed\n throw new Error(`Failed to send email after ${maxRetries} attempts. Last error: ${lastError?.message}`);\n }\n}",[],[177,424],"843937d0-8a7c-11f0-a88e-0224a6c84d84","email-delivery-job.cron.ts","8439388e-8a7c-11f0-a88e-0224a6c84d84",49,["D",1757092784698],"/**\n * Scheduled job for sending AI-generated summaries via email\n * This cron job sends periodic email digests with the latest summaries\n * \n * Configure this in Val Town's interface to run at your desired interval\n * Recommended: Daily at 8 AM or weekly on Sundays\n */\n\nimport { EmailDeliveryService } from \"./email-delivery.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 email delivery job...\");\n\n try {\n // Initialize database\n await initializeDatabase();\n\n // Get configuration from environment variables\n const recipientEmail = Deno.env.get(\"USER_EMAIL\");\n const emailFrequency = Deno.env.get(\"EMAIL_DELIVERY_FREQUENCY\") || \"daily\";\n const maxSummaries = parseInt(Deno.env.get(\"EMAIL_MAX_SUMMARIES\") || \"10\");\n const emailEnabled = Deno.env.get(\"EMAIL_DELIVERY_ENABLED\") !== \"false\";\n\n if (!emailEnabled) {\n console.log(\"📧 Email delivery is disabled via EMAIL_DELIVERY_ENABLED=false\");\n return;\n }\n\n if (!recipientEmail) {\n const errorMsg = \"📧 No recipient email configured. Set USER_EMAIL environment variable.\";\n console.error(errorMsg);\n throw new Error(errorMsg);\n }\n\n console.log(\"📧 Email delivery configuration:\", {\n recipient: recipientEmail,\n frequency: emailFrequency,\n maxSummaries,\n });\n\n // Initialize email service\n const emailService = new EmailDeliveryService();\n\n // Generate appropriate subject based on frequency\n const subjects = {\n daily: \"Your Daily Twitter Summary\",\n weekly: \"Your Weekly Twitter Digest\", \n hourly: \"Your Twitter Update\",\n };\n const subject = subjects[emailFrequency as keyof typeof subjects] || \"Your Twitter Feed Summary\";\n\n // Send email with summaries\n const result = await emailService.sendLatestSummaries({\n recipientEmail,\n subject,\n maxSummaries,\n includeMetrics: true,\n });\n\n // Calculate execution time\n const executionTime = Date.now() - startTime;\n\n // Log results\n console.log(\"📧 Email delivery job completed:\");\n console.log(` - Success: ${result.success}`);\n console.log(` - Summaries sent: ${result.sentCount}`);\n console.log(` - Execution time: ${executionTime}ms`);\n\n if (!result.success) {\n console.error(` - Error: ${result.error}`);\n }\n\n // Send notification email about the job status if configured\n const sendJobNotifications = Deno.env.get(\"EMAIL_JOB_NOTIFICATIONS\") === \"true\";\n const adminEmail = Deno.env.get(\"ADMIN_EMAIL\") || recipientEmail;\n\n if (sendJobNotifications && adminEmail && (!result.success || result.sentCount === 0)) {\n try {\n await sendJobNotificationEmail(result, executionTime, adminEmail);\n console.log(\"📧 Job notification email sent successfully\");\n } catch (emailError) {\n console.error(\"📧 Failed to send job notification email:\", emailError);\n }\n }\n\n if (result.success && result.sentCount > 0) {\n console.log(\"✅ Email delivery job completed successfully\");\n } else if (result.sentCount === 0) {\n console.log(\"ℹ️ Email delivery job completed - no new summaries to send\");\n } else {\n throw new Error(result.error || \"Unknown email delivery error\");\n }\n\n } catch (error: unknown) {\n const executionTime = Date.now() - startTime;\n const errorMessage = `Email delivery job failed: ${error}`;\n \n console.error(\"❌ Email delivery job failed:\", error);\n\n // Try to send error notification email\n const sendJobNotifications = Deno.env.get(\"EMAIL_JOB_NOTIFICATIONS\") === \"true\";\n const adminEmail = Deno.env.get(\"ADMIN_EMAIL\") || Deno.env.get(\"USER_EMAIL\");\n\n if (sendJobNotifications && adminEmail) {\n try {\n await sendJobErrorEmail(error, executionTime, adminEmail);\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 job notification email for issues\n */\nasync function sendJobNotificationEmail(\n result: any,\n executionTime: number,\n recipientEmail: string,\n): Promise {\n const subject = result.success \n ? \"OffX: Email Delivery - No New Summaries\"\n : \"OffX: Email Delivery Failed\";\n \n const html = `\n

\n 📧 Email Delivery Job Report\n

\n \n

📊 Job Status

Success: ${result.success ? '✅ Yes' : '❌ No'}
Summaries sent: ${result.sentCount}
Execution time: ${(executionTime / 1000).toFixed(2)}s
Error: ${result.error}

\n\n ${result.sentCount === 0 ? `\n

ℹ️ No New Summaries

There were no new summaries to send since the last email delivery.

This might be normal if:

No new Twitter data has been processed recently
No new summarizations have been generated
The email frequency is set too high

\n ` : ''}\n\n

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

This is an automated report from your Email Delivery service.

To disable these notifications, set EMAIL_JOB_NOTIFICATIONS=false

\n `;\n\n const text = `\nEmail Delivery Job Report\n\nSuccess: ${result.success ? 'Yes' : 'No'}\nSummaries sent: ${result.sentCount}\nExecution time: ${(executionTime / 1000).toFixed(2)}s\n${result.error ? `Error: ${result.error}` : ''}\n\n${result.sentCount === 0 ? `\nNo new summaries were available to send.\nThis might be normal if no new content has been processed recently.\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 sendJobErrorEmail(\n error: any,\n executionTime: number,\n recipientEmail: string,\n): Promise {\n const subject = \"OffX: Email Delivery Job Failed\";\n \n const html = `\n

❌ Email Delivery 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.

Common causes might include:

Database connectivity issues
Email service problems
Configuration errors
Network failures

\n `;\n\n const text = `\nEmail Delivery 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}",[],[177,433],"842d73a0-8a7c-11f0-81bc-0224a6c84d84","input-sanitizer.ts","842d7472-8a7c-11f0-81bc-0224a6c84d84","83c567a6-8a7c-11f0-85b0-0224a6c84d84",47,["D",1757092784657],"/**\n * Basic input sanitization utility for single-user application\n * Provides minimal sanitization to prevent common XSS attacks\n */\n\n/**\n * Simple input sanitization function that removes dangerous characters\n * @param input - The string to sanitize\n * @returns Sanitized string with dangerous characters removed\n */\nexport function sanitizeInput(input: string): string {\n if (typeof input !== 'string') {\n return '';\n }\n \n // Remove the most dangerous characters that could be used for XSS\n // Keep it simple - just remove < and > characters\n return input.replace(/[<>]/g, '');\n}\n\n/**\n * Sanitize an object's string properties\n * @param obj - Object with string properties to sanitize\n * @returns New object with sanitized string values\n */\nexport function sanitizeObject>(obj: T): T {\n const sanitized = { ...obj };\n \n for (const key in sanitized) {\n if (typeof sanitized[key] === 'string') {\n sanitized[key] = sanitizeInput(sanitized[key]) as T[Extract];\n }\n }\n \n return sanitized;\n}\n\n/**\n * Middleware for Hono to automatically sanitize request body\n */\nexport const sanitizeMiddleware = async (c: any, next: any) => {\n // Only sanitize POST/PUT requests with JSON body\n if (c.req.method === 'POST' || c.req.method === 'PUT') {\n try {\n const contentType = c.req.header('content-type');\n if (contentType && contentType.includes('application/json')) {\n const originalJson = c.req.json;\n c.req.json = async () => {\n const body = await originalJson.call(c.req);\n return sanitizeObject(body);\n };\n }\n } catch (error: unknown) {\n // If there's an error, continue without sanitization\n console.warn('Input sanitization failed:', error);\n }\n }\n \n await next();\n};",[],[177,449,441],"security","83c566ac-8a7c-11f0-85b0-0224a6c84d84",33,["D",1757092783975],[201],[177,449],"06b1146a-55f5-11f0-918b-f69ea79377d9","routes","06b11500-55f5-11f0-918b-f69ea79377d9",12,["D",1751317131604],[],[177,456],"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",[],[177,471,463],"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",[],[177,471,473],"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",[],[177,471,417],"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",[],[177,471,488],"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```",[],[177,471,151],"06a4db3c-55f5-11f0-9d32-f69ea79377d9",11,["D",1751317131524],[194,195,196,197,198],[177,471],["D",1751316325838],[193,199,200,202,203,204,205,206,207,208,209,210,211,212,213,214],[177],["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":547,"_548":549,"_550":551,"_552":24,"_553":24,"_554":24,"_555":58,"_556":-5,"_557":-7,"_558":-7,"_559":139,"_560":24,"_561":24,"_562":-5,"_563":24,"_564":24,"_565":24,"_566":-5},"ENV",{"_518":519,"_520":521,"_522":86,"_523":524,"_525":526,"_527":528,"_529":530,"_531":532,"_533":534,"_535":536,"_537":538,"_539":540,"_541":542,"_543":544,"_545":546},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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 · v55