[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_298":299,"_300":301},"routes/_app.x.$handle.$name",{"_97":96,"_31":44,"_106":87,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":24,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":24},"version",114,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","lib/sync.ts","latestPath","fileId","d58e8c74-4260-11f1-900d-42b51c65c3df","name","sync.ts","fileType","script","content","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\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 };\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","createdAt",["D",1777311909219],"branchVersion","branchId","3ddb19fa-4243-11f1-8011-42b51c65c3df","id","3dda5d80-4243-11f1-8011-42b51c65c3df","fsq2pds",["D",1777299199304],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Foursquare/Swarm checkins → ATProto PDS","imageUrl","60ee761a-2727-4820-a921-a3de0f67378e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","dc713b9c-8776-46e0-8027-faa0b9eae4af","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","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":24},"branch",{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"isOwned",134,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","barryf","handle","displayName","Barry Frost","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4Y3gxZ2p3ZkZydXhzM1lVTnAwekdLMXJBWSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":293,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":294,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":295,"_81":296,"_83":297,"_85":24},"tree",[214,215,216,217,218,224,225,226,227],"files",[214,215,216,217,218,219,220,221,222,223,224,225,226,227],"counts",{"_203":60,"_204":144,"_205":60,"_206":207,"_208":209},"contents",[128,129,130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":197,"_31":198,"_29":199,"_140":-5,"_40":41,"_39":200,"_142":24,"_37":201,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_26":202},{"_42":191,"_31":192,"_29":193,"_140":-5,"_40":41,"_39":194,"_142":24,"_37":195,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_26":196},{"_42":185,"_31":186,"_29":187,"_140":-5,"_40":41,"_39":188,"_142":24,"_37":189,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_26":190},{"_42":179,"_31":180,"_29":181,"_140":-5,"_40":41,"_39":182,"_142":24,"_37":183,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_26":184},{"_42":171,"_31":172,"_29":173,"_140":-5,"_40":41,"_39":174,"_142":175,"_37":176,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_26":178},{"_42":164,"_31":165,"_29":166,"_140":-5,"_40":41,"_39":167,"_142":24,"_37":168,"_13":60,"_33":20,"_35":169,"_23":24,"_146":-5,"_26":170},{"_42":157,"_31":158,"_29":159,"_140":-5,"_40":41,"_39":160,"_142":24,"_37":161,"_13":60,"_33":20,"_35":162,"_23":24,"_146":-5,"_26":163},{"_42":148,"_31":149,"_29":150,"_140":-5,"_40":41,"_39":151,"_142":24,"_37":152,"_13":153,"_33":154,"_35":155,"_23":24,"_146":-5,"_26":156},{"_42":137,"_31":138,"_29":139,"_140":-5,"_40":41,"_39":141,"_142":24,"_37":143,"_13":144,"_33":20,"_35":145,"_23":24,"_146":-5,"_26":147},"55f415a2-424b-11f1-a519-42b51c65c3df","deno.json","3f00c4f6-4243-11f1-8240-42b51c65c3df","parentId",97,"latest",["D",1777302675629],1,"{\n \"tasks\": {\n \"bootstrap\": \"deno run --allow-env --allow-net bootstrap/fsq-oauth.ts\",\n \"publish-lexicon\": \"deno run --allow-env --allow-net --allow-read bootstrap/publish-lexicon.ts\"\n }\n}\n","label",[138],"565f61b8-424b-11f1-a0af-42b51c65c3df","cron.ts","3f2214da-4243-11f1-8a8a-42b51c65c3df",100,["D",1777302676038],2,"interval","import {\n ensureSchema,\n getState,\n setState,\n hasCheckin,\n recordCheckin,\n} from \"./lib/db.ts\";\nimport { getCheckins } from \"./lib/foursquare.ts\";\nimport { fetchPhoto } from \"./lib/photos.ts\";\nimport { clearSession, getSession, uploadBlob, createRecord } from \"./lib/atproto.ts\";\n\nconst FSQ_OAUTH_TOKEN = Deno.env.get(\"FSQ_OAUTH_TOKEN\") ?? \"\";\nconst FSQ_API_VERSION = Deno.env.get(\"FSQ_API_VERSION\") ?? \"20240101\";\n\ninterface Interval {\n lastRunAt: Date | undefined;\n}\n\nexport default async function (_interval: Interval): Promise {\n if (!FSQ_OAUTH_TOKEN) {\n console.error(\"FSQ_OAUTH_TOKEN is not set\");\n return;\n }\n\n await ensureSchema();\n clearSession(); // fresh session each run; avoids stale JWT issues\n\n const cursorStr = await getState(\"cursor_ts\");\n\n // First ever run: record the launch time as our cursor and exit.\n // Sync will begin from this point on the next run.\n if (cursorStr === null) {\n const now = Math.floor(Date.now() / 1000);\n await setState(\"launched_at\", String(now));\n await setState(\"cursor_ts\", String(now));\n console.log(`First run: launch cursor set to ${new Date(now * 1000).toISOString()}`);\n return;\n }\n\n const launchTs = parseInt(cursorStr, 10);\n\n console.log(`Fetching recent checkins (launch cursor: ${new Date(launchTs * 1000).toISOString()})`);\n\n let checkins;\n try {\n checkins = await getCheckins(FSQ_OAUTH_TOKEN, FSQ_API_VERSION);\n } catch (err) {\n console.error(\"Failed to fetch checkins from Foursquare:\", err);\n return;\n }\n\n // Filter to checkins after our launch timestamp; FSQ returns newest-first\n const newCheckins = checkins.filter((c) => c.createdAt > launchTs);\n\n if (newCheckins.length === 0) {\n console.log(\"No new checkins\");\n return;\n }\n\n // Process oldest-first so records are written in chronological order\n newCheckins.reverse();\n\n console.log(`Processing ${newCheckins.length} checkin(s)`);\n\n let session;\n try {\n session = await getSession();\n } catch (err) {\n console.error(\"Failed to authenticate with PDS:\", err);\n return;\n }\n\n for (const checkin of newCheckins) {\n if (await hasCheckin(checkin.id)) {\n console.log(`Already synced: ${checkin.id}`);\n continue;\n }\n\n try {\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\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 // Non-fatal: checkin record still created without this photo\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 };\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, // FSQ checkin ID used as rkey — unique, valid chars, stable\n record,\n );\n\n await recordCheckin(checkin.id, checkin.createdAt, uri, cid);\n console.log(`Synced ${checkin.id} (${checkin.venue.name}) → ${uri}`);\n } catch (err) {\n console.error(`Failed to process checkin ${checkin.id}:`, err);\n // Stop here; seen_checkins dedup ensures next run replays this checkin cleanly\n break;\n }\n }\n}\n\n",[149],"3edd42f6-4243-11f1-a8c8-42b51c65c3df","README.md","3edd43be-4243-11f1-a8c8-42b51c65c3df",6,["D",1777299201001],"# fsq2pds\n\nSyncs your Foursquare/Swarm checkins to your ATProto PDS as `com.barryfrost.checkin` records. Runs on Val.Town's free tier as a 15-minute cron.\n\n## Setup\n\n### 1. Create a Foursquare developer app\n\n1. Go to https://foursquare.com/developers/ and create a new app.\n2. Add `http://localhost:8765/callback` as an allowed Redirect URI.\n3. Note your **Client ID** and **Client Secret**.\n\n### 2. Mint your OAuth token (one-time, local)\n\n```sh\nFSQ_CLIENT_ID= FSQ_CLIENT_SECRET= deno task bootstrap\n```\n\nA browser window will open. Log in and approve. The token is printed to your terminal — it doesn't expire.\n\n### 3. Create a Bluesky app password\n\n1. Go to https://bsky.app/settings/app-passwords\n2. Create a new app password named `fsq2pds`.\n\n### 4. Deploy to Val.Town\n\n1. Install the `vt` CLI: https://docs.val.town/cli/\n2. From this directory run `vt push` (or use the Val.Town editor to paste the files).\n3. Set these **environment variables** in Val.Town settings:\n\n | Variable | Value |\n |----------|-------|\n | `FSQ_OAUTH_TOKEN` | Token from step 2 |\n | `FSQ_API_VERSION` | `20240101` |\n | `BSKY_HANDLE` | Your Bluesky handle |\n | `BSKY_APP_PASSWORD` | App password from step 3 |\n\n4. Open `cron.ts` in Val.Town and add a **cron trigger** set to every 15 minutes.\n\n### 5. Verify\n\n1. **Trigger manually** (first run). It will set the sync cursor to now and exit — no records written yet. Check the logs for `First run: launch cursor set to ...`.\n2. **Check in on Swarm.**\n3. **Trigger again** (or wait up to 15 minutes). Check the logs for `Synced () → at://...`.\n4. **View your records** at:\n ```\n https://pdsls.dev/at:///com.barryfrost.checkin\n ```\n\n## Record shape\n\n```json\n{\n \"$type\": \"com.barryfrost.checkin\",\n \"createdAt\": \"2024-06-01T14:30:00.000Z\",\n \"location\": {\n \"$type\": \"community.lexicon.location.fsq\",\n \"fsq_place_id\": \"abc123def456\",\n \"name\": \"Blue Bottle Coffee\",\n \"latitude\": \"37.776\",\n \"longitude\": \"-122.418\"\n },\n \"photos\": [\n {\n \"image\": {\n \"$type\": \"blob\",\n \"ref\": { \"$link\": \"bafyrei...\" },\n \"mimeType\": \"image/jpeg\",\n \"size\": 245678\n }\n }\n ]\n}\n```\n\n## Notes\n\n- **Only new checkins** are synced. Nothing before the first run is imported.\n- **Photos**: fetched at FSQ's `1024x1024` size. Skipped if >1MB or unreachable.\n- **Edits/deletes**: not synced. Records are write-once. Delete PDS records manually if needed.\n- **If a run fails mid-way**, the cursor stays at the last successful checkin. The next run replays cleanly — duplicate protection is handled by the `seen_checkins` table.\n",[158],"f1bc3a32-424b-11f1-8e47-42b51c65c3df",".vtignore","f1bc3adc-424b-11f1-8e47-42b51c65c3df",102,["D",1777302937067],".git/\n.gitignore\n.claude/\nPLAN.md\nREADME.md\nbootstrap/\nlexicons/\n",[165],"3eb4128c-4243-11f1-bd90-42b51c65c3df","lib","3eb4134a-4243-11f1-bd90-42b51c65c3df",4,true,["D",1777299200731],"directory",[172],"d5556a66-4260-11f1-a58c-42b51c65c3df","lexicons","d5556b42-4260-11f1-a58c-42b51c65c3df",112,["D",1777311908854],[180],"d515e936-4260-11f1-86a0-42b51c65c3df","bootstrap","d515e9f4-4260-11f1-86a0-42b51c65c3df",110,["D",1777311908437],[186],"d5716dce-4260-11f1-900d-42b51c65c3df",".git","d5716e82-4260-11f1-900d-42b51c65c3df",113,["D",1777311909039],[192],"d534397c-4260-11f1-900d-42b51c65c3df",".claude","d5343a3a-4260-11f1-900d-42b51c65c3df",111,["D",1777311908637],[198],"pulls","branches","forks","envVars",{"_210":212,"_213":60},"connections",{"_210":60,"_211":60},"count","unfilledCount",5,"emptyCount",{"_42":197,"_31":198,"_29":199,"_140":-5,"_40":41,"_39":200,"_142":24,"_37":290,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_229":291,"_26":292},{"_42":191,"_31":192,"_29":193,"_140":-5,"_40":41,"_39":194,"_142":24,"_37":287,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_229":288,"_26":289},{"_42":185,"_31":186,"_29":187,"_140":-5,"_40":41,"_39":188,"_142":24,"_37":284,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_229":285,"_26":286},{"_42":179,"_31":180,"_29":181,"_140":-5,"_40":41,"_39":182,"_142":24,"_37":281,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_229":282,"_26":283},{"_42":171,"_31":172,"_29":173,"_140":-5,"_40":41,"_39":174,"_142":175,"_37":278,"_13":60,"_33":177,"_35":-5,"_23":24,"_146":-5,"_229":279,"_26":280},{"_42":270,"_31":271,"_29":272,"_140":173,"_40":41,"_39":273,"_142":24,"_37":274,"_13":60,"_33":34,"_35":275,"_23":24,"_146":-5,"_229":276,"_26":277},{"_42":262,"_31":263,"_29":264,"_140":173,"_40":41,"_39":265,"_142":175,"_37":266,"_13":60,"_33":34,"_35":267,"_23":24,"_146":-5,"_229":268,"_26":269},{"_42":253,"_31":254,"_29":255,"_140":173,"_40":41,"_39":256,"_142":24,"_37":257,"_13":258,"_33":34,"_35":259,"_23":24,"_146":-5,"_229":260,"_26":261},{"_42":245,"_31":246,"_29":247,"_140":173,"_40":41,"_39":248,"_142":24,"_37":249,"_13":60,"_33":34,"_35":250,"_23":24,"_146":-5,"_229":251,"_26":252},{"_42":241,"_31":32,"_29":30,"_140":173,"_40":41,"_39":14,"_142":24,"_37":242,"_13":60,"_33":34,"_35":36,"_23":24,"_146":-5,"_229":243,"_26":244},{"_42":164,"_31":165,"_29":166,"_140":-5,"_40":41,"_39":167,"_142":24,"_37":238,"_13":60,"_33":20,"_35":169,"_23":24,"_146":-5,"_229":239,"_26":240},{"_42":157,"_31":158,"_29":159,"_140":-5,"_40":41,"_39":160,"_142":24,"_37":235,"_13":60,"_33":20,"_35":162,"_23":24,"_146":-5,"_229":236,"_26":237},{"_42":148,"_31":149,"_29":150,"_140":-5,"_40":41,"_39":151,"_142":24,"_37":232,"_13":153,"_33":154,"_35":155,"_23":24,"_146":-5,"_229":233,"_26":234},{"_42":137,"_31":138,"_29":139,"_140":-5,"_40":41,"_39":141,"_142":24,"_37":228,"_13":144,"_33":20,"_35":145,"_23":24,"_146":-5,"_229":230,"_26":231},["D",1777302675629],"children",[],[138],["D",1777302676038],[],[149],["D",1777299201001],[],[158],["D",1777302937067],[],[165],"d58e8bb6-4260-11f1-900d-42b51c65c3df",["D",1777311909219],[],[172,32],"3ef89970-4243-11f1-a8c8-42b51c65c3df","photos.ts","3ef89a10-4243-11f1-a8c8-42b51c65c3df",8,["D",1777299201181],"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",[],[172,246],"566b4500-424b-11f1-b6f5-42b51c65c3df","foursquare.ts","3f1362aa-4243-11f1-a9ae-42b51c65c3df",101,["D",1777302676037],3,"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}\n\nexport async function getCheckins(\n oauthToken: string,\n apiVersion: string,\n): Promise {\n const params = new URLSearchParams({\n oauth_token: oauthToken,\n v: apiVersion,\n limit: \"50\",\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",[],[172,254],"3f1dea7c-4243-11f1-8a98-42b51c65c3df","db.ts","3f1deb4e-4243-11f1-8a98-42b51c65c3df",13,["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",[],[172,263],"3f18edf6-4243-11f1-a8c8-42b51c65c3df","atproto.ts","3f18eea0-4243-11f1-a8c8-42b51c65c3df",12,["D",1777299201382],"const PDS_URL = Deno.env.get(\"BSKY_PDS_URL\") ?? \"https://bsky.social\";\n\ninterface 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

Diff · v114