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/index.ts";
3import { initializeDatabase } from "./database/migrations.ts";
4import api from "./routes/api.ts";
5import mcp from "./routes/mcp.ts";
12});
13
14// Initialize database on startup
15await initializeDatabase();
16
17// Mount API routes
37    timestamp: new Date().toISOString(),
38    services: {
39      database: "connected",
40      api: "available",
41      mcp: "available"

16  getAllTypes,
17  getAllTags
18} from "../database/queries.ts";
19
20const mcp = new Hono();

9  getAllTypes,
10  getAllTags
11} from "../database/queries.ts";
12
13const api = new Hono();

3const TABLE_NAME = 'mcp_data_records';
4
5export async function initializeDatabase() {
6  // Create the main data table
7  await sqlite.execute(`
33  `);
34
35  console.log('Database initialized successfully');
36}
37

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema
19│   │   └── queries.ts       # Database operations
20│   ├── routes/
21│   │   ├── api.ts          # REST API endpoints

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations } from "./database/migrations.ts";
3import voiceNotesRoutes from "./routes/voicenotes.ts";
4import staticRoutes from "./routes/static.ts";
11});
12
13// Run database migrations on startup
14try {
15  await runMigrations();

19    )`);
20    
21    console.log('Database migrations completed successfully');
22  } catch (error) {
23    console.error('Database migration failed:', error);
24    throw error;
25  }

27```
28├── backend/
29│   ├── database/
30│   │   ├── migrations.ts    # Database schema
31│   │   └── queries.ts       # Database operations
32│   ├── routes/
33│   │   ├── voicenotes.ts    # Voice note CRUD operations
51
52- **Backend**: Hono (TypeScript API framework)
53- **Database**: SQLite for voice note metadata
54- **Storage**: Val Town Blob storage for audio files
55- **AI**: OpenAI Whisper for transcription

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 bookings from "./routes/bookings.ts";
5import contact from "./routes/contact.ts";
13});
14
15// Initialize database
16await runMigrations();
17

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { createContactMessage, getContactMessages } from "../database/queries.ts";
3import { email } from "https://esm.town/v/std/email";
4