[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_470":471,"_472":473},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_41":-7,"_323":-5,"_19":324,"_325":326,"_327":328,"_329":330,"_331":332,"_21":-5,"_333":-5,"_334":-5,"_335":70,"_336":337,"_338":70,"_339":-5,"_340":-5,"_341":342},"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":24,"_30":-5},"handle","barryf","name","fsq2pds","branchName","main","path",".git/objects","project",{"_35":271,"_13":14,"_39":272,"_273":-5,"_274":70,"_275":276,"_277":276,"_278":279,"_280":-5,"_30":71,"_281":-5,"_282":70,"_283":-5,"_284":-5,"_285":26,"_43":44,"_286":287,"_288":289,"_290":291,"_292":-5,"_293":294,"_295":294,"_296":297,"_298":297,"_299":297,"_300":294,"_301":294,"_54":302,"_303":304,"_305":306,"_307":70},"file",{"_64":268,"_13":269,"_67":68,"_69":24,"_270":94},"isDirectory",true,"page",0,"history",[31,32,33,34],"hasNext","userId",{"_35":92,"_37":38,"_39":93,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":96,"_21":97,"_57":-5,"_58":-5,"_59":-5,"_60":98,"_61":99},{"_35":83,"_37":38,"_39":84,"_41":85,"_43":44,"_45":74,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":86,"_21":87,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":88},{"_35":74,"_37":38,"_39":75,"_41":76,"_43":44,"_45":36,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":77,"_21":78,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":79},{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":55,"_21":56,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":62},"id","53a76ee8-424b-11f1-8ed1-42b51c65c3df","branchId","3ddb19fa-4243-11f1-8011-42b51c65c3df","createdAt",["D",1777302671829],"version",53,"orgId","dc713b9c-8776-46e0-8027-faa0b9eae4af","parentId","538af790-424b-11f1-9314-42b51c65c3df","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":65,"_13":66,"_67":68,"_69":70},"pull","merge","revert","multiple","commits",[63],{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":55,"_21":56,"_57":-5,"_58":-5,"_59":-5},"fileId","53a45da2-424b-11f1-8ed1-42b51c65c3df","1c","fileType","directory","deleted",false,"60ee761a-2727-4820-a921-a3de0f67378e","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4Y3gxZ2p3ZkZydXhzM1lVTnAwekdLMXJBWSJ9","53c4506c-424b-11f1-9314-42b51c65c3df",["D",1777302672020],54,{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":81,"_13":82,"_67":68,"_69":70},[80],{"_35":74,"_37":38,"_39":75,"_41":76,"_43":44,"_45":36,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":77,"_21":78,"_57":-5,"_58":-5,"_59":-5},"53c10da8-424b-11f1-9314-42b51c65c3df","8b","53e60d1a-424b-11f1-bdee-42b51c65c3df",["D",1777302672212],55,{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":90,"_13":91,"_67":68,"_69":70},[89],{"_35":83,"_37":38,"_39":84,"_41":85,"_43":44,"_45":74,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":86,"_21":87,"_57":-5,"_58":-5,"_59":-5},"53dee21a-424b-11f1-bdee-42b51c65c3df","13","07a6d938-424c-11f1-b4f6-42b51c65c3df",["D",1777302973699],104,"058d1ee6-424c-11f1-8b47-42b51c65c3df",{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":266,"_13":267,"_67":68,"_69":24},{"_263":264,"_265":264},[100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128],{"_35":92,"_37":38,"_39":93,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":96,"_21":97,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":258,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":259,"_21":260,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":255,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":256,"_21":257,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":250,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":251,"_21":252,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":245,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":246,"_21":247,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":240,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":241,"_21":242,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":235,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":236,"_21":237,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":230,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":231,"_21":232,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":225,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":226,"_21":227,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":220,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":221,"_21":222,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":215,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":216,"_21":217,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":210,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":211,"_21":212,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":205,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":206,"_21":207,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":200,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":201,"_21":202,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":195,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":196,"_21":197,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":192,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":193,"_21":194,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":187,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":188,"_21":189,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":182,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":183,"_21":184,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":179,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":180,"_21":181,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":174,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":175,"_21":176,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":169,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":170,"_21":171,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":164,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":165,"_21":166,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":159,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":160,"_21":161,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":154,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":155,"_21":156,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":149,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":150,"_21":151,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":144,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":145,"_21":146,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":139,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":140,"_21":141,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":134,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":135,"_21":136,"_57":-5,"_58":-5,"_59":-5},{"_35":92,"_37":38,"_39":129,"_41":94,"_43":44,"_45":95,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":130,"_21":131,"_57":-5,"_58":-5,"_59":-5},["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":132,"_13":133,"_67":68,"_69":24},"51c41a90-424b-11f1-8ed1-42b51c65c3df","7b",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":137,"_13":138,"_67":68,"_69":24},"534b6b8e-424b-11f1-8ed1-42b51c65c3df","2d",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":142,"_13":143,"_67":68,"_69":24},"51a19ed4-424b-11f1-8ed1-42b51c65c3df","1a",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":147,"_13":148,"_67":68,"_69":24},"5183195a-424b-11f1-8ed1-42b51c65c3df","pack",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":152,"_13":153,"_67":68,"_69":24},"536bc0fa-424b-11f1-8ed1-42b51c65c3df","41",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":157,"_13":158,"_67":68,"_69":24},"51675cd8-424b-11f1-8ed1-42b51c65c3df","20",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":162,"_13":163,"_67":68,"_69":24},"51440620-424b-11f1-a02e-42b51c65c3df","fe",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":167,"_13":168,"_67":68,"_69":24},"538835a0-424b-11f1-9314-42b51c65c3df","8d",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":172,"_13":173,"_67":68,"_69":24},"51262f6a-424b-11f1-8b03-42b51c65c3df","e4",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":177,"_13":178,"_67":68,"_69":24},"51084996-424b-11f1-bd69-42b51c65c3df","d8",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":65,"_13":66,"_67":68,"_69":24},["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":185,"_13":186,"_67":68,"_69":24},"50d0e8d4-424b-11f1-a02e-42b51c65c3df","d7",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":190,"_13":191,"_67":68,"_69":24},"50a77666-424b-11f1-a02e-42b51c65c3df","58",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":81,"_13":82,"_67":68,"_69":24},["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":198,"_13":199,"_67":68,"_69":24},"508b8910-424b-11f1-8b03-42b51c65c3df","56",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":203,"_13":204,"_67":68,"_69":24},"52985f1c-424b-11f1-a02e-42b51c65c3df","5b",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":208,"_13":209,"_67":68,"_69":24},"5277bfc8-424b-11f1-a02e-42b51c65c3df","98",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":213,"_13":214,"_67":68,"_69":24},"52dc1180-424b-11f1-bcb2-42b51c65c3df","b6",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":218,"_13":219,"_67":68,"_69":24},"52546e6a-424b-11f1-89eb-42b51c65c3df","info",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":223,"_13":224,"_67":68,"_69":24},"5236610e-424b-11f1-89eb-42b51c65c3df","6e",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":228,"_13":229,"_67":68,"_69":24},"5302b290-424b-11f1-8ed1-42b51c65c3df","e6",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":233,"_13":234,"_67":68,"_69":24},"5219c1e8-424b-11f1-a02e-42b51c65c3df","9f",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":238,"_13":239,"_67":68,"_69":24},"51fa5902-424b-11f1-89eb-42b51c65c3df","2a",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":243,"_13":244,"_67":68,"_69":24},"53271ad6-424b-11f1-8ed1-42b51c65c3df","79",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":248,"_13":249,"_67":68,"_69":24},"51deb576-424b-11f1-90e9-42b51c65c3df","81",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":253,"_13":254,"_67":68,"_69":24},"506e422e-424b-11f1-89eb-42b51c65c3df","50",["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":90,"_13":91,"_67":68,"_69":24},["D",1777302973699],{"_35":71,"_43":44,"_11":12,"_72":73},{"_64":261,"_13":262,"_67":68,"_69":24},"504f51d4-424b-11f1-9314-42b51c65c3df","92","count",29,"deletedCount","52b37a90-424b-11f1-89eb-42b51c65c3df","64","4fb8f522-424b-11f1-9314-42b51c65c3df","objects","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,"_322":73},"org",{"_11":12,"_317":318,"_72":73,"_30":71,"_319":320,"_321":70},"branch",{"_41":308,"_13":16,"_35":38,"_309":271,"_310":-5,"_311":-5,"_312":-5,"_313":-5,"_314":-5,"_315":14,"_316":12},"isOwned",134,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Barry Frost","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":271,"_13":14,"_39":465,"_273":-5,"_274":70,"_275":276,"_277":276,"_278":279,"_280":-5,"_30":71,"_281":-5,"_282":70,"_283":-5,"_284":-5,"_285":26,"_43":44,"_286":287,"_288":289,"_290":466,"_292":-5,"_293":294,"_295":294,"_296":297,"_298":297,"_299":297,"_300":294,"_301":294,"_54":467,"_303":468,"_305":469,"_307":70},"tree",[398,404,405,406,407],"files",[398,399,400,401,402,403,404,405,406,407],"counts",{"_388":26,"_389":373,"_390":26,"_391":392,"_393":394},"contents",[343,344,345,346,347],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":382,"_13":383,"_64":384,"_45":-5,"_37":38,"_351":385,"_353":24,"_39":386,"_41":26,"_67":68,"_356":-5,"_69":70,"_358":-5,"_17":387},{"_35":376,"_13":377,"_64":378,"_45":-5,"_37":38,"_351":308,"_353":24,"_39":379,"_41":355,"_67":21,"_356":380,"_69":70,"_358":-5,"_17":381},{"_35":368,"_13":369,"_64":370,"_45":-5,"_37":38,"_351":371,"_353":24,"_39":372,"_41":373,"_67":21,"_356":374,"_69":70,"_358":-5,"_17":375},{"_35":360,"_13":361,"_64":362,"_45":-5,"_37":38,"_351":363,"_353":24,"_39":364,"_41":355,"_67":365,"_356":366,"_69":70,"_358":-5,"_17":367},{"_35":348,"_13":349,"_64":350,"_45":-5,"_37":38,"_351":352,"_353":24,"_39":354,"_41":355,"_67":21,"_356":357,"_69":70,"_358":-5,"_17":359},"8e640d13-7e5c-4784-a59a-b4d01490b237","deno.json","3f00c4f6-4243-11f1-8240-42b51c65c3df","branchVersion",127,"latest",["D",1783859391405],3,"content","{\n \"tasks\": {\n \"bootstrap\": \"deno run --allow-env --allow-net bootstrap/fsq-oauth.ts\",\n \"backfill\": \"deno run --allow-env --allow-net --allow-read --allow-write bootstrap/backfill.ts\",\n \"backfill-shouts\": \"deno run --allow-env --allow-net --allow-read --allow-write bootstrap/backfill-shouts.ts\"\n }\n}\n","label",[349],"d5aad65e-4260-11f1-820a-42b51c65c3df","cron.ts","3f2214da-4243-11f1-8a8a-42b51c65c3df",117,["D",1777311909239],"interval","import {\n ensureSchema,\n getState,\n setState,\n hasCheckin,\n recordCheckin,\n} from \"./lib/db.ts\";\nimport { getCheckins } from \"./lib/foursquare.ts\";\nimport { clearSession, getSession } from \"./lib/atproto.ts\";\nimport { syncCheckin } from \"./lib/sync.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 cursorTs = parseInt(cursorStr, 10);\n let newCursorTs = cursorTs;\n\n console.log(`Fetching recent checkins (cursor: ${new Date(cursorTs * 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 cursor; FSQ returns newest-first\n const newCheckins = checkins.filter((c) => c.createdAt > cursorTs);\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 newCursorTs = Math.max(newCursorTs, checkin.createdAt);\n continue;\n }\n\n try {\n const { uri, cid } = await syncCheckin(session, checkin);\n await recordCheckin(checkin.id, checkin.createdAt, uri, cid);\n console.log(`Synced ${checkin.id} (${checkin.venue.name}) → ${uri}`);\n newCursorTs = Math.max(newCursorTs, checkin.createdAt);\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 if (newCursorTs > cursorTs) {\n await setState(\"cursor_ts\", String(newCursorTs));\n console.log(`Cursor advanced to ${new Date(newCursorTs * 1000).toISOString()}`);\n }\n}\n\n",[361],"faf9011f-2da1-41ea-bcb4-285670489cd9","README.md","3edd43be-4243-11f1-a8c8-42b51c65c3df",128,["D",1783859391400],1,"# 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 \"address\": \"123 High Street, London, UK\",\n \"category\": \"Coffee Shop\",\n \"comment\": \"Best flat white in town\",\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`address`, `category`, `comment`, and `photos` are all optional — omitted when the source checkin has no value for them. The lexicon doc itself is maintained in the `barryfrost-v7` repo, not here.\n\n## Notes\n\n- **Only new checkins** are synced. Nothing before the first run is imported. Use `deno task backfill` to import historical checkins, and `deno task backfill-shouts` to add `comment` to already-synced records whose shout predates that feature.\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. (`backfill-shouts` is a one-time exception that patches `comment` onto existing records.)\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",[369],"3ccd113a-fffe-4d15-aff4-f56b053e2804",".vtignore","f1bc3adc-424b-11f1-8e47-42b51c65c3df",["D",1783859571767],".git\n.gitignore\n.claude\nPLAN.md\nCLAUDE.md\nbootstrap\nlexicons\ndeno.lock\n",[377],"3eb4128c-4243-11f1-bd90-42b51c65c3df","lib","3eb4134a-4243-11f1-bd90-42b51c65c3df",4,["D",1777299200731],[383],"pulls","branches","forks","envVars",{"_263":396,"_397":26},"connections",{"_263":26,"_395":26},"unfilledCount",5,"emptyCount",{"_35":382,"_13":383,"_64":384,"_45":-5,"_37":38,"_351":385,"_353":24,"_39":462,"_41":26,"_67":68,"_356":-5,"_69":70,"_358":-5,"_409":463,"_17":464},{"_35":454,"_13":455,"_64":456,"_45":384,"_37":38,"_351":457,"_353":24,"_39":458,"_41":355,"_67":426,"_356":459,"_69":70,"_358":-5,"_409":460,"_17":461},{"_35":446,"_13":447,"_64":448,"_45":384,"_37":38,"_351":449,"_353":24,"_39":450,"_41":26,"_67":426,"_356":451,"_69":70,"_358":-5,"_409":452,"_17":453},{"_35":438,"_13":439,"_64":440,"_45":384,"_37":38,"_351":441,"_353":24,"_39":442,"_41":396,"_67":426,"_356":443,"_69":70,"_358":-5,"_409":444,"_17":445},{"_35":430,"_13":431,"_64":432,"_45":384,"_37":38,"_351":433,"_353":24,"_39":434,"_41":373,"_67":426,"_356":435,"_69":70,"_358":-5,"_409":436,"_17":437},{"_35":421,"_13":422,"_64":423,"_45":384,"_37":38,"_351":424,"_353":24,"_39":425,"_41":373,"_67":426,"_356":427,"_69":70,"_358":-5,"_409":428,"_17":429},{"_35":376,"_13":377,"_64":378,"_45":-5,"_37":38,"_351":308,"_353":24,"_39":418,"_41":355,"_67":21,"_356":380,"_69":70,"_358":-5,"_409":419,"_17":420},{"_35":368,"_13":369,"_64":370,"_45":-5,"_37":38,"_351":371,"_353":24,"_39":415,"_41":373,"_67":21,"_356":374,"_69":70,"_358":-5,"_409":416,"_17":417},{"_35":360,"_13":361,"_64":362,"_45":-5,"_37":38,"_351":363,"_353":24,"_39":412,"_41":355,"_67":365,"_356":366,"_69":70,"_358":-5,"_409":413,"_17":414},{"_35":348,"_13":349,"_64":350,"_45":-5,"_37":38,"_351":352,"_353":24,"_39":408,"_41":355,"_67":21,"_356":357,"_69":70,"_358":-5,"_409":410,"_17":411},["D",1783859391405],"children",[],[349],["D",1777311909239],[],[361],["D",1783859391400],[],[369],["D",1783859571767],[],[377],"002506c8-9b54-48f6-9693-074798e8ed5e","sync.ts","d58e8c74-4260-11f1-900d-42b51c65c3df",125,["D",1783859391386],"script","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",[],[383,422],"4eb94f3a-2356-4fae-b811-d5fb2f4bfc49","photos.ts","3ef89a10-4243-11f1-a8c8-42b51c65c3df",132,["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",[],[383,431],"8a29f03a-b930-4460-aa96-a63da8e6212f","foursquare.ts","3f1362aa-4243-11f1-a9ae-42b51c65c3df",126,["D",1783859391399],"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",[],[383,439],"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",[],[383,447],"c3478784-333f-43d4-b611-e43122da02ea","atproto.ts","3f18eea0-4243-11f1-a8c8-42b51c65c3df",130,["D",1783859517189],"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 · objects