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
46 }
47
48 // Now it's time to upload things to database and blob storage
49 // First, add to database, and get the ID
50 const id = await sqlite.execute(
51 `INSERT INTO ${TABLE_NAME} (title, data, type, time) VALUES ($title, $data, $type, CURRENT_TIMESTAMP)`,
379 const { OpenAI } = await import("https://esm.town/v/std/openai");
380
381 // --- Database Setup (Expanded Schema) ---
382 const TABLE_KEY = new URL(import.meta.url).pathname.replace(/[^a-zA-Z0-9_]/g, "_").slice(1);
383 const PROFILE_TABLE = `business_profiles_${TABLE_KEY}`;
442 /* ... error handling ... */
443 console.error("Error fetching profile:", e.message);
444 return new Response(JSON.stringify({ error: "Database error fetching profile" }), {
445 status: 500,
446 headers: { "Content-Type": "application/json" },
469 /* ... error handling ... */
470 console.error("Error saving profile:", e.message);
471 return new Response(JSON.stringify({ error: "Database error saving profile" }), { status: 500 });
472 }
473 }
172
173/**
174 * Get database statistics for the homepage
175 */
176export async function getSearchStats(): Promise<{
881 const offset = (page - 1) * pageSize;
882
883 // Start all database queries in parallel
884 // 1. Launch count queries
885 const countsPromise = Promise.all([
968 );
969
970 // Wait for all database operations to complete in parallel
971 const [
972 [totalFileResults, totalValResults, totalUserResults],
1242 <a href="?q=fetch" className="example-link">fetch</a>
1243 <a href="?q=api" className="example-link">api</a>
1244 <a href="?q=database" className="example-link">database</a>
1245 <a href="?q=image" className="example-link">image</a>
1246 <a href="?q=function" className="example-link">function</a>
1397 <a href="?q=fetch" className="example-link">fetch</a>
1398 <a href="?q=api" className="example-link">api</a>
1399 <a href="?q=database" className="example-link">database</a>
1400 <a href="?q=image" className="example-link">image</a>
1401 <a href="?q=function" className="example-link">function</a>
221. Create a Notion integration at https://www.notion.so/my-integrations
232. Get your Notion API key
243. Create a database in Notion for meeting pages with these properties:
25 - Title (title)
26 - Meeting Date (date)
27 - Attendee (rich text)
28 - Email (email)
294. Share your database with the integration
305. Get the database ID from the URL (the part after the workspace name and before the question mark)
31
32### 3. SERP API Setup (for better user information)
41- `GOOGLE_REFRESH_TOKEN`: Refresh token for your Google account
42- `NOTION_API_KEY`: Your Notion API key
43- `NOTION_DATABASE_ID`: ID of the Notion database where meeting pages will be created
44- `TEAM_DOMAIN`: Your team's email domain (e.g., "val.town")
45- `SERP_API_KEY`: Your SERP API key for enhanced user information