[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_214":215,"_216":217},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":25,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/cron.ts","latestPath","fileId","5cf8b1ba-32e7-11f0-83e7-569c3dd06744","name","cron.ts","fileType","script","content","import { TwitterClient } from \"./services/twitter.ts\";\nimport { initDatabase } from \"./database/migrations.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TWEETS_TABLE } from \"./database/migrations.ts\";\n\n/**\n * Cron job to fetch and update tweets\n */\nexport default async function() {\n console.log(\"Starting tweet update cron job...\");\n \n try {\n // Initialize database if needed\n await initDatabase();\n \n const twitterClient = new TwitterClient();\n \n // 1. Fetch new tweets from specified accounts\n const accounts = [\"valtown\", \"stevekrouse\", \"twitter\"];\n for (const account of accounts) {\n console.log(`Fetching tweets for ${account}...`);\n await twitterClient.getUserTweets(account, 20);\n }\n \n // 2. Update metrics for existing tweets (most recent 100)\n console.log(\"Updating metrics for existing tweets...\");\n const result = await sqlite.execute(`\n SELECT id FROM ${TWEETS_TABLE}\n ORDER BY created_at DESC\n LIMIT 100\n `);\n \n const tweetIds = result.rows.map(row => row.id as string);\n await twitterClient.updateTweetMetrics(tweetIds);\n \n // 3. Search for trending topics\n const searchTerms = [\"valtown\", \"typescript\", \"javascript\", \"deno\"];\n for (const term of searchTerms) {\n console.log(`Searching tweets for \"${term}\"...`);\n await twitterClient.searchTweets(term, 10);\n }\n \n console.log(\"Tweet update cron job completed successfully\");\n } catch (error) {\n console.error(\"Error in tweet update cron job:\", error);\n }\n}","interval","createdAt",["D",1747462975559],"branchVersion","branchId","f18e3a30-32e6-11f0-92c8-569c3dd06744","id","f18dd69e-32e6-11f0-92c8-569c3dd06744","first",["D",1747462792492],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","6188a9ab-68f8-4c46-8cb2-69799954d7f7","pinnedFileId","6fbab686-32e7-11f0-b23a-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","8dacdf4f-8a9d-4420-a8ca-3e5e0405428c","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","gthmbri","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yZ2JnSkFHMmhJV0N2ZmtVNnNrYkdyRDdpMFoifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":210,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":211,"_81":212,"_83":213,"_85":25},"tree",[156,163],"files",[156,157,158,159,160,161,162,163],"counts",{"_146":63,"_147":133,"_148":63,"_149":150,"_151":152},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":139,"_32":140,"_30":141,"_132":-5,"_42":43,"_41":142,"_134":59,"_39":143,"_13":63,"_34":144,"_36":-5,"_24":25,"_137":-5,"_27":145},{"_44":129,"_32":130,"_30":131,"_132":-5,"_42":43,"_41":133,"_134":59,"_39":135,"_13":63,"_34":20,"_36":136,"_24":25,"_137":-5,"_27":138},"349b548e-32e7-11f0-998d-569c3dd06744","README.md","349b5560-32e7-11f0-998d-569c3dd06744","parentId",1,"latest",["D",1747462904985],"# Tweet Metrics Tracker\n\nThis application scrapes tweets and other metrics from Twitter/X API, stores them in a SQLite database, and displays them in a web interface.\n\n## Features\n\n- Fetches tweets and metrics from Twitter/X API\n- Stores data in SQLite database\n- Periodically updates data using a cron job\n- Displays tweets and metrics in a web interface\n- Provides filtering and sorting options\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Schema definitions\n│ │ └── queries.ts # DB query functions\n│ ├── services/\n│ │ └── twitter.ts # Twitter API integration\n│ ├── routes/\n│ │ ├── api.ts # API routes\n│ │ └── static.ts # Static file serving\n│ ├── cron.ts # Cron job for data fetching\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/\n│ │ ├── TweetList.js # Tweet list component\n│ │ └── MetricsChart.js # Metrics visualization\n│ ├── index.html # Main HTML template\n│ ├── app.js # Frontend JS entry point\n│ └── style.css # Custom styles\n└── shared/\n └── types.ts # Shared types and interfaces\n```\n\n## Setup\n\n1. Set up the following environment variables in Val Town:\n - `TWITTER_API_KEY` - Your Twitter/X API key\n - `TWITTER_API_SECRET` - Your Twitter/X API secret\n - `TWITTER_BEARER_TOKEN` - Your Twitter/X bearer token\n\n2. Deploy the application on Val Town\n\n## Usage\n\n- Access the web interface to view tweets and metrics\n- The data is automatically updated via a cron job\n- Use the API endpoints to access the data programmatically","label",[130],"396924f0-32e7-11f0-b04c-569c3dd06744","backend","2ad76b0f-eed1-4879-b879-e24417c894bc",2,["D",1747462913044],"directory",[140],"pulls","branches","forks","envVars",{"_153":63,"_155":63},"connections",{"_153":63,"_154":63},"count","unfilledCount","emptyCount",{"_44":139,"_32":140,"_30":141,"_132":-5,"_42":43,"_41":142,"_134":59,"_39":207,"_13":63,"_34":144,"_36":-5,"_24":25,"_137":-5,"_165":208,"_27":209},{"_44":203,"_32":195,"_30":189,"_132":141,"_42":43,"_41":142,"_134":59,"_39":204,"_13":63,"_34":144,"_36":-5,"_24":25,"_137":-5,"_165":205,"_27":206},{"_44":196,"_32":197,"_30":198,"_132":189,"_42":43,"_41":142,"_134":59,"_39":199,"_13":63,"_34":35,"_36":200,"_24":25,"_137":-5,"_165":201,"_27":202},{"_44":186,"_32":187,"_30":188,"_132":189,"_42":43,"_41":190,"_134":59,"_39":191,"_13":63,"_34":35,"_36":192,"_24":25,"_137":-5,"_165":193,"_27":194},{"_44":182,"_32":181,"_30":175,"_132":141,"_42":43,"_41":176,"_134":59,"_39":183,"_13":63,"_34":144,"_36":-5,"_24":25,"_137":-5,"_165":184,"_27":185},{"_44":172,"_32":173,"_30":174,"_132":175,"_42":43,"_41":176,"_134":59,"_39":177,"_13":63,"_34":35,"_36":178,"_24":25,"_137":-5,"_165":179,"_27":180},{"_44":168,"_32":33,"_30":31,"_132":141,"_42":43,"_41":14,"_134":59,"_39":169,"_13":133,"_34":38,"_36":37,"_24":25,"_137":-5,"_165":170,"_27":171},{"_44":129,"_32":130,"_30":131,"_132":-5,"_42":43,"_41":133,"_134":59,"_39":164,"_13":63,"_34":20,"_36":136,"_24":25,"_137":-5,"_165":166,"_27":167},["D",1747462904985],"children",[],[130],"5eadea5c-32e7-11f0-864f-569c3dd06744",["D",1747462975559],[],[140,33],"57e4f472-32e7-11f0-9358-569c3dd06744","twitter.ts","57e4f51c-32e7-11f0-9358-569c3dd06744","310e2602-e1c6-4c75-bbff-22a1d7dad435",4,["D",1747462964187],"import { Tweet, TwitterUser, upsertTweet, upsertUser, recordMetrics } from \"../database/queries.ts\";\n\n// Twitter API v2 endpoints\nconst TWITTER_API_BASE = \"https://api.twitter.com/2\";\n\n/**\n * Twitter API client\n */\nexport class TwitterClient {\n private bearerToken: string;\n\n constructor() {\n const bearerToken = Deno.env.get(\"TWITTER_BEARER_TOKEN\");\n if (!bearerToken) {\n throw new Error(\"TWITTER_BEARER_TOKEN environment variable is not set\");\n }\n this.bearerToken = bearerToken;\n }\n\n /**\n * Make an authenticated request to the Twitter API\n */\n private async request(endpoint: string, params: Record = {}): Promise {\n const url = new URL(`${TWITTER_API_BASE}${endpoint}`);\n \n // Add query parameters\n Object.entries(params).forEach(([key, value]) => {\n url.searchParams.append(key, value);\n });\n\n const response = await fetch(url.toString(), {\n headers: {\n Authorization: `Bearer ${this.bearerToken}`,\n },\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Twitter API error (${response.status}): ${errorText}`);\n }\n\n return response.json();\n }\n\n /**\n * Fetch tweets from a user\n */\n async getUserTweets(username: string, count = 10): Promise {\n // First get the user ID\n const userResponse = await this.request(`/users/by/username/${username}`, {\n \"user.fields\": \"id,username,name,profile_image_url,public_metrics,created_at\",\n });\n\n if (!userResponse.data) {\n throw new Error(`User not found: ${username}`);\n }\n\n const userData = userResponse.data;\n \n // Create user object\n const user: TwitterUser = {\n id: userData.id,\n username: userData.username,\n name: userData.name,\n profile_image_url: userData.profile_image_url,\n followers_count: userData.public_metrics?.followers_count || 0,\n following_count: userData.public_metrics?.following_count || 0,\n created_at: userData.created_at,\n };\n\n // Save user to database\n await upsertUser(user);\n\n // Get user's tweets\n const tweetsResponse = await this.request(`/users/${user.id}/tweets`, {\n max_results: count.toString(),\n \"tweet.fields\": \"id,text,created_at,public_metrics\",\n exclude: \"retweets,replies\",\n });\n\n if (!tweetsResponse.data) {\n return [];\n }\n\n // Process and save tweets\n const tweets: Tweet[] = [];\n for (const tweetData of tweetsResponse.data) {\n const tweet: Tweet = {\n id: tweetData.id,\n user_id: user.id,\n text: tweetData.text,\n created_at: tweetData.created_at,\n retweet_count: tweetData.public_metrics?.retweet_count || 0,\n reply_count: tweetData.public_metrics?.reply_count || 0,\n like_count: tweetData.public_metrics?.like_count || 0,\n quote_count: tweetData.public_metrics?.quote_count || 0,\n };\n\n // Save tweet to database\n await upsertTweet(tweet);\n \n // Record metrics history\n await recordMetrics({\n tweet_id: tweet.id,\n retweet_count: tweet.retweet_count,\n reply_count: tweet.reply_count,\n like_count: tweet.like_count,\n quote_count: tweet.quote_count,\n recorded_at: new Date().toISOString(),\n });\n\n tweets.push(tweet);\n }\n\n return tweets;\n }\n\n /**\n * Search for tweets by keyword\n */\n async searchTweets(query: string, count = 10): Promise {\n const searchResponse = await this.request(`/tweets/search/recent`, {\n query,\n max_results: count.toString(),\n \"tweet.fields\": \"id,text,created_at,public_metrics,author_id\",\n \"user.fields\": \"id,username,name,profile_image_url,public_metrics,created_at\",\n \"expansions\": \"author_id\",\n });\n\n if (!searchResponse.data || searchResponse.data.length === 0) {\n return [];\n }\n\n // Process users\n const users: Record = {};\n if (searchResponse.includes?.users) {\n for (const userData of searchResponse.includes.users) {\n const user: TwitterUser = {\n id: userData.id,\n username: userData.username,\n name: userData.name,\n profile_image_url: userData.profile_image_url,\n followers_count: userData.public_metrics?.followers_count || 0,\n following_count: userData.public_metrics?.following_count || 0,\n created_at: userData.created_at,\n };\n users[user.id] = user;\n await upsertUser(user);\n }\n }\n\n // Process tweets\n const tweets: Tweet[] = [];\n for (const tweetData of searchResponse.data) {\n if (!tweetData.author_id || !users[tweetData.author_id]) {\n continue; // Skip tweets without author info\n }\n\n const tweet: Tweet = {\n id: tweetData.id,\n user_id: tweetData.author_id,\n text: tweetData.text,\n created_at: tweetData.created_at,\n retweet_count: tweetData.public_metrics?.retweet_count || 0,\n reply_count: tweetData.public_metrics?.reply_count || 0,\n like_count: tweetData.public_metrics?.like_count || 0,\n quote_count: tweetData.public_metrics?.quote_count || 0,\n };\n\n // Save tweet to database\n await upsertTweet(tweet);\n \n // Record metrics history\n await recordMetrics({\n tweet_id: tweet.id,\n retweet_count: tweet.retweet_count,\n reply_count: tweet.reply_count,\n like_count: tweet.like_count,\n quote_count: tweet.quote_count,\n recorded_at: new Date().toISOString(),\n });\n\n tweets.push(tweet);\n }\n\n return tweets;\n }\n\n /**\n * Update metrics for existing tweets\n */\n async updateTweetMetrics(tweetIds: string[]): Promise {\n if (tweetIds.length === 0) return;\n \n // Twitter API allows up to 100 tweets per request\n const chunks = [];\n for (let i = 0; i < tweetIds.length; i += 100) {\n chunks.push(tweetIds.slice(i, i + 100));\n }\n \n for (const chunk of chunks) {\n const ids = chunk.join(\",\");\n const response = await this.request(`/tweets`, {\n ids,\n \"tweet.fields\": \"id,public_metrics\",\n });\n \n if (!response.data) continue;\n \n for (const tweetData of response.data) {\n const tweet = {\n id: tweetData.id,\n user_id: \"\", // We'll keep the existing user_id\n text: \"\", // We'll keep the existing text\n created_at: \"\", // We'll keep the existing created_at\n retweet_count: tweetData.public_metrics?.retweet_count || 0,\n reply_count: tweetData.public_metrics?.reply_count || 0,\n like_count: tweetData.public_metrics?.like_count || 0,\n quote_count: tweetData.public_metrics?.quote_count || 0,\n };\n \n // Get existing tweet to preserve fields we don't want to update\n const existingTweet = await getTweet(tweet.id);\n if (existingTweet) {\n tweet.user_id = existingTweet.user_id;\n tweet.text = existingTweet.text;\n tweet.created_at = existingTweet.created_at;\n \n // Update tweet\n await upsertTweet(tweet);\n \n // Record metrics history\n await recordMetrics({\n tweet_id: tweet.id,\n retweet_count: tweet.retweet_count,\n reply_count: tweet.reply_count,\n like_count: tweet.like_count,\n quote_count: tweet.quote_count,\n recorded_at: new Date().toISOString(),\n });\n }\n }\n }\n }\n}\n\n// Helper function to get a tweet by ID\nasync function getTweet(tweetId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM tweets_v1 WHERE id = ?\n `, [tweetId]);\n \n return result.rows.length > 0 ? result.rows[0] as Tweet : null;\n}",[],[140,181,173],"services","57e5352c-32e7-11f0-9358-569c3dd06744",["D",1747462964187],[161],[140,181],"462ae304-32e7-11f0-8ebf-569c3dd06744","queries.ts","462ae3ae-32e7-11f0-8ebf-569c3dd06744","fa4bba96-c674-4352-9413-03a1619a5b54",3,["D",1747462934449],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TWEETS_TABLE, METRICS_TABLE, USERS_TABLE } from \"./migrations.ts\";\n\n// Types\nexport interface TwitterUser {\n id: string;\n username: string;\n name: string;\n profile_image_url?: string;\n followers_count: number;\n following_count: number;\n created_at: string;\n}\n\nexport interface Tweet {\n id: string;\n user_id: string;\n text: string;\n created_at: string;\n retweet_count: number;\n reply_count: number;\n like_count: number;\n quote_count: number;\n}\n\nexport interface TweetMetrics {\n tweet_id: string;\n retweet_count: number;\n reply_count: number;\n like_count: number;\n quote_count: number;\n recorded_at: string;\n}\n\nexport interface TweetWithUser extends Tweet {\n user: TwitterUser;\n}\n\n// User queries\nexport async function upsertUser(user: TwitterUser): Promise {\n await sqlite.execute(`\n INSERT INTO ${USERS_TABLE} (\n id, username, name, profile_image_url, followers_count, following_count, created_at, last_updated\n ) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP)\n ON CONFLICT(id) DO UPDATE SET\n username = excluded.username,\n name = excluded.name,\n profile_image_url = excluded.profile_image_url,\n followers_count = excluded.followers_count,\n following_count = excluded.following_count,\n last_updated = CURRENT_TIMESTAMP\n `, [\n user.id,\n user.username,\n user.name,\n user.profile_image_url || null,\n user.followers_count,\n user.following_count,\n user.created_at\n ]);\n}\n\nexport async function getUser(userId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${USERS_TABLE} WHERE id = ?\n `, [userId]);\n \n return result.rows.length > 0 ? result.rows[0] as TwitterUser : null;\n}\n\n// Tweet queries\nexport async function upsertTweet(tweet: Tweet): Promise {\n await sqlite.execute(`\n INSERT INTO ${TWEETS_TABLE} (\n id, user_id, text, created_at, retweet_count, reply_count, like_count, quote_count, last_updated\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP)\n ON CONFLICT(id) DO UPDATE SET\n retweet_count = excluded.retweet_count,\n reply_count = excluded.reply_count,\n like_count = excluded.like_count,\n quote_count = excluded.quote_count,\n last_updated = CURRENT_TIMESTAMP\n `, [\n tweet.id,\n tweet.user_id,\n tweet.text,\n tweet.created_at,\n tweet.retweet_count,\n tweet.reply_count,\n tweet.like_count,\n tweet.quote_count\n ]);\n}\n\nexport async function getTweet(tweetId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TWEETS_TABLE} WHERE id = ?\n `, [tweetId]);\n \n return result.rows.length > 0 ? result.rows[0] as Tweet : null;\n}\n\nexport async function getTweets(limit = 50, offset = 0): Promise {\n const result = await sqlite.execute(`\n SELECT \n t.*,\n u.id as user_id,\n u.username,\n u.name,\n u.profile_image_url,\n u.followers_count,\n u.following_count,\n u.created_at as user_created_at\n FROM ${TWEETS_TABLE} t\n JOIN ${USERS_TABLE} u ON t.user_id = u.id\n ORDER BY t.created_at DESC\n LIMIT ? OFFSET ?\n `, [limit, offset]);\n \n return result.rows.map(row => {\n const tweet = {\n id: row.id,\n user_id: row.user_id,\n text: row.text,\n created_at: row.created_at,\n retweet_count: row.retweet_count,\n reply_count: row.reply_count,\n like_count: row.like_count,\n quote_count: row.quote_count,\n user: {\n id: row.user_id,\n username: row.username,\n name: row.name,\n profile_image_url: row.profile_image_url,\n followers_count: row.followers_count,\n following_count: row.following_count,\n created_at: row.user_created_at\n }\n } as TweetWithUser;\n return tweet;\n });\n}\n\n// Metrics queries\nexport async function recordMetrics(metrics: TweetMetrics): Promise {\n await sqlite.execute(`\n INSERT INTO ${METRICS_TABLE} (\n tweet_id, retweet_count, reply_count, like_count, quote_count\n ) VALUES (?, ?, ?, ?, ?)\n `, [\n metrics.tweet_id,\n metrics.retweet_count,\n metrics.reply_count,\n metrics.like_count,\n metrics.quote_count\n ]);\n}\n\nexport async function getTweetMetricsHistory(tweetId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${METRICS_TABLE}\n WHERE tweet_id = ?\n ORDER BY recorded_at ASC\n `, [tweetId]);\n \n return result.rows as TweetMetrics[];\n}\n\nexport async function getTopTweets(limit = 10): Promise {\n const result = await sqlite.execute(`\n SELECT \n t.*,\n u.id as user_id,\n u.username,\n u.name,\n u.profile_image_url,\n u.followers_count,\n u.following_count,\n u.created_at as user_created_at\n FROM ${TWEETS_TABLE} t\n JOIN ${USERS_TABLE} u ON t.user_id = u.id\n ORDER BY (t.retweet_count + t.like_count + t.quote_count) DESC\n LIMIT ?\n `, [limit]);\n \n return result.rows.map(row => {\n const tweet = {\n id: row.id,\n user_id: row.user_id,\n text: row.text,\n created_at: row.created_at,\n retweet_count: row.retweet_count,\n reply_count: row.reply_count,\n like_count: row.like_count,\n quote_count: row.quote_count,\n user: {\n id: row.user_id,\n username: row.username,\n name: row.name,\n profile_image_url: row.profile_image_url,\n followers_count: row.followers_count,\n following_count: row.following_count,\n created_at: row.user_created_at\n }\n } as TweetWithUser;\n return tweet;\n });\n}",[],[140,195,187],"database","39691dac-32e7-11f0-b04c-569c3dd06744","migrations.ts","39691e60-32e7-11f0-b04c-569c3dd06744",["D",1747462913044],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning for schema changes\nexport const TWEETS_TABLE = \"tweets_v1\";\nexport const METRICS_TABLE = \"metrics_v1\";\nexport const USERS_TABLE = \"twitter_users_v1\";\n\n/**\n * Initialize database tables\n */\nexport async function initDatabase() {\n // Create users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id TEXT PRIMARY KEY,\n username TEXT NOT NULL,\n name TEXT NOT NULL,\n profile_image_url TEXT,\n followers_count INTEGER,\n following_count INTEGER,\n created_at TIMESTAMP,\n last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create tweets table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TWEETS_TABLE} (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at TIMESTAMP,\n retweet_count INTEGER DEFAULT 0,\n reply_count INTEGER DEFAULT 0,\n like_count INTEGER DEFAULT 0,\n quote_count INTEGER DEFAULT 0,\n last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${USERS_TABLE}(id)\n )\n `);\n\n // Create metrics table for storing historical metrics\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${METRICS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n tweet_id TEXT NOT NULL,\n retweet_count INTEGER DEFAULT 0,\n reply_count INTEGER DEFAULT 0,\n like_count INTEGER DEFAULT 0,\n quote_count INTEGER DEFAULT 0,\n recorded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (tweet_id) REFERENCES ${TWEETS_TABLE}(id)\n )\n `);\n\n console.log(\"Database initialized successfully\");\n}",[],[140,195,197],"396926b2-32e7-11f0-b04c-569c3dd06744",["D",1747462913044],[158,159],[140,195],["D",1747462913044],[157,160,162],[140],["D",1747462792492],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":247,"_248":249,"_250":251,"_252":25,"_253":25,"_254":25,"_255":59,"_256":-5,"_257":-7,"_258":-7,"_259":63,"_260":25,"_261":25,"_262":-5,"_263":25,"_264":25,"_265":25,"_266":-5},"ENV",{"_218":219,"_220":221,"_222":87,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6