27โโโ backend/
28โ โโโ index.ts # Main Hono server
29โ โโโ database/
30โ โ โโโ schema.ts # Database schema
31โ โ โโโ queries.ts # Database operations
32โ โโโ routes/
33โ โโโ stolen.ts # Stolen car reports
533. Use the map view to see locations of reported vehicles
54
55## Database
56
57Uses SQLite with tables for:
81 await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_found ON ${MATCHES_TABLE}(found_car_id);`);
82
83 console.log('Database tables created successfully');
84}
8 updateStolenCarStatus,
9 updateFoundCarStatus
10} from "../database/queries.ts";
11
12const app = new Hono();
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { createTables } from "./database/migrations.ts";
4
5// Import route modules
16});
17
18// Initialize database on startup
19await createTables();
20
8 findPotentialMatches,
9 createMatch
10} from "../database/queries.ts";
11
12const app = new Hono();
6 getAdvertisementWithLeads,
7 getAdvertisementStats
8} from "../database/queries.ts";
9import type {
10 User,
8
9export async function runMigrations() {
10 console.log('Running database migrations...');
11
12 // Create users table
92 await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_orders_status ON ${ORDERS_TABLE}(status)`);
93
94 console.log('Database migrations completed');
95}
96
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import type { TodoItem, ApiResponse } from "../../shared/types.ts";
3import * as queries from "../database/queries.ts";
4
5const todos = new Hono();
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import type { ScheduleEvent, ApiResponse } from "../../shared/types.ts";
3import * as queries from "../database/queries.ts";
4
5const events = new Hono();
33 `);
34
35 console.log('Database migrations completed');
36}