[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_389":390,"_391":392},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_53":-7,"_256":-5,"_19":257,"_258":259,"_260":261,"_262":263,"_264":265,"_21":266,"_267":-5,"_268":-5,"_269":30,"_270":271,"_272":30,"_273":-5,"_274":-5,"_275":276},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":-5},"handle","barryf","name","fsq2pds","branchName","main","path","lib","project",{"_47":204,"_13":14,"_51":205,"_206":-5,"_207":30,"_208":209,"_210":209,"_211":212,"_213":-5,"_31":82,"_214":-5,"_215":30,"_216":-5,"_217":-5,"_218":26,"_55":56,"_219":220,"_221":222,"_223":224,"_225":-5,"_226":227,"_228":227,"_229":230,"_231":230,"_232":230,"_233":227,"_234":227,"_66":235,"_236":237,"_238":239,"_240":30},"file",{"_76":201,"_13":18,"_79":202,"_81":30,"_203":-5},"isDirectory",true,"page",0,"history",[32,33,34,35,36,37,38,39,40,41,42,43,44,45,46],"hasNext",false,"userId",{"_47":193,"_49":50,"_51":194,"_53":195,"_55":56,"_57":196,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":197,"_21":198,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":199},{"_47":186,"_49":50,"_51":187,"_53":188,"_55":56,"_57":178,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":189,"_21":190,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":191},{"_47":178,"_49":50,"_51":179,"_53":180,"_55":56,"_57":181,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":182,"_21":183,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":184},{"_47":171,"_49":50,"_51":172,"_53":173,"_55":56,"_57":163,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":174,"_21":175,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":176},{"_47":163,"_49":50,"_51":164,"_53":165,"_55":56,"_57":166,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":167,"_21":168,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":169},{"_47":155,"_49":50,"_51":156,"_53":157,"_55":56,"_57":158,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":159,"_21":160,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":161},{"_47":147,"_49":50,"_51":148,"_53":149,"_55":56,"_57":150,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":151,"_21":152,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":153},{"_47":137,"_49":50,"_51":138,"_53":139,"_55":56,"_57":140,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":141,"_21":142,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":143},{"_47":129,"_49":50,"_51":130,"_53":131,"_55":56,"_57":132,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":133,"_21":134,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":135},{"_47":121,"_49":50,"_51":122,"_53":123,"_55":56,"_57":124,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":125,"_21":126,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":127},{"_47":113,"_49":50,"_51":114,"_53":115,"_55":56,"_57":116,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":117,"_21":118,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":119},{"_47":104,"_49":50,"_51":105,"_53":106,"_55":56,"_57":95,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":107,"_21":108,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":109},{"_47":95,"_49":50,"_51":96,"_53":97,"_55":56,"_57":85,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":98,"_21":99,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":100},{"_47":85,"_49":50,"_51":86,"_53":87,"_55":56,"_57":88,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":89,"_21":90,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":91},{"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_21":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74},"id","3efb23e8-4243-11f1-a8c8-42b51c65c3df","branchId","3ddb19fa-4243-11f1-8011-42b51c65c3df","createdAt",["D",1777299201181],"version",8,"orgId","dc713b9c-8776-46e0-8027-faa0b9eae4af","parentId","3ef2169a-4243-11f1-a8c8-42b51c65c3df","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":77,"_13":78,"_79":80,"_81":30},"pull","merge","revert","multiple","commits",[75],{"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_21":68,"_69":-5,"_70":-5,"_71":-5},"fileId","3ef89a10-4243-11f1-a8c8-42b51c65c3df","photos.ts","fileType","script","deleted","60ee761a-2727-4820-a921-a3de0f67378e","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4Y3gxZ2p3ZkZydXhzM1lVTnAwekdLMXJBWSJ9","3f16f910-4243-11f1-a9ae-42b51c65c3df",["D",1777299201317],11,"3f0c3818-4243-11f1-b8b5-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":93,"_13":94,"_79":80,"_81":30},[92],{"_47":85,"_49":50,"_51":86,"_53":87,"_55":56,"_57":88,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":89,"_21":90,"_69":-5,"_70":-5,"_71":-5},"3f1362aa-4243-11f1-a9ae-42b51c65c3df","foursquare.ts","3f1aeb24-4243-11f1-a8c8-42b51c65c3df",["D",1777299201382],12,{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":102,"_13":103,"_79":80,"_81":30},[101],{"_47":95,"_49":50,"_51":96,"_53":97,"_55":56,"_57":85,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":98,"_21":99,"_69":-5,"_70":-5,"_71":-5},"3f18eea0-4243-11f1-a8c8-42b51c65c3df","atproto.ts","3f1fce82-4243-11f1-8a98-42b51c65c3df",["D",1777299201415],13,{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":111,"_13":112,"_79":80,"_81":30},[110],{"_47":104,"_49":50,"_51":105,"_53":106,"_55":56,"_57":95,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":107,"_21":108,"_69":-5,"_70":-5,"_71":-5},"3f1deb4e-4243-11f1-8a98-42b51c65c3df","db.ts","500ac114-4245-11f1-8a14-42b51c65c3df",["D",1777300088793],17,"3f353bd2-4243-11f1-8240-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":93,"_13":94,"_79":80,"_81":30},[120],{"_47":113,"_49":50,"_51":114,"_53":115,"_55":56,"_57":116,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":117,"_21":118,"_69":-5,"_70":-5,"_71":-5},"a8ca6354-4245-11f1-8caf-42b51c65c3df",["D",1777300237687],19,"5014ba48-4245-11f1-9595-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":93,"_13":94,"_79":80,"_81":30},[128],{"_47":121,"_49":50,"_51":122,"_53":123,"_55":56,"_57":124,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":125,"_21":126,"_69":-5,"_70":-5,"_71":-5},"566fb680-424b-11f1-b6f5-42b51c65c3df",["D",1777302676037],101,"566281d6-424b-11f1-a0af-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":93,"_13":94,"_79":80,"_81":30},[136],{"_47":129,"_49":50,"_51":130,"_53":131,"_55":56,"_57":132,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":133,"_21":134,"_69":-5,"_70":-5,"_71":-5},"d5911fb6-4260-11f1-900d-42b51c65c3df",["D",1777311909219],114,"d5734b4e-4260-11f1-900d-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":145,"_13":146,"_79":80,"_81":30},[144],{"_47":137,"_49":50,"_51":138,"_53":139,"_55":56,"_57":140,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":141,"_21":142,"_69":-5,"_70":-5,"_71":-5},"d58e8c74-4260-11f1-900d-42b51c65c3df","sync.ts","d5a190da-4260-11f1-9f2e-42b51c65c3df",["D",1777311909258],116,"d5970a48-4260-11f1-8bbb-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":93,"_13":94,"_79":80,"_81":30},[154],{"_47":147,"_49":50,"_51":148,"_53":149,"_55":56,"_57":150,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":151,"_21":152,"_69":-5,"_70":-5,"_71":-5},"d5c12ddc-4260-11f1-9f2e-42b51c65c3df",["D",1777311909425],118,"d5b3584c-4260-11f1-820a-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":102,"_13":103,"_79":80,"_81":30},[162],{"_47":155,"_49":50,"_51":156,"_53":157,"_55":56,"_57":158,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":159,"_21":160,"_69":-5,"_70":-5,"_71":-5},"971e87eb-8e5a-46d6-bedb-478f3aae6821",["D",1783859391386],125,"218343e0-4261-11f1-9ac6-42b51c65c3df",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":145,"_13":146,"_79":80,"_81":30},[170],{"_47":163,"_49":50,"_51":164,"_53":165,"_55":56,"_57":166,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":167,"_21":168,"_69":-5,"_70":-5,"_71":-5},"d0020c38-c466-424c-8164-c97662331178",["D",1783859391399],126,{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":93,"_13":94,"_79":80,"_81":30},[177],{"_47":171,"_49":50,"_51":172,"_53":173,"_55":56,"_57":163,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":174,"_21":175,"_69":-5,"_70":-5,"_71":-5},"bf6e33bb-70f2-4d79-9dc2-16941d7fc479",["D",1783859391409],129,"b2671795-b40a-4ce3-abce-b03389983a02",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":102,"_13":103,"_79":80,"_81":30},[185],{"_47":178,"_49":50,"_51":179,"_53":180,"_55":56,"_57":181,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":182,"_21":183,"_69":-5,"_70":-5,"_71":-5},"17109495-a5ff-40e6-868c-315da7d4c1f6",["D",1783859517189],130,{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":102,"_13":103,"_79":80,"_81":30},[192],{"_47":186,"_49":50,"_51":187,"_53":188,"_55":56,"_57":178,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":189,"_21":190,"_69":-5,"_70":-5,"_71":-5},"e9b2bb9c-3977-4657-94f8-7816034bd73d",["D",1783859517379],132,"23f0fa80-4975-41d2-98fc-bfd6a0afd68c",{"_47":82,"_55":56,"_11":12,"_83":84},{"_76":77,"_13":78,"_79":80,"_81":30},[200],{"_47":193,"_49":50,"_51":194,"_53":195,"_55":56,"_57":196,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":197,"_21":198,"_69":-5,"_70":-5,"_71":-5},"3eb4134a-4243-11f1-bd90-42b51c65c3df","directory","deletedAtVersion","3dda5d80-4243-11f1-8011-42b51c65c3df",["D",1777299199304],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Foursquare/Swarm checkins → ATProto PDS","imageUrl","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","3dda5d80424311f1801142b51c65c3df","tursoHostname","3dda5d80424311f1801142b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_255":84},"org",{"_11":12,"_250":251,"_83":84,"_31":82,"_252":253,"_254":30},"branch",{"_53":241,"_13":16,"_47":50,"_242":204,"_243":-5,"_244":-5,"_245":-5,"_246":-5,"_247":-5,"_248":14,"_249":12},"isOwned",134,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Barry Frost","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_47":204,"_13":14,"_51":384,"_206":-5,"_207":30,"_208":209,"_210":209,"_211":212,"_213":-5,"_31":82,"_214":-5,"_215":30,"_216":-5,"_217":-5,"_218":26,"_55":56,"_219":220,"_221":222,"_223":385,"_225":-5,"_226":227,"_228":227,"_229":230,"_231":230,"_232":230,"_233":227,"_234":227,"_66":386,"_236":387,"_238":388,"_240":30},"tree",[323,329,330,331,332],"files",[323,324,325,326,327,328,329,330,331,332],"counts",{"_313":26,"_314":292,"_315":26,"_316":317,"_318":319},"contents",[285,286,287,288,289],{"_47":277,"_13":18,"_76":201,"_57":-5,"_49":50,"_278":279,"_280":24,"_51":281,"_53":26,"_79":202,"_282":-5,"_81":30,"_283":-5,"_17":284},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"3eb4128c-4243-11f1-bd90-42b51c65c3df","branchVersion",4,"latest",["D",1777299200731],"content","label",[18],{"_47":308,"_13":103,"_76":102,"_57":201,"_49":50,"_278":188,"_280":24,"_51":309,"_53":310,"_79":80,"_282":311,"_81":30,"_283":-5,"_17":312},{"_47":304,"_13":112,"_76":111,"_57":201,"_49":50,"_278":106,"_280":24,"_51":305,"_53":26,"_79":80,"_282":306,"_81":30,"_283":-5,"_17":307},{"_47":299,"_13":94,"_76":93,"_57":201,"_49":50,"_278":173,"_280":24,"_51":300,"_53":301,"_79":80,"_282":302,"_81":30,"_283":-5,"_17":303},{"_47":295,"_13":78,"_76":77,"_57":201,"_49":50,"_278":195,"_280":24,"_51":296,"_53":292,"_79":80,"_282":297,"_81":30,"_283":-5,"_17":298},{"_47":290,"_13":146,"_76":145,"_57":201,"_49":50,"_278":165,"_280":24,"_51":291,"_53":292,"_79":80,"_282":293,"_81":30,"_283":-5,"_17":294},"002506c8-9b54-48f6-9693-074798e8ed5e",["D",1783859391386],1,"import { type FsqCheckin } from \"./foursquare.ts\";\nimport { fetchPhoto } from \"./photos.ts\";\nimport { uploadBlob, createRecord, type Session } from \"./atproto.ts\";\n\nexport interface SyncResult {\n uri: string;\n cid: string;\n photosUploaded: number;\n}\n\nexport async function syncCheckin(\n session: Session,\n checkin: FsqCheckin,\n): Promise {\n const location: Record = {\n \"$type\": \"community.lexicon.location.fsq\",\n fsq_place_id: checkin.venue.id,\n name: checkin.venue.name,\n };\n if (checkin.venue.location?.lat != null && checkin.venue.location?.lng != null) {\n location.latitude = String(checkin.venue.location.lat);\n location.longitude = String(checkin.venue.location.lng);\n }\n\n const formattedAddress = checkin.venue.location?.formattedAddress;\n const address = formattedAddress?.length ? formattedAddress.join(\", \") : undefined;\n const category = checkin.venue.categories?.[0]?.name;\n const comment = checkin.shout?.trim();\n\n const photos: object[] = [];\n for (const photo of checkin.photos?.items ?? []) {\n const fetched = await fetchPhoto(photo);\n if (!fetched) continue;\n try {\n const blobRef = await uploadBlob(session, fetched.bytes, fetched.mimeType);\n photos.push({ image: blobRef });\n } catch (err) {\n console.warn(`Photo upload failed for checkin ${checkin.id}:`, err);\n }\n }\n\n const record: Record = {\n \"$type\": \"com.barryfrost.checkin\",\n createdAt: new Date(checkin.createdAt * 1000).toISOString(),\n location,\n ...(address && { address }),\n ...(category && { category }),\n ...(comment && { comment }),\n };\n if (photos.length > 0) {\n record.photos = photos;\n }\n\n const { uri, cid } = await createRecord(\n session,\n \"com.barryfrost.checkin\",\n checkin.id,\n record,\n );\n\n return { uri, cid, photosUploaded: photos.length };\n}\n",[18,146],"4eb94f3a-2356-4fae-b811-d5fb2f4bfc49",["D",1783859517379],"import { photoUrl, type FsqPhoto } from \"./foursquare.ts\";\n\nconst MAX_PHOTO_BYTES = 1_000_000;\n\nexport interface FetchedPhoto {\n bytes: Uint8Array;\n mimeType: string;\n}\n\nexport async function fetchPhoto(photo: FsqPhoto): Promise {\n const url = photoUrl(photo);\n try {\n const resp = await fetch(url);\n if (!resp.ok) {\n console.warn(`Photo fetch failed (${resp.status}): ${url}`);\n return null;\n }\n const bytes = new Uint8Array(await resp.arrayBuffer());\n if (bytes.byteLength > MAX_PHOTO_BYTES) {\n console.warn(`Photo too large (${bytes.byteLength} bytes), skipping: ${url}`);\n return null;\n }\n const mimeType = resp.headers.get(\"content-type\")?.split(\";\")[0].trim() ?? \"image/jpeg\";\n return { bytes, mimeType };\n } catch (err) {\n console.warn(`Photo fetch error for ${url}:`, err);\n return null;\n }\n}\n",[18,78],"8a29f03a-b930-4460-aa96-a63da8e6212f",["D",1783859391399],5,"const FSQ_API_BASE = \"https://api.foursquare.com/v2\";\n\nexport interface FsqPhoto {\n prefix: string;\n suffix: string;\n}\n\nexport interface FsqCheckin {\n id: string;\n createdAt: number; // unix seconds\n venue: {\n id: string;\n name: string;\n location?: {\n lat?: number;\n lng?: number;\n formattedAddress?: string[];\n };\n categories?: { name: string }[];\n };\n photos?: {\n count: number;\n items: FsqPhoto[];\n };\n shout?: string;\n}\n\nexport async function getCheckins(\n oauthToken: string,\n apiVersion: string,\n offset = 0,\n limit = 50,\n): Promise {\n const params = new URLSearchParams({\n oauth_token: oauthToken,\n v: apiVersion,\n limit: String(limit),\n offset: String(offset),\n });\n const resp = await fetch(`${FSQ_API_BASE}/users/self/checkins?${params}`);\n if (!resp.ok) {\n throw new Error(`FSQ API error ${resp.status}: ${await resp.text()}`);\n }\n const data = await resp.json();\n if (data.meta?.code !== 200) {\n throw new Error(`FSQ API returned non-200: ${JSON.stringify(data.meta)}`);\n }\n return (data.response?.checkins?.items ?? []) as FsqCheckin[];\n}\n\nexport function photoUrl(photo: FsqPhoto, size = \"1024x1024\"): string {\n return `${photo.prefix}${size}${photo.suffix}`;\n}\n",[18,94],"3f1dea7c-4243-11f1-8a98-42b51c65c3df",["D",1777299201415],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function ensureSchema(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS seen_checkins (\n fsq_id TEXT PRIMARY KEY,\n fsq_created_at INTEGER NOT NULL,\n pds_at_uri TEXT NOT NULL,\n pds_cid TEXT NOT NULL,\n processed_at INTEGER NOT NULL DEFAULT (unixepoch())\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_seen_created ON seen_checkins(fsq_created_at)`,\n );\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sync_state (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )\n `);\n}\n\nexport async function getState(key: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT value FROM sync_state WHERE key = ?\",\n args: [key],\n });\n return result.rows.length > 0 ? String(result.rows[0].value) : null;\n}\n\nexport async function setState(key: string, value: string): Promise {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO sync_state (key, value) VALUES (?, ?)\",\n args: [key, value],\n });\n}\n\nexport async function hasCheckin(fsqId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT 1 FROM seen_checkins WHERE fsq_id = ?\",\n args: [fsqId],\n });\n return result.rows.length > 0;\n}\n\nexport async function recordCheckin(\n fsqId: string,\n fsqCreatedAt: number,\n pdsAtUri: string,\n pdsCid: string,\n): Promise {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO seen_checkins (fsq_id, fsq_created_at, pds_at_uri, pds_cid)\n VALUES (?, ?, ?, ?)`,\n args: [fsqId, fsqCreatedAt, pdsAtUri, pdsCid],\n });\n}\n",[18,112],"c3478784-333f-43d4-b611-e43122da02ea",["D",1783859517189],3,"const PDS_URL = Deno.env.get(\"BSKY_PDS_URL\") ?? \"https://bsky.social\";\n\nexport interface Session {\n accessJwt: string;\n did: string;\n}\n\n// Module-scoped session cache; cleared on each cron invocation via clearSession()\nlet cachedSession: Session | null = null;\n\nexport function clearSession(): void {\n cachedSession = null;\n}\n\nexport async function getSession(): Promise {\n if (cachedSession) return cachedSession;\n const handle = Deno.env.get(\"BSKY_HANDLE\");\n const password = Deno.env.get(\"BSKY_APP_PASSWORD\");\n if (!handle || !password) {\n throw new Error(\"BSKY_HANDLE and BSKY_APP_PASSWORD env vars are required\");\n }\n const resp = await fetch(`${PDS_URL}/xrpc/com.atproto.server.createSession`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ identifier: handle, password }),\n });\n if (!resp.ok) {\n throw new Error(`createSession failed (${resp.status}): ${await resp.text()}`);\n }\n const data = await resp.json();\n cachedSession = { accessJwt: data.accessJwt, did: data.did };\n return cachedSession;\n}\n\nexport async function uploadBlob(\n session: Session,\n bytes: Uint8Array,\n mimeType: string,\n): Promise

History · lib