Val Town Code SearchReturn to Val Town

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 { runMigrations, seedData } from "./database/migrations.ts";
4import classesRouter from "./routes/classes.ts";
5import membersRouter from "./routes/members.ts";
13});
14
15// Initialize database on startup
16await runMigrations();
17await seedData();

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllClasses, getClassById, createClass, createBooking, cancelBooking } from "../database/queries.ts";
3
4const app = new Hono();

1// Database query functions for shipping operations
2
3import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
273}
274
275// Helper function to build shipment object from database row
276async function buildShipmentFromRow(row: any): Promise<Shipment> {
277  const packages = await getPackagesByShipment(row.id);

1// Database schema setup for shipping operations
2
3import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
4
5export async function runMigrations() {
6  console.log("Running database migrations...");
7
8  // Shipments table
125  await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_tracking_timestamp ON tracking_events (timestamp)`);
126
127  console.log("Database migrations completed successfully!");
128}
129

16```
17├── backend/
18│   ├── database/
19│   │   ├── migrations.ts    # Database schema setup
20│   │   └── queries.ts       # Database query functions
21│   ├── routes/
22│   │   ├── shipments.ts     # Shipment CRUD operations
53## Getting Started
54
551. The system automatically sets up the database on first run
562. Access the dashboard at the root URL
573. Create shipments using the form interface

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 { runMigrations } from "./database/migrations.ts";
4import { getMoodStats, getRecentMoodEntries, getRecentJournalEntries } from "./database/queries.ts";
5import moodRoutes from "./routes/mood.ts";
6import journalRoutes from "./routes/journal.ts";
13});
14
15// Initialize database on startup
16await runMigrations();
17

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 { runMigrations } from "./database/migrations.ts";
4import jobs from "./routes/jobs.ts";
5import chat from "./routes/chat.ts";
12});
13
14// Run database migrations on startup
15await runMigrations();
16

7  updateJournalEntry,
8  deleteJournalEntry
9} from "../database/queries.ts";
10
11const journal = new Hono();

7  updateMoodEntry,
8  getMoodStats
9} from "../database/queries.ts";
10
11const mood = new Hono();

31  `);
32
33  console.log("Database migrations completed successfully");
34}