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
15await runMigrations();
16
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { CreateMessageRequest } from "../../shared/types.ts";
4
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllJobs, createJob } from "../database/queries.ts";
3import type { CreateJobRequest } from "../../shared/types.ts";
4
31 `);
32
33 console.log('Database migrations completed');
34}
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";
4import { getAllItems } from "./database/queries.ts";
5import itemsRouter from "./routes/items.ts";
6
12});
13
14// Initialize database
15await createTables();
16
6 updateItem,
7 deleteItem
8} from "../database/queries.ts";
9import type { CreateGroceryItem, UpdateGroceryItem } from "../../shared/types.ts";
10
17```
18โโโ backend/
19โ โโโ database/
20โ โ โโโ migrations.ts # Database schema
21โ โ โโโ queries.ts # Database operations
22โ โโโ routes/
23โ โ โโโ items.ts # Grocery items API routes
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { setCookie, getCookie, deleteCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import { createUser, getUserByEmail, getUserWithPassword, createSession, getSession, deleteSession, cleanupExpiredSessions } from "../database/queries.ts";
4
5const auth = new Hono();
2
3export async function runMigrations() {
4 console.log("Running database migrations...");
5
6 // Users table
76 `);
77
78 console.log("Database migrations completed successfully");
79}
17```
18โโโ backend/
19โ โโโ database/
20โ โ โโโ migrations.ts # Database schema
21โ โ โโโ queries.ts # Database operations
22โ โโโ routes/
23โ โ โโโ auth.ts # Authentication routes
44- **Frontend**: React 18.2.0 with TypeScript
45- **Backend**: Hono framework
46- **Database**: SQLite
47- **Styling**: TailwindCSS
48- **Charts**: Chart.js