Val Town Code SearchReturn to Val Town

2
3/**
4 * Retrieves all memories from the database
5 * @param includeDate Whether to include date-specific memories or not
6 * @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

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

15const app = new Hono();
16
17app.post("/example/database/pages", async (c) => {
18  // blob keys map to endpoints for the cron resets
19  const blobKey = await c.req.url.replace("https://", "");
20  const askingFor = c.req.headers.get("asking_for") || "default"; // val.town or default
21
22  // capture the database id to store in the blob
23  const targetId = c.req.headers.get("target_id");
24
25  // get the pages in this database
26  const databaseChildren = await notion.databases.query({ database_id: targetId });
27  // delete all pages to prevent bad actors from leaving naughty rows behi
28  for (const [key, child] of databaseChildren.results.entries()) {
29    const page = await notion.pages.update({
30      page_id: child.id,
33  }
34
35  // get the database
36  const database = await notion.databases.retrieve({ database_id: targetId });
37  // convert the statuses string in the status property into JSON
38  const statuses = JSON.parse(database?.properties?.Statuses?.formula?.expression);
39  // get the first item on the list of statuses, to set the status for new pages
40  const status = statuses[0];
41  // add back pages; fresh start for the next person to add favicons
42  const defaults = ["val.town", "notion.com", "hono.dev"].reverse();
43  // create new database pages from default object
44  for (const item of defaults) {
45    const page = await notion.pages.create({
46      parent: {
47        type: "database_id",
48        database_id: targetId,
49      },
50      properties: {
79});
80
81app.post("/example/database/page", async (c) => {
82  const payload = await c.req.json();
83  const data = await payload?.data;
91
92  // store webhook data in blob storage for resets
93  // capture the database id to store in the blob
94  const databaseId = data?.parent?.database_id;
95  const blobObject = {
96    id: databaseId,
97    date: new Date(),
98    content: askingFor,

1import { generateCode } from "./backend/generate-code";
2import { createTables } from "./database/migrations";
3import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries";
4
5async function servePublicFile(path: string): Promise<Response> {

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);