[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_150":151,"_172":173,"_174":-5},"handle","tejpochiraju","name","atproto-to-fediverse","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_149":20},"id","8e8105ba-8cbb-11f0-995f-0224a6c84d84","createdAt",["D",1757339762573],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019927ee-6538-724d-822d-7d56458fe16c","pinnedFileId","pinPreview","screenshotVersion","likeCount","019927ee-6538-724d-822d-8338457509f9","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMlA5c2lCcG1VeTludVJUQjgzakZJdDl1OGgifQ","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":146,"_147":96,"_148":94},"version",1,"8e8571e0-8cbb-11f0-995f-0224a6c84d84","projectId","forkedBranchId","c4d19400-63b1-11f0-866e-0224a6c84d84","forkedBranchVersion",420,"forkedProjectPrivacy","forkedProjectId","c4d11e94-63b1-11f0-866e-0224a6c84d84","forkedProjectOrgId","c04d51b2-a7dc-46ca-ad6f-52f47c2906a8","projectName","userHandle","isOwned","file",{"_101":152,"_95":153,"_154":155,"_156":157,"_158":136,"_159":135,"_160":161,"_103":162,"_134":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_97":169},"8ebb9c5c-8cbb-11f0-995f-0224a6c84d84","queries.ts","fileId","0199299c-c119-707c-92f3-4dcd657ea64a","parentId","0199299c-c119-707c-92f3-52ffe4ba246a","branchId","branchVersion","latest",true,["D",1757339762573],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\n\nexport interface UserAccount {\n id: number;\n atproto_did?: string;\n atproto_pds_url?: string;\n atproto_handle?: string;\n atproto_access_token?: string;\n atproto_refresh_token?: string;\n atproto_token_expires_at?: number;\n atproto_dpop_private_key?: string;\n atproto_dpop_public_jwk?: string;\n atproto_app_password?: string;\n mastodon_instance_url?: string;\n mastodon_username?: string;\n mastodon_access_token?: string;\n mastodon_client_id?: string;\n mastodon_client_secret?: string;\n setup_completed: boolean;\n last_sync_at?: number;\n last_sync_cursor?: string;\n created_at: number;\n updated_at: number;\n}\n\nexport interface PostTracking {\n id: number;\n atproto_uri: string;\n atproto_cid: string;\n atproto_rkey: string;\n mastodon_id?: string;\n mastodon_url?: string;\n content_hash: string;\n sync_status: \"pending\" | \"success\" | \"failed\" | \"skipped\";\n error_message?: string;\n retry_count: number;\n max_retries: number;\n atproto_created_at: number;\n synced_at?: number;\n created_at: number;\n updated_at: number;\n}\n\nexport interface SyncLog {\n id: number;\n sync_type: \"manual\" | \"cron\" | \"webhook\";\n posts_fetched: number;\n posts_synced: number;\n posts_failed: number;\n posts_skipped: number;\n error_message?: string;\n stack_trace?: string;\n duration_ms?: number;\n cursor_start?: string;\n cursor_end?: string;\n created_at: number;\n}\n\nexport interface Settings {\n id: number;\n sync_enabled: boolean;\n sync_interval_minutes: number;\n skip_replies: boolean;\n skip_mentions: boolean;\n skip_reposts: boolean;\n include_media: boolean;\n compress_images: boolean;\n created_at: number;\n updated_at: number;\n}\n\n// Single User Account queries\nexport async function createUserAccount(): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.USER_ACCOUNTS} (id) VALUES (1) RETURNING *`,\n );\n return result.rows[0] as unknown as UserAccount;\n}\n\nexport async function getUserAccount(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USER_ACCOUNTS} WHERE id = 1`,\n );\n return (result.rows[0] as unknown as UserAccount) || null;\n}\n\nexport async function getUserAccountByHandle(\n handle: string,\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.USER_ACCOUNTS} WHERE atproto_handle = ? AND id = 1`,\n [handle],\n );\n return (result.rows[0] as unknown as UserAccount) || null;\n}\n\n// Get the single user account (for single-user service)\nexport async function getSingleUserAccount(): Promise {\n return await getUserAccount();\n}\n\nexport async function updateUserAccount(\n updates: Partial,\n): Promise {\n const keys = Object.keys(updates);\n const values = Object.values(updates);\n const setClause = keys.map((key) => `${key} = ?`).join(\", \");\n\n await sqlite.execute(\n `UPDATE ${TABLES.USER_ACCOUNTS} SET ${setClause}, updated_at = unixepoch() WHERE id = 1`,\n values,\n );\n}\n\n// Settings queries\nexport async function createDefaultSettings(): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.SETTINGS} (id) VALUES (1) RETURNING *`,\n );\n return result.rows[0] as unknown as Settings;\n}\n\nexport async function getSettings(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.SETTINGS} WHERE id = 1`,\n );\n return (result.rows[0] as unknown as Settings) || null;\n}\n\nexport async function updateSettings(\n updates: Partial,\n): Promise {\n const keys = Object.keys(updates);\n const values = Object.values(updates);\n const setClause = keys.map((key) => `${key} = ?`).join(\", \");\n\n await sqlite.execute(\n `UPDATE ${TABLES.SETTINGS} SET ${setClause}, updated_at = unixepoch() WHERE id = 1`,\n values,\n );\n}\n\n// Post tracking queries\nexport async function getRecentPosts(\n limit: number = 10,\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.POST_TRACKING} \n WHERE sync_status = 'success' \n ORDER BY synced_at DESC \n LIMIT ?`,\n [limit],\n );\n return result.rows as unknown as PostTracking[];\n}\n\nexport async function cullOldPostLogs(keepCount: number = 100): Promise {\n // Delete old post tracking records, keeping only the most recent ones\n await sqlite.execute(\n `\n DELETE FROM ${TABLES.POST_TRACKING}\n WHERE id NOT IN (\n SELECT id FROM ${TABLES.POST_TRACKING}\n ORDER BY created_at DESC\n LIMIT ?\n )\n `,\n [keepCount],\n );\n}\n\nexport async function getPostStats(): Promise<{\n posts_synced: number;\n posts_failed: number;\n posts_pending: number;\n}> {\n const result = await sqlite.execute(`\n SELECT \n COUNT(CASE WHEN sync_status = 'success' THEN 1 END) as posts_synced,\n COUNT(CASE WHEN sync_status = 'failed' THEN 1 END) as posts_failed,\n COUNT(CASE WHEN sync_status = 'pending' THEN 1 END) as posts_pending\n FROM ${TABLES.POST_TRACKING}\n `);\n\n const row = result.rows[0] as any;\n return {\n posts_synced: row.posts_synced || 0,\n posts_failed: row.posts_failed || 0,\n posts_pending: row.posts_pending || 0,\n };\n}\n\n// Sync log queries\nexport async function getRecentSyncLogs(limit: number = 5): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.SYNC_LOGS} ORDER BY created_at DESC LIMIT ?`,\n [limit],\n );\n return result.rows as unknown as SyncLog[];\n}\n\nexport async function getLastSyncLog(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.SYNC_LOGS} ORDER BY created_at DESC LIMIT 1`,\n );\n return (result.rows[0] as unknown as SyncLog) || null;\n}\n","deleted","label",[170,171,153],"backend","database","permalink","https://www.val.town/x/tejpochiraju/atproto-to-fediverse/code/backend/database/queries.ts","extension","actionData","errors"]