[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_246":247,"_248":249},"routes/_app.x.$handle.$name",{"_95":94,"_32":44,"_103":85,"_27":36,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":26,"_117":118,"_119":26,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":24,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":26},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path","new-file-1680.tsx","latestPath","fileId","f2f9e5c6-3f85-11f0-a786-76b3cceeab13","name","fileType","script","content","","createdAt",["D",1748850498809],"branchVersion","branchId","96238d58-3f84-11f0-b0be-76b3cceeab13","id","962348fc-3f84-11f0-b0be-76b3cceeab13","FindMyCar",["D",1748849913559],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","VehiclesFinder","imageUrl","defccae0-3f83-11f0-ad5b-814c56c8abb0","pinnedFileId","2dc95f68-3f9c-11f0-9808-76b3cceeab13","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","d0808b00-181f-4bcb-ac9d-1d1a3c21ac29","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":26},"branch",{"_13":84,"_32":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",89,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Sarax201","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d1dOeGY5REVGZU1uNWZSang1R1hiaFBqVyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_32":44,"_37":242,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":24,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":243,"_79":244,"_81":245,"_83":26},"tree",[171,177,179,180,181],"files",[171,172,173,174,175,176,177,178,179,180,181],"counts",{"_161":61,"_162":138,"_163":138,"_164":165,"_166":167},"contents",[124,125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":155,"_32":156,"_30":157,"_130":-5,"_40":41,"_39":158,"_131":24,"_37":159,"_13":61,"_33":153,"_35":-5,"_23":26,"_133":-5,"_27":160},{"_42":148,"_32":149,"_30":150,"_130":-5,"_40":41,"_39":151,"_131":24,"_37":152,"_13":61,"_33":153,"_35":-5,"_23":26,"_133":-5,"_27":154},{"_42":141,"_32":142,"_30":143,"_130":-5,"_40":41,"_39":144,"_131":26,"_37":145,"_13":138,"_33":20,"_35":146,"_23":26,"_133":-5,"_27":147},{"_42":135,"_32":136,"_30":137,"_130":-5,"_40":41,"_39":138,"_131":26,"_37":139,"_13":61,"_33":34,"_35":36,"_23":26,"_133":-5,"_27":140},{"_42":129,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_131":26,"_37":132,"_13":61,"_33":34,"_35":36,"_23":26,"_133":-5,"_27":134},"f2f9e508-3f85-11f0-a786-76b3cceeab13","parentId","latest",["D",1748850498809],"label",[28],"96252172-3f84-11f0-b0be-76b3cceeab13","main.tsx","96252226-3f84-11f0-b0be-76b3cceeab13",1,["D",1748849913568],[136],"5b8c154c-3f85-11f0-b83d-76b3cceeab13","README.md","eb5327ca-3f84-11f0-af7d-76b3cceeab13",5,["D",1748850244745],"# Lost Cars Finder App\n\nA comprehensive app to help reunite stolen vehicles with their owners.\n\n## Features\n\n### For Car Owners\n- Report stolen vehicles with detailed information\n- View reports of found cars that might match\n- Contact system when someone finds their car\n\n### For Good Samaritans\n- Report found/suspicious vehicles with photos\n- Add location, license plate, and vehicle details\n- Help reunite cars with owners\n\n### Core Functionality\n- Photo upload for found vehicles\n- Location tracking with maps\n- Search and filter system\n- Secure contact system\n- Mobile-responsive design\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server\n│ ├── database/\n│ │ ├── schema.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ ├── stolen.ts # Stolen car reports\n│ ├── found.ts # Found car reports\n│ └── matches.ts # Matching system\n├── frontend/\n│ ├── index.html # Main page\n│ ├── components/\n│ │ ├── App.tsx # Main React app\n│ │ ├── ReportStolen.tsx\n│ │ ├── ReportFound.tsx\n│ │ ├── CarList.tsx\n│ │ └── CarMap.tsx\n│ └── style.css\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The app runs on `/backend/index.ts` as an HTTP val\n2. Visit the main page to start reporting or searching for cars\n3. Use the map view to see locations of reported vehicles\n\n## Database\n\nUses SQLite with tables for:\n- `stolen_cars` - Reports from car owners\n- `found_cars` - Reports from people who found vehicles\n- `matches` - Potential matches between stolen and found cars",[142],"efb773d4-3f84-11f0-a1f4-76b3cceeab13","shared","d0f372b1-a8f7-4978-b98a-109430d74356",3,["D",1748850063838],"directory",[149],"f4bc9b34-3f84-11f0-917f-76b3cceeab13","backend","af436097-5c4b-4ae1-9232-154369ce0aba",4,["D",1748850072260],[156],"pulls","branches","forks","envVars",{"_168":61,"_170":61},"connections",{"_168":61,"_169":61},"count","unfilledCount","emptyCount",{"_42":155,"_32":156,"_30":157,"_130":-5,"_40":41,"_39":158,"_131":24,"_37":239,"_13":61,"_33":153,"_35":-5,"_23":26,"_133":-5,"_183":240,"_27":241},{"_42":235,"_32":226,"_30":220,"_130":157,"_40":41,"_39":158,"_131":24,"_37":236,"_13":61,"_33":153,"_35":-5,"_23":26,"_133":-5,"_183":237,"_27":238},{"_42":227,"_32":228,"_30":229,"_130":220,"_40":41,"_39":230,"_131":26,"_37":231,"_13":138,"_33":34,"_35":232,"_23":26,"_133":-5,"_183":233,"_27":234},{"_42":217,"_32":218,"_30":219,"_130":220,"_40":41,"_39":221,"_131":26,"_37":222,"_13":61,"_33":34,"_35":223,"_23":26,"_133":-5,"_183":224,"_27":225},{"_42":213,"_32":212,"_30":206,"_130":157,"_40":41,"_39":207,"_131":24,"_37":214,"_13":61,"_33":153,"_35":-5,"_23":26,"_133":-5,"_183":215,"_27":216},{"_42":203,"_32":204,"_30":205,"_130":206,"_40":41,"_39":207,"_131":24,"_37":208,"_13":61,"_33":34,"_35":209,"_23":26,"_133":-5,"_183":210,"_27":211},{"_42":148,"_32":149,"_30":150,"_130":-5,"_40":41,"_39":151,"_131":24,"_37":200,"_13":61,"_33":153,"_35":-5,"_23":26,"_133":-5,"_183":201,"_27":202},{"_42":192,"_32":193,"_30":194,"_130":150,"_40":41,"_39":195,"_131":24,"_37":196,"_13":138,"_33":34,"_35":197,"_23":26,"_133":-5,"_183":198,"_27":199},{"_42":141,"_32":142,"_30":143,"_130":-5,"_40":41,"_39":144,"_131":26,"_37":189,"_13":138,"_33":20,"_35":146,"_23":26,"_133":-5,"_183":190,"_27":191},{"_42":135,"_32":136,"_30":137,"_130":-5,"_40":41,"_39":138,"_131":26,"_37":186,"_13":61,"_33":34,"_35":36,"_23":26,"_133":-5,"_183":187,"_27":188},{"_42":129,"_32":28,"_30":31,"_130":-5,"_40":41,"_39":14,"_131":26,"_37":182,"_13":61,"_33":34,"_35":36,"_23":26,"_133":-5,"_183":184,"_27":185},["D",1748850498809],"children",[],[28],["D",1748849913568],[],[136],["D",1748850244745],[],[142],"765053ca-3f85-11f0-948f-76b3cceeab13","types.ts","efb76b82-3f84-11f0-a1f4-76b3cceeab13",6,["D",1748850289651],"// Shared types for the Lost Cars Finder app\n\nexport interface StolenCar {\n id?: number;\n make: string;\n model: string;\n year: number;\n color: string;\n license_plate: string;\n vin?: string;\n description?: string;\n stolen_date: string;\n stolen_location: string;\n stolen_lat?: number;\n stolen_lng?: number;\n owner_name: string;\n owner_phone: string;\n owner_email: string;\n police_report_number?: string;\n created_at?: string;\n status: 'active' | 'found' | 'resolved';\n}\n\nexport interface FoundCar {\n id?: number;\n make?: string;\n model?: string;\n year?: number;\n color: string;\n license_plate?: string;\n description: string;\n found_date: string;\n found_location: string;\n found_lat?: number;\n found_lng?: number;\n photo_url?: string;\n reporter_name: string;\n reporter_phone: string;\n reporter_email: string;\n created_at?: string;\n status: 'active' | 'matched' | 'resolved';\n}\n\nexport interface CarMatch {\n id?: number;\n stolen_car_id: number;\n found_car_id: number;\n match_score: number;\n match_reasons: string[];\n created_at?: string;\n status: 'pending' | 'confirmed' | 'rejected';\n}\n\nexport interface Location {\n lat: number;\n lng: number;\n address?: string;\n}\n\nexport interface SearchFilters {\n make?: string;\n model?: string;\n color?: string;\n license_plate?: string;\n location?: string;\n date_from?: string;\n date_to?: string;\n type?: 'stolen' | 'found' | 'all';\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n message?: string;\n}",[],[149,193],["D",1748850063838],[178],[149],"e53b04f6-3f85-11f0-b014-76b3cceeab13","stolen.ts","e53b058c-3f85-11f0-b014-76b3cceeab13","3504feee-a91e-470b-a5ed-d57a41f7ab5c",9,["D",1748850475745],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { StolenCar, ApiResponse } from \"../../shared/types.ts\";\nimport { \n createStolenCarReport, \n getStolenCars, \n getStolenCarById, \n updateStolenCarStatus \n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all stolen cars with optional filters\napp.get(\"/\", async (c) => {\n try {\n const filters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n );\n\n const cars = await getStolenCars(Object.keys(cleanFilters).length > 0 ? cleanFilters : undefined);\n \n const response: ApiResponse = {\n success: true,\n data: cars\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get specific stolen car by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const car = await getStolenCarById(id);\n if (!car) {\n const response: ApiResponse = {\n success: false,\n error: \"Stolen car not found\"\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: car\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new stolen car report\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as StolenCar;\n \n // Validate required fields\n const requiredFields = ['make', 'model', 'year', 'color', 'license_plate', 'stolen_date', 'stolen_location', 'owner_name', 'owner_phone', 'owner_email'];\n const missingFields = requiredFields.filter(field => !body[field as keyof StolenCar]);\n \n if (missingFields.length > 0) {\n const response: ApiResponse = {\n success: false,\n error: `Missing required fields: ${missingFields.join(', ')}`\n };\n return c.json(response, 400);\n }\n\n // Set default status if not provided\n if (!body.status) {\n body.status = 'active';\n }\n\n const carId = await createStolenCarReport(body);\n const createdCar = await getStolenCarById(carId);\n \n const response: ApiResponse = {\n success: true,\n data: createdCar!,\n message: \"Stolen car report created successfully\"\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update stolen car status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['active', 'found', 'resolved'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'active', 'found', or 'resolved'\"\n };\n return c.json(response, 400);\n }\n\n // Check if car exists\n const existingCar = await getStolenCarById(id);\n if (!existingCar) {\n const response: ApiResponse = {\n success: false,\n error: \"Stolen car not found\"\n };\n return c.json(response, 404);\n }\n\n await updateStolenCarStatus(id, status);\n const updatedCar = await getStolenCarById(id);\n \n const response: ApiResponse = {\n success: true,\n data: updatedCar!,\n message: \"Status updated successfully\"\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[156,212,204],"routes","e53b0f14-3f85-11f0-b014-76b3cceeab13",["D",1748850475745],[176],[156,212],"d93303ca-3f85-11f0-ad4a-76b3cceeab13","queries.ts","d9330492-3f85-11f0-ad4a-76b3cceeab13","15b4017d-7886-4af1-a52e-f6d95b64fdf9",8,["D",1748850455562],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { STOLEN_CARS_TABLE, FOUND_CARS_TABLE, MATCHES_TABLE } from \"./migrations.ts\";\nimport type { StolenCar, FoundCar, CarMatch, SearchFilters } from \"../../shared/types.ts\";\n\n// Stolen Cars Queries\nexport async function createStolenCarReport(car: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${STOLEN_CARS_TABLE} (\n make, model, year, color, license_plate, vin, description,\n stolen_date, stolen_location, stolen_lat, stolen_lng,\n owner_name, owner_phone, owner_email, police_report_number, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n car.make, car.model, car.year, car.color, car.license_plate, car.vin, car.description,\n car.stolen_date, car.stolen_location, car.stolen_lat, car.stolen_lng,\n car.owner_name, car.owner_phone, car.owner_email, car.police_report_number, car.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getStolenCars(filters?: SearchFilters): Promise {\n let query = `SELECT * FROM ${STOLEN_CARS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.make) {\n query += ` AND LOWER(make) LIKE LOWER(?)`;\n params.push(`%${filters.make}%`);\n }\n if (filters?.model) {\n query += ` AND LOWER(model) LIKE LOWER(?)`;\n params.push(`%${filters.model}%`);\n }\n if (filters?.color) {\n query += ` AND LOWER(color) LIKE LOWER(?)`;\n params.push(`%${filters.color}%`);\n }\n if (filters?.license_plate) {\n query += ` AND LOWER(license_plate) LIKE LOWER(?)`;\n params.push(`%${filters.license_plate}%`);\n }\n if (filters?.date_from) {\n query += ` AND stolen_date >= ?`;\n params.push(filters.date_from);\n }\n if (filters?.date_to) {\n query += ` AND stolen_date <= ?`;\n params.push(filters.date_to);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as StolenCar[];\n}\n\nexport async function getStolenCarById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${STOLEN_CARS_TABLE} WHERE id = ?`, [id]);\n return result.rows[0] as StolenCar || null;\n}\n\nexport async function updateStolenCarStatus(id: number, status: 'active' | 'found' | 'resolved'): Promise {\n await sqlite.execute(`UPDATE ${STOLEN_CARS_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Found Cars Queries\nexport async function createFoundCarReport(car: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${FOUND_CARS_TABLE} (\n make, model, year, color, license_plate, description,\n found_date, found_location, found_lat, found_lng, photo_url,\n reporter_name, reporter_phone, reporter_email, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n car.make, car.model, car.year, car.color, car.license_plate, car.description,\n car.found_date, car.found_location, car.found_lat, car.found_lng, car.photo_url,\n car.reporter_name, car.reporter_phone, car.reporter_email, car.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getFoundCars(filters?: SearchFilters): Promise {\n let query = `SELECT * FROM ${FOUND_CARS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.make) {\n query += ` AND LOWER(make) LIKE LOWER(?)`;\n params.push(`%${filters.make}%`);\n }\n if (filters?.model) {\n query += ` AND LOWER(model) LIKE LOWER(?)`;\n params.push(`%${filters.model}%`);\n }\n if (filters?.color) {\n query += ` AND LOWER(color) LIKE LOWER(?)`;\n params.push(`%${filters.color}%`);\n }\n if (filters?.license_plate) {\n query += ` AND LOWER(license_plate) LIKE LOWER(?)`;\n params.push(`%${filters.license_plate}%`);\n }\n if (filters?.date_from) {\n query += ` AND found_date >= ?`;\n params.push(filters.date_from);\n }\n if (filters?.date_to) {\n query += ` AND found_date <= ?`;\n params.push(filters.date_to);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as FoundCar[];\n}\n\nexport async function getFoundCarById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${FOUND_CARS_TABLE} WHERE id = ?`, [id]);\n return result.rows[0] as FoundCar || null;\n}\n\nexport async function updateFoundCarStatus(id: number, status: 'active' | 'matched' | 'resolved'): Promise {\n await sqlite.execute(`UPDATE ${FOUND_CARS_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Matching System\nexport async function findPotentialMatches(foundCarId: number): Promise {\n const foundCar = await getFoundCarById(foundCarId);\n if (!foundCar) return [];\n\n let query = `SELECT * FROM ${STOLEN_CARS_TABLE} WHERE status = 'active'`;\n const params: any[] = [];\n\n // Exact license plate match (highest priority)\n if (foundCar.license_plate) {\n query += ` AND license_plate = ?`;\n params.push(foundCar.license_plate);\n } else {\n // Match by make, model, color if no license plate\n const conditions: string[] = [];\n \n if (foundCar.make) {\n conditions.push(`LOWER(make) = LOWER(?)`);\n params.push(foundCar.make);\n }\n if (foundCar.model) {\n conditions.push(`LOWER(model) = LOWER(?)`);\n params.push(foundCar.model);\n }\n if (foundCar.color) {\n conditions.push(`LOWER(color) = LOWER(?)`);\n params.push(foundCar.color);\n }\n if (foundCar.year) {\n conditions.push(`year = ?`);\n params.push(foundCar.year);\n }\n\n if (conditions.length > 0) {\n query += ` AND (${conditions.join(' OR ')})`;\n }\n }\n\n const result = await sqlite.execute(query, params);\n return result.rows as StolenCar[];\n}\n\nexport async function createMatch(match: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${MATCHES_TABLE} (stolen_car_id, found_car_id, match_score, match_reasons, status)\n VALUES (?, ?, ?, ?, ?)\n `, [\n match.stolen_car_id, \n match.found_car_id, \n match.match_score, \n JSON.stringify(match.match_reasons), \n match.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getMatches(stolenCarId?: number, foundCarId?: number): Promise {\n let query = `SELECT * FROM ${MATCHES_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (stolenCarId) {\n query += ` AND stolen_car_id = ?`;\n params.push(stolenCarId);\n }\n if (foundCarId) {\n query += ` AND found_car_id = ?`;\n params.push(foundCarId);\n }\n\n query += ` ORDER BY match_score DESC, created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows.map(row => ({\n ...row,\n match_reasons: JSON.parse(row.match_reasons as string)\n })) as CarMatch[];\n}\n\nexport async function updateMatchStatus(id: number, status: 'pending' | 'confirmed' | 'rejected'): Promise {\n await sqlite.execute(`UPDATE ${MATCHES_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Search across both tables\nexport async function searchAllCars(filters: SearchFilters) {\n const results = {\n stolen: [] as StolenCar[],\n found: [] as FoundCar[]\n };\n\n if (filters.type === 'stolen' || filters.type === 'all' || !filters.type) {\n results.stolen = await getStolenCars(filters);\n }\n\n if (filters.type === 'found' || filters.type === 'all' || !filters.type) {\n results.found = await getFoundCars(filters);\n }\n\n return results;\n}",[],[156,226,218],"database","8443c4da-3f85-11f0-9a31-76b3cceeab13","migrations.ts","f4bc8c84-3f84-11f0-917f-76b3cceeab13",7,["D",1748850313057],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const STOLEN_CARS_TABLE = 'stolen_cars_v1';\nexport const FOUND_CARS_TABLE = 'found_cars_v1';\nexport const MATCHES_TABLE = 'car_matches_v1';\n\nexport async function createTables() {\n // Create stolen cars table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STOLEN_CARS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n make TEXT NOT NULL,\n model TEXT NOT NULL,\n year INTEGER NOT NULL,\n color TEXT NOT NULL,\n license_plate TEXT NOT NULL,\n vin TEXT,\n description TEXT,\n stolen_date TEXT NOT NULL,\n stolen_location TEXT NOT NULL,\n stolen_lat REAL,\n stolen_lng REAL,\n owner_name TEXT NOT NULL,\n owner_phone TEXT NOT NULL,\n owner_email TEXT NOT NULL,\n police_report_number TEXT,\n status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'found', 'resolved')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Create found cars table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FOUND_CARS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n make TEXT,\n model TEXT,\n year INTEGER,\n color TEXT NOT NULL,\n license_plate TEXT,\n description TEXT NOT NULL,\n found_date TEXT NOT NULL,\n found_location TEXT NOT NULL,\n found_lat REAL,\n found_lng REAL,\n photo_url TEXT,\n reporter_name TEXT NOT NULL,\n reporter_phone TEXT NOT NULL,\n reporter_email TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'matched', 'resolved')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Create matches table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MATCHES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n stolen_car_id INTEGER NOT NULL,\n found_car_id INTEGER NOT NULL,\n match_score REAL NOT NULL,\n match_reasons TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'rejected')),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (stolen_car_id) REFERENCES ${STOLEN_CARS_TABLE}(id),\n FOREIGN KEY (found_car_id) REFERENCES ${FOUND_CARS_TABLE}(id)\n )\n `);\n\n // Create indexes for better search performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_make ON ${STOLEN_CARS_TABLE}(make);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_model ON ${STOLEN_CARS_TABLE}(model);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_license ON ${STOLEN_CARS_TABLE}(license_plate);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_status ON ${STOLEN_CARS_TABLE}(status);`);\n \n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_color ON ${FOUND_CARS_TABLE}(color);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_license ON ${FOUND_CARS_TABLE}(license_plate);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_status ON ${FOUND_CARS_TABLE}(status);`);\n \n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_stolen ON ${MATCHES_TABLE}(stolen_car_id);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_found ON ${MATCHES_TABLE}(found_car_id);`);\n\n console.log('Database tables created successfully');\n}",[],[156,226,228],"f4bc9d14-3f84-11f0-917f-76b3cceeab13",["D",1748850072260],[173,174],[156,226],["D",1748850072260],[172,175],[156],["D",1748849913559],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":26},{"_13":84,"_32":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_121":279,"_280":281,"_282":283,"_284":26,"_285":26,"_286":26,"_287":24,"_288":-5,"_289":-7,"_290":-7,"_291":61,"_292":26,"_293":26,"_294":-5,"_295":26,"_296":26,"_297":26,"_298":-5},"ENV",{"_250":251,"_252":253,"_254":85,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v10