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> {
34
35/**
36 * Store a chat message in the database
37 */
38export async function storeChatMessage(
6const TABLE_NAME = `${KEY}_summaries_v4`;
7
8async function initDatabase() {
9 await sqlite.execute(`
10 CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
63 }
64
65 await initDatabase();
66
67 const { description, long = false } = await req.json();
9- The **client-side entrypoint** is `/frontend/index.html`, which in turn imports `/frontend/index.tsx`, which in turn imports the React app from `/frontend/components/App.tsx`.
10
11[React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a fuller featured example project, with a SQLite database table, queries, client-side CSS and a favicon, and some shared code that runs on both client and server.
1/**
2 * Database constants used throughout the application
3 */
4
374];
375
376// Insert memories into the database
377async function insertDemoMemories() {
378 try {
415 await insertDemoMemories();
416
417 console.log("Demo database successfully populated!");
418 return "Demo database successfully populated!";
419 } catch (error) {
420 console.error("Error populating demo database:", error);
421 throw error;
422 }
1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2import { type Memory } from "../../shared/types.ts";
3import { MEMORIES_TABLE } from "../../shared/databaseConstants.ts";
4
5// Using the centralized table name constant
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)
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);
4
5* `index.ts` - this is the **entrypoint** for this whole project
6* `database/` - this contains the code for interfacing with the app's SQLite database table
7
8## Hono
26## CRUD API Routes
27
28This app has two CRUD API routes: for reading and inserting into the messages table. They both speak JSON, which is standard. They import their functions from `/backend/database/queries.ts`. These routes are called from the React app to refresh and update data.
29
30## Errors