34
35/**
36 * Store a chat message in the database
37 */
38export async function storeChatMessage(
130 }
131
132 console.log(`Weather forecast updated in the database.`);
133 return summary;
134}
125 }
126
127 console.log(`Calendar events imported into the database.`);
128 return events;
129 } catch (error) {
8
9/**
10 * Retrieves previously generated fun facts from the memories database
11 * @returns Array of previous fun facts
12 */
47
48/**
49 * Inserts a fun fact into the memories database
50 * @param date Date for the fun fact in ISO format
51 * @param factText The fun fact text
208```
209โโโ backend/
210โ โโโ database/
211โ โ โโโ migrations.ts # Schema definitions
212โ โ โโโ queries.ts # DB query functions
270- Handle API calls properly with proper error catching
271
272### Database Patterns
273- Run migrations on startup or comment out for performance
274- Change table names when modifying schemas rather than altering
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations } from "./database/migrations.ts";
3import eventsRouter from "./routes/events.ts";
4import adminRouter from "./routes/admin.ts";
12});
13
14// Initialize database on startup
15await runMigrations();
16
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getCookie, setCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import { createEvent, deleteEvent, getAdminStats } from "../database/queries.ts";
4import type { CreateEventRequest } from "../../shared/types.ts";
5
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getUpcomingEvents, createRSVP, getRSVPCount, checkExistingRSVP, getEventById } from "../database/queries.ts";
3import type { RSVPRequest } from "../../shared/types.ts";
4
29 )`);
30
31 console.log('Database migrations completed');
32}
33
14```
15โโโ backend/
16โ โโโ database/
17โ โ โโโ migrations.ts # Database schema setup
18โ โ โโโ queries.ts # Database query functions
19โ โโโ routes/
20โ โ โโโ admin.ts # Admin authentication and event management