[{"_1":2,"_176":-5,"_177":-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","4ff166458996ccfe3bfa8627489090938620785a","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,"_173":174,"_175":-5},"handle","tijs","name","atproto-to-fediverse","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":110,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":-5,"_118":119,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","c4d11e94-63b1-11f0-866e-0224a6c84d84","createdAt",["D",1752827561082],"deletedAt","legacyEnvVars","privacy","public","description","Syncing Bluesky posts to Mastodon - Prod","imageUrl","14049850-28c1-11f0-89c9-c7d0e2d9e1ea","pinnedFileId","2e2e3aac-63bc-11f0-8513-0224a6c84d84","pinPreview",true,"screenshotVersion","likeCount",1,"c04d51b2-a7dc-46ca-ad6f-52f47c2906a8","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd2Nod2N0bE1MWFdEUlRYd083ZE5pbXJ1bDAifQ","org",{"_93":94,"_135":132},"avatar","branch",{"_138":139,"_95":43,"_101":140,"_141":102,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":96,"_148":94},"version",420,"c4d19400-63b1-11f0-866e-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":152,"_95":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_103":162,"_138":163,"_164":165,"_166":167,"_168":20,"_169":-5,"_97":170},"63504ee4-665c-11f0-b312-0224a6c84d84","queries.ts","fileId","2e23df9e-63bc-11f0-be89-0224a6c84d84","parentId","2d732582-63bc-11f0-922f-0224a6c84d84","branchId","branchVersion",344,"latest",["D",1753120743756],11,"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",[171,172,153],"backend","database","permalink","https://www.val.town/x/tijs/atproto-to-fediverse/code/backend/database/queries.ts","extension","actionData","errors"]