1import { DateTime } from "https://esm.sh/luxon@3.4.4";
2import { MEMORIES_TABLE } from "./shared/databaseConstants.ts";
3
4/**
5 * Retrieves all memories from the database
6 * @param includeDate Whether to include date-specific memories or not
7 * @param startDate Optional start date to filter memories from (ISO format)
12 getAllMemories,
13 updateMemory,
14} from "./database/queries.ts";
15import { type Memory } from "../shared/types.ts";
16import { blob } from "https://esm.town/v/std/blob";
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
1/**
2 * Database constants used throughout the application
3 */
4
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
5 CLERK_FRONTEND_SRC: z.string(),
6 CLERK_JWT_KEY: z.string().transform((v) => v.replaceAll("|", "\n")),
7 DATABASE_URL: z.string(),
8});
9
1// Script to set up the telegram_chats table in SQLite
2// Run this script manually to create the database table
3
4export default async function setupTelegramChatDb() {
25 `);
26
27 return "Telegram chat database table created successfully.";
28 } catch (error) {
29 console.error("Error setting up telegram_chats table:", error);