Val Town Code SearchReturn to Val Town

14```
15├── backend/
16│   ├── database/
17│   │   ├── migrations.ts    # Database schema setup
18│   │   └── queries.ts       # Database query functions
19│   └── routes/
20│       └── api.ts          # API endpoints
40- `GET /api/companies/{id}` - Get company details
41
42## Database Schema
43
44### Companies Table

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

1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema setup for e-commerce chat app
4export async function runMigrations() {
5  console.log("Running database migrations...");
6
7  // Products table
140  }
141
142  console.log("Database migrations completed successfully!");
143}

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";
4
5// Import route modules
16});
17
18// Initialize database on startup
19await runMigrations();
20

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getRecentMessages, createMessage } from "../database/queries.ts";
3import type { CreateMessageRequest, ApiResponse } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllJobs, createJob, deleteJob } from "../database/queries.ts";
3import type { CreateJobRequest, ApiResponse } from "../../shared/types.ts";
4

30  `);
31
32  console.log('Database migrations completed');
33}

13```
14├── backend/
15│   ├── database/
16│   │   ├── migrations.ts    # Database schema setup
17│   │   └── queries.ts       # Database query functions
18│   ├── routes/
19│   │   ├── jobs.ts         # Job posting API routes
43- `POST /api/chat/messages` - Send a new chat message
44
45## Database Schema
46
47### Jobs Table

5  getChatRoom, 
6  getAllChatRooms 
7} from "../database/queries.ts";
8import type { ApiResponse, ChatMessage, ChatRoom } from "../../shared/types.ts";
9

7  getCartItems,
8  clearCart
9} from "../database/queries.ts";
10import type { ApiResponse, Order, OrderItem, CheckoutData } from "../../shared/types.ts";
11