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
28
29/**
30 * Store a chat message in the database
31 */
32export async function storeChatMessage(
1function initDatabase() {
2 setupTelegramChatDb();
3 setupMemories();
4}
5
6initDatabase();
7
8async function setupTelegramChatDb() {
29 `);
30
31 return "Telegram chat database table created successfully.";
32 } catch (error) {
33 console.error("Error setting up telegram_chats table:", error);
58 `);
59
60 return "Memories database table created successfully.";
61 } catch (error) {
62 console.error("Error setting up memories table:", error);
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);
55 `);
56
57 return "Telegram chat database table created successfully.";
58 } catch (error) {
59 console.error("Error setting up telegram_chats table:", error);
442];
443
444// Insert memories into the database
445async function insertDemoMemories() {
446 try {
486 // await insertDemoMemories();
487
488 // console.log("Demo database successfully populated!");
489 // return "Demo database successfully populated!";
490 } catch (error) {
491 // console.error("Error populating demo database:", error);
492 throw error;
493 }
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 setupMemoriesDb() {
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() {
29 `);
30
31 return "Telegram chat database table created successfully.";
32 } catch (error) {
33 console.error("Error setting up telegram_chats table:", error);