[{"_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","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,"_172":173,"_174":-5},"handle","index","name","atproto-to-fediverse","path","backend/storage/sqlite-storage.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","85eaef70-8094-11f0-a977-0224a6c84d84","createdAt",["D",1756003583839],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019876e8-c0b9-75f1-91ce-fb8d4b14811e","pinnedFileId","pinPreview","screenshotVersion","likeCount","019876e8-c0b9-75f1-91ce-fcb19f42fd07","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMHE0OVpmUEF6TXZPWUZsM3Y2a2xSUkVyV2IifQ","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,"85ef72f2-8094-11f0-a977-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},"8616959e-8094-11f0-a977-0224a6c84d84","sqlite-storage.ts","fileId","0198d9f8-487c-763c-a562-9c88abc5e11e","parentId","0198d9f8-487c-763c-a562-a273c08812ce","branchId","branchVersion","latest",true,["D",1756003583839],"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",[170,171,153],"backend","storage","permalink","https://www.val.town/x/index/atproto-to-fediverse/code/backend/storage/sqlite-storage.ts","extension","actionData","errors"]