\n \n\n \n \n

\n\n \n\n {error && (\n \n Error: {error}\n \n )}\n \n );\n}\n",[],[607,614,621],{"_103":630,"_95":631,"_154":632,"_156":615,"_157":139,"_158":633,"_160":161,"_105":634,"_100":159,"_163":226,"_165":635,"_166":22,"_167":-5,"_168":636,"_98":637},"20f94272-77ae-11f0-aade-0224a6c84d84","CheckinCard.tsx","2be117fc-7545-11f0-9d24-0224a6c84d84",673,["D",1755025020961],"/** @jsxImportSource https://esm.sh/react */\nimport { CheckinData } from \"../types/index.ts\";\n\ninterface CheckinCardProps {\n checkin: CheckinData;\n}\n\nexport function CheckinCard({ checkin }: CheckinCardProps) {\n const handleClick = () => {\n globalThis.location.href = `/checkin/${checkin.id}`;\n };\n\n return (\n {\n e.currentTarget.style.transform = \"translateY(-1px)\";\n e.currentTarget.style.boxShadow = \"0 4px 12px rgba(0,0,0,0.15)\";\n // Change arrow color on hover\n const arrow = e.currentTarget.querySelector(\n \"[data-arrow]\",\n ) as HTMLElement;\n if (arrow) arrow.style.color = \"#007aff\";\n }}\n onMouseLeave={(e) => {\n e.currentTarget.style.transform = \"translateY(0)\";\n e.currentTarget.style.boxShadow = \"0 1px 3px rgba(0,0,0,0.1)\";\n // Reset arrow color\n const arrow = e.currentTarget.querySelector(\n \"[data-arrow]\",\n ) as HTMLElement;\n if (arrow) arrow.style.color = \"#c7c7cc\";\n }}\n >\n \n {checkin.author.avatar\n ? (\n \n )\n : (\n \n {(checkin.author.displayName || checkin.author.handle)?.[0]\n ?.toUpperCase() || \"?\"}\n \n )}\n\n

\n \n {checkin.author.displayName || checkin.author.handle}\n

\n \n @{checkin.author.handle}\n \n \n\n \n \n {(() => {\n const date = new Date(checkin.createdAt);\n const now = new Date();\n const diffMs = now.getTime() - date.getTime();\n const diffSecs = Math.floor(diffMs / 1000);\n const diffMins = Math.floor(diffSecs / 60);\n const diffHours = Math.floor(diffMins / 60);\n const diffDays = Math.floor(diffHours / 24);\n\n if (diffSecs < 60) return \"now\";\n if (diffMins < 60) return diffMins + \"m\";\n if (diffHours < 24) return diffHours + \"h\";\n if (diffDays < 7) return diffDays + \"d\";\n return date.toLocaleDateString();\n })()}\n \n \n →\n \n \n \n\n

\n {checkin.text && (\n \n {checkin.text}\n

\n )}\n\n {(checkin.address || checkin.coordinates) && (\n \n 📍\n \n {checkin.address\n ? [\n checkin.address.name,\n checkin.address.locality,\n ].filter(Boolean).join(\", \")\n : checkin.coordinates\n ? `${checkin.coordinates.latitude.toFixed(4)}, ${\n checkin.coordinates.longitude.toFixed(4)\n }`\n : \"\"}\n \n \n )}\n \n \n );\n}\n",[],[607,614,631],{"_103":639,"_95":640,"_154":641,"_156":615,"_157":139,"_158":642,"_160":161,"_105":643,"_100":419,"_163":226,"_165":644,"_166":22,"_167":-5,"_168":645,"_98":646},"b04ab924-77b3-11f0-9285-0224a6c84d84","CheckinDetail.tsx","49f1b3d6-77ad-11f0-8af8-0224a6c84d84",681,["D",1755027408891],"/** @jsxImportSource https://esm.sh/react */\nimport { useEffect, useRef, useState } from \"https://esm.sh/react\";\nimport { CheckinData } from \"../types/index.ts\";\n\ninterface CheckinDetailProps {\n checkinId: string;\n}\n\ninterface MapWidgetProps {\n latitude: number;\n longitude: number;\n venueName?: string;\n}\n\nfunction MapWidget({ latitude, longitude, venueName }: MapWidgetProps) {\n const mapRef = useRef(null);\n const mapInstanceRef = useRef(null);\n\n useEffect(() => {\n // Dynamically load Leaflet\n const loadLeaflet = async () => {\n if (mapInstanceRef.current || !mapRef.current) return;\n\n try {\n // Load Leaflet CSS\n const link = document.createElement(\"link\");\n link.rel = \"stylesheet\";\n link.href = \"https://unpkg.com/leaflet@1.9.4/dist/leaflet.css\";\n document.head.appendChild(link);\n\n // Load Leaflet JS\n const L = await import(\"https://esm.sh/leaflet@1.9.4\");\n\n // Create map\n const map = L.default.map(mapRef.current).setView(\n [latitude, longitude],\n 16,\n );\n\n // Add CartoDB Voyager tiles - clean and modern style\n L.default.tileLayer(\n \"https://{s}.basemaps.cartocdn.com/rastertiles/voyager/{z}/{x}/{y}{r}.png\",\n {\n attribution:\n '© OpenStreetMap contributors © CARTO',\n maxZoom: 20,\n subdomains: \"abcd\",\n },\n ).addTo(map);\n\n // Add marker\n const marker = L.default.marker([latitude, longitude]).addTo(map);\n\n if (venueName) {\n marker.bindPopup(venueName).openPopup();\n }\n\n mapInstanceRef.current = map;\n\n // Clean up on unmount\n return () => {\n if (mapInstanceRef.current) {\n mapInstanceRef.current.remove();\n mapInstanceRef.current = null;\n }\n };\n } catch (error) {\n console.error(\"Failed to load map:\", error);\n }\n };\n\n loadLeaflet();\n }, [latitude, longitude, venueName]);\n\n return (\n \n );\n}\n\nexport function CheckinDetail({ checkinId }: CheckinDetailProps) {\n const [checkin, setCheckin] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n // Inject proper CSS styles on mount\n useEffect(() => {\n const style = document.createElement(\"style\");\n style.textContent = `\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n \n body {\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', system-ui, sans-serif;\n line-height: 1.5;\n color: #1c1c1e;\n background: #f2f2f7;\n min-height: 100vh;\n }\n `;\n document.head.appendChild(style);\n return () => {\n if (style.parentNode) {\n document.head.removeChild(style);\n }\n };\n }, []);\n\n useEffect(() => {\n async function fetchCheckin() {\n try {\n setLoading(true);\n setError(null);\n\n const response = await fetch(`/api/checkin/${checkinId}`);\n\n if (!response.ok) {\n if (response.status === 404) {\n setError(\"Checkin not found\");\n } else {\n setError(\"Failed to load checkin\");\n }\n return;\n }\n\n const data = await response.json();\n setCheckin(data);\n } catch (err) {\n setError(\"Failed to load checkin\");\n console.error(\"Failed to fetch checkin:\", err);\n } finally {\n setLoading(false);\n }\n }\n\n fetchCheckin();\n }, [checkinId]);\n\n if (loading) {\n return (\n \n Loading checkin...\n \n );\n }\n\n if (error || !checkin) {\n return (\n \n {error || \"Checkin not found\"}\n \n );\n }\n\n const shareUrl = `${globalThis.location.origin}/checkin/${checkinId}`;\n\n return (\n \n {/* Back button */}\n {\n // If there's history, go back, otherwise go to feed\n if (globalThis.history.length > 1) {\n globalThis.history.back();\n } else {\n globalThis.location.href = \"/\";\n }\n }}\n style={{\n background: \"#f8f9fa\",\n border: \"1px solid #d1d1d6\",\n padding: \"8px 16px\",\n borderRadius: \"8px\",\n fontSize: \"14px\",\n color: \"#1c1c1e\",\n cursor: \"pointer\",\n marginBottom: \"20px\",\n fontWeight: \"500\",\n transition: \"all 0.1s ease-in-out\",\n }}\n onMouseEnter={(e) => {\n e.currentTarget.style.background = \"#e9ecef\";\n e.currentTarget.style.borderColor = \"#007aff\";\n e.currentTarget.style.color = \"#007aff\";\n }}\n onMouseLeave={(e) => {\n e.currentTarget.style.background = \"#f8f9fa\";\n e.currentTarget.style.borderColor = \"#d1d1d6\";\n e.currentTarget.style.color = \"#1c1c1e\";\n }}\n >\n ← Back to Feed\n \n\n {/* Main checkin card */}\n \n {/* Author header */}\n \n {checkin.author.avatar\n ? (\n \n )\n : (\n \n {(checkin.author.displayName || checkin.author.handle)?.[0]\n ?.toUpperCase() || \"?\"}\n \n )}\n\n

\n \n {checkin.author.displayName || checkin.author.handle}\n

\n \n @{checkin.author.handle}\n \n \n\n \n {new Date(checkin.createdAt).toLocaleDateString(undefined, {\n weekday: \"long\",\n year: \"numeric\",\n month: \"long\",\n day: \"numeric\",\n })}\n
\n {new Date(checkin.createdAt).toLocaleTimeString(undefined, {\n hour: \"numeric\",\n minute: \"2-digit\",\n })}\n \n \n\n {/* Checkin message */}\n {checkin.text && (\n \n {checkin.text}\n \n )}\n\n {/* Location info */}\n {(checkin.address || checkin.coordinates) && (\n \n \n 📍\n \n Location\n \n \n\n {checkin.address && (\n

\n {checkin.address.name && (\n \n {checkin.address.name}\n

\n )}\n \n {[\n checkin.address.street,\n checkin.address.locality,\n checkin.address.region,\n checkin.address.country,\n ].filter(Boolean).join(\", \")}\n \n \n )}\n\n {checkin.coordinates && (\n <>\n \n {checkin.coordinates.latitude.toFixed(6)},{\" \"}\n {checkin.coordinates.longitude.toFixed(6)}\n \n\n {/* Map widget */}\n \n \n )}\n \n )}\n \n\n {/* Share section */}\n \n \n Share this checkin\n \n\n \n \n {\n // Copy URL only\n try {\n await navigator.clipboard.writeText(shareUrl);\n alert(\"Link copied to clipboard!\");\n } catch (_err) {\n // Fallback for older browsers\n const textArea = document.createElement(\"textarea\");\n textArea.value = shareUrl;\n document.body.appendChild(textArea);\n textArea.select();\n document.execCommand(\"copy\");\n document.body.removeChild(textArea);\n alert(\"Link copied to clipboard!\");\n }\n }}\n style={{\n background: \"#f8f9fa\",\n color: \"#007aff\",\n border: \"1px solid #007aff\",\n padding: \"6px 12px\",\n borderRadius: \"6px\",\n fontSize: \"14px\",\n cursor: \"pointer\",\n marginRight: \"4px\",\n }}\n >\n Copy\n \n {navigator.share && (\n {\n try {\n const shareText = `Dropped anchor at ${\n checkin.address?.name || \"a location\"\n } ${shareUrl}`;\n await navigator.share({\n text: shareText,\n });\n } catch (err) {\n console.log(\"Share cancelled or failed:\", err);\n }\n }}\n style={{\n background: \"#007aff\",\n color: \"white\",\n border: \"none\",\n padding: \"6px 12px\",\n borderRadius: \"6px\",\n fontSize: \"14px\",\n cursor: \"pointer\",\n }}\n >\n Share\n \n )}\n \n \n \n );\n}\n",[],[607,614,640],{"_103":648,"_95":649,"_154":650,"_156":615,"_157":139,"_158":651,"_160":161,"_105":652,"_100":159,"_163":226,"_165":653,"_166":22,"_167":-5,"_168":654,"_98":655},"d5aef13c-75f4-11f0-89f5-0224a6c84d84","Feed.tsx","2bd5b920-7545-11f0-bd64-0224a6c84d84",523,["D",1754835486583],"/** @jsxImportSource https://esm.sh/react */\nimport { AuthState, CheckinData, FeedType } from \"../types/index.ts\";\nimport { CheckinCard } from \"./CheckinCard.tsx\";\n\ninterface FeedProps {\n feedType: FeedType;\n setFeedType: (type: FeedType) => void;\n checkins: CheckinData[];\n loading: boolean;\n auth: AuthState;\n onLogin: () => void;\n}\n\nexport function Feed(\n { feedType, setFeedType, checkins, loading, auth, onLogin }: FeedProps,\n) {\n return (\n <>\n \n \n setFeedType(\"timeline\")}\n style={{\n flex: \"1\",\n padding: \"8px 16px\",\n textAlign: \"center\",\n borderRadius: \"6px\",\n fontSize: \"14px\",\n fontWeight: \"500\",\n border: \"none\",\n background: feedType === \"timeline\" ? \"white\" : \"none\",\n cursor: \"pointer\",\n color: feedType === \"timeline\" ? \"#007aff\" : \"#3c3c43\",\n transition: \"all 0.2s\",\n boxShadow: feedType === \"timeline\"\n ? \"0 1px 2px rgba(0,0,0,0.1)\"\n : \"none\",\n }}\n onMouseEnter={(e) => {\n if (feedType !== \"timeline\") {\n e.currentTarget.style.background = \"#e5e5ea\";\n }\n }}\n onMouseLeave={(e) => {\n if (feedType !== \"timeline\") {\n e.currentTarget.style.background = \"none\";\n }\n }}\n >\n Timeline\n \n setFeedType(\"following\")}\n style={{\n flex: \"1\",\n padding: \"8px 16px\",\n textAlign: \"center\",\n borderRadius: \"6px\",\n fontSize: \"14px\",\n fontWeight: \"500\",\n border: \"none\",\n background: feedType === \"following\" ? \"white\" : \"none\",\n cursor: \"pointer\",\n color: feedType === \"following\" ? \"#007aff\" : \"#3c3c43\",\n transition: \"all 0.2s\",\n boxShadow: feedType === \"following\"\n ? \"0 1px 2px rgba(0,0,0,0.1)\"\n : \"none\",\n }}\n >\n Following\n \n setFeedType(\"global\")}\n style={{\n flex: \"1\",\n padding: \"8px 16px\",\n textAlign: \"center\",\n borderRadius: \"6px\",\n fontSize: \"14px\",\n fontWeight: \"500\",\n border: \"none\",\n background: feedType === \"global\" ? \"white\" : \"none\",\n cursor: \"pointer\",\n color: feedType === \"global\" ? \"#007aff\" : \"#3c3c43\",\n transition: \"all 0.2s\",\n boxShadow: feedType === \"global\"\n ? \"0 1px 2px rgba(0,0,0,0.1)\"\n : \"none\",\n }}\n >\n Global\n \n \n \n\n {loading && (\n \n \n \n \n Loading check-ins...\n \n \n \n )}\n\n {checkins.length === 0 && !loading && (\n \n {/* Show login illustration for timeline and following when not authenticated */}\n {(feedType === \"timeline\" || feedType === \"following\") &&\n !auth.isAuthenticated\n ? (\n \n \n \n Sign in to see your {feedType}\n \n \n {feedType === \"following\"\n ? \"Connect with your Bluesky account to see check-ins from people you follow.\"\n : \"Connect with your Bluesky account to see your personalized timeline.\"}\n

\n {\n e.currentTarget.style.background = \"#0056b3\";\n e.currentTarget.style.transform = \"translateY(-1px)\";\n }}\n onMouseLeave={(e) => {\n e.currentTarget.style.background = \"#007aff\";\n e.currentTarget.style.transform = \"translateY(0)\";\n }}\n >\n Sign in with Bluesky\n \n \n )\n : (\n /* Show regular empty state for global feed or authenticated empty feeds */\n <>\n \n \n {feedType === \"global\"\n ? \"No check-ins yet\"\n : feedType === \"following\"\n ? \"No check-ins from people you follow\"\n : \"Your timeline is empty\"}\n \n \n {feedType === \"global\"\n ? \"Check-ins from the community will appear here as people start sharing their locations.\"\n : feedType === \"following\"\n ? \"Check-ins from people you follow will appear here.\"\n : \"Your personalized timeline is empty. Check back later!\"}\n

\n \n )}\n \n )}\n\n {checkins.length > 0 && (\n

\n {checkins.map((checkin) => (\n \n ))}\n

\n )}\n \n );\n}\n",[],[607,614,649],{"_103":657,"_95":658,"_154":659,"_156":615,"_157":139,"_158":660,"_160":161,"_105":661,"_100":254,"_163":226,"_165":662,"_166":22,"_167":-5,"_168":663,"_98":664},"2a23b3a2-7923-11f0-9e48-0224a6c84d84","Header.tsx","2bde1d72-7545-11f0-b19c-0224a6c84d84",728,["D",1755185238617],"/** @jsxImportSource https://esm.sh/react */\nimport { AuthState } from \"../types/index.ts\";\n\ninterface HeaderProps {\n auth: AuthState;\n onLogin: () => void;\n onLogout: () => void;\n showUserDropdown: boolean;\n setShowUserDropdown: (show: boolean) => void;\n}\n\nexport function Header({\n auth,\n onLogin,\n onLogout,\n showUserDropdown,\n setShowUserDropdown,\n}: HeaderProps) {\n return (\n \n \n \n \n \n\n \n {!auth.isAuthenticated\n ? (\n {\n e.currentTarget.style.background = \"#0056cc\";\n }}\n onMouseOut={(e) => {\n e.currentTarget.style.background = \"#007aff\";\n }}\n >\n Login\n \n )\n : (\n

\n setShowUserDropdown(!showUserDropdown)}\n style={{\n display: \"flex\",\n alignItems: \"center\",\n gap: \"10px\",\n background: \"white\",\n border: \"1px solid #e5e5ea\",\n borderRadius: \"24px\",\n padding: \"6px 16px 6px 6px\",\n cursor: \"pointer\",\n boxShadow: \"0 2px 8px rgba(0,0,0,0.08)\",\n fontSize: \"15px\",\n color: \"#1c1c1e\",\n transition: \"all 0.2s ease\",\n }}\n >\n {auth.userAvatar\n ? (\n \n )\n : (\n \n {(auth.userDisplayName || auth.userHandle)?.[0]\n ?.toUpperCase() || \"?\"}\n

\n )}\n \n {auth.userDisplayName || auth.userHandle}\n \n \n ▼\n \n \n\n {showUserDropdown && (\n \n {\n e.currentTarget.style.background = \"#f2f2f7\";\n }}\n onMouseOut={(e) => {\n e.currentTarget.style.background = \"none\";\n }}\n >\n Sign out\n \n \n )}\n \n )}\n \n \n \n );\n}\n",[],[607,614,658],{"_103":666,"_95":667,"_154":668,"_156":615,"_157":139,"_158":669,"_160":161,"_105":670,"_100":463,"_163":226,"_165":671,"_166":22,"_167":-5,"_168":672,"_98":673},"c4a7c1b0-7546-11f0-aed4-0224a6c84d84","LoginForm.tsx","2bd0f9a8-7545-11f0-8c6f-0224a6c84d84",444,["D",1754760725547],"/** @jsxImportSource https://esm.sh/react */\n\ninterface LoginFormProps {\n showLoginForm: boolean;\n setShowLoginForm: (show: boolean) => void;\n loginHandle: string;\n setLoginHandle: (handle: string) => void;\n loginLoading: boolean;\n onSubmitLogin: (e: any) => void;\n}\n\nexport function LoginForm({\n showLoginForm,\n setShowLoginForm,\n loginHandle,\n setLoginHandle,\n loginLoading,\n onSubmitLogin,\n}: LoginFormProps) {\n if (!showLoginForm) return null;\n\n return (\n {\n if (e.target === e.currentTarget) {\n setShowLoginForm(false);\n }\n }}\n >\n \n \n \n Sign in with Bluesky\n \n setShowLoginForm(false)}\n style={{\n background: \"none\",\n border: \"none\",\n fontSize: \"18px\",\n color: \"#8e8e93\",\n cursor: \"pointer\",\n padding: \"4px\",\n borderRadius: \"12px\",\n }}\n onMouseOver={(e) => {\n e.currentTarget.style.background = \"#f2f2f7\";\n }}\n onMouseOut={(e) => {\n e.currentTarget.style.background = \"none\";\n }}\n >\n ✕\n \n \n\n

\n \n Bluesky Handle\n \n setLoginHandle(e.target.value)}\n placeholder=\"your-handle.bsky.social\"\n required\n style={{\n width: \"100%\",\n fontSize: \"16px\",\n padding: \"12px 16px\",\n border: \"1px solid #e5e5ea\",\n borderRadius: \"8px\",\n background: \"white\",\n color: \"#1c1c1e\",\n outline: \"none\",\n }}\n onFocus={(e) => {\n e.currentTarget.style.borderColor = \"#007aff\";\n }}\n onBlur={(e) => {\n e.currentTarget.style.borderColor = \"#e5e5ea\";\n }}\n />\n \n Enter your Bluesky handle (e.g., alice.bsky.social)\n

\n\n \n setShowLoginForm(false)}\n style={{\n fontSize: \"16px\",\n fontWeight: \"500\",\n background: \"none\",\n color: \"#007aff\",\n border: \"none\",\n borderRadius: \"8px\",\n padding: \"10px 16px\",\n cursor: \"pointer\",\n }}\n onMouseOver={(e) => {\n e.currentTarget.style.background = \"#f0f8ff\";\n }}\n onMouseOut={(e) => {\n e.currentTarget.style.background = \"none\";\n }}\n >\n Cancel\n \n {\n if (!loginLoading) {\n e.currentTarget.style.background = \"#0056cc\";\n }\n }}\n onMouseOut={(e) => {\n if (!loginLoading) {\n e.currentTarget.style.background = \"#007aff\";\n }\n }}\n >\n {loginLoading ? \"Connecting...\" : \"Sign in\"}\n \n \n \n \n \n );\n}\n",[],[607,614,667],{"_103":675,"_95":676,"_154":677,"_156":615,"_157":139,"_158":678,"_160":161,"_105":679,"_100":372,"_163":226,"_165":680,"_166":22,"_167":-5,"_168":681,"_98":682},"698e3400-7f3a-11f0-8fe7-0224a6c84d84","MobileAuth.tsx","35f7cfdc-75f5-11f0-bfd9-0224a6c84d84",838,["D",1755854930413],"/** @jsxImportSource https://esm.sh/react */\nimport React, { useEffect, useState } from \"https://esm.sh/react\";\n\nexport function MobileAuth() {\n const [handle, setHandle] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n\n // Inject proper CSS styles for fonts and animations\n useEffect(() => {\n const style = document.createElement(\"style\");\n style.textContent = `\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n \n body {\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', system-ui, sans-serif;\n line-height: 1.5;\n color: #1c1c1e;\n }\n\n @keyframes spin {\n to { transform: rotate(360deg); }\n }\n `;\n document.head.appendChild(style);\n return () => {\n if (style.parentNode) {\n document.head.removeChild(style);\n }\n };\n }, []);\n\n // Generate PKCE parameters for secure OAuth flow\n const generatePKCE = async () => {\n // Generate code verifier (128 characters, URL-safe)\n const array = new Uint8Array(96);\n crypto.getRandomValues(array);\n const codeVerifier = btoa(String.fromCharCode(...array))\n .replace(/\\+/g, \"-\")\n .replace(/\\//g, \"_\")\n .replace(/=/g, \"\");\n\n // Generate code challenge (SHA256 hash of verifier)\n const encoder = new TextEncoder();\n const data = encoder.encode(codeVerifier);\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n const codeChallenge = btoa(String.fromCharCode(...hashArray))\n .replace(/\\+/g, \"-\")\n .replace(/\\//g, \"_\")\n .replace(/=/g, \"\");\n\n return { codeVerifier, codeChallenge };\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n\n if (!handle.trim()) {\n setError(\"Please enter your Bluesky handle\");\n return;\n }\n\n setError(null);\n setLoading(true);\n\n try {\n // Generate PKCE parameters for this OAuth flow\n const { codeVerifier, codeChallenge } = await generatePKCE();\n\n // Store code verifier for later use (in sessionStorage for this tab)\n sessionStorage.setItem(\"pkce_code_verifier\", codeVerifier);\n\n const response = await fetch(\"/api/auth/mobile-start\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n handle: handle.trim(),\n code_challenge: codeChallenge,\n }),\n });\n\n if (!response.ok) {\n throw new Error(\"Failed to start authentication\");\n }\n\n const data = await response.json();\n\n if (data.authUrl) {\n // Redirect to OAuth authorization\n globalThis.location.href = data.authUrl;\n } else {\n throw new Error(\"No authorization URL received\");\n }\n } catch (error) {\n console.error(\"Login failed:\", error);\n setError(\"Login failed. Please check your handle and try again.\");\n setLoading(false);\n }\n };\n\n return (\n \n \n \n \n \n\n \n Sign in to Anchor\n \n\n \n Connect with your Bluesky account\n

\n\n {error && (\n \n {error}\n \n )}\n\n

\n \n Bluesky Handle\n \n setHandle(e.target.value)}\n placeholder=\"alice.bsky.social\"\n autoComplete=\"username\"\n required\n style={{\n width: \"100%\",\n padding: \"16px\",\n border: \"2px solid #f2f2f7\",\n borderRadius: \"12px\",\n fontSize: \"16px\",\n background: \"#f9f9f9\",\n transition: \"all 0.2s ease\",\n boxSizing: \"border-box\",\n }}\n onFocus={(e) => {\n e.target.style.borderColor = \"#007aff\";\n e.target.style.background = \"white\";\n e.target.style.boxShadow = \"0 0 0 4px rgba(0, 122, 255, 0.1)\";\n }}\n onBlur={(e) => {\n e.target.style.borderColor = \"#f2f2f7\";\n e.target.style.background = \"#f9f9f9\";\n e.target.style.boxShadow = \"none\";\n }}\n />\n

\n\n {\n if (!loading) {\n e.currentTarget.style.background = \"#0056b3\";\n e.currentTarget.style.transform = \"translateY(-1px)\";\n }\n }}\n onMouseLeave={(e) => {\n if (!loading) {\n e.currentTarget.style.background = \"#007aff\";\n e.currentTarget.style.transform = \"translateY(0)\";\n }\n }}\n >\n {loading\n ? (\n <>\n \n Signing in...\n \n )\n : (\n \"Sign in with Bluesky\"\n )}\n \n \n\n \n Powered by AT Protocol\n \n \n \n );\n}\n",[],[607,614,676],{"_103":684,"_95":685,"_154":686,"_156":615,"_157":139,"_158":687,"_160":161,"_105":688,"_100":32,"_163":226,"_165":689,"_166":22,"_167":-5,"_168":690,"_98":691},"e5895ade-83dc-11f0-95c9-0224a6c84d84","MobileLogin.tsx","e5895b7e-83dc-11f0-95c9-0224a6c84d84",894,["D",1756364521543],"/** @jsxImportSource https://esm.sh/react */\nimport React, { useState } from \"https://esm.sh/react\";\n\ninterface MobileLoginProps {\n redirectUri: string;\n}\n\nexport function MobileLogin({ redirectUri }: MobileLoginProps) {\n const [handle, setHandle] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n\n if (!handle.trim()) {\n setError(\"Please enter your Bluesky handle\");\n return;\n }\n\n setLoading(true);\n setError(\"\");\n\n try {\n // Redirect to OAuth flow with handle and redirect_uri\n const params = new URLSearchParams({\n handle: handle.trim(),\n redirect_uri: redirectUri,\n });\n\n globalThis.location.href = `/mobile/login?${params.toString()}`;\n } catch (_err) {\n setError(\"Failed to connect. Please try again.\");\n setLoading(false);\n }\n };\n\n return (\n \n \n {/* Header with logo */}\n \n \n \n Sign in to Anchor\n \n \n Enter your Bluesky handle to continue\n

\n \n\n {/* Login form */}\n

\n \n \n Bluesky Handle\n \n setHandle(e.target.value)}\n placeholder=\"username.bsky.social or your.domain\"\n autoComplete=\"username\"\n autoCapitalize=\"none\"\n autoCorrect=\"off\"\n disabled={loading}\n style={{\n width: \"100%\",\n padding: \"12px 16px\",\n border: \"1px solid #e5e5ea\",\n borderRadius: \"12px\",\n fontSize: \"16px\",\n background: loading ? \"#f8f9fa\" : \"white\",\n color: \"#1c1c1e\",\n outline: \"none\",\n transition: \"border-color 0.2s ease\",\n }}\n onFocus={(e) => {\n e.target.style.borderColor = \"#007aff\";\n }}\n onBlur={(e) => {\n e.target.style.borderColor = \"#e5e5ea\";\n }}\n />\n \n\n {\n if (!loading && handle.trim()) {\n e.currentTarget.style.background = \"#0056cc\";\n }\n }}\n onMouseOut={(e) => {\n if (!loading && handle.trim()) {\n e.currentTarget.style.background = \"#007aff\";\n }\n }}\n >\n {loading && (\n \n )}\n {loading ? \"Connecting...\" : \"Continue with Bluesky\"}\n \n\n {error && (\n \n {error}\n \n )}\n \n\n {/* Security note */}\n \n \n \n 🔒\n \n \n Secure Authentication\n \n \n \n Your password will be entered securely on Bluesky's servers. Anchor\n never sees your password.\n

\n \n \n\n {/* CSS animation for spinner */}\n \n \n );\n}\n",[],[607,614,685],[607,614],{"_103":694,"_95":695,"_154":696,"_156":608,"_157":139,"_158":697,"_160":161,"_105":698,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":699,"_98":700},"2bb5d8c6-7545-11f0-bee6-0224a6c84d84","hooks","2bb5d952-7545-11f0-bee6-0224a6c84d84",429,["D",1754760039494],[],[607,695],{"_103":702,"_95":703,"_154":704,"_156":608,"_157":139,"_158":705,"_160":161,"_105":706,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":707,"_98":717},"2b9e8ed2-7545-11f0-b19c-0224a6c84d84","types","2b9e8fa4-7545-11f0-b19c-0224a6c84d84",428,["D",1754760039342],[708],{"_103":709,"_95":710,"_154":711,"_156":704,"_157":139,"_158":712,"_160":161,"_105":713,"_100":32,"_163":226,"_165":714,"_166":22,"_167":-5,"_168":715,"_98":716},"2bcdef2e-7545-11f0-ba71-0224a6c84d84","index.ts","2bcdf0f0-7545-11f0-ba71-0224a6c84d84",430,["D",1754760039655],"// Shared TypeScript types for the frontend\n\nexport interface CheckinData {\n id: string;\n uri: string;\n author: {\n did: string;\n handle: string;\n displayName?: string;\n avatar?: string;\n };\n text: string;\n createdAt: string;\n coordinates?: {\n latitude: number;\n longitude: number;\n };\n address?: {\n name?: string;\n street?: string;\n locality?: string;\n region?: string;\n country?: string;\n postalCode?: string;\n };\n distance?: number;\n}\n\nexport interface AuthState {\n isAuthenticated: boolean;\n userHandle?: string;\n userDid?: string;\n userAvatar?: string;\n userDisplayName?: string;\n}\n\nexport type FeedType = \"timeline\" | \"following\" | \"global\";\n",[],[607,703,710],[607,703],{"_103":719,"_95":505,"_154":720,"_156":608,"_157":139,"_158":721,"_160":161,"_105":722,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":723,"_98":724},"829db33e-7aae-11f0-9d49-0224a6c84d84","829db41a-7aae-11f0-9d49-0224a6c84d84",788,["D",1755355038265],[],[607,505],{"_103":726,"_95":727,"_154":728,"_156":608,"_157":139,"_158":729,"_160":161,"_105":730,"_100":463,"_163":177,"_165":731,"_166":22,"_167":-5,"_168":732,"_98":733},"53421110-7500-11f0-8949-0224a6c84d84","index.html","ca076f42-7466-11f0-b0f6-0224a6c84d84",377,["D",1754730470563],"\n\n \n \n \n Anchor - Location-based Social Network\n \n \n \n \n \n \n \n

\n \n \n\n",[],[607,727],{"_103":735,"_95":736,"_154":737,"_156":608,"_157":139,"_158":738,"_160":161,"_105":739,"_100":119,"_163":226,"_165":740,"_166":22,"_167":-5,"_168":741,"_98":742},"cf4f1970-7545-11f0-b167-0224a6c84d84","index.tsx","ca00096e-7466-11f0-a509-0224a6c84d84",441,["D",1754760313961],"/** @jsxImportSource https://esm.sh/react */\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();\n",[],[607,736],[607],{"_103":745,"_95":746,"_154":747,"_156":-5,"_157":139,"_158":748,"_160":161,"_105":749,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":750,"_98":880},"56be52d0-58b4-11f0-9210-f69ea79377d9","tests","56be5424-58b4-11f0-9210-f69ea79377d9",3,["D",1751619202108],[751,768,784,801],{"_103":752,"_95":753,"_154":754,"_156":747,"_157":139,"_158":755,"_160":161,"_105":756,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":757,"_98":767},"5769d894-58b4-11f0-a0a5-f69ea79377d9","fixtures","5769d952-58b4-11f0-a0a5-f69ea79377d9",10,["D",1751619203233],[758],{"_103":759,"_95":760,"_154":761,"_156":754,"_157":139,"_158":762,"_160":161,"_105":763,"_100":119,"_163":226,"_165":764,"_166":22,"_167":-5,"_168":765,"_98":766},"dabc4fea-5a7d-11f0-9153-f69ea79377d9","test-data.ts","58119f98-58b4-11f0-84ee-f69ea79377d9",64,["D",1751815703553],"// Test fixtures for Anchor AppView tests\n\nexport const mockCheckins = [\n {\n id: \"checkin1\",\n uri: \"at://did:plc:user1/app.dropanchor.checkin/checkin1\",\n author_did: \"did:plc:user1\",\n author_handle: \"alice.bsky.social\",\n text: \"Amazing coffee at this local spot! ☕️\",\n created_at: \"2024-07-04T10:30:00Z\",\n latitude: 40.7128,\n longitude: -74.0060,\n address_ref_uri:\n \"at://did:plc:venues/community.lexicon.location.address/cafe-joe\",\n address_ref_cid: \"bafyreic7...\",\n cached_address_name: \"Joe's Coffee Shop\",\n cached_address_street: \"123 Broadway\",\n cached_address_locality: \"New York\",\n cached_address_region: \"NY\",\n cached_address_country: \"US\",\n cached_address_postal_code: \"10001\",\n },\n {\n id: \"checkin2\",\n uri: \"at://did:plc:user2/app.dropanchor.checkin/checkin2\",\n author_did: \"did:plc:user2\",\n author_handle: \"bob.bsky.social\",\n text: \"Great lunch spot with outdoor seating 🌞\",\n created_at: \"2024-07-04T12:15:00Z\",\n latitude: 40.7589,\n longitude: -73.9851,\n address_ref_uri:\n \"at://did:plc:venues/community.lexicon.location.address/times-square-cafe\",\n address_ref_cid: \"bafyreie8...\",\n cached_address_name: \"Times Square Cafe\",\n cached_address_street: \"1500 Broadway\",\n cached_address_locality: \"New York\",\n cached_address_region: \"NY\",\n cached_address_country: \"US\",\n cached_address_postal_code: \"10036\",\n },\n {\n id: \"checkin3\",\n uri: \"at://did:plc:user3/app.dropanchor.checkin/checkin3\",\n author_did: \"did:plc:user3\",\n author_handle: \"charlie.bsky.social\",\n text: \"Perfect spot for remote work 💻\",\n created_at: \"2024-07-04T14:45:00Z\",\n latitude: 37.7749,\n longitude: -122.4194,\n address_ref_uri: null,\n address_ref_cid: null,\n cached_address_name: null,\n cached_address_street: null,\n cached_address_locality: \"San Francisco\",\n cached_address_region: \"CA\",\n cached_address_country: \"US\",\n cached_address_postal_code: \"94102\",\n },\n];\n\nexport const mockAddresses = [\n {\n uri: \"at://did:plc:venues/community.lexicon.location.address/cafe-joe\",\n cid: \"bafyreic7...\",\n name: \"Joe's Coffee Shop\",\n street: \"123 Broadway\",\n locality: \"New York\",\n region: \"NY\",\n country: \"US\",\n postal_code: \"10001\",\n latitude: 40.7128,\n longitude: -74.0060,\n full_data: {\n name: \"Joe's Coffee Shop\",\n street: \"123 Broadway\",\n locality: \"New York\",\n region: \"NY\",\n country: \"US\",\n postalCode: \"10001\",\n latitude: 40.7128,\n longitude: -74.0060,\n hours: {\n monday: \"7:00-19:00\",\n tuesday: \"7:00-19:00\",\n },\n amenities: [\"wifi\", \"outdoor_seating\", \"accepts_cards\"],\n },\n resolved_at: \"2024-07-04T09:00:00Z\",\n },\n {\n uri:\n \"at://did:plc:venues/community.lexicon.location.address/times-square-cafe\",\n cid: \"bafyreie8...\",\n name: \"Times Square Cafe\",\n street: \"1500 Broadway\",\n locality: \"New York\",\n region: \"NY\",\n country: \"US\",\n postal_code: \"10036\",\n latitude: 40.7589,\n longitude: -73.9851,\n full_data: {\n name: \"Times Square Cafe\",\n street: \"1500 Broadway\",\n locality: \"New York\",\n region: \"NY\",\n country: \"US\",\n postalCode: \"10036\",\n latitude: 40.7589,\n longitude: -73.9851,\n hours: {\n monday: \"6:00-22:00\",\n tuesday: \"6:00-22:00\",\n },\n amenities: [\"wifi\", \"outdoor_seating\", \"delivery\"],\n },\n resolved_at: \"2024-07-04T11:30:00Z\",\n },\n];\n\nexport const mockUsers = [\n {\n did: \"did:plc:user1\",\n handle: \"alice.bsky.social\",\n displayName: \"Alice Johnson\",\n avatar: \"https://example.com/avatar1.jpg\",\n },\n {\n did: \"did:plc:user2\",\n handle: \"bob.bsky.social\",\n displayName: \"Bob Smith\",\n avatar: \"https://example.com/avatar2.jpg\",\n },\n {\n did: \"did:plc:user3\",\n handle: \"charlie.bsky.social\",\n displayName: \"Charlie Brown\",\n avatar: \"https://example.com/avatar3.jpg\",\n },\n];\n\nexport const mockFollows = [\n {\n follower_did: \"did:plc:user1\",\n following_did: \"did:plc:user2\",\n created_at: \"2024-06-01T10:00:00Z\",\n synced_at: \"2024-07-04T08:00:00Z\",\n },\n {\n follower_did: \"did:plc:user1\",\n following_did: \"did:plc:user3\",\n created_at: \"2024-06-15T14:30:00Z\",\n synced_at: \"2024-07-04T08:00:00Z\",\n },\n {\n follower_did: \"did:plc:user2\",\n following_did: \"did:plc:user1\",\n created_at: \"2024-06-02T09:15:00Z\",\n synced_at: \"2024-07-04T08:00:00Z\",\n },\n];\n\nexport const mockJetstreamEvents = [\n {\n kind: \"commit\",\n commit: {\n repo: \"did:plc:user1\",\n collection: \"app.dropanchor.checkin\",\n operation: \"create\",\n rkey: \"checkin1\",\n record: {\n text: \"Amazing coffee at this local spot! ☕️\",\n createdAt: \"2024-07-04T10:30:00Z\",\n coordinates: {\n latitude: \"40.7128\",\n longitude: \"-74.0060\",\n },\n addressRef: {\n uri:\n \"at://did:plc:venues/community.lexicon.location.address/cafe-joe\",\n cid: \"bafyreic7...\",\n },\n },\n },\n },\n {\n kind: \"commit\",\n commit: {\n repo: \"did:plc:user2\",\n collection: \"app.dropanchor.checkin\",\n operation: \"create\",\n rkey: \"checkin2\",\n record: {\n text: \"Great lunch spot with outdoor seating 🌞\",\n createdAt: \"2024-07-04T12:15:00Z\",\n coordinates: {\n latitude: \"40.7589\",\n longitude: \"-73.9851\",\n },\n addressRef: {\n uri:\n \"at://did:plc:venues/community.lexicon.location.address/times-square-cafe\",\n cid: \"bafyreie8...\",\n },\n },\n },\n },\n];\n\nexport const mockProcessingLogs = [\n {\n id: 1,\n run_at: \"2024-07-04T10:00:00Z\",\n events_processed: 5,\n errors: 0,\n duration_ms: 1250,\n },\n {\n id: 2,\n run_at: \"2024-07-04T10:05:00Z\",\n events_processed: 3,\n errors: 1,\n duration_ms: 2100,\n },\n {\n id: 3,\n run_at: \"2024-07-04T10:10:00Z\",\n events_processed: 7,\n errors: 0,\n duration_ms: 980,\n },\n];\n\n// Coordinate pairs for testing spatial queries\nexport const testCoordinates = {\n newYork: { lat: 40.7128, lng: -74.0060 },\n sanFrancisco: { lat: 37.7749, lng: -122.4194 },\n london: { lat: 51.5074, lng: -0.1278 },\n tokyo: { lat: 35.6762, lng: 139.6503 },\n sydney: { lat: -33.8688, lng: 151.2093 },\n};\n\n// Helper function to create formatted checkin records\nexport function formatTestCheckin(rawCheckin: typeof mockCheckins[0]) {\n return {\n id: rawCheckin.id,\n uri: rawCheckin.uri,\n author: {\n did: rawCheckin.author_did,\n handle: rawCheckin.author_handle,\n },\n text: rawCheckin.text,\n createdAt: rawCheckin.created_at,\n coordinates: rawCheckin.latitude && rawCheckin.longitude\n ? {\n latitude: rawCheckin.latitude,\n longitude: rawCheckin.longitude,\n }\n : undefined,\n address: rawCheckin.cached_address_name\n ? {\n name: rawCheckin.cached_address_name,\n street: rawCheckin.cached_address_street,\n locality: rawCheckin.cached_address_locality,\n region: rawCheckin.cached_address_region,\n country: rawCheckin.cached_address_country,\n postalCode: rawCheckin.cached_address_postal_code,\n }\n : undefined,\n };\n}\n",[],[746,753,760],[746,753],{"_103":769,"_95":770,"_154":771,"_156":747,"_157":139,"_158":382,"_160":161,"_105":772,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":773,"_98":783},"5753ebce-58b4-11f0-9040-f69ea79377d9","integration","5753ec82-58b4-11f0-9040-f69ea79377d9",["D",1751619203088],[774],{"_103":775,"_95":776,"_154":777,"_156":771,"_157":139,"_158":778,"_160":161,"_105":779,"_100":159,"_163":226,"_165":780,"_166":22,"_167":-5,"_168":781,"_98":782},"e919dc66-7b51-11f0-bbe6-0224a6c84d84","api.test.ts","580a4cb6-58b4-11f0-b945-f69ea79377d9",804,["D",1755425218173],"import {\n assertEquals,\n assertExists,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport {\n restore as _restore,\n stub as _stub,\n} from \"https://deno.land/std@0.208.0/testing/mock.ts\";\n\n// Mock SQLite for testing\nconst _mockDatabase = new Map();\n\nconst _mockSqlite = {\n execute(query: string, _params: any[] = []) {\n // Simple mock that returns test data based on query patterns\n if (query.includes(\"CREATE TABLE\")) {\n return [];\n }\n\n if (query.includes(\"SELECT COUNT(*) as count FROM checkins_v1\")) {\n return [{ count: 42 }];\n }\n\n if (query.includes(\"SELECT * FROM checkins_v1\")) {\n return [\n {\n id: \"test123\",\n uri: \"at://did:plc:test/app.dropanchor.checkin/test123\",\n author_did: \"did:plc:test\",\n author_handle: \"test.bsky.social\",\n text: \"Great coffee!\",\n created_at: \"2024-01-01T12:00:00Z\",\n latitude: 40.7128,\n longitude: -74.0060,\n cached_address_name: \"Test Cafe\",\n cached_address_street: \"123 Test St\",\n cached_address_locality: \"New York\",\n cached_address_region: \"NY\",\n cached_address_country: \"US\",\n cached_address_postal_code: \"10001\",\n },\n ];\n }\n\n if (query.includes(\"SELECT DISTINCT author_did FROM checkins_v1\")) {\n return [{ author_did: \"did:plc:test\" }];\n }\n\n return [];\n },\n};\n\n// Import the API handler (we'll need to mock the sqlite import)\n// For now, let's test the core functionality by creating a test version\n\nfunction createTestAPIHandler() {\n // Mock CORS headers type\n interface CorsHeaders extends Record {\n \"Access-Control-Allow-Origin\": string;\n \"Access-Control-Allow-Methods\": string;\n \"Access-Control-Allow-Headers\": string;\n \"Content-Type\": string;\n }\n\n const corsHeaders: CorsHeaders = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n \"Content-Type\": \"application/json\",\n };\n\n async function handleRequest(req: Request): Promise {\n const url = new URL(req.url);\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { headers: corsHeaders });\n }\n\n switch (url.pathname) {\n case \"/global\":\n return new Response(\n JSON.stringify({\n checkins: await getMockCheckins(),\n cursor: null,\n }),\n { headers: corsHeaders },\n );\n\n case \"/stats\":\n return new Response(\n JSON.stringify({\n totalCheckins: 42,\n totalUsers: 10,\n recentActivity: 5,\n timestamp: new Date().toISOString(),\n }),\n { headers: corsHeaders },\n );\n\n case \"/nearby\": {\n const lat = parseFloat(url.searchParams.get(\"lat\") || \"0\");\n const lng = parseFloat(url.searchParams.get(\"lng\") || \"0\");\n const radius = parseFloat(url.searchParams.get(\"radius\") || \"5\");\n\n if (\n isNaN(lat) || isNaN(lng) || url.searchParams.get(\"lat\") === null ||\n url.searchParams.get(\"lng\") === null\n ) {\n return new Response(\n JSON.stringify({ error: \"lat and lng parameters required\" }),\n {\n status: 400,\n headers: corsHeaders,\n },\n );\n }\n\n return new Response(\n JSON.stringify({\n checkins: await getMockNearbyCheckins(lat, lng, radius),\n center: { latitude: lat, longitude: lng },\n radius,\n }),\n { headers: corsHeaders },\n );\n }\n\n case \"/api/places/categories\": {\n // Import CategoryService to get real data\n const { CategoryService } = await import(\n \"../../backend/services/category-service.ts\"\n );\n\n const categories = CategoryService.getAllCategoryObjects();\n const defaultSearch = CategoryService.getDefaultSearchCategories();\n const sociallyRelevant = CategoryService\n .getSociallyRelevantCategories();\n\n return new Response(\n JSON.stringify({\n categories,\n defaultSearch,\n sociallyRelevant,\n metadata: {\n totalCategories: categories.length,\n defaultSearchCount: defaultSearch.length,\n sociallyRelevantCount: sociallyRelevant.length,\n },\n }),\n { headers: corsHeaders },\n );\n }\n\n default:\n return new Response(JSON.stringify({ error: \"Not Found\" }), {\n status: 404,\n headers: corsHeaders,\n });\n }\n }\n\n function getMockCheckins() {\n return [\n {\n id: \"test123\",\n uri: \"at://did:plc:test/app.dropanchor.checkin/test123\",\n author: {\n did: \"did:plc:test\",\n handle: \"test.bsky.social\",\n },\n text: \"Great coffee!\",\n createdAt: \"2024-01-01T12:00:00Z\",\n coordinates: {\n latitude: 40.7128,\n longitude: -74.0060,\n },\n address: {\n name: \"Test Cafe\",\n street: \"123 Test St\",\n locality: \"New York\",\n region: \"NY\",\n country: \"US\",\n postalCode: \"10001\",\n },\n },\n ];\n }\n\n async function getMockNearbyCheckins(\n lat: number,\n lng: number,\n radius: number,\n ) {\n // Simple distance check for test data\n const testLat = 40.7128;\n const testLng = -74.0060;\n const distance =\n Math.sqrt(Math.pow(lat - testLat, 2) + Math.pow(lng - testLng, 2)) * 111; // Rough km conversion\n\n if (distance <= radius) {\n const checkins = await getMockCheckins();\n return checkins.map((checkin) => ({\n ...checkin,\n distance: Math.round(distance * 100) / 100,\n }));\n }\n\n return [];\n }\n\n return handleRequest;\n}\n\nDeno.test(\"API Integration - OPTIONS request returns CORS headers\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\"http://localhost/global\", { method: \"OPTIONS\" });\n const response = await handler(req);\n\n assertEquals(response.status, 200);\n assertEquals(response.headers.get(\"Access-Control-Allow-Origin\"), \"*\");\n});\n\nDeno.test(\"API Integration - /global endpoint returns checkin data\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\"http://localhost/global\");\n const response = await handler(req);\n\n assertEquals(response.status, 200);\n\n const data = await response.json();\n assertExists(data.checkins);\n assertEquals(Array.isArray(data.checkins), true);\n assertEquals(data.checkins.length, 1);\n assertEquals(data.checkins[0].id, \"test123\");\n});\n\nDeno.test(\"API Integration - /stats endpoint returns statistics\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\"http://localhost/stats\");\n const response = await handler(req);\n\n assertEquals(response.status, 200);\n\n const data = await response.json();\n assertEquals(data.totalCheckins, 42);\n assertEquals(data.totalUsers, 10);\n assertEquals(data.recentActivity, 5);\n assertExists(data.timestamp);\n});\n\nDeno.test(\"API Integration - /nearby endpoint requires lat/lng parameters\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\"http://localhost/nearby\");\n const response = await handler(req);\n\n assertEquals(response.status, 400);\n\n const data = await response.json();\n assertEquals(data.error, \"lat and lng parameters required\");\n});\n\nDeno.test(\"API Integration - /nearby endpoint returns nearby checkins\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\n \"http://localhost/nearby?lat=40.7128&lng=-74.0060&radius=5\",\n );\n const response = await handler(req);\n\n assertEquals(response.status, 200);\n\n const data = await response.json();\n assertExists(data.checkins);\n assertExists(data.center);\n assertEquals(data.center.latitude, 40.7128);\n assertEquals(data.center.longitude, -74.0060);\n assertEquals(data.radius, 5);\n\n if (data.checkins.length > 0) {\n assertExists(data.checkins[0].distance);\n }\n});\n\nDeno.test(\"API Integration - /nearby endpoint filters by distance\", async () => {\n const handler = await createTestAPIHandler();\n\n // Test far away coordinates\n const req = new Request(\"http://localhost/nearby?lat=0&lng=0&radius=5\");\n const response = await handler(req);\n\n assertEquals(response.status, 200);\n\n const data = await response.json();\n assertEquals(data.checkins.length, 0); // Should be empty due to distance\n});\n\nDeno.test(\"API Integration - /api/places/categories endpoint returns category data\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\"http://localhost/api/places/categories\");\n const response = await handler(req);\n\n assertEquals(response.status, 200);\n\n const data = await response.json();\n assertExists(data.categories);\n assertExists(data.defaultSearch);\n assertExists(data.sociallyRelevant);\n assertExists(data.metadata);\n\n // Verify structure\n assertEquals(Array.isArray(data.categories), true);\n assertEquals(Array.isArray(data.defaultSearch), true);\n assertEquals(Array.isArray(data.sociallyRelevant), true);\n assertEquals(typeof data.metadata.totalCategories, \"number\");\n assertEquals(typeof data.metadata.defaultSearchCount, \"number\");\n assertEquals(typeof data.metadata.sociallyRelevantCount, \"number\");\n\n // Verify data consistency\n assertEquals(data.metadata.totalCategories, data.categories.length);\n assertEquals(data.metadata.defaultSearchCount, data.defaultSearch.length);\n assertEquals(\n data.metadata.sociallyRelevantCount,\n data.sociallyRelevant.length,\n );\n\n // Verify category structure\n if (data.categories.length > 0) {\n const category = data.categories[0];\n assertExists(category.id);\n assertExists(category.name);\n assertExists(category.icon);\n assertExists(category.group);\n assertExists(category.osmTag);\n }\n});\n\nDeno.test(\"API Integration - unknown endpoint returns 404\", async () => {\n const handler = await createTestAPIHandler();\n const req = new Request(\"http://localhost/unknown\");\n const response = await handler(req);\n\n assertEquals(response.status, 404);\n\n const data = await response.json();\n assertEquals(data.error, \"Not Found\");\n});\n",[],[746,770,776],[746,770],{"_103":785,"_95":786,"_154":787,"_156":747,"_157":139,"_158":788,"_160":161,"_105":789,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":790,"_98":800},"813eebba-63a8-11f0-b4c9-0224a6c84d84","mocks","813eec96-63a8-11f0-b4c9-0224a6c84d84",149,["D",1752823582243],[791],{"_103":792,"_95":793,"_154":794,"_156":787,"_157":139,"_158":795,"_160":161,"_105":796,"_100":463,"_163":226,"_165":797,"_166":22,"_167":-5,"_168":798,"_98":799},"2f153e74-6930-11f0-be5b-0224a6c84d84","sqlite-mock.ts","815bf85e-63a8-11f0-a6d7-0224a6c84d84",185,["D",1753431611765],"// Mock SQLite implementation for testing\n// Provides in-memory database functionality without requiring Val Town authentication\n\nexport class MockSQLite {\n private tables: Map = new Map();\n private schemas: Map = new Map();\n\n execute(query: string, params?: any[]): Promise<{ rows?: any[] }> {\n const normalizedQuery = query.trim().toLowerCase();\n\n // Handle CREATE TABLE\n if (normalizedQuery.startsWith(\"create table\")) {\n const tableName = this.extractTableName(query);\n if (tableName) {\n this.tables.set(tableName, []);\n this.schemas.set(tableName, query);\n }\n return Promise.resolve({ rows: [] });\n }\n\n // Handle CREATE INDEX\n if (normalizedQuery.startsWith(\"create index\")) {\n return Promise.resolve({ rows: [] });\n }\n\n // Handle INSERT\n if (normalizedQuery.startsWith(\"insert\")) {\n const tableName = this.extractTableNameFromInsert(query);\n if (tableName && params) {\n const table = this.tables.get(tableName) || [];\n const columns = this.extractColumnsFromInsert(query);\n const row: any = {};\n\n columns.forEach((col, index) => {\n row[col] = params[index];\n });\n\n table.push(row);\n this.tables.set(tableName, table);\n }\n return Promise.resolve({ rows: [] });\n }\n\n // Handle SELECT\n if (normalizedQuery.startsWith(\"select\")) {\n const tableName = this.extractTableNameFromSelect(query);\n if (tableName) {\n let table = this.tables.get(tableName) || [];\n\n // Apply WHERE clause if present\n if (normalizedQuery.includes(\"where\") && params) {\n table = this.applyWhereClause(table, query, params);\n }\n\n // Apply ORDER BY if present\n if (normalizedQuery.includes(\"order by\")) {\n table = this.applyOrderBy(table, query);\n }\n\n // Apply LIMIT if present\n if (normalizedQuery.includes(\"limit\")) {\n table = this.applyLimit(table, query, params);\n }\n\n return Promise.resolve({ rows: table });\n }\n return Promise.resolve({ rows: [] });\n }\n\n // Handle COUNT queries\n if (normalizedQuery.includes(\"count(*)\")) {\n const tableName = this.extractTableNameFromSelect(query);\n if (tableName) {\n const table = this.tables.get(tableName) || [];\n return Promise.resolve({ rows: [{ count: table.length }] });\n }\n return Promise.resolve({ rows: [{ count: 0 }] });\n }\n\n // Handle DELETE\n if (normalizedQuery.startsWith(\"delete\")) {\n const tableName = this.extractTableNameFromDelete(query);\n if (tableName) {\n this.tables.set(tableName, []);\n }\n return Promise.resolve({ rows: [] });\n }\n\n // Handle UPDATE\n if (normalizedQuery.startsWith(\"update\")) {\n const tableName = this.extractTableNameFromUpdate(query);\n if (tableName && params) {\n const table = this.tables.get(tableName) || [];\n // Simple UPDATE implementation - update all rows for testing\n table.forEach((row) => {\n if (query.includes(\"SET author_handle =\")) {\n row.author_handle = params[0];\n }\n });\n this.tables.set(tableName, table);\n }\n return Promise.resolve({ rows: [] });\n }\n\n return Promise.resolve({ rows: [] });\n }\n\n private extractTableName(query: string): string | null {\n const match = query.match(/create table if not exists\\s+(\\w+)/i);\n return match ? match[1] : null;\n }\n\n private extractTableNameFromInsert(query: string): string | null {\n const match = query.match(/insert (?:or ignore )?into\\s+(\\w+)/i);\n return match ? match[1] : null;\n }\n\n private extractTableNameFromSelect(query: string): string | null {\n const match = query.match(/from\\s+(\\w+)/i);\n return match ? match[1] : null;\n }\n\n private extractTableNameFromDelete(query: string): string | null {\n const match = query.match(/delete from\\s+(\\w+)/i);\n return match ? match[1] : null;\n }\n\n private extractTableNameFromUpdate(query: string): string | null {\n const match = query.match(/update\\s+(\\w+)/i);\n return match ? match[1] : null;\n }\n\n private extractColumnsFromInsert(query: string): string[] {\n const match = query.match(/\$([^)]+)\$/);\n if (match) {\n return match[1].split(\",\").map((col) => col.trim());\n }\n return [];\n }\n\n private applyWhereClause(table: any[], query: string, params: any[]): any[] {\n const normalizedQuery = query.toLowerCase();\n\n if (normalizedQuery.includes(\"where did =\")) {\n const did = params[0];\n return table.filter((row) => row.did === did);\n }\n\n if (normalizedQuery.includes(\"where author_did =\")) {\n const did = params[0];\n return table.filter((row) => row.author_did === did);\n }\n\n if (normalizedQuery.includes(\"where id =\")) {\n const id = params[0];\n return table.filter((row) => row.id === id);\n }\n\n if (normalizedQuery.includes(\"where fetched_at <\")) {\n const threshold = params[0];\n return table.filter((row) => row.fetched_at < threshold);\n }\n\n return table;\n }\n\n private applyOrderBy(table: any[], query: string): any[] {\n const normalizedQuery = query.toLowerCase();\n\n if (normalizedQuery.includes(\"order by created_at desc\")) {\n return [...table].sort((a, b) =>\n (b.created_at || \"\").localeCompare(a.created_at || \"\")\n );\n }\n\n if (normalizedQuery.includes(\"order by fetched_at asc\")) {\n return [...table].sort((a, b) =>\n (a.fetched_at || \"\").localeCompare(b.fetched_at || \"\")\n );\n }\n\n return table;\n }\n\n private applyLimit(table: any[], query: string, params?: any[]): any[] {\n const match = query.match(/limit\\s+(\\d+|\\?)/i);\n if (match) {\n const limit = match[1] === \"?\"\n ? params?.[params.length - 1]\n : parseInt(match[1]);\n return table.slice(0, limit);\n }\n return table;\n }\n\n // Helper method to clear all data\n clear() {\n this.tables.clear();\n this.schemas.clear();\n }\n}\n\n// Export singleton instance\nexport const mockSqlite = new MockSQLite();\n",[],[746,786,793],[746,786],{"_103":802,"_95":803,"_154":804,"_156":747,"_157":139,"_158":419,"_160":161,"_105":805,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":806,"_98":879},"573c83c6-58b4-11f0-a3e4-f69ea79377d9","unit","573c8484-58b4-11f0-a3e4-f69ea79377d9",["D",1751619202935],[807,816,825,834,843,852,861,870],{"_103":808,"_95":809,"_154":810,"_156":804,"_157":139,"_158":811,"_160":161,"_105":812,"_100":32,"_163":226,"_165":813,"_166":22,"_167":-5,"_168":814,"_98":815},"7f4a7980-7b51-11f0-a247-0224a6c84d84","category-service.test.ts","7f4a7a3e-7b51-11f0-a247-0224a6c84d84",800,["D",1755425040621],"// Test suite for CategoryService\n// Tests centralized category system with metadata and use-case functions\n\nimport {\n assertEquals,\n assertExists,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport { CategoryService } from \"../../backend/services/category-service.ts\";\nimport { PlaceCategoryGroup } from \"../../backend/models/place-models.ts\";\n\nDeno.test(\"CategoryService - Use case specific methods\", () => {\n // Default search categories (when user doesn't specify)\n const defaultSearch = CategoryService.getDefaultSearchCategories();\n assertEquals(defaultSearch.includes(\"amenity=restaurant\"), true);\n assertEquals(defaultSearch.includes(\"amenity=cafe\"), true);\n assertEquals(defaultSearch.includes(\"leisure=fitness_centre\"), true);\n assertEquals(defaultSearch.includes(\"amenity=toilets\"), false); // Should not include on-demand categories\n\n // Socially relevant categories\n const social = CategoryService.getSociallyRelevantCategories();\n assertEquals(social.includes(\"amenity=restaurant\"), true);\n assertEquals(social.includes(\"tourism=attraction\"), true);\n assertEquals(social.includes(\"amenity=hospital\"), false); // Not socially relevant\n\n console.log(\n `Default search: ${defaultSearch.length}, Social: ${social.length}`,\n );\n});\n\nDeno.test(\"CategoryService - Address strategy methods\", () => {\n // Venue address strategy (skip expensive geocoding)\n assertEquals(\n CategoryService.shouldUseVenueAddressStrategy(\"restaurant\"),\n true,\n );\n assertEquals(CategoryService.shouldUseVenueAddressStrategy(\"cafe\"), true);\n assertEquals(CategoryService.shouldUseVenueAddressStrategy(\"bank\"), true);\n assertEquals(CategoryService.shouldUseVenueAddressStrategy(\"park\"), false);\n assertEquals(CategoryService.shouldUseVenueAddressStrategy(\"unknown\"), false);\n\n // Geographic address strategy (use Nominatim)\n assertEquals(\n CategoryService.shouldUseGeographicAddressStrategy(\"park\"),\n true,\n );\n assertEquals(\n CategoryService.shouldUseGeographicAddressStrategy(\"playground\"),\n true,\n );\n assertEquals(\n CategoryService.shouldUseGeographicAddressStrategy(\"attraction\"),\n true,\n );\n assertEquals(\n CategoryService.shouldUseGeographicAddressStrategy(\"restaurant\"),\n false,\n );\n assertEquals(\n CategoryService.shouldUseGeographicAddressStrategy(\"unknown\"),\n false,\n );\n});\n\nDeno.test(\"CategoryService - Backward compatibility\", () => {\n // Should maintain all existing PlaceCategorization methods\n const allCategories = CategoryService.getAllCategories();\n const prioritized = CategoryService.getPrioritizedCategories();\n\n assertEquals(allCategories.length > 40, true);\n assertEquals(prioritized.length > 20, true);\n assertEquals(prioritized.length < allCategories.length, true);\n\n // Category group mapping\n assertEquals(\n CategoryService.getCategoryGroup(\"amenity\", \"cafe\"),\n PlaceCategoryGroup.FOOD_AND_DRINK,\n );\n assertEquals(\n CategoryService.getCategoryGroup(\"leisure\", \"fitness_centre\"),\n PlaceCategoryGroup.SPORTS,\n );\n assertEquals(CategoryService.getCategoryGroup(\"unknown\", \"value\"), null);\n\n // Icon mapping\n assertEquals(CategoryService.getIcon(\"amenity\", \"cafe\"), \"☕\");\n assertEquals(CategoryService.getIcon(\"amenity\", \"restaurant\"), \"🍽️\");\n assertEquals(CategoryService.getIcon(\"unknown\", \"value\"), \"📍\");\n\n // Category objects\n const objects = CategoryService.getAllCategoryObjects();\n assertEquals(objects.length, allCategories.length);\n\n const cafeCategory = objects.find((obj) => obj.id === \"amenity_cafe\");\n assertExists(cafeCategory);\n assertEquals(cafeCategory.name, \"Cafe\");\n assertEquals(cafeCategory.icon, \"☕\");\n assertEquals(cafeCategory.group, PlaceCategoryGroup.FOOD_AND_DRINK);\n\n // Category by ID\n const cafeById = CategoryService.getCategoryById(\"amenity_cafe\");\n assertExists(cafeById);\n assertEquals(cafeById.id, \"amenity_cafe\");\n assertEquals(cafeById.name, \"Cafe\");\n\n assertEquals(CategoryService.getCategoryById(\"invalid\"), null);\n assertEquals(CategoryService.getCategoryById(\"\"), null);\n});\n\nDeno.test(\"CategoryService - Category definitions integrity\", () => {\n const definitions = CategoryService.getAllCategoryDefinitions();\n\n // Should have reasonable number of categories\n assertEquals(definitions.length > 40, true);\n assertEquals(definitions.length < 200, true);\n\n for (const def of definitions) {\n // Required fields\n assertExists(def.tag);\n assertExists(def.value);\n assertExists(def.group);\n assertExists(def.icon);\n assertExists(def.metadata);\n\n // Metadata validation\n assertEquals(typeof def.metadata.includeInDefaultSearch, \"boolean\");\n assertEquals(\n [\"venue\", \"geographic\", \"standard\"].includes(\n def.metadata.addressStrategy,\n ),\n true,\n );\n assertEquals(typeof def.metadata.socialRelevance, \"boolean\");\n\n // Tag/value format validation\n assertEquals(def.tag.length > 0, true);\n assertEquals(def.value.length > 0, true);\n assertEquals(def.icon.length > 0, true);\n\n // Group should be valid enum value\n assertEquals(Object.values(PlaceCategoryGroup).includes(def.group), true);\n }\n});\n\nDeno.test(\"CategoryService - Search inclusion distribution\", () => {\n const definitions = CategoryService.getAllCategoryDefinitions();\n\n const includedCount =\n definitions.filter((def) => def.metadata.includeInDefaultSearch).length;\n const excludedCount =\n definitions.filter((def) => !def.metadata.includeInDefaultSearch).length;\n\n // Should have reasonable distribution\n assertEquals(\n includedCount > 15,\n true,\n \"Should have substantial default search categories\",\n );\n assertEquals(includedCount < 50, true, \"Default search should be focused\");\n assertEquals(\n excludedCount > 5,\n true,\n \"Should have some on-demand categories\",\n );\n\n console.log(\n `Search inclusion - Included: ${includedCount}, Excluded: ${excludedCount}`,\n );\n});\n\nDeno.test(\"CategoryService - Address strategy distribution\", () => {\n const definitions = CategoryService.getAllCategoryDefinitions();\n\n const venueCount =\n definitions.filter((def) => def.metadata.addressStrategy === \"venue\")\n .length;\n const geographicCount =\n definitions.filter((def) => def.metadata.addressStrategy === \"geographic\")\n .length;\n const standardCount =\n definitions.filter((def) => def.metadata.addressStrategy === \"standard\")\n .length;\n\n // Should have reasonable distribution\n assertEquals(\n venueCount > 10,\n true,\n \"Should have substantial venue categories\",\n );\n assertEquals(geographicCount > 5, true, \"Should have geographic categories\");\n\n console.log(\n `Address strategy distribution - Venue: ${venueCount}, Geographic: ${geographicCount}, Standard: ${standardCount}`,\n );\n});\n\nDeno.test(\"CategoryService - Social relevance validation\", () => {\n const definitions = CategoryService.getAllCategoryDefinitions();\n\n const socialCount =\n definitions.filter((def) => def.metadata.socialRelevance).length;\n const nonSocialCount =\n definitions.filter((def) => !def.metadata.socialRelevance).length;\n\n // Should have focused social categories\n assertEquals(\n socialCount > 15,\n true,\n \"Should have substantial social categories\",\n );\n assertEquals(socialCount < 45, true, \"Social categories should be focused\");\n assertEquals(nonSocialCount > 5, true, \"Should have non-social categories\");\n\n // Default search categories should mostly be social\n const defaultSearchSocial =\n definitions.filter((def) =>\n def.metadata.includeInDefaultSearch && def.metadata.socialRelevance\n ).length;\n const defaultSearchTotal =\n definitions.filter((def) => def.metadata.includeInDefaultSearch).length;\n\n assertEquals(\n defaultSearchSocial / defaultSearchTotal > 0.7,\n true,\n \"Most default search categories should be social\",\n );\n\n console.log(\n `Social relevance - Social: ${socialCount}, Non-social: ${nonSocialCount}, Default search social ratio: ${\n Math.round(defaultSearchSocial / defaultSearchTotal * 100)\n }%`,\n );\n});\n",[],[746,803,809],{"_103":817,"_95":818,"_154":819,"_156":804,"_157":139,"_158":820,"_160":161,"_105":821,"_100":32,"_163":226,"_165":822,"_166":22,"_167":-5,"_168":823,"_98":824},"c707edf0-7496-11f0-a81f-0224a6c84d84","handle-resolver.test.ts","c707eeae-7496-11f0-a81f-0224a6c84d84",337,["D",1754685138149],"import { assertEquals } from \"https://deno.land/std@0.208.0/assert/mod.ts\";\n\n// Handle resolution utilities for testing\nexport interface HandleResolver {\n resolveHandle(handle: string): Promise;\n isValidHandle(handle: string): boolean;\n normalizeHandle(handle: string): string;\n}\n\nexport class ATProtocolHandleResolver implements HandleResolver {\n async resolveHandle(handle: string): Promise {\n const normalizedHandle = this.normalizeHandle(handle);\n\n if (!this.isValidHandle(normalizedHandle)) {\n return null;\n }\n\n try {\n // Try DNS resolution first\n const dnsResult = await this.resolveDNS(normalizedHandle);\n if (dnsResult) {\n return dnsResult;\n }\n\n // Fall back to HTTP resolution\n return await this.resolveHTTP(normalizedHandle);\n } catch (error) {\n console.error(`Failed to resolve handle ${normalizedHandle}:`, error);\n return null;\n }\n }\n\n isValidHandle(handle: string): boolean {\n // Basic handle validation rules\n if (!handle || handle.length === 0) return false;\n if (handle.length > 253) return false;\n if (handle.startsWith(\".\") || handle.endsWith(\".\")) return false;\n if (handle.includes(\"..\")) return false;\n\n // Must contain only valid characters\n const validPattern = /^[a-zA-Z0-9.-]+$/;\n if (!validPattern.test(handle)) return false;\n\n // Must have at least one dot (domain structure)\n if (!handle.includes(\".\")) return false;\n\n return true;\n }\n\n normalizeHandle(handle: string): string {\n // Remove @ prefix if present\n let normalized = handle.startsWith(\"@\") ? handle.slice(1) : handle;\n\n // Convert to lowercase\n normalized = normalized.toLowerCase();\n\n // Add .bsky.social if no domain is present\n if (!normalized.includes(\".\") || normalized.endsWith(\".bsky\")) {\n normalized = normalized.replace(/\\.bsky$/, \"\") + \".bsky.social\";\n }\n\n return normalized;\n }\n\n private resolveDNS(handle: string): Promise {\n try {\n // In a real implementation, this would do DNS TXT record lookup\n // For testing, we'll simulate common patterns\n if (handle.endsWith(\".bsky.social\")) {\n return Promise.resolve(null); // These use HTTP resolution\n }\n\n // Custom domain resolution would happen here\n return Promise.resolve(null);\n } catch {\n return Promise.resolve(null);\n }\n }\n\n private async resolveHTTP(handle: string): Promise {\n try {\n const response = await fetch(\n `https://bsky.social/xrpc/com.atproto.identity.resolveHandle?handle=${handle}`,\n );\n\n if (!response.ok) {\n return null;\n }\n\n const data = await response.json();\n return data.did || null;\n } catch {\n return null;\n }\n }\n}\n\nexport class MockHandleResolver implements HandleResolver {\n private handleMap = new Map();\n\n constructor(mockData: Record = {}) {\n Object.entries(mockData).forEach(([handle, did]) => {\n this.handleMap.set(this.normalizeHandle(handle), did);\n });\n }\n\n resolveHandle(handle: string): Promise {\n const normalized = this.normalizeHandle(handle);\n if (!this.isValidHandle(normalized)) {\n return Promise.resolve(null);\n }\n return Promise.resolve(this.handleMap.get(normalized) || null);\n }\n\n isValidHandle(handle: string): boolean {\n const resolver = new ATProtocolHandleResolver();\n return resolver.isValidHandle(handle);\n }\n\n normalizeHandle(handle: string): string {\n const resolver = new ATProtocolHandleResolver();\n return resolver.normalizeHandle(handle);\n }\n\n setMockHandle(handle: string, did: string): void {\n this.handleMap.set(this.normalizeHandle(handle), did);\n }\n}\n\n// Tests\nDeno.test(\"HandleResolver - normalizeHandle basic cases\", () => {\n const resolver = new ATProtocolHandleResolver();\n\n assertEquals(\n resolver.normalizeHandle(\"@user.bsky.social\"),\n \"user.bsky.social\",\n );\n assertEquals(\n resolver.normalizeHandle(\"USER.BSKY.SOCIAL\"),\n \"user.bsky.social\",\n );\n assertEquals(resolver.normalizeHandle(\"user\"), \"user.bsky.social\");\n assertEquals(resolver.normalizeHandle(\"user.bsky\"), \"user.bsky.social\");\n});\n\nDeno.test(\"HandleResolver - normalizeHandle preserves custom domains\", () => {\n const resolver = new ATProtocolHandleResolver();\n\n assertEquals(\n resolver.normalizeHandle(\"user.example.com\"),\n \"user.example.com\",\n );\n assertEquals(\n resolver.normalizeHandle(\"@subdomain.example.org\"),\n \"subdomain.example.org\",\n );\n});\n\nDeno.test(\"HandleResolver - isValidHandle validation\", () => {\n const resolver = new ATProtocolHandleResolver();\n\n // Valid handles\n assertEquals(resolver.isValidHandle(\"user.bsky.social\"), true);\n assertEquals(resolver.isValidHandle(\"test-user.example.com\"), true);\n assertEquals(resolver.isValidHandle(\"a.b\"), true);\n\n // Invalid handles\n assertEquals(resolver.isValidHandle(\"\"), false);\n assertEquals(resolver.isValidHandle(\"user\"), false); // No domain\n assertEquals(resolver.isValidHandle(\".user.com\"), false); // Starts with dot\n assertEquals(resolver.isValidHandle(\"user.com.\"), false); // Ends with dot\n assertEquals(resolver.isValidHandle(\"user..com\"), false); // Double dot\n assertEquals(resolver.isValidHandle(\"user@domain.com\"), false); // Invalid character\n assertEquals(resolver.isValidHandle(\"a\".repeat(254)), false); // Too long\n});\n\nDeno.test(\"HandleResolver - isValidHandle edge cases\", () => {\n const resolver = new ATProtocolHandleResolver();\n\n assertEquals(resolver.isValidHandle(\"user_name.com\"), false); // Underscore not allowed\n assertEquals(resolver.isValidHandle(\"user name.com\"), false); // Space not allowed\n assertEquals(resolver.isValidHandle(\"user#name.com\"), false); // Hash not allowed\n assertEquals(resolver.isValidHandle(\"123.bsky.social\"), true); // Numbers are fine\n});\n\nDeno.test(\"MockHandleResolver - basic functionality\", async () => {\n const mockData = {\n \"test.bsky.social\": \"did:plc:test123\",\n \"user.example.com\": \"did:plc:user456\",\n };\n\n const resolver = new MockHandleResolver(mockData);\n\n assertEquals(\n await resolver.resolveHandle(\"test.bsky.social\"),\n \"did:plc:test123\",\n );\n assertEquals(\n await resolver.resolveHandle(\"user.example.com\"),\n \"did:plc:user456\",\n );\n assertEquals(await resolver.resolveHandle(\"unknown.bsky.social\"), null);\n});\n\nDeno.test(\"MockHandleResolver - handle normalization in resolution\", async () => {\n const resolver = new MockHandleResolver({\n \"test.bsky.social\": \"did:plc:test123\",\n });\n\n // Should resolve with various input formats\n assertEquals(\n await resolver.resolveHandle(\"@test.bsky.social\"),\n \"did:plc:test123\",\n );\n assertEquals(\n await resolver.resolveHandle(\"TEST.BSKY.SOCIAL\"),\n \"did:plc:test123\",\n );\n assertEquals(await resolver.resolveHandle(\"test\"), \"did:plc:test123\");\n assertEquals(await resolver.resolveHandle(\"test.bsky\"), \"did:plc:test123\");\n});\n\nDeno.test(\"MockHandleResolver - setMockHandle\", async () => {\n const resolver = new MockHandleResolver();\n\n resolver.setMockHandle(\"dynamic.bsky.social\", \"did:plc:dynamic123\");\n\n assertEquals(\n await resolver.resolveHandle(\"dynamic.bsky.social\"),\n \"did:plc:dynamic123\",\n );\n assertEquals(await resolver.resolveHandle(\"@dynamic\"), \"did:plc:dynamic123\");\n});\n\nDeno.test(\"MockHandleResolver - invalid handle rejection\", async () => {\n const resolver = new MockHandleResolver({\n \"valid.bsky.social\": \"did:plc:valid123\",\n });\n\n // Even if mock data exists, invalid handles should be rejected\n resolver.setMockHandle(\"invalid..handle\", \"did:plc:invalid\");\n\n assertEquals(\n await resolver.resolveHandle(\"valid.bsky.social\"),\n \"did:plc:valid123\",\n );\n assertEquals(await resolver.resolveHandle(\"invalid..handle\"), null);\n});\n\nDeno.test(\"HandleResolver - handle with hyphens and numbers\", () => {\n const resolver = new ATProtocolHandleResolver();\n\n assertEquals(resolver.isValidHandle(\"user-123.bsky.social\"), true);\n assertEquals(resolver.isValidHandle(\"123-user.example.com\"), true);\n assertEquals(\n resolver.normalizeHandle(\"User-123.BSKY.social\"),\n \"user-123.bsky.social\",\n );\n});\n\nDeno.test(\"HandleResolver - boundary length testing\", () => {\n const resolver = new ATProtocolHandleResolver();\n\n // Test maximum valid length (253 characters)\n const maxHandle = \"a\".repeat(240) + \".bsky.social\"; // 240 + 12 = 252 chars\n assertEquals(resolver.isValidHandle(maxHandle), true);\n\n // Test over maximum length\n const overMaxHandle = \"a\".repeat(241) + \".bsky.social\"; // 241 + 12 = 253 chars\n assertEquals(resolver.isValidHandle(overMaxHandle), true);\n\n // Test way over maximum\n const wayOverMaxHandle = \"a\".repeat(250) + \".bsky.social\"; // 250 + 12 = 262 chars\n assertEquals(resolver.isValidHandle(wayOverMaxHandle), false);\n});\n",[],[746,803,818],{"_103":826,"_95":827,"_154":828,"_156":804,"_157":139,"_158":829,"_160":161,"_105":830,"_100":119,"_163":226,"_165":831,"_166":22,"_167":-5,"_168":832,"_98":833},"2f3a344a-6930-11f0-a02f-0224a6c84d84","jetstream-retry.test.ts","36c04f34-692f-11f0-96f3-0224a6c84d84",188,["D",1753431612008],"import { assertEquals } from \"https://deno.land/std@0.208.0/assert/mod.ts\";\n\nDeno.test(\"Jetstream Retry Logic\", async (t) => {\n await t.step(\"should retry connection on failure\", async () => {\n let attemptCount = 0;\n const maxRetries = 3;\n\n // Simulate connection attempts with retry logic\n for (let attempt = 1; attempt <= maxRetries; attempt++) {\n try {\n attemptCount++;\n // Simulate failure on first 2 attempts\n if (attempt < 3) {\n throw new Error(\"WebSocket connection failed\");\n }\n // Success on 3rd attempt\n break;\n } catch (_error) {\n if (attempt < maxRetries) {\n // Exponential backoff simulation\n const backoffMs = Math.pow(2, attempt - 1) * 100; // Using 100ms base for test\n await new Promise((resolve) => setTimeout(resolve, backoffMs));\n }\n }\n }\n\n assertEquals(attemptCount, 3, \"Should have attempted 3 times\");\n });\n\n await t.step(\"should use exponential backoff\", async () => {\n const delays: number[] = [];\n const startTime = Date.now();\n\n for (let attempt = 1; attempt <= 3; attempt++) {\n if (attempt > 1) {\n delays.push(Date.now() - startTime);\n }\n const backoffMs = Math.pow(2, attempt - 1) * 100;\n await new Promise((resolve) => setTimeout(resolve, backoffMs));\n }\n\n // Check that delays follow exponential pattern (100ms, 200ms, 400ms)\n assertEquals(delays.length, 2);\n // Allow some tolerance for timing\n assertEquals(\n delays[0] >= 90 && delays[0] <= 110,\n true,\n \"First delay should be ~100ms\",\n );\n assertEquals(\n delays[1] >= 290 && delays[1] <= 310,\n true,\n \"Second delay should be ~300ms total\",\n );\n });\n});\n",[],[746,803,827],{"_103":835,"_95":836,"_154":837,"_156":804,"_157":139,"_158":838,"_160":161,"_105":839,"_100":32,"_163":226,"_165":840,"_166":22,"_167":-5,"_168":841,"_98":842},"7f44fd02-7b51-11f0-9b24-0224a6c84d84","place-categorization-comprehensive.test.ts","7f44fdca-7b51-11f0-9b24-0224a6c84d84",799,["D",1755425040614],"// Comprehensive test suite for PlaceCategorization\n// Tests system integrity across all 175+ categories efficiently\n\nimport {\n assertEquals,\n assertExists,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport { PlaceCategorization } from \"../../backend/utils/place-categorization.ts\";\nimport { PlaceCategoryGroup } from \"../../backend/models/place-models.ts\";\n\nDeno.test(\"PlaceCategorization - System integrity validation\", () => {\n const allCategories = PlaceCategorization.getAllCategories();\n const allObjects = PlaceCategorization.getAllCategoryObjects();\n const prioritizedCategories = PlaceCategorization.getPrioritizedCategories();\n\n // Basic counts validation\n assertEquals(\n allCategories.length,\n allObjects.length,\n \"Category count mismatch between getAllCategories() and getAllCategoryObjects()\",\n );\n assertEquals(\n allCategories.length > 170,\n true,\n \"Should have reasonable number of categories (170+)\",\n );\n assertEquals(\n prioritizedCategories.length > 30 && prioritizedCategories.length < 50,\n true,\n \"Prioritized categories should be focused subset\",\n );\n\n // All categories should be properly formatted OSM tags\n for (const category of allCategories) {\n assertEquals(\n category.includes(\"=\"),\n true,\n `Category ${category} should contain '=' for OSM tag format`,\n );\n assertEquals(\n category.split(\"=\").length,\n 2,\n `Category ${category} should have exactly one '=' separator`,\n );\n }\n\n // All prioritized categories should exist in main categories\n const allCategoriesSet = new Set(allCategories);\n for (const prioritized of prioritizedCategories) {\n assertEquals(\n allCategoriesSet.has(prioritized),\n true,\n `Prioritized category ${prioritized} not found in all categories`,\n );\n }\n\n // Categories should be sorted\n const sortedCategories = [...allCategories].sort();\n assertEquals(\n allCategories,\n sortedCategories,\n \"Categories should be sorted alphabetically\",\n );\n});\n\nDeno.test(\"PlaceCategorization - Category object structure validation\", () => {\n const allObjects = PlaceCategorization.getAllCategoryObjects();\n\n for (const categoryObj of allObjects) {\n // Required fields\n assertExists(categoryObj.id, `Category object missing id`);\n assertExists(\n categoryObj.name,\n `Category object ${categoryObj.id} missing name`,\n );\n assertExists(\n categoryObj.icon,\n `Category object ${categoryObj.id} missing icon`,\n );\n assertExists(\n categoryObj.group,\n `Category object ${categoryObj.id} missing group`,\n );\n assertExists(\n categoryObj.osmTag,\n `Category object ${categoryObj.id} missing osmTag`,\n );\n\n // ID format validation (should be tag_value, may have multiple underscores in value)\n assertEquals(\n categoryObj.id.includes(\"_\"),\n true,\n `Category ID ${categoryObj.id} should contain underscore`,\n );\n assertEquals(\n categoryObj.id.split(\"_\").length >= 2,\n true,\n `Category ID ${categoryObj.id} should have at least one underscore`,\n );\n\n // OSM tag format validation\n assertEquals(\n categoryObj.osmTag.includes(\"=\"),\n true,\n `OSM tag ${categoryObj.osmTag} should contain '='`,\n );\n assertEquals(\n categoryObj.osmTag.split(\"=\").length,\n 2,\n `OSM tag ${categoryObj.osmTag} should have exactly one '='`,\n );\n\n // ID should match OSM tag structure (first part before underscore = tag, rest = value)\n const underscoreIndex = categoryObj.id.indexOf(\"_\");\n const idTag = categoryObj.id.substring(0, underscoreIndex);\n const idValue = categoryObj.id.substring(underscoreIndex + 1);\n const [osmTag, osmValue] = categoryObj.osmTag.split(\"=\");\n assertEquals(\n idTag,\n osmTag,\n `ID tag ${idTag} should match OSM tag ${osmTag}`,\n );\n assertEquals(\n idValue,\n osmValue,\n `ID value ${idValue} should match OSM value ${osmValue}`,\n );\n\n // Group should be valid enum value\n assertEquals(\n Object.values(PlaceCategoryGroup).includes(categoryObj.group),\n true,\n `Invalid category group: ${categoryObj.group}`,\n );\n\n // Name should be properly formatted (Title Case)\n assertEquals(\n categoryObj.name.length > 0,\n true,\n `Category name should not be empty for ${categoryObj.id}`,\n );\n assertEquals(\n categoryObj.name[0].toUpperCase(),\n categoryObj.name[0],\n `Category name should start with capital letter: ${categoryObj.name}`,\n );\n }\n});\n\nDeno.test(\"PlaceCategorization - Category group mapping validation\", () => {\n const allObjects = PlaceCategorization.getAllCategoryObjects();\n\n // Group all categories by their tag type\n const categoriesByTag: Record = {};\n for (const obj of allObjects) {\n const [tag] = obj.osmTag.split(\"=\");\n if (!categoriesByTag[tag]) categoriesByTag[tag] = [];\n categoriesByTag[tag].push(obj);\n }\n\n // Validate each major tag type has proper group coverage\n const expectedTags = [\"amenity\", \"leisure\", \"shop\", \"tourism\"];\n for (const tag of expectedTags) {\n assertEquals(\n categoriesByTag[tag]?.length > 0,\n true,\n `Should have categories for ${tag} tag`,\n );\n\n // Each tag type should map to multiple different groups (not all the same)\n const groups = new Set(categoriesByTag[tag].map((c) => c.group));\n assertEquals(\n groups.size > 1,\n true,\n `Tag ${tag} should map to multiple category groups, found: ${\n Array.from(groups)\n }`,\n );\n }\n\n // Food & Drink should be well represented\n const foodAndDrinkCategories = allObjects.filter((obj) =>\n obj.group === PlaceCategoryGroup.FOOD_AND_DRINK\n );\n assertEquals(\n foodAndDrinkCategories.length > 10,\n true,\n \"Should have substantial Food & Drink category coverage\",\n );\n\n // Shopping should be well represented\n const shoppingCategories = allObjects.filter((obj) =>\n obj.group === PlaceCategoryGroup.SHOPPING\n );\n assertEquals(\n shoppingCategories.length > 10,\n true,\n \"Should have substantial Shopping category coverage\",\n );\n});\n\nDeno.test(\"PlaceCategorization - Icon mapping validation\", () => {\n const allObjects = PlaceCategorization.getAllCategoryObjects();\n\n let specificIconCount = 0;\n let defaultIconCount = 0;\n\n for (const obj of allObjects) {\n // Icon should be valid emoji or default\n assertEquals(\n obj.icon.length > 0,\n true,\n `Icon should not be empty for ${obj.id}`,\n );\n\n if (obj.icon === \"📍\") {\n defaultIconCount++;\n } else {\n specificIconCount++;\n // Specific icons should be actual emoji characters (may be multi-codepoint)\n assertEquals(\n obj.icon.length <= 10,\n true,\n `Icon should be reasonable emoji length, got: ${obj.icon} (${obj.icon.length} chars) for ${obj.id}`,\n );\n }\n }\n\n // At least some categories should have specific icons (not all defaults)\n assertEquals(\n specificIconCount > 20,\n true,\n `Should have substantial number of specific icons, found ${specificIconCount}`,\n );\n\n console.log(\n `Icon coverage: ${specificIconCount} specific, ${defaultIconCount} default (${\n Math.round(specificIconCount / allObjects.length * 100)\n }% specific)`,\n );\n});\n\nDeno.test(\"PlaceCategorization - getCategoryGroup method validation\", () => {\n // Test a representative sample of each tag type\n const testCases = [\n {\n tag: \"amenity\",\n value: \"restaurant\",\n expectedGroup: PlaceCategoryGroup.FOOD_AND_DRINK,\n },\n {\n tag: \"amenity\",\n value: \"hospital\",\n expectedGroup: PlaceCategoryGroup.HEALTH,\n },\n {\n tag: \"amenity\",\n value: \"bank\",\n expectedGroup: PlaceCategoryGroup.SERVICES,\n },\n {\n tag: \"leisure\",\n value: \"fitness_centre\",\n expectedGroup: PlaceCategoryGroup.SPORTS,\n },\n { tag: \"leisure\", value: \"park\", expectedGroup: PlaceCategoryGroup.NATURE },\n {\n tag: \"shop\",\n value: \"supermarket\",\n expectedGroup: PlaceCategoryGroup.FOOD_AND_DRINK,\n },\n {\n tag: \"shop\",\n value: \"clothes\",\n expectedGroup: PlaceCategoryGroup.SHOPPING,\n },\n {\n tag: \"tourism\",\n value: \"hotel\",\n expectedGroup: PlaceCategoryGroup.ACCOMMODATION,\n },\n {\n tag: \"tourism\",\n value: \"museum\",\n expectedGroup: PlaceCategoryGroup.CULTURE,\n },\n ];\n\n for (const { tag, value, expectedGroup } of testCases) {\n const result = PlaceCategorization.getCategoryGroup(tag, value);\n assertEquals(\n result,\n expectedGroup,\n `getCategoryGroup(${tag}, ${value}) should return ${expectedGroup}`,\n );\n }\n\n // Test unknown tag/value combinations\n assertEquals(PlaceCategorization.getCategoryGroup(\"unknown\", \"value\"), null);\n assertEquals(\n PlaceCategorization.getCategoryGroup(\"amenity\", \"unknown_value\"),\n PlaceCategoryGroup.SERVICES,\n ); // fallback\n});\n\nDeno.test(\"PlaceCategorization - getCategoryById validation\", () => {\n // Test valid IDs\n const cafeCategory = PlaceCategorization.getCategoryById(\"amenity_cafe\");\n assertExists(cafeCategory);\n assertEquals(cafeCategory.id, \"amenity_cafe\");\n assertEquals(cafeCategory.osmTag, \"amenity=cafe\");\n assertEquals(cafeCategory.group, PlaceCategoryGroup.FOOD_AND_DRINK);\n\n // Test invalid IDs\n assertEquals(PlaceCategorization.getCategoryById(\"invalid\"), null);\n assertEquals(\n PlaceCategorization.getCategoryById(\"invalid_format_too_many_parts\"),\n null,\n );\n assertEquals(PlaceCategorization.getCategoryById(\"\"), null);\n});\n\nDeno.test(\"PlaceCategorization - Social check-in focus validation\", () => {\n const prioritized = PlaceCategorization.getPrioritizedCategories();\n\n // Prioritized should focus on social/experience categories\n const socialCategories = [\n \"amenity=restaurant\",\n \"amenity=cafe\",\n \"amenity=bar\",\n \"amenity=cinema\",\n \"tourism=attraction\",\n \"tourism=museum\",\n \"leisure=fitness_centre\",\n ];\n\n for (const category of socialCategories) {\n assertEquals(\n prioritized.includes(category),\n true,\n `Prioritized should include social category: ${category}`,\n );\n }\n\n // Should NOT prioritize utility categories (unless essential)\n const utilityCategories = [\n \"amenity=toilets\",\n \"amenity=waste_disposal\",\n \"amenity=recycling\",\n ];\n\n for (const category of utilityCategories) {\n assertEquals(\n prioritized.includes(category),\n false,\n `Prioritized should NOT include utility category: ${category}`,\n );\n }\n});\n",[],[746,803,836],{"_103":844,"_95":845,"_154":846,"_156":804,"_157":139,"_158":847,"_160":161,"_105":848,"_100":159,"_163":226,"_165":849,"_166":22,"_167":-5,"_168":850,"_98":851},"4b5a3676-7816-11f0-9845-0224a6c84d84","places-api.test.ts","734c8f18-754a-11f0-87b3-0224a6c84d84",694,["D",1755069759686],"// Test suite for places API endpoint\n// Tests the TypeScript port of OSM/Overpass place discovery\n\nimport {\n assertEquals,\n assertExists,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport { OverpassService } from \"../../backend/services/overpass-service.ts\";\nimport { PlaceCategorization } from \"../../backend/utils/place-categorization.ts\";\nimport { PlaceCategoryGroup } from \"../../backend/models/place-models.ts\";\n\nDeno.test(\"PlaceCategorization - Category mapping\", () => {\n // Test category group mapping\n assertEquals(\n PlaceCategorization.getCategoryGroup(\"amenity\", \"cafe\"),\n PlaceCategoryGroup.FOOD_AND_DRINK,\n );\n\n assertEquals(\n PlaceCategorization.getCategoryGroup(\"leisure\", \"climbing\"),\n PlaceCategoryGroup.SPORTS,\n );\n\n assertEquals(\n PlaceCategorization.getCategoryGroup(\"shop\", \"supermarket\"),\n PlaceCategoryGroup.FOOD_AND_DRINK,\n );\n\n assertEquals(\n PlaceCategorization.getCategoryGroup(\"tourism\", \"hotel\"),\n PlaceCategoryGroup.ACCOMMODATION,\n );\n});\n\nDeno.test(\"PlaceCategorization - Icon mapping\", () => {\n assertEquals(PlaceCategorization.getIcon(\"amenity\", \"cafe\"), \"☕\");\n assertEquals(PlaceCategorization.getIcon(\"amenity\", \"restaurant\"), \"🍽️\");\n assertEquals(PlaceCategorization.getIcon(\"leisure\", \"climbing\"), \"🧗‍♂️\");\n assertEquals(PlaceCategorization.getIcon(\"shop\", \"supermarket\"), \"🛒\");\n assertEquals(PlaceCategorization.getIcon(\"unknown\", \"tag\"), \"📍\");\n});\n\nDeno.test(\"PlaceCategorization - Get all categories\", () => {\n const categories = PlaceCategorization.getAllCategories();\n\n // Should have categories from all tag types\n assertEquals(categories.includes(\"amenity=cafe\"), true);\n assertEquals(categories.includes(\"leisure=climbing\"), true);\n assertEquals(categories.includes(\"shop=supermarket\"), true);\n assertEquals(categories.includes(\"tourism=hotel\"), true);\n\n // Should be sorted\n const sorted = [...categories].sort();\n assertEquals(categories, sorted);\n});\n\nDeno.test(\"PlaceCategorization - Prioritized categories\", () => {\n const prioritized = PlaceCategorization.getPrioritizedCategories();\n\n // Should include most common places\n assertEquals(prioritized.includes(\"amenity=restaurant\"), true);\n assertEquals(prioritized.includes(\"amenity=cafe\"), true);\n assertEquals(prioritized.includes(\"leisure=climbing\"), true);\n\n // Should be reasonable number (focused on check-in worthy places)\n assertEquals(prioritized.length > 30 && prioritized.length < 50, true);\n});\n\nDeno.test(\"PlaceCategorization - Category objects with IDs\", () => {\n const categoryObjects = PlaceCategorization.getAllCategoryObjects();\n\n // Should have IDs in correct format\n const cafeCategory = categoryObjects.find((c) => c.id === \"amenity_cafe\");\n assertExists(cafeCategory);\n assertEquals(cafeCategory.name, \"Cafe\");\n assertEquals(cafeCategory.icon, \"☕\");\n assertEquals(cafeCategory.osmTag, \"amenity=cafe\");\n assertEquals(cafeCategory.group, PlaceCategoryGroup.FOOD_AND_DRINK);\n});\n\nDeno.test(\"OverpassService - Distance calculation\", () => {\n const service = new OverpassService();\n\n // Access private method via any cast for testing\n const calculateDistance = (service as any).calculateDistance;\n\n // Test known distance (approximately)\n const distance = calculateDistance(37.7749, -122.4194, 37.7849, -122.4094);\n\n // Should be roughly 1.4km between these SF coordinates\n assertEquals(Math.abs(distance - 1400) < 100, true);\n});\n\nDeno.test(\"OverpassService - Distance formatting\", () => {\n const service = new OverpassService();\n\n // Access private method\n const formatDistance = (service as any).formatDistance;\n\n assertEquals(formatDistance(45), \"45m\");\n assertEquals(formatDistance(999), \"999m\");\n assertEquals(formatDistance(1000), \"1.0km\");\n assertEquals(formatDistance(1500), \"1.5km\");\n});\n\n// Mock test for OverpassService (no external API calls)\nDeno.test(\"OverpassService - Mock API query\", async () => {\n // Mock the OverpassService to avoid external API calls\n class MockOverpassService {\n findNearbyPlacesWithDistance(\n _coordinate: { latitude: number; longitude: number },\n _radiusMeters: number,\n ) {\n // Return mock places data\n return [\n {\n id: \"node:123456789\",\n elementType: \"node\" as const,\n elementId: 123456789,\n name: \"Golden Gate Bridge\",\n latitude: 37.8199,\n longitude: -122.4783,\n tags: {\n \"name\": \"Golden Gate Bridge\",\n \"man_made\": \"bridge\",\n },\n address: {\n $type: \"community.lexicon.location.address\" as const,\n name: \"Golden Gate Bridge\",\n locality: \"San Francisco\",\n region: \"CA\",\n country: \"US\",\n },\n category: \"bridge\",\n categoryGroup: undefined,\n icon: \"🌉\",\n distanceMeters: 50,\n formattedDistance: \"50m\",\n },\n {\n id: \"node:987654321\",\n elementType: \"node\" as const,\n elementId: 987654321,\n name: \"Test Cafe\",\n latitude: 37.8200,\n longitude: -122.4784,\n tags: {\n \"name\": \"Test Cafe\",\n \"amenity\": \"cafe\",\n },\n address: {\n $type: \"community.lexicon.location.address\" as const,\n name: \"Test Cafe\",\n street: \"123 Test St\",\n locality: \"San Francisco\",\n region: \"CA\",\n country: \"US\",\n },\n category: \"cafe\",\n categoryGroup: undefined,\n icon: \"☕\",\n distanceMeters: 150,\n formattedDistance: \"150m\",\n },\n ];\n }\n }\n\n const mockService = new MockOverpassService();\n const coordinate = { latitude: 37.8199, longitude: -122.4783 };\n\n const places = await mockService.findNearbyPlacesWithDistance(\n coordinate,\n 1000,\n );\n\n // Test that mock data is returned correctly\n assertEquals(places.length, 2);\n assertEquals(places[0].name, \"Golden Gate Bridge\");\n assertEquals(places[0].distanceMeters, 50);\n assertEquals(places[1].name, \"Test Cafe\");\n assertEquals(places[1].distanceMeters, 150);\n\n // Test that places are properly structured\n for (const place of places) {\n assertExists(place.id);\n assertExists(place.name);\n assertExists(place.latitude);\n assertExists(place.longitude);\n assertExists(place.address);\n assertExists(place.address.name);\n assertExists(place.distanceMeters);\n assertExists(place.formattedDistance);\n assertEquals(typeof place.distanceMeters, \"number\");\n assertEquals(place.distanceMeters >= 0, true);\n }\n});\n",[],[746,803,845],{"_103":853,"_95":854,"_154":855,"_156":804,"_157":139,"_158":856,"_160":161,"_105":857,"_100":32,"_163":226,"_165":858,"_166":22,"_167":-5,"_168":859,"_98":860},"c70d58c6-7496-11f0-b0b3-0224a6c84d84","profile-resolver.test.ts","c70d5966-7496-11f0-b0b3-0224a6c84d84",338,["D",1754685138150],"import {\n assertEquals,\n assertExists,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport {\n ATProtocolProfileResolver,\n MockProfileFetcher,\n} from \"../../backend/utils/profile-resolver.ts\";\nimport { InMemoryStorageProvider } from \"../../backend/utils/storage-provider.ts\";\n\nDeno.test(\"ProfileResolver - resolveProfile with cache hit\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n // Pre-populate cache\n const did = \"did:plc:test123\";\n const cachedProfile = {\n did,\n handle: \"test.bsky.social\",\n displayName: \"Test User\",\n fetchedAt: new Date().toISOString(),\n };\n await storage.setProfile(cachedProfile);\n\n const result = await resolver.resolveProfile(did);\n assertExists(result);\n assertEquals(result.did, did);\n assertEquals(result.handle, \"test.bsky.social\");\n assertEquals(result.displayName, \"Test User\");\n});\n\nDeno.test(\"ProfileResolver - resolveProfile with cache miss\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n const did = \"did:plc:test456\";\n mockFetcher.setMockProfile(did, {\n handle: \"newuser.bsky.social\",\n displayName: \"New User\",\n });\n\n const result = await resolver.resolveProfile(did);\n assertExists(result);\n assertEquals(result.did, did);\n assertEquals(result.handle, \"newuser.bsky.social\");\n assertEquals(result.displayName, \"New User\");\n\n // Verify it was cached\n const cached = await storage.getProfile(did);\n assertExists(cached);\n assertEquals(cached.did, did);\n});\n\nDeno.test(\"ProfileResolver - resolveProfile with stale cache\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n const did = \"did:plc:stale123\";\n\n // Add stale cache entry (25+ hours ago)\n const staleDate = new Date();\n staleDate.setHours(staleDate.getHours() - 25);\n const staleProfile = {\n did,\n handle: \"oldhandle.bsky.social\",\n displayName: \"Old Name\",\n fetchedAt: staleDate.toISOString(),\n };\n await storage.setProfile(staleProfile);\n\n // Set up fresh data\n mockFetcher.setMockProfile(did, {\n handle: \"newhandle.bsky.social\",\n displayName: \"New Name\",\n });\n\n const result = await resolver.resolveProfile(did);\n assertExists(result);\n assertEquals(result.handle, \"newhandle.bsky.social\");\n assertEquals(result.displayName, \"New Name\");\n});\n\nDeno.test(\"ProfileResolver - batchResolveProfiles\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n const dids = [\"did:plc:batch1\", \"did:plc:batch2\", \"did:plc:batch3\"];\n\n // Pre-cache one profile\n await storage.setProfile({\n did: dids[0],\n handle: \"cached.bsky.social\",\n displayName: \"Cached User\",\n fetchedAt: new Date().toISOString(),\n });\n\n // Set up mock data for the others\n mockFetcher.setMockProfile(dids[1], {\n handle: \"user2.bsky.social\",\n displayName: \"User 2\",\n });\n mockFetcher.setMockProfile(dids[2], {\n handle: \"user3.bsky.social\",\n displayName: \"User 3\",\n });\n\n const results = await resolver.batchResolveProfiles(dids);\n assertEquals(results.size, 3);\n assertEquals(results.get(dids[0])?.handle, \"cached.bsky.social\");\n assertEquals(results.get(dids[1])?.handle, \"user2.bsky.social\");\n assertEquals(results.get(dids[2])?.handle, \"user3.bsky.social\");\n});\n\nDeno.test(\"ProfileResolver - refreshStaleProfiles\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n const dids = [\"did:plc:refresh1\", \"did:plc:refresh2\"];\n\n // Add stale profiles\n const staleDate = new Date();\n staleDate.setHours(staleDate.getHours() - 25);\n\n for (const did of dids) {\n await storage.setProfile({\n did,\n handle: `old-${did.slice(-6)}.bsky.social`,\n displayName: \"Old Name\",\n fetchedAt: staleDate.toISOString(),\n });\n\n mockFetcher.setMockProfile(did, {\n handle: `new-${did.slice(-6)}.bsky.social`,\n displayName: \"New Name\",\n });\n }\n\n const refreshed = await resolver.refreshStaleProfiles(10);\n assertEquals(refreshed, 2);\n\n // Verify profiles were updated\n for (const did of dids) {\n const profile = await storage.getProfile(did);\n assertExists(profile);\n assertEquals(profile.handle.startsWith(\"new-\"), true);\n assertEquals(profile.displayName, \"New Name\");\n }\n});\n\nDeno.test(\"ProfileResolver - handles fetch failures gracefully\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n const did = \"did:plc:missing\";\n\n // Don't set up any mock data, so fetch will return null\n\n const result = await resolver.resolveProfile(did);\n assertEquals(result, null);\n});\n\nDeno.test(\"ProfileResolver - returns stale cache on fetch failure\", async () => {\n const storage = new InMemoryStorageProvider();\n const mockFetcher = new MockProfileFetcher();\n const resolver = new ATProtocolProfileResolver(storage, mockFetcher);\n\n const did = \"did:plc:fallback\";\n\n // Add stale cache\n const staleDate = new Date();\n staleDate.setHours(staleDate.getHours() - 25);\n const staleProfile = {\n did,\n handle: \"stale.bsky.social\",\n displayName: \"Stale User\",\n fetchedAt: staleDate.toISOString(),\n };\n await storage.setProfile(staleProfile);\n\n // Don't set up fresh data, so fetch will fail\n\n const result = await resolver.resolveProfile(did);\n assertExists(result);\n assertEquals(result.handle, \"stale.bsky.social\");\n assertEquals(result.displayName, \"Stale User\");\n});\n\nDeno.test(\"MockProfileFetcher - basic functionality\", async () => {\n const mockFetcher = new MockProfileFetcher();\n const did = \"did:plc:mock123\";\n\n mockFetcher.setMockProfile(did, {\n handle: \"mock.bsky.social\",\n displayName: \"Mock User\",\n avatar: \"https://example.com/avatar.jpg\",\n });\n\n const result = await mockFetcher.fetchProfile(did);\n assertExists(result);\n assertEquals(result.did, did);\n assertEquals(result.handle, \"mock.bsky.social\");\n assertEquals(result.displayName, \"Mock User\");\n assertEquals(result.avatar, \"https://example.com/avatar.jpg\");\n assertExists(result.fetchedAt);\n});\n\nDeno.test(\"MockProfileFetcher - generates handle if not provided\", async () => {\n const mockFetcher = new MockProfileFetcher();\n const did = \"did:plc:auto123456\";\n\n mockFetcher.setMockProfile(did, {\n displayName: \"Auto Handle\",\n });\n\n const result = await mockFetcher.fetchProfile(did);\n assertExists(result);\n assertEquals(result.handle, \"123456.bsky.social\");\n});\n\nDeno.test(\"MockProfileFetcher - returns null for unknown DIDs\", async () => {\n const mockFetcher = new MockProfileFetcher();\n const result = await mockFetcher.fetchProfile(\"did:plc:unknown\");\n assertEquals(result, null);\n});\n",[],[746,803,854],{"_103":862,"_95":863,"_154":864,"_156":804,"_157":139,"_158":865,"_160":161,"_105":866,"_100":119,"_163":226,"_165":867,"_166":22,"_167":-5,"_168":868,"_98":869},"daaf4fde-5a7d-11f0-9d68-f69ea79377d9","spatial.test.ts","5801066a-58b4-11f0-a0a5-f69ea79377d9",62,["D",1751815703470],"import {\n assertAlmostEquals,\n assertEquals,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\n\n// Haversine distance calculation (from the API code)\nfunction calculateDistance(\n lat1: number,\n lng1: number,\n lat2: number,\n lng2: number,\n): number {\n const R = 6371; // Earth's radius in km\n const dLat = (lat2 - lat1) * Math.PI / 180;\n const dLng = (lng2 - lng1) * Math.PI / 180;\n const a = Math.sin(dLat / 2) * Math.sin(dLat / 2) +\n Math.cos(lat1 * Math.PI / 180) * Math.cos(lat2 * Math.PI / 180) *\n Math.sin(dLng / 2) * Math.sin(dLng / 2);\n const c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));\n return R * c;\n}\n\nDeno.test(\"Spatial - calculateDistance same point\", () => {\n const distance = calculateDistance(40.7128, -74.0060, 40.7128, -74.0060);\n assertEquals(distance, 0);\n});\n\nDeno.test(\"Spatial - calculateDistance New York to Los Angeles\", () => {\n // NYC: 40.7128° N, 74.0060° W\n // LA: 34.0522° N, 118.2437° W\n const distance = calculateDistance(40.7128, -74.0060, 34.0522, -118.2437);\n\n // Expected distance is approximately 3944 km\n assertAlmostEquals(distance, 3944, 50); // Allow 50km tolerance\n});\n\nDeno.test(\"Spatial - calculateDistance short distance\", () => {\n // Two points in Manhattan, approximately 1km apart\n const lat1 = 40.7589; // Times Square\n const lng1 = -73.9851;\n const lat2 = 40.7505; // Empire State Building\n const lng2 = -73.9934;\n\n const distance = calculateDistance(lat1, lng1, lat2, lng2);\n\n // Should be approximately 1.2 km\n assertAlmostEquals(distance, 1.2, 0.5);\n});\n\nDeno.test(\"Spatial - calculateDistance across equator\", () => {\n // Test crossing the equator\n const distance = calculateDistance(10, 0, -10, 0);\n\n // 20 degrees of latitude ≈ 2222 km\n assertAlmostEquals(distance, 2222, 50);\n});\n\nDeno.test(\"Spatial - calculateDistance across 180th meridian\", () => {\n // Test crossing the international date line\n const distance = calculateDistance(0, 179, 0, -179);\n\n // Should be about 222 km (2 degrees of longitude at equator)\n assertAlmostEquals(distance, 222, 50);\n});\n\nDeno.test(\"Spatial - distance filtering logic\", () => {\n interface TestCheckin {\n id: string;\n latitude: number;\n longitude: number;\n distance?: number;\n }\n\n const centerLat = 40.7128;\n const centerLng = -74.0060;\n const radius = 5; // 5km radius\n\n const checkins: TestCheckin[] = [\n { id: \"nearby1\", latitude: 40.7150, longitude: -74.0080 }, // ~250m away\n { id: \"nearby2\", latitude: 40.7200, longitude: -74.0100 }, // ~1km away\n { id: \"far1\", latitude: 40.8000, longitude: -74.0000 }, // ~10km away\n { id: \"far2\", latitude: 41.0000, longitude: -74.0000 }, // ~32km away\n ];\n\n // Calculate distances and filter\n const nearbyCheckins = checkins\n .map((checkin) => ({\n ...checkin,\n distance: calculateDistance(\n centerLat,\n centerLng,\n checkin.latitude,\n checkin.longitude,\n ),\n }))\n .filter((checkin) => checkin.distance <= radius)\n .sort((a, b) => a.distance - b.distance);\n\n // Should have 2 nearby checkins\n assertEquals(nearbyCheckins.length, 2);\n assertEquals(nearbyCheckins[0].id, \"nearby1\");\n assertEquals(nearbyCheckins[1].id, \"nearby2\");\n\n // Verify distances are calculated and within radius\n assertEquals(nearbyCheckins[0].distance! < radius, true);\n assertEquals(nearbyCheckins[1].distance! < radius, true);\n\n // Verify sorting by distance\n assertEquals(\n nearbyCheckins[0].distance! <= nearbyCheckins[1].distance!,\n true,\n );\n});\n\nDeno.test(\"Spatial - coordinate validation\", () => {\n // Test invalid coordinates\n const invalidLat = calculateDistance(91, 0, 0, 0); // Latitude > 90\n assertEquals(isNaN(invalidLat), false); // Should still calculate, even if unrealistic\n\n const invalidLng = calculateDistance(0, 181, 0, 0); // Longitude > 180\n assertEquals(isNaN(invalidLng), false); // Should still calculate\n});\n\nDeno.test(\"Spatial - precision rounding\", () => {\n const distance = calculateDistance(40.7128, -74.0060, 40.7130, -74.0062);\n const rounded = Math.round(distance * 100) / 100; // 2 decimal places\n\n // Should be a very small distance, properly rounded\n assertEquals(typeof rounded, \"number\");\n assertEquals(rounded >= 0, true);\n assertEquals(rounded < 1, true); // Should be less than 1km\n});\n\nDeno.test(\"Spatial - boundary conditions\", () => {\n // Test at the poles\n const northPole1 = calculateDistance(90, 0, 90, 180);\n assertAlmostEquals(northPole1, 0, 0.001); // All points at north pole are the same (within 1m)\n\n // Test at extreme longitudes\n const extremeLng = calculateDistance(0, -180, 0, 180);\n assertAlmostEquals(extremeLng, 0, 0.001); // -180 and 180 longitude are the same meridian (within 1m)\n});\n",[],[746,803,863],{"_103":871,"_95":872,"_154":873,"_156":804,"_157":139,"_158":874,"_160":161,"_105":875,"_100":32,"_163":226,"_165":876,"_166":22,"_167":-5,"_168":877,"_98":878},"c71dcbf2-7496-11f0-bb83-0224a6c84d84","storage-provider.test.ts","c71dccec-7496-11f0-bb83-0224a6c84d84",340,["D",1754685138258],"import {\n assertEquals,\n assertExists,\n} from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport {\n InMemoryStorageProvider,\n ProfileData,\n} from \"../../backend/utils/storage-provider.ts\";\n\nDeno.test(\"InMemoryStorageProvider - store and retrieve profile\", async () => {\n const storage = new InMemoryStorageProvider();\n const profile: ProfileData = {\n did: \"did:plc:test123\",\n handle: \"test.bsky.social\",\n displayName: \"Test User\",\n avatar: \"https://example.com/avatar.jpg\",\n description: \"A test user profile\",\n fetchedAt: new Date().toISOString(),\n };\n\n await storage.setProfile(profile);\n const retrieved = await storage.getProfile(profile.did);\n\n assertExists(retrieved);\n assertEquals(retrieved.did, profile.did);\n assertEquals(retrieved.handle, profile.handle);\n assertEquals(retrieved.displayName, profile.displayName);\n assertEquals(retrieved.avatar, profile.avatar);\n assertEquals(retrieved.description, profile.description);\n assertEquals(retrieved.fetchedAt, profile.fetchedAt);\n});\n\nDeno.test(\"InMemoryStorageProvider - retrieve non-existent profile\", async () => {\n const storage = new InMemoryStorageProvider();\n const result = await storage.getProfile(\"did:plc:nonexistent\");\n assertEquals(result, null);\n});\n\nDeno.test(\"InMemoryStorageProvider - overwrite existing profile\", async () => {\n const storage = new InMemoryStorageProvider();\n const did = \"did:plc:overwrite123\";\n\n const originalProfile: ProfileData = {\n did,\n handle: \"original.bsky.social\",\n displayName: \"Original Name\",\n fetchedAt: new Date().toISOString(),\n };\n\n const updatedProfile: ProfileData = {\n did,\n handle: \"updated.bsky.social\",\n displayName: \"Updated Name\",\n avatar: \"https://example.com/new-avatar.jpg\",\n fetchedAt: new Date().toISOString(),\n };\n\n await storage.setProfile(originalProfile);\n await storage.setProfile(updatedProfile);\n\n const retrieved = await storage.getProfile(did);\n assertExists(retrieved);\n assertEquals(retrieved.handle, \"updated.bsky.social\");\n assertEquals(retrieved.displayName, \"Updated Name\");\n assertEquals(retrieved.avatar, \"https://example.com/new-avatar.jpg\");\n});\n\nDeno.test(\"InMemoryStorageProvider - getStaleProfiles\", async () => {\n const storage = new InMemoryStorageProvider();\n\n // Create profiles with different timestamps\n const now = new Date();\n const oneHourAgo = new Date(now.getTime() - 1 * 60 * 60 * 1000);\n const sixHoursAgo = new Date(now.getTime() - 6 * 60 * 60 * 1000);\n const twentyFiveHoursAgo = new Date(now.getTime() - 25 * 60 * 60 * 1000);\n\n const profiles: ProfileData[] = [\n {\n did: \"did:plc:fresh\",\n handle: \"fresh.bsky.social\",\n fetchedAt: oneHourAgo.toISOString(),\n },\n {\n did: \"did:plc:medium\",\n handle: \"medium.bsky.social\",\n fetchedAt: sixHoursAgo.toISOString(),\n },\n {\n did: \"did:plc:stale\",\n handle: \"stale.bsky.social\",\n fetchedAt: twentyFiveHoursAgo.toISOString(),\n },\n ];\n\n for (const profile of profiles) {\n await storage.setProfile(profile);\n }\n\n // Get profiles older than 24 hours (stale threshold)\n const staleProfiles = await storage.getStaleProfiles(10, 24);\n\n assertEquals(staleProfiles.length, 1);\n assertEquals(staleProfiles[0].did, \"did:plc:stale\");\n});\n\nDeno.test(\"InMemoryStorageProvider - getStaleProfiles with limit\", async () => {\n const storage = new InMemoryStorageProvider();\n\n // Create multiple stale profiles\n const twentyFiveHoursAgo = new Date();\n twentyFiveHoursAgo.setHours(twentyFiveHoursAgo.getHours() - 25);\n\n const staleProfiles: ProfileData[] = [\n {\n did: \"did:plc:stale1\",\n handle: \"stale1.bsky.social\",\n fetchedAt: new Date(twentyFiveHoursAgo.getTime() - 1000).toISOString(),\n },\n {\n did: \"did:plc:stale2\",\n handle: \"stale2.bsky.social\",\n fetchedAt: new Date(twentyFiveHoursAgo.getTime() - 2000).toISOString(),\n },\n {\n did: \"did:plc:stale3\",\n handle: \"stale3.bsky.social\",\n fetchedAt: new Date(twentyFiveHoursAgo.getTime() - 3000).toISOString(),\n },\n ];\n\n for (const profile of staleProfiles) {\n await storage.setProfile(profile);\n }\n\n // Get only 2 stale profiles\n const result = await storage.getStaleProfiles(2, 24);\n\n assertEquals(result.length, 2);\n // Should be sorted by fetchedAt (oldest first)\n assertEquals(result[0].did, \"did:plc:stale3\");\n assertEquals(result[1].did, \"did:plc:stale2\");\n});\n\nDeno.test(\"InMemoryStorageProvider - getStaleProfiles empty result\", async () => {\n const storage = new InMemoryStorageProvider();\n\n // Add only fresh profiles\n const freshProfile: ProfileData = {\n did: \"did:plc:fresh\",\n handle: \"fresh.bsky.social\",\n fetchedAt: new Date().toISOString(),\n };\n\n await storage.setProfile(freshProfile);\n\n const staleProfiles = await storage.getStaleProfiles(10, 24);\n assertEquals(staleProfiles.length, 0);\n});\n\nDeno.test(\"InMemoryStorageProvider - clear functionality\", () => {\n const storage = new InMemoryStorageProvider();\n\n // Add a profile\n const profile: ProfileData = {\n did: \"did:plc:clear\",\n handle: \"clear.bsky.social\",\n fetchedAt: new Date().toISOString(),\n };\n\n storage.setProfile(profile);\n storage.clear();\n\n // Profile should be gone after clear\n storage.getProfile(\"did:plc:clear\").then((result) => {\n assertEquals(result, null);\n });\n});\n\nDeno.test(\"InMemoryStorageProvider - ensureTablesExist\", async () => {\n const storage = new InMemoryStorageProvider();\n // Should not throw for in-memory storage\n await storage.ensureTablesExist();\n});\n\nDeno.test(\"InMemoryStorageProvider - profile with minimal data\", async () => {\n const storage = new InMemoryStorageProvider();\n const minimalProfile: ProfileData = {\n did: \"did:plc:minimal\",\n handle: \"minimal.bsky.social\",\n fetchedAt: new Date().toISOString(),\n };\n\n await storage.setProfile(minimalProfile);\n const retrieved = await storage.getProfile(minimalProfile.did);\n\n assertExists(retrieved);\n assertEquals(retrieved.did, \"did:plc:minimal\");\n assertEquals(retrieved.handle, \"minimal.bsky.social\");\n assertEquals(retrieved.displayName, undefined);\n assertEquals(retrieved.avatar, undefined);\n assertEquals(retrieved.description, undefined);\n assertExists(retrieved.fetchedAt);\n});\n",[],[746,803,872],[746,803],[746],{"_103":882,"_95":703,"_154":883,"_156":-5,"_157":139,"_158":884,"_160":161,"_105":885,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":886,"_98":896},"f66fe6f0-8676-11f0-9b7d-0224a6c84d84","f66fe7a4-8676-11f0-9b7d-0224a6c84d84",919,["D",1756650594721],[887],{"_103":888,"_95":889,"_154":890,"_156":883,"_157":139,"_158":891,"_160":161,"_105":892,"_100":32,"_163":226,"_165":893,"_166":22,"_167":-5,"_168":894,"_98":895},"f68ee6c2-8676-11f0-9d49-0224a6c84d84","valtown-fallback.d.ts","f68ee762-8676-11f0-9d49-0224a6c84d84",920,["D",1756650594924],"/**\n * Fallback types for Val Town services when external types are unavailable\n * Used as backup when https://www.val.town/types/valtown.d.ts is unavailable\n */\n\ndeclare module \"https://esm.town/v/std/sqlite2\" {\n export interface SQLiteExecuteResult {\n columns: string[];\n rows: any[][];\n }\n\n export interface SQLite {\n execute(\n options: { sql: string; args?: any[] },\n ): Promise;\n }\n\n export const sqlite: SQLite;\n}\n\ndeclare module \"https://esm.town/v/std/blob\" {\n export interface Blob {\n get(key: string): Promise;\n set(key: string, value: any): Promise;\n delete(key: string): Promise;\n }\n\n export const blob: Blob;\n}\n\ndeclare module \"https://esm.town/v/std/utils*\" {\n export function serveFile(path: string, base: string): Promise;\n}\n",[],[703,889],[703],{"_103":898,"_95":899,"_154":900,"_156":-5,"_157":139,"_158":176,"_160":161,"_105":901,"_100":32,"_163":177,"_165":902,"_166":22,"_167":-5,"_168":903,"_98":904},"582a883c-58b4-11f0-acd5-f69ea79377d9",".gitignore","582a8904-58b4-11f0-acd5-f69ea79377d9",["D",1751619204496],"# AnchorPDS .gitignore\n# Practical gitignore for Deno + Val Town + SQLite project\n\n# === Environment & Secrets ===\n.env\n.env.*\n!.env.example\n*.key\n*.pem\nconfig/secrets.json\n\n# === Deno ===\n# Deno cache and lock files\n.deno/\ndeno.lock\n\n# === Val Town ===\n# Val Town CLI cache and temp files\n.valtown/\n.vt/\nvaltown-cache/\n\n# === Database ===\n# Local SQLite databases (Val Town uses hosted SQLite)\n*.db\n*.sqlite\n*.sqlite3\ndata/\ndb/\n\n# === Testing & Coverage ===\ncoverage/\ntest-results/\n.coverage\n*.lcov\n*.log\n\n# === Development ===\n# IDE and editor files\n.vscode/\n.idea/\n*.swp\n*.swo\n*~\n.DS_Store\nThumbs.db\n\n# === Temporary Files ===\ntmp/\ntemp/\n*.tmp\n*.temp\n\n# === Logs ===\nlogs/\n*.log\nnpm-debug.log*\nyarn-debug.log*\nyarn-error.log*\n\n# === Node.js (if any tooling uses it) ===\nnode_modules/\nnpm-debug.log\nyarn-error.log\npackage-lock.json\nyarn.lock\n\n# === Build artifacts ===\ndist/\nbuild/\nout/\n\n# === Backup files ===\n*.bak\n*.backup\n*.orig\n\n# === OS Generated ===\n.DS_Store\n.DS_Store?\n._*\n.Spotlight-V100\n.Trashes\nehthumbs.db\nThumbs.db\n\n# === Documentation builds ===\ndocs/build/\nsite/\n\n# === Val Town deployment artifacts ===\n.val/\ndeployment-logs/\n\n# === LLM Conntext ===\nLLMDocs/",[],[899],{"_103":906,"_95":907,"_154":908,"_156":-5,"_157":139,"_158":909,"_160":161,"_105":910,"_100":32,"_163":177,"_165":911,"_166":22,"_167":-5,"_168":912,"_98":913},"58443494-58b4-11f0-9539-f69ea79377d9",".vtignore","58443566-58b4-11f0-9539-f69ea79377d9",30,["D",1751619204666],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor\nLLMDocs",[],[907],{"_103":915,"_95":916,"_154":917,"_156":-5,"_157":139,"_158":918,"_160":161,"_105":919,"_100":920,"_163":177,"_165":921,"_166":22,"_167":-5,"_168":922,"_98":923},"1a4a57fc-7de1-11f0-91d2-0224a6c84d84","CLAUDE.md","5847d28e-58b4-11f0-a0a5-f69ea79377d9",821,["D",1755706621056],19,"# CLAUDE.md\n\nThis file provides guidance to Claude Code (claude.ai/code) when working with\ncode in this repository.\n\n## Project Overview\n\nThis is the **Anchor AppView** - a location-based social feed generator and\nOAuth authentication system for the Anchor app, built on the AT Protocol\n(Bluesky) infrastructure. The system ingests check-in data from the\ndecentralized AT Protocol network, provides spatial and social feeds, and\nincludes a complete OAuth WebView implementation for mobile app integration.\n\n## Architecture\n\n### Entry Point and Deployment\n\n- **Main Entry**: `main.tsx` (Val Town HTTP function with\n `// @val-town anchordashboard` comment)\n- **Base URL**: `https://dropanchor.app` (configurable via `ANCHOR_BASE_URL` env\n var)\n- **Platform**: Single Hono-based web server deployed on Val Town using Deno\n runtime\n\n### Core Components\n\n1. **HTTP Server (main.tsx)** - Unified Hono server handling all routes:\n - OAuth authentication endpoints\n - AppView API endpoints (global, nearby, user, following feeds)\n - Mobile OAuth WebView pages\n - React frontend serving\n - Admin API endpoints\n\n2. **OAuth Authentication System (`backend/oauth/`)** - Complete OAuth 2.0 +\n DPoP implementation:\n - PKCE flow with automatic handle resolution and PDS discovery\n - Mobile app detection for WebView integration\n - Custom URL scheme redirect: `anchor-app://auth-callback`\n - Session management with SQLite storage\n\n3. **AppView Data Layer (`backend/api/anchor-api.ts`)** - AT Protocol compliant\n feed system:\n - Immediate database saves when check-ins are created via app\n - StrongRef address resolution and caching\n - Spatial queries using Haversine distance calculations\n - Social graph integration with Bluesky\n\n4. **React Dashboard (`frontend/`)** - Web interface for authentication and feed\n management\n\n### Key Technologies\n\n- **AT Protocol** - Decentralized social networking with OAuth 2.0 + DPoP\n authentication\n- **Val Town** - Serverless platform deployment with Deno runtime\n- **SQLite** - Database for check-ins, addresses, social graph, and OAuth\n sessions\n- **Hono** - Lightweight web framework for unified API serving\n- **React 18.2.0** - Frontend dashboard with TypeScript\n\n## Database Schema\n\nThe system uses five main tables:\n\n- `checkins_v1` - Main check-ins with coordinates and cached address data\n- `address_cache_v1` - Cached venue/address information from StrongRef\n resolution\n- `profile_cache_v1` - Cached user profile data (display names, avatars)\n- `user_follows_v1` - Social graph data for following-based feeds\n- `oauth_sessions` - OAuth session storage with DPoP keys and user profiles\n- `processing_log_v1` - Monitoring and operational logging\n\n## Development Commands\n\n### Deno Tasks\n\nThe project includes several Deno tasks for common development workflows:\n\n- `deno task quality` - Run formatter, linter, type checking, and all tests in\n sequence\n- `deno task deploy` - Deploy to Val Town (runs quality checks first)\n- `deno task fmt` - Format code using deno fmt\n- `deno task lint` - Run linter to check code quality\n- `deno task check` - TypeScript type checking for all source files\n- `deno task test` - Run all tests with `--allow-all` permissions\n- `deno task test:unit` - Run unit tests only\n- `deno task test:integration` - Run integration tests only\n- `deno task test:watch` - Run tests in watch mode for development\n\n### Testing\n\n- `./scripts/test.sh` - Run complete test suite (unit + integration)\n- `deno test --allow-all` - Run all tests directly\n- Test files use comprehensive mocking for Val Town services (sqlite, blob\n storage)\n\n### Deployment\n\n- `./scripts/deploy.sh` - One-click deployment to Val Town using CLI\n- `vt create cron|http --file ` - Deploy individual functions\n- Requires Val Town CLI: `npm install -g @valtown/cli`\n\n### Debugging\n\n- `deno run --allow-net scripts/debug.ts` - Check data availability and API\n status\n- `deno run --allow-net scripts/debug.ts --check-data` - Check AT Protocol\n records only\n- `deno run --allow-net scripts/debug.ts --test-api` - Test API endpoints only\n\n## Key Features\n\n- **Immediate feed updates** - check-ins appear instantly when created via app\n- **Embedded location data** with coordinates and address details included in\n check-in records\n- **Spatial queries** for nearby check-ins using coordinate-based distance\n calculations\n- **Social feeds** leveraging Bluesky's social graph for personalized content\n- **Optimized architecture** with direct database saves eliminating ingestion\n delays\n\n## API Endpoints\n\n**Base URL**: `https://dropanchor.app`\n\n### AppView API\n\n- `/api/global` - Recent check-ins from all users with pagination\n- `/api/nearby` - Spatial queries for check-ins within specified radius\n- `/api/user` - User-specific check-ins\n- `/api/following` - Check-ins from followed users (requires social graph sync)\n- `/api/stats` - AppView health and statistics\n- `/api/places/nearby` - OpenStreetMap POI discovery via Overpass API\n- `/api/places/categories` - Complete category system for mobile app consumption\n\n#### Places Categories API Endpoint\n\nThe `/api/places/categories` endpoint provides comprehensive category data\ndesigned for mobile app consumption, enabling apps to cache and use the complete\ncategory system locally.\n\n**Response Format:**\n\n```json\n{\n \"categories\": [\n {\n \"id\": \"amenity_restaurant\",\n \"name\": \"Restaurant\",\n \"icon\": \"🍽️\",\n \"group\": \"FOOD_AND_DRINK\",\n \"osmTag\": \"amenity=restaurant\"\n }\n // ... 56 total categories\n ],\n \"defaultSearch\": [\n \"amenity=restaurant\",\n \"amenity=cafe\"\n // ... 37 categories optimized for default search queries\n ],\n \"sociallyRelevant\": [\n \"amenity=restaurant\",\n \"tourism=attraction\"\n // ... 37 categories suitable for social check-ins\n ],\n \"metadata\": {\n \"totalCategories\": 56,\n \"defaultSearchCount\": 37,\n \"sociallyRelevantCount\": 37\n }\n}\n```\n\n**Usage Notes:**\n\n- **Categories**: Complete category objects with UI-ready data (names, icons,\n groups)\n- **Default Search**: OSM tags for default Overpass API queries when user\n doesn't specify categories\n- **Socially Relevant**: Categories appropriate for social check-in experiences\n- **Metadata**: Category counts for validation and UI display\n- **Mobile Integration**: Designed for caching in mobile apps to eliminate\n hardcoded category arrays\n\n### OAuth Authentication API\n\n- `/client-metadata.json` - OAuth client metadata endpoint\n- `/api/auth/start` - Initiate OAuth flow (POST with handle)\n- `/oauth/callback` - Complete OAuth token exchange\n- `/api/auth/session` - Session validation for web and mobile (auto-extends\n session lifetime)\n- `/api/auth/logout` - Session cleanup\n- `/api/auth/validate-mobile-session` - Mobile token validation with automatic\n token refresh\n- `/api/auth/refresh-mobile-token` - Explicit mobile token refresh endpoint\n\n### Mobile OAuth WebView\n\n- `/mobile-auth` - Mobile-optimized OAuth login page for WebView integration\n\n### Frontend API (Dashboard)\n\n- `/api/feed` - Dashboard feed data\n- `/api/admin/stats` - Administrative statistics\n- `/api/admin/backfill` - Manual data backfill operations\n- `/api/admin/discover-checkins` - Comprehensive checkin discovery\n- `/api/admin/backfill-profiles` - Profile data backfill\n- `/api/admin/resolve-addresses` - Address resolution operations\n\n## Mobile OAuth WebView Integration\n\nThe system includes a complete OAuth authentication flow designed for mobile app\nWebView integration with extended session duration (30+ days):\n\n### Mobile Authentication Flow\n\n1. **iOS app loads WebView**: `https://dropanchor.app/mobile-auth`\n2. **User completes OAuth**: Beautiful mobile-optimized login interface with\n auto-completion\n3. **Mobile app detection**: Server detects WebView context via User-Agent and\n Referer headers\n4. **Custom URL scheme redirect**: Success page triggers\n `anchor-app://auth-callback` with tokens\n5. **iOS app handles callback**: Parse authentication data from URL parameters\n\n### Mobile App Detection Logic\n\n- User-Agent contains \"AnchorApp\"\n- Referer from `/mobile-auth` endpoint\n- iPhone Mobile user agents\n- Automatically routes mobile vs web authentication flows\n\n### Authentication Data Format\n\nThe mobile callback URL includes all necessary authentication data:\n\n```\nanchor-app://auth-callback?access_token=...&refresh_token=...&did=...&handle=...&session_id=...&avatar=...&display_name=...\n```\n\n### iOS Integration Requirements\n\n- **URL Scheme Registration**: `anchor-app` in Info.plist\n- **WebView Configuration**: Set User-Agent to \"AnchorApp\" for detection\n- **Secure Storage**: Store tokens in iOS Keychain for production apps\n- **Session Management**: Use session validation endpoints for token\n verification with automatic refresh\n\n### Session Duration & Token Management\n\n- **Extended Sessions**: Sessions now persist for 30+ days with automatic\n lifetime extension\n- **Token Refresh**: Automatic token refresh when AT Protocol access tokens\n expire\n- **Session Touching**: Session validation endpoints automatically extend\n session lifetime\n- **Database Cleanup**: Sessions are only cleaned up after 90 days of inactivity\n (extended from 30 days)\n- **Mobile Token Refresh**: Dedicated endpoint for mobile clients to explicitly\n refresh tokens\n\n## Implementation Phases\n\nThe project is structured in phases:\n\n1. **Phase 1**: Core infrastructure and basic ingestion\n2. **Phase 2**: Address resolution and caching\n3. **Phase 3**: Global feed APIs and spatial queries\n4. **Phase 4**: Social features and following feeds\n\n## Val Town Deployment\n\nThe system deploys as a single unified HTTP function on Val Town:\n\n- **Main Function**: `anchordashboard` (main.tsx) - Unified Hono server handling\n all routes\n- **Deployment Command**: `deno task deploy` - Runs quality checks and pushes to\n Val Town\n- **Platform Integration**: Uses Val Town CLI (`vt push`) for deployment\n- **Database Initialization**: Automatic SQLite table creation on startup\n\n### Key Deployment Notes\n\n- **Single Entry Point**: All functionality consolidated in main.tsx for\n simplified deployment\n- **Static File Serving**: Frontend files served via Val Town utils with\n `serveFile`\n- **Environment Variables**: Base URL configurable via `ANCHOR_BASE_URL`\n- **Database Schema**: Version-based table naming for schema evolution\n\n## Val Town Development Guidelines\n\n### Code Standards\n\n- Use TypeScript for all Val Town functions\n- Never hardcode secrets - always use environment variables with\n `Deno.env.get('keyname')`\n- **Import SQLite using**\n `import { sqlite } from \"https://esm.town/v/std/sqlite2\"`\n - ⚠️ **CRITICAL**: Use `sqlite2` not `sqlite` (the old path is deprecated)\n - Val Town updated their sqlite module - always use the `sqlite2` version\n- Import blob storage using `import { blob } from \"https://esm.town/v/std/blob\"`\n- Use `https://esm.sh` for external dependencies\n- All functions must be properly typed with TypeScript interfaces\n\n### SQLite Best Practices\n\n- When changing table schema, increment table name (e.g., `checkins_v1` →\n `checkins_v2`)\n- Always create tables before querying with `IF NOT EXISTS`\n- Use proper indexing for coordinate-based spatial queries\n- Initialize tables on every function execution for robustness\n\n#### SQLite API Format (sqlite2)\n\nThe new sqlite2 API uses object format for queries:\n\n```typescript\n// CORRECT (sqlite2 format)\nawait sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [userId],\n});\n\n// INCORRECT (old format - will not work)\nawait sqlite.execute(\"SELECT * FROM users WHERE id = ?\", [userId]);\n```\n\n#### Result Format Conversion\n\nThe sqlite2 API returns `{ columns, rows }` where rows are arrays. Use helper\nfunction:\n\n```typescript\n// Helper function (already implemented in session.ts and storage-provider.ts)\nfunction rowsToObjects(\n columns: string[],\n rows: any[][],\n): Record[] {\n return rows.map((row) => {\n const obj: Record = {};\n columns.forEach((column, index) => {\n obj[column] = row[index];\n });\n return obj;\n });\n}\n\n// Usage\nconst result = await sqlite.execute({ sql: \"SELECT * FROM users\", args: [] });\nconst objects = rowsToObjects(result.columns, result.rows);\n```\n\n### Val Town Triggers\n\n- **Cron Functions**: Export default async function with no parameters\n- **HTTP Functions**: Export default async function with `(req: Request)`\n parameter\n\n### Error Handling\n\n- Let errors bubble up with full context rather than catching and logging\n- Use comprehensive error tracking in processing logs\n- Handle AT Protocol save failures gracefully with fallback strategies\n\n### Troubleshooting Common Issues\n\n#### SQLite Module Errors\n\nIf you encounter `Module not found` errors with SQLite:\n\n1. **Check import path**: Must use `https://esm.town/v/std/sqlite2` (not\n `sqlite`)\n2. **Update API calls**: Use object format `{ sql: \"...\", args: [...] }`\n3. **Row format**: Results are arrays, use `rowsToObjects()` helper for objects\n4. **Force refresh**: Add comment to trigger redeployment if cached\n\n```typescript\n// Common error patterns and fixes:\n\n// ❌ WRONG - old import path\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ✅ CORRECT - new import path\nimport { sqlite } from \"https://esm.town/v/std/sqlite2\";\n\n// ❌ WRONG - old API format\nawait sqlite.execute(\"SELECT * FROM users WHERE id = ?\", [id]);\n\n// ✅ CORRECT - new API format\nawait sqlite.execute({ sql: \"SELECT * FROM users WHERE id = ?\", args: [id] });\n```\n\n## Important Implementation Details\n\n- **StrongRef Address Resolution**: Check-in records contain `addressRef`\n StrongRefs that must be resolved to separate address records and cached\n\n### Check-in Record Structure (Current Format)\n\n#### AT Protocol Record Format (when queried directly)\n\n```json\n{\n \"uri\": \"at://did:plc:example/app.dropanchor.checkin/abc123\",\n \"value\": {\n \"text\": \"Just testing my new check-in records\",\n \"$type\": \"app.dropanchor.checkin\",\n \"createdAt\": \"2025-07-06T15:03:15Z\",\n \"coordinates\": {\n \"$type\": \"community.lexicon.location.geo\",\n \"latitude\": \"52.080178\",\n \"longitude\": \"4.3578971\"\n },\n \"addressRef\": {\n \"uri\": \"at://did:plc:example/community.lexicon.location.address/venue123\",\n \"cid\": \"bafyreicv3pecq6fuua22xcoguxep76otivb33nlaofzl76fpagczo5t5jm\"\n }\n }\n}\n```\n\n#### Immediate Save Process (app-created check-ins)\n\nWhen a check-in is created via the mobile app:\n\n1. **Create address record** in user's PDS via AT Protocol\n2. **Create check-in record** in user's PDS with StrongRef to address\n3. **Immediately save to local database** using the same processing logic\n4. **Check-in appears instantly** in all feeds without any ingestion delay\n\nThis eliminates the need for periodic crawling or real-time ingestion systems,\nproviding the best user experience with instant feed updates.\n\n### Address Resolution Process\n\n1. **Ingest check-in** with `coordinates` and `addressRef` StrongRef\n2. **Store StrongRef** in `address_ref_uri` and `address_ref_cid` fields\n3. **Resolve StrongRef** to separate address record using address resolver\n4. **Cache address data** in `cached_address_*` fields for fast API responses\n5. **Return complete objects** in API feeds with resolved address data\n\n- **Social Graph Integration**: Following feeds require syncing follow\n relationships from Bluesky's public API\n- **Spatial Indexing**: Performance depends on proper SQLite indexing for\n coordinate-based queries\n- **Rate Limiting**: Social graph sync includes rate limiting to respect API\n constraints\n- **Error Handling**: Comprehensive error tracking for monitoring ingestion\n health\n- **Data Processing Pipeline**: Extracts coordinates from `coordinates` field\n and resolves `addressRef` StrongRefs to cache complete address data\n- **Hybrid Storage**: SQLite for relational data, blob storage for key-value\n caching\n\n## Testing Architecture\n\nThe project includes comprehensive testing:\n\n- **Unit Tests**: Mock Val Town services (sqlite, blob) for isolated testing\n- **Integration Tests**: Full API endpoint testing with realistic data flows\n- **Spatial Tests**: Haversine distance calculations with edge case handling\n- **Database Tests**: Schema validation and query testing with mock SQLite\n- **Test Coverage**: 31 tests across 5 test files ensuring reliability\n\n### Test Patterns\n\n- Use `assertAlmostEquals` for floating-point spatial calculations\n- Mock external services comprehensively but realistically\n- Test error conditions and edge cases (coordinate validation, cache expiry)\n- Validate TypeScript interfaces with proper type casting\n\n## Mobile App Integration\n\n### OAuth WebView Flow\n\nThe system provides complete OAuth authentication for the Anchor iOS app:\n\n- **Mobile detection**: Automatically detects iOS WebView requests via\n User-Agent\n- **PDS URL resolution**: Resolves user's actual PDS from DID document (supports\n personal PDS servers)\n- **User registration**: Automatically registers authenticated users for session\n management and immediate check-in processing\n- **Custom URL scheme**: Returns auth data via `anchor-app://auth-callback` with\n all required parameters\n\n### Critical OAuth Implementation Details\n\n- **PDS URL parameter**: Backend includes resolved `pds_url` in mobile callback\n (line 486 in `endpoints.ts`)\n- **Handle resolution**: Tries multiple resolution services before falling back\n to defaults\n- **Session storage**: Stores complete OAuth session data including PDS\n endpoints in SQLite\n- **Error handling**: Graceful handling of OAuth failures without breaking\n mobile app flow\n\n### Mobile Callback URL Format\n\n```\nanchor-app://auth-callback?access_token=...&refresh_token=...&did=...&handle=...&session_id=...&pds_url=...&avatar=...&display_name=...\n```\n\n## Development Workflow with iOS App\n\n### Common Development Pattern\n\n1. Make changes to backend OAuth/API logic\n2. Run `deno task quality` to verify all tests pass\n3. Deploy with `deno task deploy`\n4. Test iOS app integration with new backend\n5. Verify OAuth flow works with personal PDS servers\n\n### Troubleshooting OAuth Issues\n\n- **Missing PDS URL**: Check if `pds_url` parameter is included in mobile\n redirect\n- **Personal PDS failures**: Verify DID document resolution and PDS endpoint\n extraction\n- **Session issues**: Check `oauth_sessions` table for proper session storage\n\n## Date Format Compatibility\n\n### API Response Format\n\nThe system returns ISO8601 timestamps in two formats:\n\n- **With fractional seconds**: `\"2025-08-11T18:34:55.966Z\"` (real-time data)\n- **Without fractional seconds**: `\"2025-08-11T18:34:55Z\"` (legacy/processed\n data)\n\n### iOS App Compatibility\n\nEnsure consistent date formatting for iOS client consumption:\n\n- Backend stores timestamps with full precision when available\n- API responses maintain original timestamp format from AT Protocol records\n- iOS client handles both formats via flexible parsing utility\n\nThe system is designed to scale within Val Town's resource limits while\nmaintaining full AT Protocol compatibility for decentralized social networking.\n",[],[916],{"_103":925,"_95":926,"_154":927,"_156":-5,"_157":139,"_158":928,"_160":161,"_105":929,"_100":930,"_163":177,"_165":931,"_166":22,"_167":-5,"_168":932,"_98":933},"1a336c5e-7de1-11f0-a51c-0224a6c84d84","README.md","5836c7aa-58b4-11f0-a9f0-f69ea79377d9",820,["D",1755706620743],12,"# Anchor AppView\n\nA complete location-based social feed generator and web interface built on the\nAT Protocol for decentralized social networking. Provides both API endpoints for\nmobile clients and a web interface for viewing and sharing check-ins.\n\n## 🏗️ Architecture\n\nThe system consists of 4 main components:\n\n- **Check-in Creation** - Immediate database saves when check-ins are created\n via mobile app\n- **API** - RESTful APIs for global, nearby, user, and following feeds\n- **Web Interface** - React-based web frontend for viewing feeds and shareable\n checkin detail pages\n- **Social** - Social graph sync from Bluesky for following feeds\n\n## 📁 Project Structure\n\n```\nbackend/\n├── ingestion/ # Check-in processing logic\n│ ├── record-processor.ts # Processes check-in records for database storage\n│ ├── followers-crawler.ts # Social graph data collection\n│ └── followers-processor.ts # Social relationship processing\n├── api/ # HTTP API endpoints\n│ ├── anchor-api.ts # Main AppView API\n│ └── checkins.ts # Check-in creation with immediate saves\n├── admin/ # Administrative tools and backfill operations\n└── utils/ # Shared utilities\n ├── profile-resolver.ts # Profile caching and resolution\n └── storage-provider.ts # Database abstraction layer\n\nfrontend/\n├── main.tsx # React app entry point and routing\n├── components/ # React components\n│ ├── CheckinDetail.tsx # Individual checkin detail view with map\n│ ├── Feed.tsx # Global feed component\n│ └── Layout.tsx # App layout and navigation\n└── types/\n └── index.ts # TypeScript type definitions\n\ndatabase/\n├── database-schema.sql # SQLite schema and indexes\n└── add-profile-cache.sql # Profile cache migration\n\ndocs/\n├── api-documentation.md # Complete API reference for client development\n└── deployment-guide.md # Deployment instructions\n\nscripts/\n├── deploy.sh # One-click deployment script\n├── test.sh # Run complete test suite\n├── debug.ts # Debug data availability and API status\n└── monitor-api.sh # Monitor deployed API status\n\ntests/\n├── unit/ # Unit tests for individual functions\n│ ├── handle-resolver.test.ts\n│ ├── profile-resolver.test.ts # Profile caching and resolution\n│ ├── address-cache.test.ts\n│ ├── database.test.ts\n│ └── spatial.test.ts\n├── integration/ # Integration tests for API endpoints\n│ ├── api.test.ts\n│ └── api-profiles.test.ts # API endpoints with profile data\n└── fixtures/ # Test data and fixtures\n └── test-data.ts\n```\n\n## 🚀 Quick Start\n\n### Deployment\n\n```bash\ndeno task deploy # Runs quality checks and pushes to Val Town\n```\n\n> **Note**: No manual database setup required! Tables are created automatically\n> when functions first run.\n\n## 🔌 API Endpoints\n\n**Base URL**: `https://dropanchor.app`\n\n### Feed APIs\n\n#### Global Feed\n\n```http\nGET https://dropanchor.app/api/global?limit=50&cursor=2025-06-29T15:00:00Z\n```\n\nRecent check-ins from all users with pagination.\n\n#### Nearby Checkins\n\n```http\nGET https://dropanchor.app/api/nearby?lat=52.0705&lng=4.3007&radius=5&limit=50\n```\n\nSpatial query for check-ins within specified radius (km).\n\n#### User Checkins\n\n```http\nGET https://dropanchor.app/api/user?did=did:plc:abc123&limit=50\n```\n\nAll check-ins from a specific user.\n\n#### Following Feed\n\n```http\nGET https://dropanchor.app/api/following?user=did:plc:abc123&limit=50&cursor=2025-06-29T15:00:00Z\n```\n\nCheck-ins from people the specified user follows on Bluesky.\n\n### Individual Checkin\n\n#### Checkin Detail API\n\n```http\nGET https://dropanchor.app/api/checkin/{rkey}\n```\n\nIndividual checkin data by record key for detail views and sharing.\n\n### System APIs\n\n#### Statistics\n\n```http\nGET https://dropanchor.app/api/stats\n```\n\nAppView health metrics and processing statistics.\n\n## 🌐 Web Interface\n\n### Public Web Pages\n\n#### Global Feed\n\n```\nhttps://dropanchor.app/\n```\n\nWeb interface showing the global feed of check-ins.\n\n#### Shareable Checkin Details\n\n```\nhttps://dropanchor.app/checkin/{rkey}\n```\n\nIndividual checkin detail page with interactive map, optimized for sharing on\nsocial media with Open Graph meta tags.\n\n## 📚 API Documentation\n\nFor complete API documentation including examples, data models, and SDK code\nsamples, see:\n\n**[📖 API Documentation](docs/api-documentation.md)**\n\n## 📊 Database Schema\n\nThe system uses 5 main SQLite tables:\n\n- `checkins_v1` - Main check-ins with coordinates and cached address data\n- `address_cache_v1` - Resolved venue/address information from strongrefs\n- `profile_cache_v1` - Cached user profile data (display names, avatars)\n- `user_follows_v1` - Social graph data for following-based feeds\n- `processing_log_v1` - Monitoring and operational logging\n\n## 🌟 Key Features\n\n### Backend Features\n\n- **Immediate Updates**: Check-ins appear instantly in feeds when created via\n app\n- **Address Resolution**: Automatic strongref resolution with caching\n- **Profile Resolution**: Automatic profile data fetching and caching\n- **Spatial Queries**: Nearby check-ins using Haversine distance calculations\n- **Social Integration**: Following feeds leveraging Bluesky's social graph\n- **Performance**: SQLite with proper indexing for fast queries\n- **Optimized Architecture**: Direct database saves eliminating ingestion delays\n\n### Web Interface Features\n\n- **Global Feed View**: Browse all check-ins with author profiles and timestamps\n- **Shareable Checkin Pages**: Individual checkin detail pages with interactive\n maps\n- **Interactive Maps**: OpenStreetMap integration via Leaflet with CartoDB tiles\n- **Social Sharing**: Optimized sharing with Web Share API and copy\n functionality\n- **Responsive Design**: Mobile-friendly interface using system fonts\n- **Open Graph Tags**: Rich social media previews for shared checkin URLs\n\n## 🔧 Development\n\n### Known Technical Debt\n\n- **Share URL Collisions**: Currently using AT Protocol rkeys as unique\n identifiers in share URLs (`/checkin/{rkey}`). While collision risk is\n negligible at current scale (~32 simultaneous checkins per microsecond for 50%\n collision probability), rkeys only provide 10 bits of entropy and are not\n cryptographically guaranteed to be globally unique. Consider migrating to\n composite identifiers (DID+rkey) or backend-generated UUIDs if collision\n issues emerge at scale.\n\n### Testing\n\nThe project includes comprehensive tests for all components:\n\n**Unit Tests**:\n\n- `profile-resolver.test.ts` - Profile caching, resolution, and refresh logic\n- `handle-resolver.test.ts` - Handle resolution from DIDs\n- `address-cache.test.ts` - Address caching and resolution\n- `database.test.ts` - Database operations\n- `spatial.test.ts` - Spatial calculations\n- `record-processor.test.ts` - Check-in processing and immediate saves\n\n**Integration Tests**:\n\n- `api-profiles.test.ts` - API endpoints with profile data included\n- `api.test.ts` - Core API functionality\n\n```bash\n# Run all tests\n./scripts/test.sh\n\n# Run specific test suites\ndeno test --allow-all tests/unit/ # Unit tests only\ndeno test --allow-all tests/integration/ # Integration tests only\n\n# Run tests in watch mode\n./scripts/test.sh --watch\n\n# Run with coverage\n./scripts/test.sh --coverage\n```\n\n### Val Town Best Practices\n\n- Use TypeScript for all functions\n- **Import SQLite**: `import { sqlite } from \"https://esm.town/v/std/sqlite2\"`\n - ⚠️ **IMPORTANT**: Always use `sqlite2`, not `sqlite` (deprecated)\n - Use object format: `await sqlite.execute({ sql: \"...\", args: [...] })`\n- Import blob storage: `import { blob } from \"https://esm.town/v/std/blob\"`\n- Use `https://esm.sh` for external dependencies\n- Never hardcode secrets - use `Deno.env.get('keyname')`\n- Let errors bubble up with full context rather than catching and logging\n\n### Data Storage Strategy\n\n- **SQLite**: Primary data (checkins, social graph, processing logs)\n- **Blob Storage**: Caching layer for address resolution with automatic expiry\n- **Schema Changes**: Increment table versions (e.g., `checkins_v1` →\n `checkins_v2`)\n- Always create tables with `IF NOT EXISTS` on function startup\n\n## 📈 Monitoring\n\n- Monitor `/stats` endpoint for system health\n- Check `processing_log_v1` for ingestion metrics\n- Use built-in logging and debugging tools\n- Monitor SQLite performance as data grows\n\n## 🔒 Security\n\n- All API endpoints include proper CORS headers\n- Public APIs only - no authentication required\n- Rate limiting built into external service calls\n- No sensitive data logged or stored\n\n## 🌐 AT Protocol Integration\n\nThe AppView is fully compatible with the AT Protocol ecosystem:\n\n- Creates records via `com.atproto.repo.createRecord` with immediate local saves\n- Resolves DIDs using PLC directory and Slingshot resolver\n- Supports personal PDS servers with automatic DID document resolution\n- Integrates with Bluesky social graph APIs for following feeds\n\n## 📄 License\n\nThis implementation is part of the Anchor project for location-based social\nnetworking on the AT Protocol.\n",[],[926],{"_103":935,"_95":936,"_154":937,"_156":-5,"_157":139,"_158":938,"_160":161,"_105":939,"_100":940,"_163":177,"_165":941,"_166":22,"_167":-5,"_168":942,"_98":943},"558a9b38-8697-11f0-9d28-0224a6c84d84","deno.json","5815fb42-58b4-11f0-aaa5-f69ea79377d9",931,["D",1756664498170],11,"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"imports\": {\n \"@tijs/oauth-client-deno\": \"jsr:@tijs/oauth-client-deno@1.0.0\"\n },\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"./types/valtown-fallback.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"include\": [\n \"backend/\",\n \"frontend/\",\n \"tests/\"\n ],\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n },\n \"tasks\": {\n \"test\": \"deno test --allow-all tests/\",\n \"test:unit\": \"deno test --allow-all tests/unit/\",\n \"test:integration\": \"deno test --allow-all tests/integration/\",\n \"test:watch\": \"deno test --allow-all --watch tests/\",\n \"quality\": \"deno fmt && deno lint && deno check --allow-import && deno test --allow-all tests/\",\n \"deploy\": \"deno task quality && vt push\"\n }\n}\n",[],[936],{"_103":945,"_95":946,"_154":947,"_156":-5,"_157":139,"_158":948,"_160":161,"_105":949,"_100":119,"_163":177,"_165":950,"_166":22,"_167":-5,"_168":951,"_98":952},"2f9b4f6e-6930-11f0-981d-0224a6c84d84","deno.test.json","8190950a-63a8-11f0-a6d7-0224a6c84d84",202,["D",1753431612631],"{\n \"test\": {\n \"include\": [\n \"tests/**/*.test.ts\"\n ],\n \"exclude\": [\n \"node_modules\",\n \"dist\"\n ]\n },\n \"permissions\": {\n \"net\": true,\n \"read\": true,\n \"write\": true\n }\n}\n",[],[946],{"_103":954,"_95":955,"_154":956,"_156":-5,"_157":139,"_158":957,"_160":161,"_105":958,"_100":959,"_163":960,"_165":961,"_166":22,"_167":962,"_168":963,"_98":964},"f69f6646-8676-11f0-a913-0224a6c84d84","main.tsx","db7d92c8-58ab-11f0-bdec-f69ea79377d9",921,["D",1756650595027],76,"http","// @val-town anchordashboard\n// Main HTTP entry point for Anchor AppView - unified endpoints\nimport { Hono } from \"https://esm.sh/hono\";\nimport { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { db, initializeTables } from \"./backend/database/db.ts\";\nimport {\n getDashboardStats,\n getSessionBySessionId as _getSessionBySessionId,\n} from \"./backend/database/queries.ts\";\nimport { createOAuthRouter } from \"./backend/oauth/iron-router.ts\";\nimport anchorApiHandler from \"./backend/api/anchor-api.ts\";\n\nconst app = new Hono();\n\n// Initialize database on startup\nawait initializeTables();\n\n// Serve static frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Iron Session OAuth routes - replaces all old OAuth endpoints\napp.route(\"/\", createOAuthRouter());\n\n// Terms of Service endpoint\napp.get(\"/terms\", (_c) => {\n return new Response(\n `\n \n \n \n \n \n Terms of Service - Anchor\n \n \n \n

Terms of Service

Last updated: ${\n new Date().toLocaleDateString()\n }

\n \n

1. Acceptance of Terms

By using Anchor, you agree to these Terms of Service. Anchor is a location-based social app for the AT Protocol network.

\n \n

2. Description of Service

Anchor allows users to:

Check in at locations and share with the AT Protocol network
View location-based posts from other users
Connect with the decentralized social web via Bluesky and AT Protocol

\n \n

3. User Responsibilities

Users are responsible for:

Providing accurate location information
Respecting others' privacy and safety
Complying with local laws regarding location sharing
Maintaining the security of their account credentials

\n \n

4. Privacy and Data

Your location data and posts are stored on your chosen AT Protocol PDS (Personal Data Server). \n Anchor does not permanently store your personal data. See our Privacy Policy for details.

\n \n

5. Content Policy

Users must not post content that is illegal, harmful, or violates others' rights. \n Content moderation follows AT Protocol and your chosen PDS policies.

\n \n

6. Service Availability

Anchor is provided \"as is\" without warranties. We may modify or discontinue the service at any time.

\n \n

7. Contact

For questions about these terms, contact us through the AT Protocol network or via our project repository.

\n \n \n `,\n {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n});\n\n// Privacy Policy endpoint\napp.get(\"/privacy\", (_c) => {\n return new Response(\n `\n \n \n \n \n \n Privacy Policy - Anchor\n \n \n \n

Privacy Policy

Last updated: ${\n new Date().toLocaleDateString()\n }

\n \n

\n Key Principle: Anchor is built on the AT Protocol, which means your data belongs to you \n and is stored on your chosen Personal Data Server (PDS), not on Anchor's servers.\n

\n \n

1. Information We Collect

Location Data

When you check in at locations, we collect:

GPS coordinates of your check-ins
Place names and addresses from OpenStreetMap
Your custom messages associated with check-ins

\n \n

Authentication Data

For OAuth authentication with AT Protocol:

Your AT Protocol handle and DID
Temporary OAuth tokens (refreshed automatically)
Your chosen PDS URL

\n \n

2. How We Use Your Information

Your information is used to:

Enable location-based check-ins
Display your posts on the AT Protocol network
Provide location-based feeds and discovery
Maintain your authentication session

\n \n

3. Data Storage and Control

Your Data, Your Server

All your check-ins and location data are stored as AT Protocol records on YOUR chosen PDS. \n Anchor does not permanently store your personal content.

\n \n

What We Store Temporarily

OAuth session tokens (for authentication)
Cached feed data (for performance)
Anonymous usage statistics

\n \n

4. Data Sharing

Your location check-ins are published to the AT Protocol network according to your PDS's settings. \n This means they may be visible to other AT Protocol applications and users, subject to your chosen visibility settings.

\n \n

5. Third-Party Services

Anchor integrates with:

OpenStreetMap: For place data and geocoding
AT Protocol Network: For decentralized social features
Your PDS: For storing your data

\n \n

6. Your Rights

Because your data is stored on AT Protocol:

You can export all your data at any time
You can delete your data by deleting it from your PDS
You can switch PDS providers and take your data with you
You control who can see your location data

\n \n

7. Security

We protect your data using:

OAuth 2.1 with PKCE for secure authentication
DPoP (Demonstration of Proof of Possession) for token security
HTTPS encryption for all communications
Secure credential storage in iOS Keychain

\n \n

8. Children's Privacy

Anchor is not intended for users under 13. We do not knowingly collect personal information from children under 13.

\n \n

9. Changes to This Policy

We may update this privacy policy as needed. Changes will be posted at this URL with an updated date.

\n \n

10. Contact Us

For privacy questions, contact us through the AT Protocol network or via our project repository.

\n \n

AT Protocol Benefits

By building on AT Protocol, Anchor ensures your location data remains under your control, \n portable between services, and not locked into any single platform.

\n \n \n `,\n {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n});\n\n// ========================================\n// Core Anchor API Routes (handled by anchor-api.ts)\n// These routes provide the main API functionality with consistent CORS handling\n// ========================================\napp.all(\"/api/global\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/nearby\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/user\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/following\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/stats\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/places/nearby\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/places/categories\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/checkins\", (c) => anchorApiHandler(c.req.raw));\napp.all(\"/api/checkin/*\", (c) => anchorApiHandler(c.req.raw));\n\n// ========================================\n// Dashboard API Routes (for React frontend)\n// ========================================\n// Removed duplicate /api/feed endpoint - web and mobile both use /api/global\n\napp.get(\"/api/admin/stats\", async (c) => {\n try {\n const stats = await getDashboardStats();\n return c.json(stats);\n } catch (error) {\n console.error(\"Stats error:\", error);\n return c.json({ error: \"Failed to load stats\" }, 500);\n }\n});\n\napp.post(\"/api/admin/backfill-addresses\", async (c) => {\n try {\n console.log(\"Starting address backfill...\");\n\n // Parse query parameters\n const url = new URL(c.req.url);\n const limit = parseInt(url.searchParams.get(\"limit\") || \"50\");\n const isDryRun = url.searchParams.get(\"dry_run\") === \"true\";\n\n // Import and run backfill\n const { backfillAddresses } = await import(\n \"./backend/admin/backfill-addresses-api.ts\"\n );\n const result = await backfillAddresses(limit, isDryRun);\n\n console.log(\n `Address backfill completed: ${result.stats?.updated || 0} updated, ${\n result.stats?.errors || 0\n } errors`,\n );\n\n return c.json(result);\n } catch (error) {\n console.error(\"Address backfill error:\", error);\n return c.json({\n success: false,\n error: \"Failed to run address backfill\",\n message: error.message,\n }, 500);\n }\n});\n\n// Removed old backfill endpoint - use /api/admin/clean-and-backfill instead\n\n// Removed old discovery endpoint - use /api/admin/clean-and-backfill instead\n\napp.post(\"/api/admin/backfill-profiles\", async (c) => {\n try {\n console.log(\"Starting profile backfill...\");\n\n // Get all unique DIDs from checkins\n const { getAllCheckinDids } = await import(\"./backend/database/queries.ts\");\n const dids = await getAllCheckinDids();\n\n if (dids.length === 0) {\n return c.json({ message: \"No DIDs found to process\", dids_processed: 0 });\n }\n\n // Initialize storage\n const { DrizzleStorageProvider } = await import(\n \"./backend/utils/storage-provider.ts\"\n );\n // Use Drizzle db instance for type safety\n const storage = new DrizzleStorageProvider(db);\n\n // Force resolve all profiles using direct fetching\n const { BlueskyProfileFetcher } = await import(\n \"./backend/utils/profile-resolver.ts\"\n );\n const fetcher = new BlueskyProfileFetcher();\n\n const resolvedProfiles = new Map();\n\n console.log(`Found DIDs to process: ${JSON.stringify(dids)}`);\n\n for (const did of dids) {\n try {\n console.log(`Resolving profile for DID: ${did}`);\n\n // Direct fetch to bypass any caching issues\n const profile = await fetcher.fetchProfile(did);\n console.log(`Profile fetched for ${did}:`, !!profile);\n\n if (profile) {\n // Store in cache\n await storage.setProfile(profile);\n resolvedProfiles.set(did, profile);\n console.log(`Stored profile for ${did}: ${profile.handle}`);\n } else {\n console.log(`No profile data returned for ${did}`);\n }\n } catch (error) {\n console.error(`Failed to resolve profile for ${did}:`, error);\n }\n }\n\n console.log(\n `Profile backfill completed: ${resolvedProfiles.size}/${dids.length} profiles resolved`,\n );\n\n return c.json({\n success: true,\n dids_found: dids.length,\n profiles_resolved: resolvedProfiles.size,\n resolved_profiles: Array.from(resolvedProfiles.entries()).map((\n [did, profile],\n ) => ({\n did,\n handle: profile.handle,\n displayName: profile.displayName,\n avatar: profile.avatar ? \"✅\" : \"❌\",\n })),\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"Profile backfill error:\", error);\n return c.json({\n success: false,\n error: \"Profile backfill failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.get(\"/api/admin/test-profile\", async (c) => {\n try {\n // Test direct profile fetching\n const { BlueskyProfileFetcher } = await import(\n \"./backend/utils/profile-resolver.ts\"\n );\n const fetcher = new BlueskyProfileFetcher();\n\n const testDid = \"did:plc:wxex3wx5k4ctciupsv5m5stb\";\n console.log(`Testing profile fetch for ${testDid}`);\n\n const profile = await fetcher.fetchProfile(testDid);\n\n return c.json({\n success: true,\n test_did: testDid,\n profile_fetched: !!profile,\n profile_data: profile,\n });\n } catch (error) {\n console.error(\"Profile test error:\", error);\n return c.json({\n success: false,\n error: error.message,\n }, 500);\n }\n});\n\napp.get(\"/api/admin/check-users\", async (c) => {\n try {\n console.log(\"Running user migration diagnostic check...\");\n\n const checkModule = await import(\"./backend/admin/check-existing-users.ts\");\n await checkModule.default();\n\n return c.json({\n success: true,\n message:\n \"User diagnostic check completed successfully. See server logs for details.\",\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"User check error:\", error);\n return c.json({\n success: false,\n error: \"User check failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.get(\"/api/admin/simple-user-check\", async (c) => {\n try {\n console.log(\"Running simple user check...\");\n\n const checkModule = await import(\"./backend/admin/simple-user-check.ts\");\n const result = await checkModule.default();\n\n return c.json({\n success: result.success,\n data: result,\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"Simple user check error:\", error);\n return c.json({\n success: false,\n error: \"Simple user check failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.get(\"/api/admin/db-diagnostic\", async (c) => {\n try {\n console.log(\"Running database diagnostic...\");\n\n const diagnosticModule = await import(\"./backend/admin/db-diagnostic.ts\");\n const result = await diagnosticModule.default();\n\n return c.json({\n success: result.success,\n data: result,\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"Database diagnostic error:\", error);\n return c.json({\n success: false,\n error: \"Database diagnostic failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.get(\"/api/admin/user-sync-diagnostic\", async (c) => {\n try {\n console.log(\"Running user sync diagnostic...\");\n\n const diagnosticModule = await import(\n \"./backend/admin/user-sync-diagnostic.ts\"\n );\n const result = await diagnosticModule.default();\n\n return c.json({\n success: result.success,\n data: result,\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"User sync diagnostic error:\", error);\n return c.json({\n success: false,\n error: \"User sync diagnostic failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.post(\"/api/admin/sync-missing-users\", async (c) => {\n try {\n console.log(\"Starting user sync repair...\");\n\n const body = await c.req.json().catch(() => ({}));\n const dryRun = body.dry_run !== false; // Default to dry run\n\n const syncModule = await import(\"./backend/admin/sync-missing-users.ts\");\n const result = await syncModule.default(dryRun);\n\n return c.json({\n success: result.success,\n data: result,\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"User sync repair error:\", error);\n return c.json({\n success: false,\n error: \"User sync repair failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.post(\"/api/admin/run-migrations\", async (c) => {\n try {\n console.log(\"Running database migrations manually...\");\n\n const migrationModule = await import(\"./backend/admin/run-migrations.ts\");\n const result = await migrationModule.default();\n\n return c.json({\n success: result.success,\n data: result,\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n console.error(\"Migration error:\", error);\n return c.json({\n success: false,\n error: \"Migration failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.post(\"/api/admin/crawl-followers\", async (c) => {\n try {\n console.log(\"Starting followers crawler...\");\n\n const crawlerModule = await import(\n \"./backend/ingestion/followers-crawler.ts\"\n );\n const response = await crawlerModule.default();\n\n if (response.status === 200) {\n const result = await response.text();\n return c.text(result);\n } else {\n const error = await response.text();\n return c.text(error, { status: response.status as any });\n }\n } catch (error) {\n console.error(\"Followers crawler error:\", error);\n return c.json({\n error: \"Followers crawler failed\",\n details: error.message,\n }, 500);\n }\n});\n\n// ========================================\n// Cron-ready crawler endpoints\n// ========================================\n\napp.post(\"/api/cron/checkins\", async (c) => {\n try {\n const cronModule = await import(\"./backend/admin/cron-crawlers.ts\");\n const response = await cronModule.cronCheckins();\n\n if (response.status === 200) {\n const result = await response.text();\n return c.text(result);\n } else {\n const error = await response.text();\n return c.text(error, { status: response.status as any });\n }\n } catch (error) {\n console.error(\"Cron checkins crawler error:\", error);\n return c.json({\n error: \"Cron checkins crawler failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.post(\"/api/cron/followers\", async (c) => {\n try {\n const cronModule = await import(\"./backend/admin/cron-crawlers.ts\");\n const response = await cronModule.cronFollowers();\n\n if (response.status === 200) {\n const result = await response.text();\n return c.text(result);\n } else {\n const error = await response.text();\n return c.text(error, { status: response.status as any });\n }\n } catch (error) {\n console.error(\"Cron followers crawler error:\", error);\n return c.json({\n error: \"Cron followers crawler failed\",\n details: error.message,\n }, 500);\n }\n});\n\n// Address resolution endpoint removed - address resolver was using removed database tables\n\n// Backfill endpoints using the consolidated script\napp.post(\"/api/admin/backfill\", async (c) => {\n try {\n const body = await c.req.json().catch(() => ({}));\n const mode = body.mode || \"incremental\"; // default to incremental\n\n console.log(`Starting ${mode} backfill...`);\n\n const backfillModule = await import(\"./backend/admin/backfill-checkins.ts\");\n const response = await backfillModule.default({ mode });\n\n if (response.status === 200) {\n const result = await response.text();\n return c.text(result);\n } else {\n const error = await response.text();\n return c.text(error, { status: response.status as any });\n }\n } catch (error) {\n console.error(\"Backfill error:\", error);\n return c.json({\n error: \"Backfill failed\",\n details: error.message,\n }, 500);\n }\n});\n\napp.get(\"/api/auth/session\", async (c) => {\n try {\n // Support both cookie-based (web) and Bearer token (mobile) authentication\n const { getIronSession, unsealData } = await import(\n \"npm:iron-session@8.0.4\"\n );\n const { valTownStorage } = await import(\"./backend/oauth/iron-storage.ts\");\n\n const COOKIE_SECRET = Deno.env.get(\"COOKIE_SECRET\") ||\n \"anchor-default-secret-for-development-only\";\n\n let userDid: string | null = null;\n\n // Try Bearer token first (mobile)\n const authHeader = c.req.header(\"Authorization\");\n if (authHeader?.startsWith(\"Bearer \")) {\n try {\n const sealedToken = authHeader.slice(7);\n const sessionData = await unsealData(sealedToken, {\n password: COOKIE_SECRET,\n }) as { did: string };\n userDid = sessionData.did;\n console.log(\"Bearer token authentication successful\");\n } catch (err) {\n console.log(\"Bearer token authentication failed:\", err);\n }\n }\n\n // Fallback to cookie authentication (web)\n if (!userDid) {\n try {\n interface Session {\n did: string;\n }\n\n const session = await getIronSession(c.req.raw, c.res, {\n cookieName: \"sid\",\n password: COOKIE_SECRET,\n });\n\n userDid = session.did;\n console.log(\"Cookie authentication successful\");\n } catch (err) {\n console.log(\"Cookie authentication failed:\", err);\n }\n }\n\n if (!userDid) {\n return c.json({ authenticated: false });\n }\n\n // Get OAuth session data from storage\n const oauthSession = await valTownStorage.get(`oauth_session:${userDid}`);\n if (!oauthSession) {\n return c.json({ authenticated: false });\n }\n\n // Return user info without sensitive tokens\n return c.json({\n authenticated: true,\n userHandle: oauthSession.handle,\n userDid: userDid,\n userDisplayName: oauthSession.handle, // We can add displayName later if needed\n userAvatar: null, // We can add avatar later if needed\n });\n } catch (error) {\n console.error(\"Session check error:\", error);\n return c.json({ authenticated: false });\n }\n});\n\n// ========================================\n// Mobile OAuth Routes\n// ========================================\n\n// Mobile authentication page for WebView integration\napp.get(\n \"/mobile-auth\",\n (_c) => serveFile(\"/frontend/index.html\", import.meta.url),\n);\n\n// Checkin detail pages with dynamic meta tags\napp.get(\"/checkin/*\", async (c) => {\n const url = new URL(c.req.url);\n const checkinId = url.pathname.split(\"/checkin/\")[1];\n\n if (!checkinId) {\n return serveFile(\"/frontend/index.html\", import.meta.url);\n }\n\n try {\n // Fetch checkin data for meta tags\n const checkinResponse = await fetch(\n `${url.origin}/api/checkin/${checkinId}`,\n );\n\n if (checkinResponse.ok) {\n const checkin = await checkinResponse.json();\n\n // Create dynamic HTML with meta tags\n const baseHtml = await serveFile(\"/frontend/index.html\", import.meta.url);\n const htmlText = await baseHtml.text();\n\n const description = checkin.text\n ? `${checkin.text} - Check-in by ${\n checkin.author.displayName || checkin.author.handle\n }`\n : `Check-in by ${checkin.author.displayName || checkin.author.handle}`;\n\n const locationText = checkin.address?.name\n ? `at ${checkin.address.name}`\n : checkin.coordinates\n ? `at ${checkin.coordinates.latitude.toFixed(4)}, ${\n checkin.coordinates.longitude.toFixed(4)\n }`\n : \"\";\n\n const title = `${\n checkin.author.displayName || checkin.author.handle\n } ${locationText} - Anchor`;\n\n // Inject meta tags\n const metaTags = `\n \n \n \n \n \n \n \n \n ${\n checkin.author.avatar\n ? ``\n : \"\"\n }\n `;\n\n const enhancedHtml = htmlText.replace(\n \"Anchor\",\n `${title.replace(/\"/g, \""\")}${metaTags}`,\n );\n\n return new Response(enhancedHtml, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n } catch (error) {\n console.error(\"Failed to generate checkin meta tags:\", error);\n }\n\n // Fallback to regular HTML\n return serveFile(\"/frontend/index.html\", import.meta.url);\n});\n\n// Old mobile OAuth endpoints removed - replaced by Iron Session OAuth router\n\n// ========================================\n// Frontend Routes (HTML/React views)\n// ========================================\n\n// Serve main app for all other routes\napp.get(\"*\", (_c) => serveFile(\"/frontend/index.html\", import.meta.url));\n\n// Error handler\napp.onError((err, _c) => {\n console.error(\"Server error:\", err);\n throw err; // Re-throw for full stack traces\n});\n\n// Export the Hono app's fetch handler for Val Town\nexport default app.fetch;\n","dropanchor",[],[955],{"_103":966,"_95":967,"_154":968,"_156":-5,"_157":139,"_158":969,"_160":161,"_105":970,"_100":32,"_163":177,"_165":971,"_166":22,"_167":-5,"_168":972,"_98":973},"ca2a5502-7466-11f0-a509-0224a6c84d84","opinionated-val-town.md","ca2a55fc-7466-11f0-a509-0224a6c84d84",273,["D",1754664527495],"# Val Town Development Guide\n\nYou are an advanced assistant that helps programmers code on Val Town.\n\n## Core Guidelines\n\n- Ask clarifying questions when requirements are ambiguous\n- Plan large refactors or big features before you start coding\n- Provide complete, functional solutions rather than skeleton implementations\n- Test your logic against edge cases before presenting the final solution\n- Ensure all code follows Val Town's specific platform requirements\n- Always prefer small, single purpose, single responsibility components over\n large files that do many things\n- If a section of code is getting too complex, consider refactoring it into\n subcomponents\n- **Frontend = React, Backend = Hono, Database = Drizzle** - This is the way\n- **Write testable code** - Use dependency injection, follow SOLID principles,\n mock external services, write fakes instead of testing dependencies\n\n## Code Standards\n\n- Generate code in TypeScript or TSX\n- Add appropriate TypeScript types and interfaces for all data structures\n- Prefer official SDKs or libraries than writing API calls directly\n- Ask the user to supply API or library documentation if you are at all unsure\n about it\n- **Never bake in secrets into the code** - always use environment variables\n- Include comments explaining complex logic (avoid commenting obvious\n operations)\n- Follow modern ES6+ conventions and functional programming practices if\n possible\n- **Every function must be testable** - Accept dependencies as parameters,\n return predictable outputs\n- **Write tests alongside code** - Place `.test.ts` files next to the code they\n test\n\n## Project Structure\n\n### Project Organization\n\nWhen organizing a Val Town project, consider separating deployable code from\nlocal resources:\n\n```text\n├── your-project-name/ # Deployable directory (what Val Town will see)\n│ ├── backend/\n│ │ ├── database/\n│ │ │ ├── schema.ts # All table definitions, relations, and types\n│ │ │ ├── db.ts # Database connection and Drizzle instance \n│ │ │ ├── migrations.ts # Schema migration logic\n│ │ │ └── queries.ts # Reusable query functions\n│ │ ├── routes/ # Route modules\n│ │ │ ├── [route].ts\n│ │ │ └── static.ts # Static file serving\n│ │ └── index.ts # Main entry point\n│ ├── frontend/\n│ │ ├── components/\n│ │ │ ├── App.tsx\n│ │ │ └── [Component].tsx\n│ │ ├── index.html # Minimal HTML bootstrap file\n│ │ ├── index.tsx # React entry point with createRoot\n│ │ └── style.css # Global styles (prefer Tailwind classes)\n│ ├── shared/\n│ │ └── utils.ts # Shared types and functions\n│ └── deno.json # Deno configuration (MUST be in the deployed directory)\n├── resources/ # Local-only resources (images, assets)\n├── docs/ # Local-only documentation\n├── README.md # Project documentation\n└── AGENTS.md # AI assistant instructions\n```\n\n**Key Points:**\n\n- Only the contents of your main project directory will be deployed to Val Town\n- The `deno.json` file MUST be inside the deployment directory\n- Keep non-deployable resources outside the deployment directory\n\n### Deno Configuration\n\nPlace your `deno.json` in the deployable directory:\n\n```json\n{\n \"tasks\": {\n \"quality\": \"deno fmt && deno lint --fix && deno check **/*.ts **/*.tsx && deno test\",\n \"deploy\": \"deno task quality && vt push\",\n \"check\": \"deno check **/*.ts **/*.tsx\",\n \"test\": \"deno test\",\n \"fmt\": \"deno fmt\",\n \"lint\": \"deno lint --fix\"\n }\n}\n```\n\n## Frontend Architecture\n\n**Always use React** for Val Town frontends. Here's the opinionated approach:\n\n### Frontend Core Principles\n\n- **HTML is just a bootstrap file** - Keep it minimal, only load React\n- **No HTML fallbacks** - JavaScript is required, period\n- **Single Page Application** - Let React handle all rendering\n- **TypeScript everywhere** - Use `.tsx` files for all components\n- **Tailwind for styling** - Use the CDN version:\n ``\n\n### React Configuration\n\n- **Use latest versions** - Import React without version constraints\n- **JSX pragma required** - Start every `.tsx` file with\n `/** @jsxImportSource https://esm.sh/react */`\n- **No build step** - Import directly from ESM URLs\n- **Client-side only** - No SSR, inject initial data if needed\n\n## Backend Architecture\n\n### Hono Framework\n\n- Main entry point should be `backend/index.ts`\n- Export with `export default app.fetch`\n- Do NOT use Hono's serveStatic middleware\n- Use Val Town's `serveFile` utility for static assets\n- Re-throw errors in error handler for full stack traces\n\n### API Design\n\n- Create RESTful routes for CRUD operations\n- Use TypeScript interfaces for request/response types\n- Bootstrap initial data by reading and modifying HTML\n- Let errors bubble up with full context\n\n## Database with Drizzle ORM\n\nVal Town uses Turso (SQLite) under the hood. Use Drizzle ORM for type safety.\n\n### Key Concepts\n\n- **Schema-first approach** - Define all tables in `schema.ts`\n- **Single database instance** - Create one connection in `db.ts`\n- **Type-safe queries** - Use Drizzle's query builder\n- **Migrations** - Track schema changes with versioned migrations\n\n### Database Best Practices\n\n- Use singular table names (e.g., `user` not `users`)\n- Define relations for efficient querying\n- Add indexes** on foreign keys and frequently queried columns\n- Use transactions** for multi-table operations\n- Handle SQLite limitations - No complex ALTER TABLE\n- Limited ALTER TABLE support\n- Change table names instead of altering\n- Always run migrations before queries\n\n### Common Patterns\n\n- **Simple CRUD**: Use Drizzle's select, insert, update, delete\n- **Relations**: Use `db.query` for nested data\n- **Complex joins**: Use select with join methods\n- **Raw SQL**: Use `db.run(sql`)`` when needed\n\n## Testing Strategy\n\n### Testing Core Principles\n\n- Write tests first or ensure code is testable\n- Place test files next to code: `user.ts` → `user.test.ts`\n- Mock all external dependencies\n- Test behavior, not implementation\n\n### Writing Testable Code\n\n```typescript\n// BAD: Hard to test\nexport async function getUser(id: string) {\n const user = await db.select().from(userTable).where(eq(userTable.id, id));\n return user[0];\n}\n\n// GOOD: Testable with dependency injection\nexport async function getUser(id: string, dbProvider = db) {\n const user = await dbProvider.select().from(userTable).where(\n eq(userTable.id, id),\n );\n return user[0];\n}\n```\n\n### SOLID Principles\n\n1. **Single Responsibility** - Each function does one thing\n2. **Open/Closed** - Use composition over modification\n3. **Liskov Substitution** - Interfaces should be substitutable\n4. **Interface Segregation** - Small, focused interfaces\n5. **Dependency Inversion** - Depend on abstractions\n\n### Running Tests\n\n```bash\ndeno test # Run all tests\ndeno test user.test.ts # Run specific test\ndeno task quality # Includes tests in quality check\n```\n\n## TypeScript Configuration\n\n### Type Checking\n\n- Use `deno check` before deployment\n- Add explicit types for function parameters and returns\n- Define interfaces for all data structures\n- External libraries from esm.sh include types automatically\n\n### TypesSript Best Practices\n\n- Leverage TypeScript's strict mode\n- Type API responses for client-side safety\n- Use type-only imports: `import type { SomeType }`\n- Ignore Bun-specific errors if they appear\n\n## Dependency Management\n\n### Import Strategy\n\n- **Use latest versions** - No version pinning needed\n- **Import from esm.sh**: `https://esm.sh/package`\n- **Trust CDN resolution** - esm.sh handles compatibility\n- **Central deps file** - Use `deps.ts` for complex projects\n\n### Common Imports\n\n```typescript\n// React (with pragma)\n/** @jsxImportSource https://esm.sh/react */\nimport React from \"https://esm.sh/react\";\n\n// Drizzle ORM\nimport { drizzle } from \"https://esm.sh/drizzle-orm/libsql\";\n\n// Hono\nimport { Hono } from \"https://esm.sh/hono\";\n```\n\n## Development Workflow\n\n### Task Commands\n\n1. **During development**: `deno task check` - Catch type errors\n2. **Before committing**: `deno task quality` - Format, lint, type check, test\n3. **To deploy**: `deno task deploy` - Quality checks then deploy\n\n### Deployment Process\n\n```bash\ndeno task deploy # Runs quality checks first\n```\n\n- Fix any issues before deployment succeeds\n- Environment variables managed in Val Town interface\n- Only deployment directory contents are uploaded\n\n## Val Town APIs\n\n### Triggers\n\n1. **HTTP Trigger** - Web APIs and endpoints\n2. **Cron Triggers** - Scheduled tasks (1 min minimum on pro)\n3. **Email Triggers** - Process incoming emails\n\n### Standard Libraries\n\n- **Blob Storage**: `import { blob } from \"https://esm.town/v/std/blob\"`\n- **SQLite**: Use Drizzle ORM instead of raw SQL\n- **OpenAI**: `import { OpenAI } from \"https://esm.town/v/std/openai\"`\n- **Email**: `import { email } from \"https://esm.town/v/std/email\"`\n\n### Utility Functions\n\n### Importing Utilities\n\nAlways import utilities with version pins to avoid breaking changes:\n\n```ts\nimport {\n readFile,\n serveFile,\n} from \"https://esm.town/v/std/utils@85-main/index.ts\";\n```\n\n### Available Utilities\n\n**serveFile** - Serve project files with proper content types\n\nFor example, in Hono:\n\n```ts\n// serve all files in frontend/ and shared/\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n```\n\n**readFile** - Read files from within the project:\n\n```ts\n// Read a file from the project\nconst fileContent = await readFile(\"/frontend/index.html\", import.meta.url);\n```\n\n**listFiles** - List all files in the project\n\n```ts\nconst files = await listFiles(import.meta.url);\n```\n\n## Platform Specifics\n\n### Important Limitations\n\n- **Redirects**: Use\n `new Response(null, { status: 302, headers: { Location: \"/path\" }})`\n- **No binary files** - Text files only\n- **No Deno KV** - Use SQLite instead\n- **No browser APIs** - No alert(), prompt(), confirm()\n- **Automatic CORS** - Don't import CORS middleware\n\n## Common Gotchas\n\n### Environment\n\n- Val Town runs on Deno, not Node.js\n- Shared code can't use Deno-specific APIs\n- Use esm.sh for browser/server compatibility\n\n### Hono Issues\n\n- NEVER import serveStatic middleware\n- NEVER import CORS middleware\n- Use Val Town's utilities instead\n- **ALWAYS import Val Town utilities directly** - Never create placeholder\n functions for `serveFile`, `blob`, `email`, etc. Import them from\n `https://esm.town/v/std/utils/index.ts` or their respective standard library\n modules from the start\n\n## Migration Strategy\n\n### Principles\n\n- Track migration history in dedicated table\n- Make migrations idempotent\n- Control with environment variables\n- Test thoroughly before deployment\n\n### Best Practices\n\n- Plan schema changes carefully\n- Consider performance impact\n- Backup before destructive changes\n- Remember SQLite limitations\n- Use emojis/unicode instead of images\n- Let errors bubble up with context\n- Prefer APIs without keys (e.g., open-meteo for weather)\n- Add error debugging script:\n ``\n- **Never create placeholder functions** for Val Town utilities - always import\n the real ones directly, even during development\n",[],[967],"files",[151,170,182,188,195,206,213,220,230,239,248,258,267,276,285,294,304,311,320,330,337,347,356,366,376,387,394,404,413,424,431,441,448,457,468,475,484,493,503,510,519,528,537,548,556,561,570,580,586,595,605,612,619,629,638,647,656,665,674,683,693,701,708,718,725,734,744,751,758,768,774,784,791,801,807,816,825,834,843,852,861,870,881,887,897,905,914,924,934,944,953,965],"counts",{"_978":32,"_979":119,"_980":32,"_981":982},"pulls","branches","forks","envVars",7,"contents",[985],{"_103":189,"_95":190,"_154":191,"_156":184,"_157":139,"_158":192,"_160":161,"_105":986,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":987},["D",1751815702884],[99,190],{"_103":183,"_95":99,"_154":184,"_156":-5,"_157":139,"_158":185,"_160":161,"_105":989,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":990},["D",1751815702718],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":997,"_149":1002,"_974":1279,"_177":1280,"_983":1282,"_1285":-5,"_1286":22,"_1287":-5,"_1288":-5,"_1289":-5,"_1290":1291},{"_103":104,"_95":96,"_105":998,"_107":-5,"_108":22,"_109":110,"_111":112,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":119,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":999,"_133":1000,"_136":1001,"_148":22},["D",1751615559344],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[1003,1009,1018,1132,1135,1144,1153,1201,1249,1255,1258,1261,1264,1267,1270,1273,1276],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":162,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1004,"_98":1008},[1005],{"_103":171,"_95":172,"_154":173,"_156":155,"_157":139,"_158":174,"_160":161,"_105":175,"_100":176,"_163":177,"_165":178,"_166":22,"_167":-5,"_168":1006,"_98":1007},[],[153,172],[153],{"_103":183,"_95":99,"_154":184,"_156":-5,"_157":139,"_158":185,"_160":161,"_105":186,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1010,"_98":1017},[1011],{"_103":189,"_95":190,"_154":191,"_156":184,"_157":139,"_158":192,"_160":161,"_105":193,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1012,"_98":1016},[1013],{"_103":196,"_95":197,"_154":198,"_156":191,"_157":139,"_158":199,"_160":161,"_105":200,"_100":32,"_163":177,"_165":201,"_166":22,"_167":-5,"_168":1014,"_98":1015},[],[99,190,197],[99,190],[99],{"_103":207,"_95":208,"_154":209,"_156":-5,"_157":139,"_158":210,"_160":161,"_105":211,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1019,"_98":1131},[1020,1050,1059,1077,1089,1095,1104,1116],{"_103":214,"_95":215,"_154":216,"_156":209,"_157":139,"_158":217,"_160":161,"_105":218,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1021,"_98":1049},[1022,1025,1028,1031,1034,1037,1040,1043,1046],{"_103":221,"_95":222,"_154":223,"_156":216,"_157":139,"_158":224,"_160":161,"_105":225,"_100":119,"_163":226,"_165":227,"_166":22,"_167":-5,"_168":1023,"_98":1024},[],[208,215,222],{"_103":231,"_95":232,"_154":233,"_156":216,"_157":139,"_158":234,"_160":161,"_105":235,"_100":119,"_163":226,"_165":236,"_166":22,"_167":-5,"_168":1026,"_98":1027},[],[208,215,232],{"_103":240,"_95":241,"_154":242,"_156":216,"_157":139,"_158":243,"_160":161,"_105":244,"_100":119,"_163":226,"_165":245,"_166":22,"_167":-5,"_168":1029,"_98":1030},[],[208,215,241],{"_103":249,"_95":250,"_154":251,"_156":216,"_157":139,"_158":252,"_160":161,"_105":253,"_100":254,"_163":226,"_165":255,"_166":22,"_167":-5,"_168":1032,"_98":1033},[],[208,215,250],{"_103":259,"_95":260,"_154":261,"_156":216,"_157":139,"_158":262,"_160":161,"_105":263,"_100":159,"_163":226,"_165":264,"_166":22,"_167":-5,"_168":1035,"_98":1036},[],[208,215,260],{"_103":268,"_95":269,"_154":270,"_156":216,"_157":139,"_158":271,"_160":161,"_105":272,"_100":32,"_163":226,"_165":273,"_166":22,"_167":-5,"_168":1038,"_98":1039},[],[208,215,269],{"_103":277,"_95":278,"_154":279,"_156":216,"_157":139,"_158":280,"_160":161,"_105":281,"_100":32,"_163":226,"_165":282,"_166":22,"_167":-5,"_168":1041,"_98":1042},[],[208,215,278],{"_103":286,"_95":287,"_154":288,"_156":216,"_157":139,"_158":289,"_160":161,"_105":290,"_100":119,"_163":226,"_165":291,"_166":22,"_167":-5,"_168":1044,"_98":1045},[],[208,215,287],{"_103":295,"_95":296,"_154":297,"_156":216,"_157":139,"_158":298,"_160":161,"_105":299,"_100":32,"_163":226,"_165":300,"_166":22,"_167":-5,"_168":1047,"_98":1048},[],[208,215,296],[208,215],{"_103":305,"_95":306,"_154":307,"_156":209,"_157":139,"_158":308,"_160":161,"_105":309,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1051,"_98":1058},[1052,1055],{"_103":312,"_95":313,"_154":314,"_156":307,"_157":139,"_158":315,"_160":161,"_105":316,"_100":176,"_163":226,"_165":317,"_166":22,"_167":-5,"_168":1053,"_98":1054},[],[208,306,313],{"_103":321,"_95":322,"_154":323,"_156":307,"_157":139,"_158":138,"_160":161,"_105":324,"_100":325,"_163":226,"_165":326,"_166":22,"_167":-5,"_168":1056,"_98":1057},[],[208,306,322],[208,306],{"_103":331,"_95":332,"_154":333,"_156":209,"_157":139,"_158":334,"_160":161,"_105":335,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1060,"_98":1076},[1061,1064,1067,1070,1073],{"_103":338,"_95":339,"_154":340,"_156":333,"_157":139,"_158":341,"_160":161,"_105":342,"_100":343,"_163":226,"_165":344,"_166":22,"_167":-5,"_168":1062,"_98":1063},[],[208,332,339],{"_103":348,"_95":349,"_154":350,"_156":333,"_157":139,"_158":351,"_160":161,"_105":352,"_100":343,"_163":226,"_165":353,"_166":22,"_167":-5,"_168":1065,"_98":1066},[],[208,332,349],{"_103":357,"_95":358,"_154":359,"_156":333,"_157":139,"_158":360,"_160":161,"_105":361,"_100":362,"_163":226,"_165":363,"_166":22,"_167":-5,"_168":1068,"_98":1069},[],[208,332,358],{"_103":367,"_95":368,"_154":369,"_156":333,"_157":139,"_158":370,"_160":161,"_105":371,"_100":372,"_163":226,"_165":373,"_166":22,"_167":-5,"_168":1071,"_98":1072},[],[208,332,368],{"_103":377,"_95":378,"_154":379,"_156":333,"_157":139,"_158":380,"_160":161,"_105":381,"_100":382,"_163":226,"_165":383,"_166":22,"_167":-5,"_168":1074,"_98":1075},[],[208,332,378],[208,332],{"_103":388,"_95":389,"_154":390,"_156":209,"_157":139,"_158":391,"_160":161,"_105":392,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1078,"_98":1088},[1079,1082,1085],{"_103":395,"_95":396,"_154":397,"_156":390,"_157":139,"_158":398,"_160":161,"_105":399,"_100":159,"_163":400,"_165":401,"_166":22,"_167":-5,"_168":1080,"_98":1081},[],[208,389,396],{"_103":405,"_95":406,"_154":407,"_156":390,"_157":139,"_158":408,"_160":161,"_105":409,"_100":159,"_163":226,"_165":410,"_166":22,"_167":-5,"_168":1083,"_98":1084},[],[208,389,406],{"_103":414,"_95":415,"_154":416,"_156":390,"_157":139,"_158":417,"_160":161,"_105":418,"_100":419,"_163":226,"_165":420,"_166":22,"_167":-5,"_168":1086,"_98":1087},[],[208,389,415],[208,389],{"_103":425,"_95":426,"_154":427,"_156":209,"_157":139,"_158":428,"_160":161,"_105":429,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1090,"_98":1094},[1091],{"_103":432,"_95":433,"_154":434,"_156":427,"_157":139,"_158":435,"_160":161,"_105":436,"_100":119,"_163":226,"_165":437,"_166":22,"_167":-5,"_168":1092,"_98":1093},[],[208,426,433],[208,426],{"_103":442,"_95":443,"_154":444,"_156":209,"_157":139,"_158":445,"_160":161,"_105":446,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1096,"_98":1103},[1097,1100],{"_103":449,"_95":450,"_154":451,"_156":444,"_157":139,"_158":452,"_160":161,"_105":453,"_100":325,"_163":226,"_165":454,"_166":22,"_167":-5,"_168":1098,"_98":1099},[],[208,443,450],{"_103":458,"_95":459,"_154":460,"_156":444,"_157":139,"_158":461,"_160":161,"_105":462,"_100":463,"_163":226,"_165":464,"_166":22,"_167":-5,"_168":1101,"_98":1102},[],[208,443,459],[208,443],{"_103":469,"_95":470,"_154":471,"_156":209,"_157":139,"_158":472,"_160":161,"_105":473,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1105,"_98":1115},[1106,1109,1112],{"_103":476,"_95":477,"_154":478,"_156":471,"_157":139,"_158":479,"_160":161,"_105":480,"_100":32,"_163":226,"_165":481,"_166":22,"_167":-5,"_168":1107,"_98":1108},[],[208,470,477],{"_103":485,"_95":486,"_154":487,"_156":471,"_157":139,"_158":488,"_160":161,"_105":489,"_100":32,"_163":226,"_165":490,"_166":22,"_167":-5,"_168":1110,"_98":1111},[],[208,470,486],{"_103":494,"_95":495,"_154":496,"_156":471,"_157":139,"_158":497,"_160":161,"_105":498,"_100":419,"_163":226,"_165":499,"_166":22,"_167":-5,"_168":1113,"_98":1114},[],[208,470,495],[208,470],{"_103":504,"_95":505,"_154":506,"_156":209,"_157":139,"_158":507,"_160":161,"_105":508,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1117,"_98":1130},[1118,1121,1124,1127],{"_103":511,"_95":512,"_154":513,"_156":506,"_157":139,"_158":514,"_160":161,"_105":515,"_100":159,"_163":226,"_165":516,"_166":22,"_167":-5,"_168":1119,"_98":1120},[],[208,505,512],{"_103":520,"_95":521,"_154":522,"_156":506,"_157":139,"_158":523,"_160":161,"_105":524,"_100":254,"_163":226,"_165":525,"_166":22,"_167":-5,"_168":1122,"_98":1123},[],[208,505,521],{"_103":529,"_95":530,"_154":531,"_156":506,"_157":139,"_158":532,"_160":161,"_105":533,"_100":119,"_163":226,"_165":534,"_166":22,"_167":-5,"_168":1125,"_98":1126},[],[208,505,530],{"_103":538,"_95":539,"_154":540,"_156":506,"_157":139,"_158":541,"_160":161,"_105":542,"_100":372,"_163":226,"_165":543,"_166":22,"_167":-5,"_168":1128,"_98":1129},[],[208,505,539],[208,505],[208],{"_103":549,"_95":550,"_154":551,"_156":-5,"_157":139,"_158":552,"_160":161,"_105":553,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1133,"_98":1134},[],[550],{"_103":557,"_95":332,"_154":558,"_156":-5,"_157":139,"_158":463,"_160":161,"_105":559,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1136,"_98":1143},[1137,1140],{"_103":562,"_95":563,"_154":564,"_156":558,"_157":139,"_158":565,"_160":161,"_105":566,"_100":32,"_163":177,"_165":567,"_166":22,"_167":-5,"_168":1138,"_98":1139},[],[332,563],{"_103":571,"_95":572,"_154":573,"_156":558,"_157":139,"_158":574,"_160":161,"_105":575,"_100":463,"_163":177,"_165":576,"_166":22,"_167":-5,"_168":1141,"_98":1142},[],[332,572],[332],{"_103":581,"_95":582,"_154":583,"_156":-5,"_157":139,"_158":254,"_160":161,"_105":584,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1145,"_98":1152},[1146,1149],{"_103":587,"_95":588,"_154":589,"_156":583,"_157":139,"_158":590,"_160":161,"_105":591,"_100":254,"_163":177,"_165":592,"_166":22,"_167":-5,"_168":1147,"_98":1148},[],[582,588],{"_103":596,"_95":597,"_154":598,"_156":583,"_157":139,"_158":599,"_160":161,"_105":600,"_100":119,"_163":177,"_165":601,"_166":22,"_167":-5,"_168":1150,"_98":1151},[],[582,597],[582],{"_103":606,"_95":607,"_154":608,"_156":-5,"_157":139,"_158":609,"_160":161,"_105":610,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1154,"_98":1200},[1155,1182,1185,1191,1194,1197],{"_103":613,"_95":614,"_154":615,"_156":608,"_157":139,"_158":616,"_160":161,"_105":617,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1156,"_98":1181},[1157,1160,1163,1166,1169,1172,1175,1178],{"_103":620,"_95":621,"_154":622,"_156":615,"_157":139,"_158":623,"_160":161,"_105":624,"_100":625,"_163":226,"_165":626,"_166":22,"_167":-5,"_168":1158,"_98":1159},[],[607,614,621],{"_103":630,"_95":631,"_154":632,"_156":615,"_157":139,"_158":633,"_160":161,"_105":634,"_100":159,"_163":226,"_165":635,"_166":22,"_167":-5,"_168":1161,"_98":1162},[],[607,614,631],{"_103":639,"_95":640,"_154":641,"_156":615,"_157":139,"_158":642,"_160":161,"_105":643,"_100":419,"_163":226,"_165":644,"_166":22,"_167":-5,"_168":1164,"_98":1165},[],[607,614,640],{"_103":648,"_95":649,"_154":650,"_156":615,"_157":139,"_158":651,"_160":161,"_105":652,"_100":159,"_163":226,"_165":653,"_166":22,"_167":-5,"_168":1167,"_98":1168},[],[607,614,649],{"_103":657,"_95":658,"_154":659,"_156":615,"_157":139,"_158":660,"_160":161,"_105":661,"_100":254,"_163":226,"_165":662,"_166":22,"_167":-5,"_168":1170,"_98":1171},[],[607,614,658],{"_103":666,"_95":667,"_154":668,"_156":615,"_157":139,"_158":669,"_160":161,"_105":670,"_100":463,"_163":226,"_165":671,"_166":22,"_167":-5,"_168":1173,"_98":1174},[],[607,614,667],{"_103":675,"_95":676,"_154":677,"_156":615,"_157":139,"_158":678,"_160":161,"_105":679,"_100":372,"_163":226,"_165":680,"_166":22,"_167":-5,"_168":1176,"_98":1177},[],[607,614,676],{"_103":684,"_95":685,"_154":686,"_156":615,"_157":139,"_158":687,"_160":161,"_105":688,"_100":32,"_163":226,"_165":689,"_166":22,"_167":-5,"_168":1179,"_98":1180},[],[607,614,685],[607,614],{"_103":694,"_95":695,"_154":696,"_156":608,"_157":139,"_158":697,"_160":161,"_105":698,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1183,"_98":1184},[],[607,695],{"_103":702,"_95":703,"_154":704,"_156":608,"_157":139,"_158":705,"_160":161,"_105":706,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1186,"_98":1190},[1187],{"_103":709,"_95":710,"_154":711,"_156":704,"_157":139,"_158":712,"_160":161,"_105":713,"_100":32,"_163":226,"_165":714,"_166":22,"_167":-5,"_168":1188,"_98":1189},[],[607,703,710],[607,703],{"_103":719,"_95":505,"_154":720,"_156":608,"_157":139,"_158":721,"_160":161,"_105":722,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1192,"_98":1193},[],[607,505],{"_103":726,"_95":727,"_154":728,"_156":608,"_157":139,"_158":729,"_160":161,"_105":730,"_100":463,"_163":177,"_165":731,"_166":22,"_167":-5,"_168":1195,"_98":1196},[],[607,727],{"_103":735,"_95":736,"_154":737,"_156":608,"_157":139,"_158":738,"_160":161,"_105":739,"_100":119,"_163":226,"_165":740,"_166":22,"_167":-5,"_168":1198,"_98":1199},[],[607,736],[607],{"_103":745,"_95":746,"_154":747,"_156":-5,"_157":139,"_158":748,"_160":161,"_105":749,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1202,"_98":1248},[1203,1209,1215,1221],{"_103":752,"_95":753,"_154":754,"_156":747,"_157":139,"_158":755,"_160":161,"_105":756,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1204,"_98":1208},[1205],{"_103":759,"_95":760,"_154":761,"_156":754,"_157":139,"_158":762,"_160":161,"_105":763,"_100":119,"_163":226,"_165":764,"_166":22,"_167":-5,"_168":1206,"_98":1207},[],[746,753,760],[746,753],{"_103":769,"_95":770,"_154":771,"_156":747,"_157":139,"_158":382,"_160":161,"_105":772,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1210,"_98":1214},[1211],{"_103":775,"_95":776,"_154":777,"_156":771,"_157":139,"_158":778,"_160":161,"_105":779,"_100":159,"_163":226,"_165":780,"_166":22,"_167":-5,"_168":1212,"_98":1213},[],[746,770,776],[746,770],{"_103":785,"_95":786,"_154":787,"_156":747,"_157":139,"_158":788,"_160":161,"_105":789,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1216,"_98":1220},[1217],{"_103":792,"_95":793,"_154":794,"_156":787,"_157":139,"_158":795,"_160":161,"_105":796,"_100":463,"_163":226,"_165":797,"_166":22,"_167":-5,"_168":1218,"_98":1219},[],[746,786,793],[746,786],{"_103":802,"_95":803,"_154":804,"_156":747,"_157":139,"_158":419,"_160":161,"_105":805,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1222,"_98":1247},[1223,1226,1229,1232,1235,1238,1241,1244],{"_103":808,"_95":809,"_154":810,"_156":804,"_157":139,"_158":811,"_160":161,"_105":812,"_100":32,"_163":226,"_165":813,"_166":22,"_167":-5,"_168":1224,"_98":1225},[],[746,803,809],{"_103":817,"_95":818,"_154":819,"_156":804,"_157":139,"_158":820,"_160":161,"_105":821,"_100":32,"_163":226,"_165":822,"_166":22,"_167":-5,"_168":1227,"_98":1228},[],[746,803,818],{"_103":826,"_95":827,"_154":828,"_156":804,"_157":139,"_158":829,"_160":161,"_105":830,"_100":119,"_163":226,"_165":831,"_166":22,"_167":-5,"_168":1230,"_98":1231},[],[746,803,827],{"_103":835,"_95":836,"_154":837,"_156":804,"_157":139,"_158":838,"_160":161,"_105":839,"_100":32,"_163":226,"_165":840,"_166":22,"_167":-5,"_168":1233,"_98":1234},[],[746,803,836],{"_103":844,"_95":845,"_154":846,"_156":804,"_157":139,"_158":847,"_160":161,"_105":848,"_100":159,"_163":226,"_165":849,"_166":22,"_167":-5,"_168":1236,"_98":1237},[],[746,803,845],{"_103":853,"_95":854,"_154":855,"_156":804,"_157":139,"_158":856,"_160":161,"_105":857,"_100":32,"_163":226,"_165":858,"_166":22,"_167":-5,"_168":1239,"_98":1240},[],[746,803,854],{"_103":862,"_95":863,"_154":864,"_156":804,"_157":139,"_158":865,"_160":161,"_105":866,"_100":119,"_163":226,"_165":867,"_166":22,"_167":-5,"_168":1242,"_98":1243},[],[746,803,863],{"_103":871,"_95":872,"_154":873,"_156":804,"_157":139,"_158":874,"_160":161,"_105":875,"_100":32,"_163":226,"_165":876,"_166":22,"_167":-5,"_168":1245,"_98":1246},[],[746,803,872],[746,803],[746],{"_103":882,"_95":703,"_154":883,"_156":-5,"_157":139,"_158":884,"_160":161,"_105":885,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":1250,"_98":1254},[1251],{"_103":888,"_95":889,"_154":890,"_156":883,"_157":139,"_158":891,"_160":161,"_105":892,"_100":32,"_163":226,"_165":893,"_166":22,"_167":-5,"_168":1252,"_98":1253},[],[703,889],[703],{"_103":898,"_95":899,"_154":900,"_156":-5,"_157":139,"_158":176,"_160":161,"_105":901,"_100":32,"_163":177,"_165":902,"_166":22,"_167":-5,"_168":1256,"_98":1257},[],[899],{"_103":906,"_95":907,"_154":908,"_156":-5,"_157":139,"_158":909,"_160":161,"_105":910,"_100":32,"_163":177,"_165":911,"_166":22,"_167":-5,"_168":1259,"_98":1260},[],[907],{"_103":915,"_95":916,"_154":917,"_156":-5,"_157":139,"_158":918,"_160":161,"_105":919,"_100":920,"_163":177,"_165":921,"_166":22,"_167":-5,"_168":1262,"_98":1263},[],[916],{"_103":925,"_95":926,"_154":927,"_156":-5,"_157":139,"_158":928,"_160":161,"_105":929,"_100":930,"_163":177,"_165":931,"_166":22,"_167":-5,"_168":1265,"_98":1266},[],[926],{"_103":935,"_95":936,"_154":937,"_156":-5,"_157":139,"_158":938,"_160":161,"_105":939,"_100":940,"_163":177,"_165":941,"_166":22,"_167":-5,"_168":1268,"_98":1269},[],[936],{"_103":945,"_95":946,"_154":947,"_156":-5,"_157":139,"_158":948,"_160":161,"_105":949,"_100":119,"_163":177,"_165":950,"_166":22,"_167":-5,"_168":1271,"_98":1272},[],[946],{"_103":954,"_95":955,"_154":956,"_156":-5,"_157":139,"_158":957,"_160":161,"_105":958,"_100":959,"_163":960,"_165":961,"_166":22,"_167":962,"_168":1274,"_98":1275},[],[955],{"_103":966,"_95":967,"_154":968,"_156":-5,"_157":139,"_158":969,"_160":161,"_105":970,"_100":32,"_163":177,"_165":971,"_166":22,"_167":-5,"_168":1277,"_98":1278},[],[967],[1003,1005,1009,1011,1013,1018,1020,1022,1025,1028,1031,1034,1037,1040,1043,1046,1050,1052,1055,1059,1061,1064,1067,1070,1073,1077,1079,1082,1085,1089,1091,1095,1097,1100,1104,1106,1109,1112,1116,1118,1121,1124,1127,1132,1135,1137,1140,1144,1146,1149,1153,1155,1157,1160,1163,1166,1169,1172,1175,1178,1182,1185,1187,1191,1194,1197,1201,1203,1205,1209,1211,1215,1217,1221,1223,1226,1229,1232,1235,1238,1241,1244,1249,1251,1255,1258,1261,1264,1267,1270,1273,1276],{"_103":183,"_95":99,"_154":184,"_156":-5,"_157":139,"_158":185,"_160":161,"_105":989,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":1281},[99],[1283],{"_103":189,"_95":190,"_154":191,"_156":184,"_157":139,"_158":192,"_160":161,"_105":986,"_100":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":1284},[99,190],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]