[{"_1":2,"_434":-5,"_435":-5},"loaderData",{"_3":4,"_91":92,"_349":350},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","cb8a548cff96feeeeb30b528c9619e76cb377f13","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":43,"_98":72,"_99":100,"_101":102,"_149":150,"_312":313,"_314":315,"_320":321,"_184":-5,"_343":-5,"_344":-5,"_345":22,"_346":22,"_347":348},"handle","tijs","name","location-feed-generator","branchName","path","version",18,"project",{"_103":104,"_95":96,"_105":106,"_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":130,"_133":134,"_136":137,"_148":22},"id","db7bc7d6-58ab-11f0-bdec-f69ea79377d9","createdAt",["D",1751615559344],"deletedAt","legacyEnvVars","privacy","public","description","This is the Anchor AppView - location based feed generator","imageUrl","14049850-28c1-11f0-89c9-c7d0e2d9e1ea","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"c04d51b2-a7dc-46ca-ad6f-52f47c2906a8","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd2Nod2N0bE1MWFdEUlRYd083ZE5pbXJ1bDAifQ","org",{"_93":94,"_135":132},"avatar","branch",{"_99":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},1067,"db7c07aa-58ab-11f0-bdec-f69ea79377d9","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[151,171,189,197,205,245,304],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":162,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":169,"_98":170},"56d49838-58b4-11f0-9e45-f69ea79377d9",".claude","fileId","56d499b4-58b4-11f0-9e45-f69ea79377d9","parentId","branchId","branchVersion",4,"latest",true,["D",1751619202254],"fileType","directory","content","deleted","label","children",[],[153],{"_103":172,"_95":173,"_154":174,"_156":-5,"_157":139,"_158":175,"_160":161,"_105":176,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":177,"_98":188},"56a78f96-58b4-11f0-9210-f69ea79377d9","database","56a79054-58b4-11f0-9210-f69ea79377d9",2,["D",1751619201960],[178],{"_103":179,"_95":180,"_154":181,"_156":174,"_157":139,"_158":182,"_160":22,"_105":183,"_99":32,"_163":184,"_165":185,"_166":22,"_167":-5,"_168":186,"_98":187},"57f0a28e-58b4-11f0-aaa5-f69ea79377d9","database-schema.sql","57f0a342-58b4-11f0-aaa5-f69ea79377d9",15,["D",1751619204117],"file","-- Anchor AppView Database Schema for Val Town SQLite\n-- Phase 1: Core Infrastructure\n\n-- Main checkins table\nCREATE TABLE IF NOT EXISTS checkins_v1 (\n id TEXT PRIMARY KEY, -- record rkey\n uri TEXT UNIQUE NOT NULL, -- full AT URI\n author_did TEXT NOT NULL, -- creator DID\n author_handle TEXT, -- cached handle for display\n text TEXT NOT NULL, -- checkin message\n created_at TEXT NOT NULL, -- ISO timestamp\n \n -- Extracted coordinates\n latitude REAL,\n longitude REAL,\n \n -- Address reference (strongref)\n address_ref_uri TEXT, -- URI to address record\n address_ref_cid TEXT, -- content hash for verification\n \n -- Cached resolved address data\n cached_address_name TEXT, -- venue name\n cached_address_street TEXT, -- street address\n cached_address_locality TEXT, -- city\n cached_address_region TEXT, -- state/province\n cached_address_country TEXT, -- country code\n cached_address_postal_code TEXT, -- postal code\n cached_address_full JSON, -- complete resolved address object\n \n -- Metadata\n address_resolved_at TEXT, -- when address was last resolved\n indexed_at TEXT DEFAULT CURRENT_TIMESTAMP\n);\n\n-- Address cache for efficiency\nCREATE TABLE IF NOT EXISTS address_cache_v1 (\n uri TEXT PRIMARY KEY, -- address record URI\n cid TEXT, -- content hash\n name TEXT,\n street TEXT,\n locality TEXT,\n region TEXT,\n country TEXT,\n postal_code TEXT,\n latitude REAL,\n longitude REAL,\n full_data JSON, -- complete address record\n resolved_at TEXT, -- when successfully fetched\n failed_at TEXT -- if resolution failed\n);\n\n-- Social graph for following feeds (v2)\nCREATE TABLE IF NOT EXISTS user_follows_v1 (\n follower_did TEXT NOT NULL,\n following_did TEXT NOT NULL,\n created_at TEXT,\n synced_at TEXT DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (follower_did, following_did)\n);\n\n-- Processing logs for monitoring\nCREATE TABLE IF NOT EXISTS processing_log_v1 (\n id INTEGER PRIMARY KEY,\n run_at TEXT NOT NULL,\n events_processed INTEGER DEFAULT 0,\n errors INTEGER DEFAULT 0,\n duration_ms INTEGER\n);\n\n-- Performance indexes\nCREATE INDEX IF NOT EXISTS idx_checkins_created ON checkins_v1(created_at DESC);\nCREATE INDEX IF NOT EXISTS idx_checkins_author ON checkins_v1(author_did);\nCREATE INDEX IF NOT EXISTS idx_checkins_location ON checkins_v1(latitude, longitude);\nCREATE INDEX IF NOT EXISTS idx_follows_follower ON user_follows_v1(follower_did);",[],[173,180],[173],{"_103":190,"_95":191,"_154":192,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":194,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":195,"_98":196},"56ec730e-58b4-11f0-8987-f69ea79377d9","docs","56ec73e0-58b4-11f0-8987-f69ea79377d9",5,["D",1751619202409],[],[191],{"_103":198,"_95":199,"_154":200,"_156":-5,"_157":139,"_158":201,"_160":22,"_105":202,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":203,"_98":204},"5703f59c-58b4-11f0-a3e4-f69ea79377d9","scripts","5703f66e-58b4-11f0-a3e4-f69ea79377d9",6,["D",1751619202565],[],[199],{"_103":206,"_95":207,"_154":208,"_156":-5,"_157":139,"_158":209,"_160":22,"_105":210,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":211,"_98":244},"571dd57a-58b4-11f0-b0d2-f69ea79377d9","src","571dd64c-58b4-11f0-b0d2-f69ea79377d9",7,["D",1751619202735],[212,220,228,236],{"_103":213,"_95":214,"_154":215,"_156":208,"_157":139,"_158":216,"_160":22,"_105":217,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":218,"_98":219},"57da2ed2-58b4-11f0-9210-f69ea79377d9","api","57da2fa4-58b4-11f0-9210-f69ea79377d9",14,["D",1751619203969],[],[207,214],{"_103":221,"_95":222,"_154":223,"_156":208,"_157":139,"_158":224,"_160":22,"_105":225,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":226,"_98":227},"578c11de-58b4-11f0-acd5-f69ea79377d9","ingestion","578c127e-58b4-11f0-acd5-f69ea79377d9",11,["D",1751619203457],[],[207,222],{"_103":229,"_95":230,"_154":231,"_156":208,"_157":139,"_158":232,"_160":22,"_105":233,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":234,"_98":235},"57b95ba8-58b4-11f0-a9f0-f69ea79377d9","social","57b95c70-58b4-11f0-a9f0-f69ea79377d9",13,["D",1751619203754],[],[207,230],{"_103":237,"_95":238,"_154":239,"_156":208,"_157":139,"_158":240,"_160":22,"_105":241,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":242,"_98":243},"57a2ef6c-58b4-11f0-a9f0-f69ea79377d9","utils","57a2f034-58b4-11f0-a9f0-f69ea79377d9",12,["D",1751619203606],[],[207,238],[207],{"_103":246,"_95":247,"_154":248,"_156":-5,"_157":139,"_158":249,"_160":161,"_105":250,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":251,"_98":303},"56be52d0-58b4-11f0-9210-f69ea79377d9","tests","56be5424-58b4-11f0-9210-f69ea79377d9",3,["D",1751619202108],[252,260,268],{"_103":253,"_95":254,"_154":255,"_156":248,"_157":139,"_158":256,"_160":161,"_105":257,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":258,"_98":259},"5769d894-58b4-11f0-a0a5-f69ea79377d9","fixtures","5769d952-58b4-11f0-a0a5-f69ea79377d9",10,["D",1751619203233],[],[247,254],{"_103":261,"_95":262,"_154":263,"_156":248,"_157":139,"_158":264,"_160":161,"_105":265,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":266,"_98":267},"5753ebce-58b4-11f0-9040-f69ea79377d9","integration","5753ec82-58b4-11f0-9040-f69ea79377d9",9,["D",1751619203088],[],[247,262],{"_103":269,"_95":270,"_154":271,"_156":248,"_157":139,"_158":272,"_160":161,"_105":273,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":274,"_98":302},"573c83c6-58b4-11f0-a3e4-f69ea79377d9","unit","573c8484-58b4-11f0-a3e4-f69ea79377d9",8,["D",1751619202935],[275,285,294],{"_103":276,"_95":277,"_154":278,"_156":271,"_157":139,"_158":279,"_160":22,"_105":280,"_99":32,"_163":281,"_165":282,"_166":22,"_167":-5,"_168":283,"_98":284},"57fd2414-58b4-11f0-9e45-f69ea79377d9","address-cache.test.ts","57fd24e6-58b4-11f0-9e45-f69ea79377d9",17,["D",1751619204121],"script","import { assertEquals, assertExists } from \"https://deno.land/std@0.208.0/assert/mod.ts\";\nimport { stub, restore } from \"https://deno.land/std@0.208.0/testing/mock.ts\";\n\n// Mock blob storage for testing\nconst mockBlobStorage = new Map();\n\n// Mock the blob import\nconst mockBlob = {\n async getJSON(key: string) {\n return mockBlobStorage.get(key) || null;\n },\n async setJSON(key: string, value: any) {\n mockBlobStorage.set(key, value);\n },\n async delete(key: string) {\n mockBlobStorage.delete(key);\n },\n async list(prefix: string) {\n return Array.from(mockBlobStorage.keys()).filter(key => key.startsWith(prefix));\n }\n};\n\n// Import and test the address cache functions\nimport { \n getCachedAddress, \n setCachedAddress, \n setCachedAddressFailure, \n getCacheStats \n} from \"../../src/utils/address-cache.ts\";\n\n// Mock the blob import in the module\nconst originalImport = (await import(\"../../src/utils/address-cache.ts\"));\n\nDeno.test(\"Address Cache - setCachedAddress stores address data\", async () => {\n const testUri = \"at://did:plc:test/collection/record\";\n const testAddress = {\n name: \"Test Venue\",\n street: \"123 Test St\",\n locality: \"Test City\",\n region: \"TS\",\n country: \"TC\",\n postalCode: \"12345\",\n latitude: 40.7128,\n longitude: -74.0060\n };\n\n // Clear storage\n mockBlobStorage.clear();\n\n // This test demonstrates the expected interface\n // In actual implementation, we'd need to mock the blob import differently\n const cacheKey = `address_cache_${encodeURIComponent(testUri)}`;\n await mockBlob.setJSON(cacheKey, {\n ...testAddress,\n resolvedAt: new Date().toISOString()\n });\n\n const stored = await mockBlob.getJSON(cacheKey);\n assertExists(stored);\n assertEquals(stored.name, \"Test Venue\");\n assertEquals(stored.latitude, 40.7128);\n});\n\nDeno.test(\"Address Cache - cache expiry logic\", async () => {\n const testUri = \"at://did:plc:expired/collection/record\";\n const cacheKey = `address_cache_${encodeURIComponent(testUri)}`;\n \n // Store an expired entry (31 days old)\n const expiredDate = new Date();\n expiredDate.setDate(expiredDate.getDate() - 31);\n \n await mockBlob.setJSON(cacheKey, {\n name: \"Expired Venue\",\n resolvedAt: expiredDate.toISOString()\n });\n\n const stored = await mockBlob.getJSON(cacheKey);\n assertExists(stored);\n \n // Check if entry would be considered expired\n const cacheAge = Date.now() - new Date(stored.resolvedAt).getTime();\n const maxAge = 30 * 24 * 60 * 60 * 1000; // 30 days\n assertEquals(cacheAge > maxAge, true);\n});\n\nDeno.test(\"Address Cache - failure caching\", async () => {\n const testUri = \"at://did:plc:failed/collection/record\";\n const cacheKey = `address_cache_${encodeURIComponent(testUri)}`;\n \n await mockBlob.setJSON(cacheKey, {\n failedAt: new Date().toISOString(),\n resolvedAt: new Date().toISOString()\n });\n\n const stored = await mockBlob.getJSON(cacheKey);\n assertExists(stored);\n assertExists(stored.failedAt);\n});\n\nDeno.test(\"Address Cache - cache statistics\", async () => {\n mockBlobStorage.clear();\n \n // Add some test entries\n await mockBlob.setJSON(\"address_cache_success1\", {\n name: \"Success 1\",\n resolvedAt: new Date().toISOString()\n });\n \n await mockBlob.setJSON(\"address_cache_success2\", {\n name: \"Success 2\", \n resolvedAt: new Date().toISOString()\n });\n \n await mockBlob.setJSON(\"address_cache_failed1\", {\n failedAt: new Date().toISOString(),\n resolvedAt: new Date().toISOString()\n });\n\n const keys = await mockBlob.list(\"address_cache_\");\n assertEquals(keys.length, 3);\n \n // Count failed entries\n let failedCount = 0;\n for (const key of keys) {\n const cached = await mockBlob.getJSON(key);\n if (cached?.failedAt) failedCount++;\n }\n \n assertEquals(failedCount, 1);\n});",[],[247,270,277],{"_103":286,"_95":287,"_154":288,"_156":271,"_157":139,"_158":289,"_160":22,"_105":290,"_99":32,"_163":281,"_165":291,"_166":22,"_167":-5,"_168":292,"_98":293},"57f61b7e-58b4-11f0-9539-f69ea79377d9","database.test.ts","57f61c3c-58b4-11f0-9539-f69ea79377d9",16,["D",1751619204119],"import { assertEquals, assertExists } from \"https://deno.land/std@0.208.0/assert/mod.ts\";\n\n// Mock SQLite implementation for testing\nclass MockSQLite {\n private tables = new Map();\n private tableSchemas = new Map();\n\n async execute(query: string, params: any[] = []): Promise {\n const normalizedQuery = query.trim().toLowerCase();\n \n // Handle CREATE TABLE\n if (normalizedQuery.startsWith('create table')) {\n const tableName = this.extractTableName(query, 'create table');\n if (tableName) {\n this.tables.set(tableName, []);\n this.tableSchemas.set(tableName, query);\n }\n return [];\n }\n \n // Handle CREATE INDEX\n if (normalizedQuery.startsWith('create index')) {\n return [];\n }\n \n // Handle INSERT\n if (normalizedQuery.startsWith('insert')) {\n const tableName = this.extractTableName(query, 'insert');\n if (tableName && this.tables.has(tableName)) {\n const table = this.tables.get(tableName)!;\n // Extract field names from the query\n const fieldsMatch = query.match(/\\(([^)]+)\\)\\s*values/i);\n if (fieldsMatch) {\n const fieldNames = fieldsMatch[1].split(',').map(f => f.trim());\n const record: any = {};\n fieldNames.forEach((field, index) => {\n if (params[index] !== undefined) {\n record[field] = params[index];\n }\n });\n table.push(record);\n } else {\n // Fallback for checkins_v1\n const record: any = {};\n if (tableName === 'checkins_v1') {\n const fields = ['id', 'uri', 'author_did', 'author_handle', 'text', 'created_at', 'latitude', 'longitude', 'address_ref_uri', 'address_ref_cid'];\n fields.forEach((field, index) => {\n if (params[index] !== undefined) {\n record[field] = params[index];\n }\n });\n }\n table.push(record);\n }\n }\n return [];\n }\n \n // Handle SELECT\n if (normalizedQuery.startsWith('select')) {\n const tableName = this.extractTableName(query, 'from');\n if (tableName && this.tables.has(tableName)) {\n let results = [...this.tables.get(tableName)!];\n \n // Simple WHERE clause handling\n if (query.toLowerCase().includes('where') && params.length > 0) {\n if (query.toLowerCase().includes('id = ?')) {\n results = results.filter(row => row.id === params[0]);\n }\n if (query.toLowerCase().includes('author_did = ?')) {\n results = results.filter(row => row.author_did === params[0]);\n }\n }\n \n // Handle COUNT queries\n if (normalizedQuery.includes('count(*)')) {\n return [{ count: results.length }];\n }\n \n return results;\n }\n }\n \n return [];\n }\n\n private extractTableName(query: string, keyword: string): string | null {\n let regex: RegExp;\n \n if (keyword === 'create table') {\n regex = /create\\s+table\\s+(?:if\\s+not\\s+exists\\s+)?(\\w+)/i;\n } else if (keyword === 'insert') {\n regex = /insert\\s+(?:or\\s+ignore\\s+)?into\\s+(\\w+)/i;\n } else if (keyword === 'from') {\n regex = /from\\s+(\\w+)/i;\n } else {\n regex = new RegExp(`${keyword}\\\\s+(?:if\\\\s+not\\\\s+exists\\\\s+)?([\\\\w_]+)`, 'i');\n }\n \n const match = query.match(regex);\n return match ? match[1].toLowerCase() : null;\n }\n\n reset() {\n this.tables.clear();\n this.tableSchemas.clear();\n }\n}\n\nconst mockSqlite = new MockSQLite();\n\n// Test database table creation\nDeno.test(\"Database - table creation\", async () => {\n mockSqlite.reset();\n \n // Test checkins table creation\n await mockSqlite.execute(`\n CREATE TABLE IF NOT EXISTS checkins_v1 (\n id TEXT PRIMARY KEY,\n uri TEXT UNIQUE NOT NULL,\n author_did TEXT NOT NULL,\n author_handle TEXT,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL,\n latitude REAL,\n longitude REAL,\n address_ref_uri TEXT,\n address_ref_cid TEXT,\n cached_address_name TEXT,\n cached_address_street TEXT,\n cached_address_locality TEXT,\n cached_address_region TEXT,\n cached_address_country TEXT,\n cached_address_postal_code TEXT,\n cached_address_full JSON,\n address_resolved_at TEXT,\n indexed_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Verify table was created\n const result = await mockSqlite.execute(\"SELECT * FROM checkins_v1\");\n assertEquals(Array.isArray(result), true);\n assertEquals(result.length, 0);\n});\n\nDeno.test(\"Database - checkin insertion and retrieval\", async () => {\n mockSqlite.reset();\n \n // Create table\n await mockSqlite.execute(`\n CREATE TABLE IF NOT EXISTS checkins_v1 (\n id TEXT PRIMARY KEY,\n uri TEXT UNIQUE NOT NULL,\n author_did TEXT NOT NULL,\n author_handle TEXT,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL,\n latitude REAL,\n longitude REAL,\n address_ref_uri TEXT,\n address_ref_cid TEXT\n )\n `);\n\n // Insert test data\n await mockSqlite.execute(`\n INSERT INTO checkins_v1 \n (id, uri, author_did, author_handle, text, created_at, latitude, longitude, address_ref_uri, address_ref_cid)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n \"test123\",\n \"at://did:plc:test/app.dropanchor.checkin/test123\",\n \"did:plc:test\",\n \"test.bsky.social\",\n \"Great coffee!\",\n \"2024-01-01T12:00:00Z\",\n 40.7128,\n -74.0060,\n null,\n null\n ]);\n\n // Retrieve all checkins\n const allCheckins = await mockSqlite.execute(\"SELECT * FROM checkins_v1\");\n assertEquals(allCheckins.length, 1);\n assertEquals(allCheckins[0].id, \"test123\");\n assertEquals(allCheckins[0].text, \"Great coffee!\");\n\n // Test duplicate prevention\n const duplicateCheck = await mockSqlite.execute(\"SELECT id FROM checkins_v1 WHERE id = ?\", [\"test123\"]);\n assertEquals(duplicateCheck.length, 1);\n});\n\nDeno.test(\"Database - schema validation\", async () => {\n mockSqlite.reset();\n \n // Test that we can create all required tables without errors\n const tables = [\n 'checkins_v1',\n 'address_cache_v1', \n 'user_follows_v1',\n 'processing_log_v1'\n ];\n \n // Create checkins table\n await mockSqlite.execute(`\n CREATE TABLE IF NOT EXISTS checkins_v1 (\n id TEXT PRIMARY KEY,\n uri TEXT UNIQUE NOT NULL,\n author_did TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n \n // Create other tables\n await mockSqlite.execute(`CREATE TABLE IF NOT EXISTS address_cache_v1 (uri TEXT PRIMARY KEY)`);\n await mockSqlite.execute(`CREATE TABLE IF NOT EXISTS user_follows_v1 (follower_did TEXT, following_did TEXT)`);\n await mockSqlite.execute(`CREATE TABLE IF NOT EXISTS processing_log_v1 (id INTEGER PRIMARY KEY)`);\n \n // Verify all tables exist (mock should have them in memory)\n const mockInstance = mockSqlite as any;\n for (const table of tables) {\n assertEquals(mockInstance.tables.has(table), true, `Table ${table} should exist`);\n }\n});\n\nDeno.test(\"Database - count queries\", async () => {\n mockSqlite.reset();\n \n // Create and populate table\n await mockSqlite.execute(`\n CREATE TABLE IF NOT EXISTS checkins_v1 (\n id TEXT PRIMARY KEY,\n uri TEXT UNIQUE NOT NULL,\n author_did TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at TEXT NOT NULL\n )\n `);\n\n // Insert test records\n for (let i = 1; i <= 5; i++) {\n await mockSqlite.execute(`\n INSERT INTO checkins_v1 (id, uri, author_did, text, created_at)\n VALUES (?, ?, ?, ?, ?)\n `, [`id${i}`, `uri${i}`, `did:plc:user${i}`, `text${i}`, \"2024-01-01T12:00:00Z\"]);\n }\n\n // Test count query\n const countResult = await mockSqlite.execute(\"SELECT COUNT(*) as count FROM checkins_v1\");\n assertEquals(countResult.length, 1);\n assertEquals(countResult[0].count, 5);\n});\n\nDeno.test(\"Database - address cache table operations\", async () => {\n mockSqlite.reset();\n\n // Create address cache table\n await mockSqlite.execute(`\n CREATE TABLE IF NOT EXISTS address_cache_v1 (\n uri TEXT PRIMARY KEY,\n cid TEXT,\n name TEXT,\n street TEXT,\n locality TEXT,\n region TEXT,\n country TEXT,\n postal_code TEXT,\n latitude REAL,\n longitude REAL,\n full_data JSON,\n resolved_at TEXT,\n failed_at TEXT\n )\n `);\n\n // Verify table creation\n const result = await mockSqlite.execute(\"SELECT * FROM address_cache_v1\");\n assertEquals(Array.isArray(result), true);\n});\n\nDeno.test(\"Database - processing logs\", async () => {\n mockSqlite.reset();\n\n // Create processing log table\n await mockSqlite.execute(`\n CREATE TABLE IF NOT EXISTS processing_log_v1 (\n id INTEGER PRIMARY KEY,\n run_at TEXT NOT NULL,\n events_processed INTEGER DEFAULT 0,\n errors INTEGER DEFAULT 0,\n duration_ms INTEGER\n )\n `);\n\n // Test table was created successfully\n const result = await mockSqlite.execute(\"SELECT * FROM processing_log_v1\");\n assertEquals(Array.isArray(result), true);\n});",[],[247,270,287],{"_103":295,"_95":296,"_154":297,"_156":271,"_157":139,"_158":100,"_160":22,"_105":298,"_99":32,"_163":281,"_165":299,"_166":22,"_167":-5,"_168":300,"_98":301},"580105c0-58b4-11f0-a0a5-f69ea79377d9","spatial.test.ts","5801066a-58b4-11f0-a0a5-f69ea79377d9",["D",1751619204223],"import { assertEquals, assertAlmostEquals } from \"https://deno.land/std@0.208.0/assert/mod.ts\";\n\n// Haversine distance calculation (from the API code)\nfunction calculateDistance(lat1: number, lng1: number, lat2: number, lng2: number): 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(centerLat, centerLng, checkin.latitude, checkin.longitude)\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(nearbyCheckins[0].distance! <= nearbyCheckins[1].distance!, true);\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});",[],[247,270,296],[247,270],[247],{"_103":305,"_95":306,"_154":307,"_156":-5,"_157":139,"_158":119,"_160":22,"_105":308,"_99":32,"_163":281,"_165":72,"_166":22,"_167":309,"_168":310,"_98":311},"db7d9232-58ab-11f0-bdec-f69ea79377d9","main.tsx","db7d92c8-58ab-11f0-bdec-f69ea79377d9",["D",1751615559352],"dropanchor",[],[306],"files",[151,171,178,189,197,205,212,220,228,236,245,252,260,268,275,285,294,304],"counts",{"_316":32,"_317":119,"_318":32,"_319":209},"pulls","branches","forks","envVars","contents",[322,325,328,331,334,337,340],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":323,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":324},["D",1751619202254],[153],{"_103":172,"_95":173,"_154":174,"_156":-5,"_157":139,"_158":175,"_160":161,"_105":326,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":327},["D",1751619201960],[173],{"_103":190,"_95":191,"_154":192,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":329,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":330},["D",1751619202409],[191],{"_103":198,"_95":199,"_154":200,"_156":-5,"_157":139,"_158":201,"_160":22,"_105":332,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":333},["D",1751619202565],[199],{"_103":206,"_95":207,"_154":208,"_156":-5,"_157":139,"_158":209,"_160":22,"_105":335,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":336},["D",1751619202735],[207],{"_103":246,"_95":247,"_154":248,"_156":-5,"_157":139,"_158":249,"_160":161,"_105":338,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":339},["D",1751619202108],[247],{"_103":305,"_95":306,"_154":307,"_156":-5,"_157":139,"_158":119,"_160":22,"_105":341,"_99":32,"_163":281,"_165":72,"_166":22,"_167":309,"_98":342},["D",1751615559352],[306],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_99":100,"_98":72,"_101":351,"_149":356,"_312":411,"_184":-7,"_320":412,"_427":-5,"_428":22,"_429":-5,"_430":-5,"_431":-5,"_432":433},{"_103":104,"_95":96,"_105":352,"_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":353,"_133":354,"_136":355,"_148":22},["D",1751615559344],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_99":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[357,360,366,369,372,387,408],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":162,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":358,"_98":359},[],[153],{"_103":172,"_95":173,"_154":174,"_156":-5,"_157":139,"_158":175,"_160":161,"_105":176,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":361,"_98":365},[362],{"_103":179,"_95":180,"_154":181,"_156":174,"_157":139,"_158":182,"_160":22,"_105":183,"_99":32,"_163":184,"_165":185,"_166":22,"_167":-5,"_168":363,"_98":364},[],[173,180],[173],{"_103":190,"_95":191,"_154":192,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":194,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":367,"_98":368},[],[191],{"_103":198,"_95":199,"_154":200,"_156":-5,"_157":139,"_158":201,"_160":22,"_105":202,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":370,"_98":371},[],[199],{"_103":206,"_95":207,"_154":208,"_156":-5,"_157":139,"_158":209,"_160":22,"_105":210,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":373,"_98":386},[374,377,380,383],{"_103":213,"_95":214,"_154":215,"_156":208,"_157":139,"_158":216,"_160":22,"_105":217,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":375,"_98":376},[],[207,214],{"_103":221,"_95":222,"_154":223,"_156":208,"_157":139,"_158":224,"_160":22,"_105":225,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":378,"_98":379},[],[207,222],{"_103":229,"_95":230,"_154":231,"_156":208,"_157":139,"_158":232,"_160":22,"_105":233,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":381,"_98":382},[],[207,230],{"_103":237,"_95":238,"_154":239,"_156":208,"_157":139,"_158":240,"_160":22,"_105":241,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":384,"_98":385},[],[207,238],[207],{"_103":246,"_95":247,"_154":248,"_156":-5,"_157":139,"_158":249,"_160":161,"_105":250,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":388,"_98":407},[389,392,395],{"_103":253,"_95":254,"_154":255,"_156":248,"_157":139,"_158":256,"_160":161,"_105":257,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":390,"_98":391},[],[247,254],{"_103":261,"_95":262,"_154":263,"_156":248,"_157":139,"_158":264,"_160":161,"_105":265,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":393,"_98":394},[],[247,262],{"_103":269,"_95":270,"_154":271,"_156":248,"_157":139,"_158":272,"_160":161,"_105":273,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_168":396,"_98":406},[397,400,403],{"_103":276,"_95":277,"_154":278,"_156":271,"_157":139,"_158":279,"_160":22,"_105":280,"_99":32,"_163":281,"_165":282,"_166":22,"_167":-5,"_168":398,"_98":399},[],[247,270,277],{"_103":286,"_95":287,"_154":288,"_156":271,"_157":139,"_158":289,"_160":22,"_105":290,"_99":32,"_163":281,"_165":291,"_166":22,"_167":-5,"_168":401,"_98":402},[],[247,270,287],{"_103":295,"_95":296,"_154":297,"_156":271,"_157":139,"_158":100,"_160":22,"_105":298,"_99":32,"_163":281,"_165":299,"_166":22,"_167":-5,"_168":404,"_98":405},[],[247,270,296],[247,270],[247],{"_103":305,"_95":306,"_154":307,"_156":-5,"_157":139,"_158":119,"_160":22,"_105":308,"_99":32,"_163":281,"_165":72,"_166":22,"_167":309,"_168":409,"_98":410},[],[306],[357,360,362,366,369,372,374,377,380,383,387,389,392,395,397,400,403,408],[413,415,417,419,421,423,425],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":323,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":414},[153],{"_103":172,"_95":173,"_154":174,"_156":-5,"_157":139,"_158":175,"_160":161,"_105":326,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":416},[173],{"_103":190,"_95":191,"_154":192,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":329,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":418},[191],{"_103":198,"_95":199,"_154":200,"_156":-5,"_157":139,"_158":201,"_160":22,"_105":332,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":420},[199],{"_103":206,"_95":207,"_154":208,"_156":-5,"_157":139,"_158":209,"_160":22,"_105":335,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":422},[207],{"_103":246,"_95":247,"_154":248,"_156":-5,"_157":139,"_158":249,"_160":161,"_105":338,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":424},[247],{"_103":305,"_95":306,"_154":307,"_156":-5,"_157":139,"_158":119,"_160":22,"_105":341,"_99":32,"_163":281,"_165":72,"_166":22,"_167":309,"_98":426},[306],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]