[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f51a00d1aedfb0f6c517a3d665913da6776cbefb","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_172":173,"_174":-5},"handle","nanaoseiiiiiiiii","name","Home","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","5585b34a-3fb4-11f0-a1e1-76b3cceeab13","createdAt",["D",1748870420994],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","9ff3db60-3fb3-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","54abd2d2-18f0-496b-80f2-5d10f0e9f682","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHhCeG95S2E5dmk4UVJ6TldJakFVUk9mWEcifQ","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",26,"55861a10-3fb4-11f0-a1e1-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_104":161,"_136":162,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"865376ea-3fb6-11f0-93c9-76b3cceeab13","queries.ts","fileId","a74e2748-3fb4-11f0-84c7-76b3cceeab13","parentId","5a357e0a-fc0f-409d-9e25-234a319ba2e9","branchId","branchVersion",21,"latest",true,["D",1748871361860],2,"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAMES } from \"./migrations.ts\";\nimport type { \n TwitterPost, \n PostMetrics, \n PostGoal, \n CreatePostRequest, \n UpdateMetricsRequest, \n CreateGoalRequest\n} from \"../../shared/types.ts\";\nimport { extractHashtags, extractMentions } from \"../../shared/types.ts\";\n\n// Post queries\nexport async function createPost(postData: CreatePostRequest): Promise {\n const hashtags = JSON.stringify(extractHashtags(postData.content));\n const mentions = JSON.stringify(extractMentions(postData.content));\n const postedAt = postData.postedAt || new Date().toISOString();\n\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAMES.POSTS} (\n tweet_id, content, url, posted_at, likes, retweets, replies, impressions,\n hashtags, mentions, media_type, is_thread, thread_position\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postData.tweetId || null,\n postData.content,\n postData.url || null,\n postedAt,\n postData.likes || 0,\n postData.retweets || 0,\n postData.replies || 0,\n postData.impressions || null,\n hashtags,\n mentions,\n postData.mediaType || 'text',\n postData.isThread || false,\n postData.threadPosition || null\n ]\n );\n\n const post = await getPostById(result.lastInsertRowId!);\n if (!post) throw new Error('Failed to create post');\n return post;\n}\n\nexport async function getPostById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, tweet_id, content, url, posted_at, likes, retweets, replies, impressions,\n hashtags, mentions, media_type, is_thread, thread_position, created_at, updated_at\n FROM ${TABLE_NAMES.POSTS} WHERE id = ?`,\n [id]\n );\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row[0] as number,\n tweetId: row[1] as string || undefined,\n content: row[2] as string,\n url: row[3] as string || undefined,\n postedAt: row[4] as string,\n likes: row[5] as number,\n retweets: row[6] as number,\n replies: row[7] as number,\n impressions: row[8] as number || undefined,\n hashtags: JSON.parse(row[9] as string || '[]'),\n mentions: JSON.parse(row[10] as string || '[]'),\n mediaType: row[11] as 'text' | 'image' | 'video' | 'gif',\n isThread: Boolean(row[12]),\n threadPosition: row[13] as number || undefined,\n createdAt: row[14] as string,\n updatedAt: row[15] as string,\n };\n}\n\nexport async function getAllPosts(limit: number = 50): Promise {\n const result = await sqlite.execute(\n `SELECT id, tweet_id, content, url, posted_at, likes, retweets, replies, impressions,\n hashtags, mentions, media_type, is_thread, thread_position, created_at, updated_at\n FROM ${TABLE_NAMES.POSTS}\n ORDER BY posted_at DESC\n LIMIT ?`,\n [limit]\n );\n\n return result.rows.map(row => ({\n id: row[0] as number,\n tweetId: row[1] as string || undefined,\n content: row[2] as string,\n url: row[3] as string || undefined,\n postedAt: row[4] as string,\n likes: row[5] as number,\n retweets: row[6] as number,\n replies: row[7] as number,\n impressions: row[8] as number || undefined,\n hashtags: JSON.parse(row[9] as string || '[]'),\n mentions: JSON.parse(row[10] as string || '[]'),\n mediaType: row[11] as 'text' | 'image' | 'video' | 'gif',\n isThread: Boolean(row[12]),\n threadPosition: row[13] as number || undefined,\n createdAt: row[14] as string,\n updatedAt: row[15] as string,\n }));\n}\n\nexport async function updatePostMetrics(postId: number, metrics: UpdateMetricsRequest): Promise {\n // Update the post\n await sqlite.execute(\n `UPDATE ${TABLE_NAMES.POSTS} \n SET likes = ?, retweets = ?, replies = ?, impressions = ?\n WHERE id = ?`,\n [metrics.likes, metrics.retweets, metrics.replies, metrics.impressions || null, postId]\n );\n\n // Record metrics history\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAMES.METRICS} (post_id, likes, retweets, replies, impressions)\n VALUES (?, ?, ?, ?, ?)`,\n [postId, metrics.likes, metrics.retweets, metrics.replies, metrics.impressions || null]\n );\n\n return await getPostById(postId);\n}\n\nexport async function deletePost(id: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TABLE_NAMES.POSTS} WHERE id = ?`,\n [id]\n );\n\n return result.changes > 0;\n}\n\n// Metrics queries\nexport async function getPostMetricsHistory(postId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, post_id, likes, retweets, replies, impressions, recorded_at\n FROM ${TABLE_NAMES.METRICS}\n WHERE post_id = ?\n ORDER BY recorded_at DESC`,\n [postId]\n );\n\n return result.rows.map(row => ({\n id: row[0] as number,\n postId: row[1] as number,\n likes: row[2] as number,\n retweets: row[3] as number,\n replies: row[4] as number,\n impressions: row[5] as number || undefined,\n recordedAt: row[6] as string,\n }));\n}\n\n// Goals queries\nexport async function createGoal(goalData: CreateGoalRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAMES.GOALS} (type, target, period)\n VALUES (?, ?, ?)`,\n [goalData.type, goalData.target, goalData.period]\n );\n\n const goal = await getGoalById(result.lastInsertRowId!);\n if (!goal) throw new Error('Failed to create goal');\n return goal;\n}\n\nexport async function getGoalById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, type, target, period, achieved, created_at\n FROM ${TABLE_NAMES.GOALS} WHERE id = ?`,\n [id]\n );\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n id: row[0] as number,\n type: row[1] as 'daily' | 'weekly' | 'monthly',\n target: row[2] as number,\n period: row[3] as string,\n achieved: row[4] as number,\n createdAt: row[5] as string,\n };\n}\n\nexport async function getAllGoals(): Promise {\n const result = await sqlite.execute(\n `SELECT id, type, target, period, achieved, created_at\n FROM ${TABLE_NAMES.GOALS}\n ORDER BY created_at DESC`\n );\n\n return result.rows.map(row => ({\n id: row[0] as number,\n type: row[1] as 'daily' | 'weekly' | 'monthly',\n target: row[2] as number,\n period: row[3] as string,\n achieved: row[4] as number,\n createdAt: row[5] as string,\n }));\n}\n\nexport async function updateGoalProgress(goalId: number, achieved: number): Promise {\n await sqlite.execute(\n `UPDATE ${TABLE_NAMES.GOALS} SET achieved = ? WHERE id = ?`,\n [achieved, goalId]\n );\n\n return await getGoalById(goalId);\n}\n\n// Analytics queries\nexport async function getPostingStats(days: number = 30) {\n const result = await sqlite.execute(\n `SELECT \n COUNT(*) as total_posts,\n SUM(likes) as total_likes,\n SUM(retweets) as total_retweets,\n SUM(replies) as total_replies,\n AVG(likes) as avg_likes,\n AVG(retweets) as avg_retweets,\n AVG(replies) as avg_replies\n FROM ${TABLE_NAMES.POSTS}\n WHERE posted_at >= datetime('now', '-${days} days')`\n );\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n totalPosts: row[0] as number,\n totalLikes: row[1] as number,\n totalRetweets: row[2] as number,\n totalReplies: row[3] as number,\n avgLikes: row[4] as number,\n avgRetweets: row[5] as number,\n avgReplies: row[6] as number,\n };\n}\n\nexport async function getTopHashtags(limit: number = 10) {\n const result = await sqlite.execute(\n `SELECT \n hashtags,\n COUNT(*) as post_count,\n AVG(likes) as avg_likes,\n AVG(retweets) as avg_retweets,\n AVG(replies) as avg_replies\n FROM ${TABLE_NAMES.POSTS}\n WHERE hashtags != '[]'\n GROUP BY hashtags\n ORDER BY post_count DESC\n LIMIT ?`,\n [limit]\n );\n\n return result.rows.map(row => ({\n hashtags: JSON.parse(row[0] as string),\n postCount: row[1] as number,\n avgLikes: row[2] as number,\n avgRetweets: row[3] as number,\n avgReplies: row[4] as number,\n }));\n}","deleted","label",[170,171,151],"backend","database","permalink","https://www.val.town/x/nanaoseiiiiiiiii/Home/code/backend/database/queries.ts","extension","actionData","errors"]