Val Town Code SearchReturn to Val Town

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

5const PROMPTS_TABLE = 'prompt_requests_v1';
6
7// Initialize database tables
8export async function initDatabase() {
9  try {
10    await sqlite.execute(`
20      )
21    `);
22    console.log("Database initialized");
23  } catch (error) {
24    console.error("Database initialization error:", error);
25    throw error;
26  }
101}
102
103// Helper function to map a database row to a PromptRequest object
104function mapRowToPromptRequest(row: any[], columns: string[]): PromptRequest {
105  const result: Record<string, any> = {};

23}
24
25// For database operations
26export interface SQLQueryResult {
27  columns: string[];

102. **Email Submission** - Users can email their prompt details, which are automatically parsed using Gemini AI.
11
12All submissions are stored in a SQLite database and can be accessed through an admin panel where administrators can:
13
14- View all prompt requests
20- `backend/` - Server-side code
21  - `index.ts` - Main API server (Hono)
22  - `database.ts` - SQLite database operations
23  - `email-service.ts` - Email processing and sending
24  - `email-handler.ts` - Email endpoint handler
43  - View all submitted requests
44  - Create and send improved prompts to users
45- **SQLite Database** for data storage
46- **Email Notifications**
47  - To admins when new requests arrive
62- Val Town Platform
63- Hono (API framework)
64- SQLite (database)
65- OpenAI (for email processing)
66- TailwindCSS (styling)

10import exampleCallout from "./routes/exampleCallout.ts";
11import exampleChildPages from "./routes/exampleChildPages.ts";
12import exampleDatabasePage from "./routes/exampleDatabasePage.ts";
13import exampleDatabasePages from "./routes/exampleDatabasePages.ts";
14import home from "./routes/home.ts";
15import testRoutes from "./routes/testRoutes.ts";
27// Mount all route modules
28app.route("/", home);
29app.route("/", exampleDatabasePages);
30app.route("/", exampleDatabasePage);
31app.route("/", exampleChildPages);
32app.route("/", exampleCallout);

5## Route Files
6
7- `exampleDatabasePages.ts` - Handles `/example/database/pages` endpoint for resetting database pages
8- `exampleDatabasePage.ts` - Handles `/example/database/page` endpoint for updating a single database page
9- `exampleChildPages.ts` - Handles `/example/child_pages` endpoint for managing child pages
10- `exampleCallout.ts` - Handles `/example/callout` endpoint for updating callout blocks

5const app = new Hono();
6
7app.post("/example/database/page", async (c) => {
8  const payload = await c.req.json();
9  const data = await payload?.data;
17
18  // store webhook data in blob storage for resets
19  // capture the database id to store in the blob
20  const databaseId = data?.parent?.database_id;
21  const blobObject = {
22    id: databaseId,
23    date: new Date(),
24    content: askingFor,

10const app = new Hono();
11
12app.post("/example/database/pages", async (c) => {
13  // blob keys map to endpoints for the cron resets
14  const blobKey = await c.req.url.replace("https://", "");
15  const askingFor = c.req.headers.get("asking_for") || "default"; // val.town or default
16
17  // capture the database id to store in the blob
18  const targetId = c.req.headers.get("target_id");
19
20  // get the pages in this database
21  const databaseChildren = await notion.databases.query({ database_id: targetId });
22  // delete all pages to prevent bad actors from leaving naughty rows behi
23  for (const [key, child] of databaseChildren.results.entries()) {
24    const page = await notion.pages.update({
25      page_id: child.id,
28  }
29
30  // get the database
31  const database = await notion.databases.retrieve({ database_id: targetId });
32  // convert the statuses string in the status property into JSON
33  const statuses = JSON.parse(database?.properties?.Statuses?.formula?.expression);
34  // get the first item on the list of statuses, to set the status for new pages
35  const status = statuses[0];
36  // add back pages; fresh start for the next person to add favicons
37  const defaults = ["val.town", "notion.com", "hono.dev"].reverse();
38  // create new database pages from default object
39  for (const item of defaults) {
40    const page = await notion.pages.create({
41      parent: {
42        type: "database_id",
43        database_id: targetId,
44      },
45      properties: {

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