[{"_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","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,"_173":174,"_175":-5},"handle","tijs","name","atproto-to-fediverse","path","backend/storage/sqlite-storage.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},"0607e67a-665c-11f0-9171-0224a6c84d84","sqlite-storage.ts","fileId","2e2a6800-63bc-11f0-bcef-0224a6c84d84","parentId","2d8adc36-63bc-11f0-bd30-0224a6c84d84","branchId","branchVersion",343,"latest",["D",1753120587094],3,"fileType","script","content","import {\n PostTracking,\n PostTrackingStorage,\n Settings,\n SettingsStorage,\n StorageProvider,\n SyncLog,\n SyncLogStorage,\n UserAccount,\n UserAccountStorage,\n} from \"../interfaces/storage.ts\";\n\nconst sqlite = (await import(\"https://esm.town/v/stevekrouse/sqlite\")).sqlite;\n\nclass SQLiteUserAccountStorage implements UserAccountStorage {\n async create(): Promise {\n const now = Date.now();\n const result = await sqlite.execute(\n `INSERT INTO bridge_user_accounts_v1 (id, setup_completed, created_at, updated_at) \n VALUES (1, FALSE, ?, ?) \n ON CONFLICT(id) DO UPDATE SET updated_at = ?\n RETURNING *`,\n [now, now, now],\n );\n return result.rows[0] as unknown as UserAccount;\n }\n\n async getSingle(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_user_accounts_v1 WHERE id = 1`,\n );\n return result.rows.length > 0\n ? result.rows[0] as unknown as UserAccount\n : null;\n }\n\n async updateSingle(updates: Partial): Promise {\n const fields = Object.keys(updates).filter((key) => key !== \"id\");\n if (fields.length === 0) return;\n\n const setClause = fields.map((field) => `${field} = ?`).join(\", \");\n const values = fields.map((field) => (updates as any)[field]);\n\n await sqlite.execute(\n `UPDATE bridge_user_accounts_v1 SET ${setClause}, updated_at = ? WHERE id = 1`,\n [...values, Date.now()],\n );\n }\n}\n\nclass SQLiteSettingsStorage implements SettingsStorage {\n async create(): Promise {\n const now = Date.now();\n const result = await sqlite.execute(\n `INSERT INTO bridge_settings_v1 (id, sync_enabled, sync_interval_minutes, created_at, updated_at) \n VALUES (1, TRUE, 15, ?, ?) \n ON CONFLICT(id) DO UPDATE SET updated_at = ?\n RETURNING *`,\n [now, now, now],\n );\n return result.rows[0] as unknown as Settings;\n }\n\n async getSingle(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_settings_v1 WHERE id = 1`,\n );\n return result.rows.length > 0\n ? result.rows[0] as unknown as Settings\n : null;\n }\n\n async updateSingle(updates: Partial): Promise {\n const fields = Object.keys(updates).filter((key) => key !== \"id\");\n if (fields.length === 0) return;\n\n const setClause = fields.map((field) => `${field} = ?`).join(\", \");\n const values = fields.map((field) => (updates as any)[field]);\n\n await sqlite.execute(\n `UPDATE bridge_settings_v1 SET ${setClause}, updated_at = ? WHERE id = 1`,\n [...values, Date.now()],\n );\n }\n}\n\nclass SQLitePostTrackingStorage implements PostTrackingStorage {\n async create(\n data: Omit,\n ): Promise {\n const now = Math.floor(Date.now() / 1000); // Convert to Unix seconds\n const result = await sqlite.execute(\n `INSERT INTO bridge_post_tracking_v1 \n (atproto_uri, atproto_cid, atproto_rkey, content_hash, atproto_created_at, sync_status, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?, 'pending', ?, ?) \n RETURNING *`,\n [\n data.atproto_uri,\n data.atproto_cid,\n data.atproto_rkey,\n data.content_hash,\n data.atproto_created_at,\n now,\n now,\n ],\n );\n return result.rows[0] as unknown as PostTracking;\n }\n\n async getByUri(uri: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_post_tracking_v1 WHERE atproto_uri = ?`,\n [uri],\n );\n return result.rows.length > 0\n ? result.rows[0] as unknown as PostTracking\n : null;\n }\n\n async updateByUri(\n uri: string,\n updates: Partial,\n ): Promise {\n const fields = Object.keys(updates).filter((key) =>\n ![\"id\", \"atproto_uri\"].includes(key)\n );\n if (fields.length === 0) return;\n\n const setClause = fields.map((field) => `${field} = ?`).join(\", \");\n const values = fields.map((field) => (updates as any)[field]);\n\n await sqlite.execute(\n `UPDATE bridge_post_tracking_v1 SET ${setClause}, updated_at = ? WHERE atproto_uri = ?`,\n [...values, Math.floor(Date.now() / 1000), uri], // Convert to Unix seconds\n );\n }\n\n async getPending(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_post_tracking_v1 WHERE sync_status = 'pending' ORDER BY created_at ASC`,\n );\n return result.rows as unknown as PostTracking[];\n }\n\n async getFailed(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_post_tracking_v1 WHERE sync_status = 'failed' ORDER BY created_at DESC`,\n );\n return result.rows as unknown as PostTracking[];\n }\n\n async getRecent(limit: number = 20): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_post_tracking_v1 ORDER BY created_at DESC LIMIT ?`,\n [limit],\n );\n return result.rows as unknown as PostTracking[];\n }\n\n async getStats(): Promise {\n const result = await sqlite.execute(\n `SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN sync_status = 'success' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN sync_status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN sync_status = 'pending' THEN 1 END) as pending_posts,\n MAX(created_at) as last_sync\n FROM bridge_post_tracking_v1`,\n );\n return result.rows[0];\n }\n}\n\nclass SQLiteSyncLogStorage implements SyncLogStorage {\n async create(data: Omit): Promise {\n const now = Math.floor(Date.now() / 1000); // Convert to Unix seconds\n const result = await sqlite.execute(\n `INSERT INTO bridge_sync_logs_v1 \n (sync_type, posts_fetched, posts_synced, posts_failed, posts_skipped, error_message, duration_ms, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?) \n RETURNING *`,\n [\n data.sync_type,\n data.posts_fetched,\n data.posts_synced,\n data.posts_failed,\n data.posts_skipped,\n data.error_message || null,\n data.duration_ms || null,\n now,\n ],\n );\n return result.rows[0] as unknown as SyncLog;\n }\n\n async getRecent(limit: number = 20): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM bridge_sync_logs_v1 ORDER BY created_at DESC LIMIT ?`,\n [limit],\n );\n return result.rows as unknown as SyncLog[];\n }\n}\n\nexport class SQLiteStorageProvider implements StorageProvider {\n userAccounts: UserAccountStorage;\n settings: SettingsStorage;\n postTracking: PostTrackingStorage;\n syncLogs: SyncLogStorage;\n\n constructor() {\n this.userAccounts = new SQLiteUserAccountStorage();\n this.settings = new SQLiteSettingsStorage();\n this.postTracking = new SQLitePostTrackingStorage();\n this.syncLogs = new SQLiteSyncLogStorage();\n }\n\n async initialize(): Promise {\n // Database migrations are handled separately\n // This method exists for interface compatibility\n }\n\n async cullOldPostLogs(keepCount: number = 100): Promise {\n // Import the cullOldPostLogs function and use it\n const { cullOldPostLogs } = await import(\"../database/queries.ts\");\n await cullOldPostLogs(keepCount);\n return keepCount; // Return the number we intended to keep\n }\n}\n","deleted","label",[171,172,153],"backend","storage","permalink","https://www.val.town/x/tijs/atproto-to-fediverse/code/backend/storage/sqlite-storage.ts","extension","actionData","errors"]