[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_797":798,"_799":800},"routes/_app.x.$handle.$name",{"_97":96,"_32":44,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":26,"_121":122,"_123":26,"_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,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":26,"_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":26},"version",79,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path",".git/hooks/pre-rebase.sample","latestPath","fileId","55808a56-424b-11f1-bb85-42b51c65c3df","name","pre-rebase.sample","fileType","content","#!/bin/sh\n#\n# Copyright (c) 2006, 2008 Junio C Hamano\n#\n# The \"pre-rebase\" hook is run just before \"git rebase\" starts doing\n# its job, and can prevent the command from running by exiting with\n# non-zero status.\n#\n# The hook is called with the following parameters:\n#\n# $1 -- the upstream the series was forked from.\n# $2 -- the branch being rebased (or empty when rebasing the current branch).\n#\n# This sample shows how to prevent topic branches that are already\n# merged to 'next' branch from getting rebased, because allowing it\n# would result in rebasing already published history.\n\npublish=next\nbasebranch=\"$1\"\nif test \"$#\" = 2\nthen\n\ttopic=\"refs/heads/$2\"\nelse\n\ttopic=`git symbolic-ref HEAD` ||\n\texit 0 ;# we do not interrupt rebasing detached HEAD\nfi\n\ncase \"$topic\" in\nrefs/heads/??/*)\n\t;;\n*)\n\texit 0 ;# we do not interrupt others.\n\t;;\nesac\n\n# Now we are dealing with a topic branch being rebased\n# on top of master. Is it OK to rebase it?\n\n# Does the topic really exist?\ngit show-ref -q \"$topic\" || {\n\techo >&2 \"No such branch $topic\"\n\texit 1\n}\n\n# Is topic fully merged to master?\nnot_in_master=`git rev-list --pretty=oneline ^master \"$topic\"`\nif test -z \"$not_in_master\"\nthen\n\techo >&2 \"$topic is fully merged to master; better remove it.\"\n\texit 1 ;# we could allow it, but there is no point.\nfi\n\n# Is topic ever merged to next? If so you should not be rebasing it.\nonly_next_1=`git rev-list ^master \"^$topic\" ${publish} | sort`\nonly_next_2=`git rev-list ^master ${publish} | sort`\nif test \"$only_next_1\" = \"$only_next_2\"\nthen\n\tnot_in_topic=`git rev-list \"^$topic\" master`\n\tif test -z \"$not_in_topic\"\n\tthen\n\t\techo >&2 \"$topic is already up to date with master\"\n\t\texit 1 ;# we could allow it, but there is no point.\n\telse\n\t\texit 0\n\tfi\nelse\n\tnot_in_next=`git rev-list --pretty=oneline ^${publish} \"$topic\"`\n\t/usr/bin/perl -e '\n\t\tmy $topic = $ARGV[0];\n\t\tmy $msg = \"* $topic has commits already merged to public branch:\\n\";\n\t\tmy (%not_in_next) = map {\n\t\t\t/^([0-9a-f]+) /;\n\t\t\t($1 => 1);\n\t\t} split(/\\n/, $ARGV[1]);\n\t\tfor my $elem (map {\n\t\t\t\t/^([0-9a-f]+) (.*)$/;\n\t\t\t\t[$1 => $2];\n\t\t\t} split(/\\n/, $ARGV[2])) {\n\t\t\tif (!exists $not_in_next{$elem->[0]}) {\n\t\t\t\tif ($msg) {\n\t\t\t\t\tprint STDERR $msg;\n\t\t\t\t\tundef $msg;\n\t\t\t\t}\n\t\t\t\tprint STDERR \" $elem->[1]\\n\";\n\t\t\t}\n\t\t}\n\t' \"$topic\" \"$not_in_next\" \"$not_in_master\"\n\texit 1\nfi\n\n<<\\DOC_END\n\nThis sample hook safeguards topic branches that have been\npublished from being rewound.\n\nThe workflow assumed here is:\n\n * Once a topic branch forks from \"master\", \"master\" is never\n merged into it again (either directly or indirectly).\n\n * Once a topic branch is fully cooked and merged into \"master\",\n it is deleted. If you need to build on top of it to correct\n earlier mistakes, a new topic branch is created by forking at\n the tip of the \"master\". This is not strictly necessary, but\n it makes it easier to keep your history simple.\n\n * Whenever you need to test or publish your changes to topic\n branches, merge them into \"next\" branch.\n\nThe script, being an example, hardcodes the publish branch name\nto be \"next\", but it is trivial to make it configurable via\n$GIT_DIR/config mechanism.\n\nWith this workflow, you would want to know:\n\n(1) ... if a topic branch has ever been merged to \"next\". Young\n topic branches can have stupid mistakes you would rather\n clean up before publishing, and things that have not been\n merged into other branches can be easily rebased without\n affecting other people. But once it is published, you would\n not want to rewind it.\n\n(2) ... if a topic branch has been fully merged to \"master\".\n Then you can delete it. More importantly, you should not\n build on top of it -- other people may already want to\n change things related to the topic as patches against your\n \"master\", so if you need further changes, it is better to\n fork the topic (perhaps with the same name) afresh from the\n tip of \"master\".\n\nLet's look at this example:\n\n\t\t o---o---o---o---o---o---o---o---o---o \"next\"\n\t\t / / / /\n\t\t / a---a---b A / /\n\t\t/ / / /\n\t / / c---c---c---c B /\n\t / / / \\ /\n\t / / / b---b C \\ /\n\t / / / / \\ /\n ---o---o---o---o---o---o---o---o---o---o---o \"master\"\n\n\nA, B and C are topic branches.\n\n * A has one fix since it was merged up to \"next\".\n\n * B has finished. It has been fully merged up to \"master\" and \"next\",\n and is ready to be deleted.\n\n * C has not merged to \"next\" at all.\n\nWe would want to allow C to be rebased, refuse A, and encourage\nB to be deleted.\n\nTo compute (1):\n\n\tgit rev-list ^master ^topic next\n\tgit rev-list ^master next\n\n\tif these match, topic has not merged in next at all.\n\nTo compute (2):\n\n\tgit rev-list master..topic\n\n\tif this is empty, it is fully merged to \"master\".\n\nDOC_END\n","createdAt",["D",1777302674955],"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":26},"branch",{"_13":86,"_32":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,"_32":44,"_37":792,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":26,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":793,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":794,"_81":795,"_83":796,"_85":26},"tree",[227,229,286,289,291,296,297,298,299,300,301],"files",[227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301],"counts",{"_216":60,"_217":154,"_218":60,"_219":220,"_221":222},"contents",[128,129,130,131,132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":210,"_32":211,"_30":212,"_142":-5,"_40":41,"_39":213,"_144":26,"_37":214,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_27":215},{"_42":204,"_32":205,"_30":206,"_142":-5,"_40":41,"_39":207,"_144":26,"_37":208,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_27":209},{"_42":199,"_32":200,"_30":201,"_142":-5,"_40":41,"_39":154,"_144":26,"_37":202,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_27":203},{"_42":193,"_32":194,"_30":195,"_142":-5,"_40":41,"_39":196,"_144":26,"_37":197,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_27":198},{"_42":186,"_32":187,"_30":188,"_142":-5,"_40":41,"_39":189,"_144":24,"_37":190,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_27":192},{"_42":179,"_32":180,"_30":181,"_142":-5,"_40":41,"_39":182,"_144":26,"_37":183,"_13":60,"_34":20,"_35":184,"_23":26,"_147":-5,"_27":185},{"_42":172,"_32":173,"_30":174,"_142":-5,"_40":41,"_39":175,"_144":26,"_37":176,"_13":60,"_34":20,"_35":177,"_23":26,"_147":-5,"_27":178},{"_42":165,"_32":166,"_30":167,"_142":-5,"_40":41,"_39":168,"_144":26,"_37":169,"_13":154,"_34":20,"_35":170,"_23":26,"_147":-5,"_27":171},{"_42":158,"_32":159,"_30":160,"_142":-5,"_40":41,"_39":161,"_144":26,"_37":162,"_13":60,"_34":20,"_35":163,"_23":26,"_147":-5,"_27":164},{"_42":149,"_32":150,"_30":151,"_142":-5,"_40":41,"_39":152,"_144":26,"_37":153,"_13":154,"_34":155,"_35":156,"_23":26,"_147":-5,"_27":157},{"_42":139,"_32":140,"_30":141,"_142":-5,"_40":41,"_39":143,"_144":26,"_37":145,"_13":60,"_34":20,"_35":146,"_23":26,"_147":-5,"_27":148},"3f00c438-4243-11f1-8240-42b51c65c3df","deno.json","3f00c4f6-4243-11f1-8240-42b51c65c3df","parentId",9,"latest",["D",1777299201231],"{\n \"tasks\": {\n \"bootstrap\": \"deno run --allow-env --allow-net bootstrap/fsq-oauth.ts\"\n }\n}\n","label",[140],"a8d935b4-4245-11f1-8caf-42b51c65c3df","cron.ts","3f2214da-4243-11f1-8a8a-42b51c65c3df",20,["D",1777300237805],1,"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 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 };\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\n",[150],"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",[159],"50115efc-4245-11f1-9595-42b51c65c3df","PLAN.md","3f2a3840-4243-11f1-b8b5-42b51c65c3df",18,["D",1777300088806],"# fsq2pds — Foursquare/Swarm checkins → ATProto PDS\n\n## Context\n\nYou want a personal pipeline that mirrors your Swarm checkins into your Bluesky-hosted PDS as ATProto records, so your website at barryfrost.com can read them via the AT Proto API. The pipeline runs entirely on Val.Town's free tier (Deno) on a 15-minute cron — which happens to be the free-tier cron floor, so this is the right cadence regardless. State lives in Val.Town SQLite (per-val 10MB DB) for robust idempotency. Records use the `community.lexicon.location.fsq` struct (embedded, not referenced — that schema is an object meant to live inside other records) wrapped in a bespoke `com.barryfrost.checkin` record.\n\n## Decisions locked in (from clarifying Q&A)\n\n- **Source**: Foursquare/Swarm v2 API via OAuth2 user token (you have a dev account, will mint a token via one-time bootstrap).\n- **Polling, not Push API**: 15-min cron is fine for a website backfill latency; Push API adds a public webhook + signature verification. Skip unless we need sub-15-min freshness later.\n- **Backfill**: none. First run records \"launch timestamp\"; only checkins after that get synced.\n- **State**: Val.Town SQLite, val-scoped (`std/sqlite`). UNIQUE PK on FSQ checkin id is the idempotency primitive.\n- **Record contents**: `createdAt` + embedded `community.lexicon.location.fsq` + photos (uploaded as PDS blobs). No shout text, no categories. (Easy to add later — record schema is yours.)\n- **Edits/deletes in Swarm**: ignored. Records are write-once. If you delete a Swarm checkin you'll manually delete the PDS record.\n- **Lexicon NSID**: `com.barryfrost.checkin`.\n- **PDS**: `bsky.social`, app-password auth.\n\n## Architecture\n\n```\n┌─────────────────────────┐ every 15min ┌────────────────────┐\n│ Val.Town cron val │ ───────────────────▶ │ Foursquare v2 API │\n│ cron.ts │ GET users/self/ │ (oauth_token) │\n│ │ checkins?after=... └────────────────────┘\n│ │\n│ ┌──────────────┐ │ per new checkin\n│ │ SQLite │ ◀──▶ │ 1. fetch photo bytes (if any)\n│ │ seen_checkins│ │ 2. createSession on bsky.social\n│ │ sync_state │ │ 3. uploadBlob × N photos\n│ └──────────────┘ │ 4. createRecord (com.barryfrost.checkin)\n│ │ 5. insert seen_checkins row\n│ │\n│ │ ───────────────────▶ ┌────────────────────┐\n└─────────────────────────┘ │ bsky.social PDS │\n │ XRPC │\n └────────────────────┘\n```\n\n## File layout (Val.Town project, edited locally via `vt`)\n\n```\nfsq2pds/\n├── CLAUDE.md # session context for future Claude runs\n├── README.md # setup steps (token mint, env vars)\n├── deno.json # imports + tasks\n├── cron.ts # main cron entry point\n├── lib/\n│ ├── foursquare.ts # FSQ v2 client (checkins, photo URL build)\n│ ├── atproto.ts # bsky XRPC: createSession, uploadBlob, createRecord\n│ ├── db.ts # SQLite schema + helpers\n│ └── photos.ts # fetch photo bytes from FSQ photo prefix/suffix\n├── lexicons/\n│ └── com.barryfrost.checkin.json # lexicon doc (publishable to PDS later)\n└── bootstrap/\n └── fsq-oauth.ts # one-time local script to mint FSQ token\n```\n\n## Lexicon: `com.barryfrost.checkin`\n\n```json\n{\n \"lexicon\": 1,\n \"id\": \"com.barryfrost.checkin\",\n \"defs\": {\n \"main\": {\n \"type\": \"record\",\n \"key\": \"tid\",\n \"record\": {\n \"type\": \"object\",\n \"required\": [\"createdAt\", \"location\"],\n \"properties\": {\n \"createdAt\": { \"type\": \"string\", \"format\": \"datetime\" },\n \"location\": {\n \"type\": \"ref\",\n \"ref\": \"community.lexicon.location.fsq\"\n },\n \"photos\": {\n \"type\": \"array\",\n \"maxLength\": 8,\n \"items\": {\n \"type\": \"object\",\n \"required\": [\"image\"],\n \"properties\": {\n \"image\": {\n \"type\": \"blob\",\n \"accept\": [\"image/jpeg\", \"image/png\", \"image/webp\"],\n \"maxSize\": 1000000\n },\n \"alt\": { \"type\": \"string\", \"maxLength\": 1000 }\n }\n }\n }\n }\n }\n }\n }\n}\n```\n\nEmbedded location object inside each record looks like:\n```json\n{\n \"$type\": \"community.lexicon.location.fsq\",\n \"fsq_place_id\": \"\",\n \"name\": \"Blue Bottle Coffee\",\n \"latitude\": \"37.776\",\n \"longitude\": \"-122.418\"\n}\n```\n\nRecord `rkey` = TID derived from FSQ `createdAt` (gives chronological ordering for free).\n\n## SQLite schema\n\n```sql\nCREATE TABLE IF NOT EXISTS seen_checkins (\n fsq_id TEXT PRIMARY KEY,\n fsq_created_at INTEGER NOT NULL, -- unix seconds\n pds_at_uri TEXT NOT NULL,\n pds_cid TEXT NOT NULL,\n processed_at INTEGER NOT NULL DEFAULT (unixepoch())\n);\nCREATE INDEX IF NOT EXISTS idx_seen_created ON seen_checkins(fsq_created_at);\n\nCREATE TABLE IF NOT EXISTS sync_state (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n);\n-- 'cursor_ts' → unix sec; advance only after successful run\n-- 'launched_at' → unix sec; written once on first ever run, used as initial cursor\n```\n\nThe PRIMARY KEY on `fsq_id` is the durability anchor: even if FSQ returns a checkin twice, or a run dies after PDS write but before cursor advance, the `INSERT OR IGNORE` keeps things consistent.\n\n## Cron flow (cron.ts, runs every 15 min)\n\n1. Open SQLite, ensure schema.\n2. `cursor_ts = sync_state['cursor_ts']`. If null → set `launched_at = now()`, `cursor_ts = now()`, exit (next run does the work).\n3. Call FSQ: `GET /v2/users/self/checkins?oauth_token=…&v=20240101&afterTimestamp=&sort=oldestfirst&limit=50`.\n4. For each checkin (in order):\n - Skip if `fsq_id` already in `seen_checkins`.\n - Build `community.lexicon.location.fsq` from `venue` (id, name, lat/lng).\n - For each `photos.items[]`: fetch `${prefix}1024x1024${suffix}` (caps each photo at safe size; FSQ's \"original\" can exceed 1MB lex limit), keep bytes only if ≤ 1,000,000 bytes.\n - Lazily createSession (once per cron run); cache `accessJwt` in a module-scoped variable.\n - For each photo: `com.atproto.repo.uploadBlob` → blob ref.\n - `com.atproto.repo.createRecord` with `repo=`, `collection=com.barryfrost.checkin`, `rkey=`, `record={createdAt, location, photos}`.\n - On success: `INSERT OR IGNORE` into `seen_checkins`, advance in-memory `cursor_ts` to `max(cursor_ts, fsq_created_at)`.\n - On failure: log, do NOT advance cursor past this id, continue to next (or break — see \"Failure semantics\" below).\n5. Persist final `cursor_ts` to `sync_state`.\n\n### Failure semantics\n\n- Per-checkin try/catch. A failure on one checkin stops the run (so we don't skip past it) but the cursor stays at the last *successfully* processed checkin's timestamp. Next run picks up at the same point; idempotency on `fsq_id` ensures any partially-processed checkin (e.g. blobs uploaded but record not created) just retries cleanly — orphan blobs on the PDS are GC'd by Bluesky after a TTL.\n- Network/auth errors at the top of the run abort early, no state change.\n\n## Secrets (Val.Town env vars)\n\n| Name | Purpose |\n|---|---|\n| `FSQ_OAUTH_TOKEN` | Long-lived FSQ user token (minted via bootstrap, doesn't expire) |\n| `FSQ_API_VERSION` | e.g. `20240101` — the FSQ `v=` param |\n| `BSKY_HANDLE` | e.g. `barryfrost.com` or `barryfrost.bsky.social` |\n| `BSKY_APP_PASSWORD` | App password from bsky.app/settings/app-passwords |\n| `BSKY_PDS_URL` | `https://bsky.social` (default) |\n\n## Bootstrap (one-time, run locally)\n\n`bootstrap/fsq-oauth.ts` — small Deno script:\n1. Print FSQ authorize URL using `FSQ_CLIENT_ID` from env + redirect_uri `http://localhost:8765/callback`.\n2. Spin up a one-shot HTTP server on `:8765`, capture `?code=`.\n3. POST to `https://foursquare.com/oauth2/access_token` to exchange for `access_token`.\n4. Print the token to stdout — paste into Val.Town env var.\n\nThis stays local (not deployed) because it needs an interactive browser handoff and is one-time.\n\n## Maintenance & durability notes\n\n- **Token longevity**: FSQ OAuth user tokens don't expire (historically). Bluesky `accessJwt` expires in ~2h, but we createSession each cron run — one extra request, no refresh logic, no edge cases. Trade tiny request volume for zero state.\n- **Rate limits**: FSQ ≈ 500 req/h/user — we use 1 req per 15 min plus a few per checkin → trivial. Bluesky free is generous; one session + N writes per run is fine.\n- **Storage**: 10MB SQLite holds ~100k checkin rows easily. Photos go to PDS blob storage, not Val.Town.\n- **Photo size**: We pull the `1024x1024` FSQ variant (rather than `original`) to stay under the 1MB lex `maxSize`. If a photo still exceeds 1MB after fetch, skip it (record still gets created without that photo) and log.\n- **Cron drift / catch-up**: If Val.Town cron is paused for hours, the `afterTimestamp` cursor + 50-checkin page size means we replay the gap on resume. For longer outages, the run loops through pages until current.\n- **Observability**: Log per checkin (fsq_id → at-uri); inspect via Val.Town logs UI. SQLite `seen_checkins` is the audit trail.\n- **Single-user assumption**: All code assumes one operator. No multi-tenancy in schema or auth.\n\n## Critical files / external references\n\n- Val.Town SQLite: `import { sqlite } from \"https://esm.town/v/std/sqlite\"`.\n- Val.Town blob (not used here, but available): `https://esm.town/v/std/blob`.\n- FSQ v2 endpoint: `https://api.foursquare.com/v2/users/self/checkins`.\n- Bluesky XRPC: `https://bsky.social/xrpc/com.atproto.server.createSession`, `…/com.atproto.repo.uploadBlob`, `…/com.atproto.repo.createRecord`.\n- Lexicon to embed: `community.lexicon.location.fsq` (struct, NOT a record — embedded via `$type` field).\n\n## Verification\n\nEnd-to-end test plan once deployed:\n1. **Bootstrap**: run `bootstrap/fsq-oauth.ts` locally, paste token into Val.Town env.\n2. **First-run gating**: deploy cron, trigger manually once. Confirm `sync_state` rows for `launched_at` and `cursor_ts` exist; no records written yet.\n3. **Real checkin**: do a real Swarm checkin (with a photo). Wait ≤15 min for next cron tick (or trigger manually).\n4. **PDS verification**: open `https://pdsls.dev/at:///com.barryfrost.checkin` (or `https://atproto-browser.vercel.app/at//com.barryfrost.checkin`) — confirm record exists with embedded location and photo blob.\n5. **Idempotency**: trigger cron again immediately. Confirm no duplicate record (check PDS list, check SQLite has only one row for that fsq_id).\n6. **DB inspection**: Val.Town admin → SQLite → `SELECT * FROM seen_checkins ORDER BY fsq_created_at DESC LIMIT 5`.\n7. **Failure replay** (optional): manually delete the just-written PDS record, then `DELETE FROM seen_checkins WHERE fsq_id = '…'`, trigger cron — confirm it re-creates cleanly.\n\n## Teething issues (encountered during setup)\n\n- **FSQ token exchange uses GET, not POST**: Foursquare's `/oauth2/access_token` endpoint expects a GET request with query params, not a POST with a JSON body. `bootstrap/fsq-oauth.ts` was fixed accordingly. The `\"unsupported_grant_type\"` error is the symptom if you accidentally revert this.\n- **`vt push` requires prior `vt create`**: The `vt` CLI needs a `.vt` directory (created by `vt create`) before `vt push` works. On a fresh local clone, run `vt create` first to initialise the project, then `vt push`.\n- **`BSKY_PDS_URL` env var warning**: Val.Town warns about any `Deno.env.get(...)` reference that isn't set in env vars, even when the code has a fallback default. Suppress by adding `BSKY_PDS_URL` = `https://bsky.social` to Val.Town env vars. Functionally harmless either way.\n\n## Out of scope (v1)\n\n- Edits / deletes from Swarm (you'll manage manually).\n- Shout text, venue categories (easy to add to lexicon later — additive change, won't break existing records).\n- Push API webhook (revisit if 15-min latency feels too slow).\n- Publishing the lexicon doc itself to your PDS as `com.atproto.lexicon.schema` (nice-to-have, doesn't affect record validity).\n- Backfill of historical checkins.\n",[166],"3f327bb8-4243-11f1-8240-42b51c65c3df","CLAUDE.md","3f327c94-4243-11f1-8240-42b51c65c3df",16,["D",1777299201543],"# fsq2pds\n\nSyncs Foursquare/Swarm checkins to an ATProto PDS (bsky.social) as `com.barryfrost.checkin` records. Runs as a Val.Town cron val (Deno) every 15 minutes — the free-tier cron minimum.\n\n## File layout\n\n| File | Purpose |\n|------|---------|\n| `cron.ts` | Entry point; exported default function is the cron handler |\n| `lib/db.ts` | Val.Town SQLite helpers (schema, state, dedup) |\n| `lib/foursquare.ts` | Foursquare v2 API client |\n| `lib/atproto.ts` | Bluesky XRPC client (createSession, uploadBlob, createRecord) |\n| `lib/photos.ts` | Downloads FSQ photos, enforces 1MB size cap |\n| `lexicons/com.barryfrost.checkin.json` | Lexicon doc for the checkin record type |\n| `bootstrap/fsq-oauth.ts` | One-time local script to mint an FSQ OAuth token |\n\n## Required env vars (Val.Town secrets)\n\n| Var | Purpose |\n|-----|---------|\n| `FSQ_OAUTH_TOKEN` | Long-lived Foursquare user token (doesn't expire) |\n| `FSQ_API_VERSION` | FSQ API date-version param (e.g. `20240101`) |\n| `BSKY_HANDLE` | Bluesky handle (e.g. `barryfrost.com`) |\n| `BSKY_APP_PASSWORD` | Bluesky app password from bsky.app/settings/app-passwords |\n| `BSKY_PDS_URL` | PDS base URL (optional; defaults to `https://bsky.social`) |\n\n## Key design decisions\n\n- **Idempotency**: `seen_checkins` table with PRIMARY KEY on `fsq_id`. `INSERT OR IGNORE` means re-running is always safe.\n- **Cursor**: `sync_state` table holds `cursor_ts` (unix seconds). Advanced only after successful write.\n- **First run**: Sets cursor to NOW and exits immediately. Sync begins next run (prevents accidental historical import).\n- **rkey**: Uses FSQ checkin ID directly (hex string, valid AT Proto rkey chars, guaranteed unique).\n- **Photos**: Downloaded at FSQ's `1024x1024` size variant. Skipped silently if fetch fails or bytes > 1MB. Checkin record still created.\n- **Session**: `createSession` called at the start of each cron run. No refresh token logic.\n- **Edits/deletes**: Not synced. Records are write-once. Manually delete PDS records if needed.\n- **Backfill**: None. Only checkins after first-run timestamp are synced.\n\n## Lexicon\n\nRecord collection: `com.barryfrost.checkin` \nLocation embedded via `community.lexicon.location.fsq` (struct, not a separate record). \nRecord shape: `{ createdAt, location, photos? }`\n\n## Observability\n\n- Val.Town logs show per-checkin outcome: `Synced () → at://...`\n- SQLite `seen_checkins` is the audit trail; inspect via Val.Town admin panel.\n- `sync_state` holds `cursor_ts` and `launched_at`.\n",[173],"55017cde-424b-11f1-b792-42b51c65c3df",".gitignore","55017d92-424b-11f1-b792-42b51c65c3df",65,["D",1777302674034],".vt/\n.env\n.claude/\n",[180],"3eb4128c-4243-11f1-bd90-42b51c65c3df","lib","3eb4134a-4243-11f1-bd90-42b51c65c3df",4,["D",1777299200731],"directory",[187],"3e943124-4243-11f1-b1e3-42b51c65c3df","lexicons","3e9431e2-4243-11f1-b1e3-42b51c65c3df",3,["D",1777299200522],[194],"3e4b85e6-4243-11f1-8011-42b51c65c3df","bootstrap","3e4b86c2-4243-11f1-8011-42b51c65c3df",["D",1777299200039],[200],"4f951d8c-424b-11f1-8ed1-42b51c65c3df",".git","4f951e5e-424b-11f1-8ed1-42b51c65c3df",21,["D",1777302664629],[205],"3e707a68-4243-11f1-b8b5-42b51c65c3df",".claude","3e707b44-4243-11f1-b8b5-42b51c65c3df",2,["D",1777299200287],[211],"pulls","branches","forks","envVars",{"_223":225,"_226":60},"connections",{"_223":60,"_224":60},"count","unfilledCount",5,"emptyCount",{"_42":210,"_32":211,"_30":212,"_142":-5,"_40":41,"_39":213,"_144":26,"_37":789,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":790,"_27":791},{"_42":781,"_32":782,"_30":783,"_142":212,"_40":41,"_39":784,"_144":26,"_37":785,"_13":60,"_34":20,"_35":786,"_23":26,"_147":-5,"_303":787,"_27":788},{"_42":204,"_32":205,"_30":206,"_142":-5,"_40":41,"_39":207,"_144":26,"_37":778,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":779,"_27":780},{"_42":773,"_32":764,"_30":760,"_142":206,"_40":41,"_39":774,"_144":26,"_37":775,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":776,"_27":777},{"_42":765,"_32":766,"_30":767,"_142":760,"_40":41,"_39":768,"_144":26,"_37":769,"_13":60,"_34":20,"_35":770,"_23":26,"_147":-5,"_303":771,"_27":772},{"_42":759,"_32":33,"_30":31,"_142":760,"_40":41,"_39":14,"_144":26,"_37":761,"_13":60,"_34":20,"_35":36,"_23":26,"_147":-5,"_303":762,"_27":763},{"_42":754,"_32":454,"_30":748,"_142":206,"_40":41,"_39":755,"_144":26,"_37":756,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":757,"_27":758},{"_42":745,"_32":746,"_30":747,"_142":748,"_40":41,"_39":749,"_144":26,"_37":750,"_13":60,"_34":20,"_35":751,"_23":26,"_147":-5,"_303":752,"_27":753},{"_42":740,"_32":702,"_30":696,"_142":206,"_40":41,"_39":741,"_144":26,"_37":742,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":743,"_27":744},{"_42":735,"_32":417,"_30":718,"_142":696,"_40":41,"_39":736,"_144":26,"_37":737,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":738,"_27":739},{"_42":730,"_32":433,"_30":725,"_142":718,"_40":41,"_39":731,"_144":26,"_37":732,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":733,"_27":734},{"_42":723,"_32":87,"_30":724,"_142":725,"_40":41,"_39":726,"_144":26,"_37":727,"_13":60,"_34":20,"_35":699,"_23":26,"_147":-5,"_303":728,"_27":729},{"_42":717,"_32":426,"_30":712,"_142":718,"_40":41,"_39":719,"_144":26,"_37":720,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":721,"_27":722},{"_42":711,"_32":419,"_30":705,"_142":712,"_40":41,"_39":713,"_144":26,"_37":714,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":715,"_27":716},{"_42":703,"_32":87,"_30":704,"_142":705,"_40":41,"_39":706,"_144":26,"_37":707,"_13":60,"_34":20,"_35":708,"_23":26,"_147":-5,"_303":709,"_27":710},{"_42":694,"_32":402,"_30":695,"_142":696,"_40":41,"_39":697,"_144":26,"_37":698,"_13":60,"_34":20,"_35":699,"_23":26,"_147":-5,"_303":700,"_27":701},{"_42":689,"_32":452,"_30":447,"_142":206,"_40":41,"_39":690,"_144":26,"_37":691,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":692,"_27":693},{"_42":684,"_32":683,"_30":677,"_142":447,"_40":41,"_39":685,"_144":26,"_37":686,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":687,"_27":688},{"_42":674,"_32":675,"_30":676,"_142":677,"_40":41,"_39":678,"_144":26,"_37":679,"_13":60,"_34":20,"_35":680,"_23":26,"_147":-5,"_303":681,"_27":682},{"_42":667,"_32":668,"_30":669,"_142":447,"_40":41,"_39":670,"_144":26,"_37":671,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":672,"_27":673},{"_42":660,"_32":661,"_30":662,"_142":447,"_40":41,"_39":663,"_144":26,"_37":664,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":665,"_27":666},{"_42":653,"_32":654,"_30":655,"_142":447,"_40":41,"_39":656,"_144":26,"_37":657,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":658,"_27":659},{"_42":646,"_32":647,"_30":648,"_142":447,"_40":41,"_39":649,"_144":26,"_37":650,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":651,"_27":652},{"_42":639,"_32":640,"_30":641,"_142":447,"_40":41,"_39":642,"_144":26,"_37":643,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":644,"_27":645},{"_42":634,"_32":633,"_30":627,"_142":447,"_40":41,"_39":635,"_144":26,"_37":636,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":637,"_27":638},{"_42":624,"_32":625,"_30":626,"_142":627,"_40":41,"_39":628,"_144":26,"_37":629,"_13":60,"_34":20,"_35":630,"_23":26,"_147":-5,"_303":631,"_27":632},{"_42":617,"_32":618,"_30":619,"_142":447,"_40":41,"_39":620,"_144":26,"_37":621,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":622,"_27":623},{"_42":610,"_32":611,"_30":612,"_142":447,"_40":41,"_39":613,"_144":26,"_37":614,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":615,"_27":616},{"_42":603,"_32":604,"_30":605,"_142":447,"_40":41,"_39":606,"_144":26,"_37":607,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":608,"_27":609},{"_42":596,"_32":597,"_30":598,"_142":447,"_40":41,"_39":599,"_144":26,"_37":600,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":601,"_27":602},{"_42":589,"_32":590,"_30":591,"_142":447,"_40":41,"_39":592,"_144":26,"_37":593,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":594,"_27":595},{"_42":582,"_32":583,"_30":584,"_142":447,"_40":41,"_39":585,"_144":26,"_37":586,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":587,"_27":588},{"_42":575,"_32":576,"_30":577,"_142":447,"_40":41,"_39":578,"_144":26,"_37":579,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":580,"_27":581},{"_42":568,"_32":569,"_30":570,"_142":447,"_40":41,"_39":571,"_144":26,"_37":572,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":573,"_27":574},{"_42":561,"_32":562,"_30":563,"_142":447,"_40":41,"_39":564,"_144":26,"_37":565,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":566,"_27":567},{"_42":554,"_32":555,"_30":556,"_142":447,"_40":41,"_39":557,"_144":26,"_37":558,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":559,"_27":560},{"_42":549,"_32":548,"_30":542,"_142":447,"_40":41,"_39":550,"_144":26,"_37":551,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":552,"_27":553},{"_42":539,"_32":540,"_30":541,"_142":542,"_40":41,"_39":543,"_144":26,"_37":544,"_13":60,"_34":20,"_35":545,"_23":26,"_147":-5,"_303":546,"_27":547},{"_42":532,"_32":533,"_30":534,"_142":447,"_40":41,"_39":535,"_144":26,"_37":536,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":537,"_27":538},{"_42":525,"_32":526,"_30":527,"_142":447,"_40":41,"_39":528,"_144":26,"_37":529,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":530,"_27":531},{"_42":518,"_32":519,"_30":520,"_142":447,"_40":41,"_39":521,"_144":26,"_37":522,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":523,"_27":524},{"_42":513,"_32":512,"_30":506,"_142":447,"_40":41,"_39":514,"_144":26,"_37":515,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":516,"_27":517},{"_42":503,"_32":504,"_30":505,"_142":506,"_40":41,"_39":507,"_144":26,"_37":508,"_13":60,"_34":20,"_35":509,"_23":26,"_147":-5,"_303":510,"_27":511},{"_42":496,"_32":497,"_30":498,"_142":447,"_40":41,"_39":499,"_144":26,"_37":500,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":501,"_27":502},{"_42":491,"_32":490,"_30":484,"_142":447,"_40":41,"_39":492,"_144":26,"_37":493,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":494,"_27":495},{"_42":481,"_32":482,"_30":483,"_142":484,"_40":41,"_39":485,"_144":26,"_37":486,"_13":60,"_34":20,"_35":487,"_23":26,"_147":-5,"_303":488,"_27":489},{"_42":474,"_32":475,"_30":476,"_142":447,"_40":41,"_39":477,"_144":26,"_37":478,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":479,"_27":480},{"_42":467,"_32":468,"_30":469,"_142":447,"_40":41,"_39":470,"_144":26,"_37":471,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":472,"_27":473},{"_42":460,"_32":461,"_30":462,"_142":447,"_40":41,"_39":463,"_144":26,"_37":464,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":465,"_27":466},{"_42":453,"_32":454,"_30":455,"_142":447,"_40":41,"_39":456,"_144":26,"_37":457,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":458,"_27":459},{"_42":444,"_32":445,"_30":446,"_142":447,"_40":41,"_39":448,"_144":26,"_37":449,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":450,"_27":451},{"_42":439,"_32":417,"_30":412,"_142":206,"_40":41,"_39":440,"_144":26,"_37":441,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":442,"_27":443},{"_42":432,"_32":433,"_30":434,"_142":412,"_40":41,"_39":435,"_144":26,"_37":436,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":437,"_27":438},{"_42":427,"_32":426,"_30":421,"_142":412,"_40":41,"_39":428,"_144":26,"_37":429,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":430,"_27":431},{"_42":418,"_32":419,"_30":420,"_142":421,"_40":41,"_39":422,"_144":26,"_37":423,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":424,"_27":425},{"_42":409,"_32":410,"_30":411,"_142":412,"_40":41,"_39":413,"_144":26,"_37":414,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":415,"_27":416},{"_42":401,"_32":402,"_30":403,"_142":206,"_40":41,"_39":404,"_144":26,"_37":405,"_13":60,"_34":20,"_35":406,"_23":26,"_147":-5,"_303":407,"_27":408},{"_42":393,"_32":394,"_30":395,"_142":206,"_40":41,"_39":396,"_144":26,"_37":397,"_13":60,"_34":20,"_35":398,"_23":26,"_147":-5,"_303":399,"_27":400},{"_42":386,"_32":51,"_30":387,"_142":206,"_40":41,"_39":388,"_144":26,"_37":389,"_13":60,"_34":20,"_35":390,"_23":26,"_147":-5,"_303":391,"_27":392},{"_42":199,"_32":200,"_30":201,"_142":-5,"_40":41,"_39":154,"_144":26,"_37":383,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":384,"_27":385},{"_42":376,"_32":377,"_30":378,"_142":201,"_40":41,"_39":225,"_144":26,"_37":379,"_13":60,"_34":326,"_35":380,"_23":26,"_147":-5,"_303":381,"_27":382},{"_42":368,"_32":369,"_30":370,"_142":201,"_40":41,"_39":371,"_144":26,"_37":372,"_13":60,"_34":326,"_35":373,"_23":26,"_147":-5,"_303":374,"_27":375},{"_42":193,"_32":194,"_30":195,"_142":-5,"_40":41,"_39":196,"_144":26,"_37":365,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":366,"_27":367},{"_42":357,"_32":358,"_30":359,"_142":195,"_40":41,"_39":360,"_144":26,"_37":361,"_13":60,"_34":20,"_35":362,"_23":26,"_147":-5,"_303":363,"_27":364},{"_42":186,"_32":187,"_30":188,"_142":-5,"_40":41,"_39":189,"_144":24,"_37":354,"_13":60,"_34":191,"_35":-5,"_23":26,"_147":-5,"_303":355,"_27":356},{"_42":346,"_32":347,"_30":348,"_142":188,"_40":41,"_39":349,"_144":26,"_37":350,"_13":60,"_34":326,"_35":351,"_23":26,"_147":-5,"_303":352,"_27":353},{"_42":338,"_32":339,"_30":340,"_142":188,"_40":41,"_39":341,"_144":24,"_37":342,"_13":60,"_34":326,"_35":343,"_23":26,"_147":-5,"_303":344,"_27":345},{"_42":330,"_32":331,"_30":332,"_142":188,"_40":41,"_39":333,"_144":26,"_37":334,"_13":213,"_34":326,"_35":335,"_23":26,"_147":-5,"_303":336,"_27":337},{"_42":321,"_32":322,"_30":323,"_142":188,"_40":41,"_39":324,"_144":26,"_37":325,"_13":60,"_34":326,"_35":327,"_23":26,"_147":-5,"_303":328,"_27":329},{"_42":179,"_32":180,"_30":181,"_142":-5,"_40":41,"_39":182,"_144":26,"_37":318,"_13":60,"_34":20,"_35":184,"_23":26,"_147":-5,"_303":319,"_27":320},{"_42":172,"_32":173,"_30":174,"_142":-5,"_40":41,"_39":175,"_144":26,"_37":315,"_13":60,"_34":20,"_35":177,"_23":26,"_147":-5,"_303":316,"_27":317},{"_42":165,"_32":166,"_30":167,"_142":-5,"_40":41,"_39":168,"_144":26,"_37":312,"_13":154,"_34":20,"_35":170,"_23":26,"_147":-5,"_303":313,"_27":314},{"_42":158,"_32":159,"_30":160,"_142":-5,"_40":41,"_39":161,"_144":26,"_37":309,"_13":60,"_34":20,"_35":163,"_23":26,"_147":-5,"_303":310,"_27":311},{"_42":149,"_32":150,"_30":151,"_142":-5,"_40":41,"_39":152,"_144":26,"_37":306,"_13":154,"_34":155,"_35":156,"_23":26,"_147":-5,"_303":307,"_27":308},{"_42":139,"_32":140,"_30":141,"_142":-5,"_40":41,"_39":143,"_144":26,"_37":302,"_13":60,"_34":20,"_35":146,"_23":26,"_147":-5,"_303":304,"_27":305},["D",1777299201231],"children",[],[140],["D",1777300237805],[],[150],["D",1777299201001],[],[159],["D",1777300088806],[],[166],["D",1777299201543],[],[173],["D",1777302674034],[],[180],"3ef89970-4243-11f1-a8c8-42b51c65c3df","photos.ts","3ef89a10-4243-11f1-a8c8-42b51c65c3df",8,["D",1777299201181],"script","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",[],[187,322],"a8c75600-4245-11f1-8caf-42b51c65c3df","foursquare.ts","3f1362aa-4243-11f1-a9ae-42b51c65c3df",19,["D",1777300237687],"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 };\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",[],[187,331],"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",[],[187,339],"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

Success! You can close this tab and return to the terminal.

Diff · v79