Val Town Code SearchReturn to Val Town

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllTodos, createTodo, updateTodo, deleteTodo } from "../database/queries.ts";
3import type { CreateTodoRequest, UpdateTodoRequest } from "../../shared/types.ts";
4

3export const TABLE_NAME = 'todos_v1';
4
5export async function initializeDatabase() {
6  await sqlite.execute(`
7    CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema
19│   │   └── queries.ts       # Database operations
20│   ├── routes/
21│   │   └── todos.ts         # Todo API routes
40## Development
41
42The app runs on Val Town with automatic deployment. The database is automatically initialized on first run.

1/**
2 * Notion API integration for book database
3 */
4
28
29export interface BookMetadata {
30  // Core fields (mapped to Notion database)
31  title?: string;
32  author?: string;
59
60/**
61 * Get records from Notion database that need metadata enrichment
62 * This includes:
63 * 1. Records with Title + Author but missing other metadata
66export async function getIncompleteRecords(): Promise<NotionBookRecord[]> {
67  const token = Deno.env.get('NOTION_API_TOKEN');
68  const databaseId = Deno.env.get('NOTION_DATABASE_ID');
69  
70  if (!token || !databaseId) {
71    throw new Error('Missing NOTION_API_TOKEN or NOTION_DATABASE_ID environment variables');
72  }
73
74  console.log('Debug info:', {
75    tokenPrefix: token.substring(0, 10) + '...',
76    databaseIdLength: databaseId.length,
77    databaseIdPrefix: databaseId.substring(0, 8) + '...'
78  });
79
80  const response = await fetch(`${NOTION_API_BASE}/databases/${databaseId}/query`, {
81    method: 'POST',
82    headers: {
464      
465      if (!additionalResponse.ok) {
466        console.log(`Property "${propName}" doesn't exist in database, skipping...`);
467      }
468    } catch (error) {

1/**
2 * Notion Book Database Auto-Populator
3 * Main HTTP handler and API endpoints
4 */
44app.get('/status', async (c) => {
45  const hasNotionToken = !!Deno.env.get('NOTION_API_TOKEN');
46  const hasNotionDatabase = !!Deno.env.get('NOTION_DATABASE_ID');
47  
48  const status = {
49    configured: hasNotionToken && hasNotionDatabase,
50    notion_token: hasNotionToken ? 'Set' : 'Missing',
51    notion_database: hasNotionDatabase ? 'Set' : 'Missing',
52    timestamp: new Date().toISOString()
53  };
60      setup_instructions: {
61        notion_token: 'Set NOTION_API_TOKEN environment variable with your Notion integration token',
62        notion_database: 'Set NOTION_DATABASE_ID environment variable with your book database ID'
63      }
64    }, 400);
110app.get('/debug', (c) => {
111  const token = Deno.env.get('NOTION_API_TOKEN');
112  const databaseId = Deno.env.get('NOTION_DATABASE_ID');
113  
114  return c.json({
118      prefix: token?.substring(0, 10) + '...' || 'N/A'
119    },
120    database_info: {
121      exists: !!databaseId,
122      length: databaseId?.length || 0,
123      prefix: databaseId?.substring(0, 8) + '...' || 'N/A'
124    }
125  });
171app.get('/help', (c) => {
172  return c.json({
173    title: 'Notion Book Database Auto-Populator',
174    description: 'Automatically enriches your Notion book database with metadata from Google Books API',
175    endpoints: {
176      'GET /': 'Process all incomplete records',
183      step1: 'Create a Notion integration at https://www.notion.so/my-integrations',
184      step2: 'Copy the integration token and set it as NOTION_API_TOKEN environment variable',
185      step3: 'Share your book database with the integration',
186      step4: 'Copy the database ID from the URL and set it as NOTION_DATABASE_ID environment variable',
187      step5: 'Ensure your database has these properties: Title (title), Author (rich text), ISBN (rich text), Year Published (number), Page Count (number), Publisher (rich text)'
188    },
189    database_properties: {
190      required: ['Title (title)', 'Author (rich text)'],
191      populated: ['ISBN (rich text)', 'Year Published (number)', 'Page Count (number)', 'Publisher (rich text)'],

15    if (result.totalProcessed > 0) {
16      const summary = `
17📚 Book Database Update Complete
18
19📊 Summary:
39
40      await email({
41        subject: `📚 Book Database Updated - ${result.successful} books enriched`,
42        text: summary
43      });
52    // Send error notification
53    await email({
54      subject: '❌ Book Database Update Failed',
55      text: `
56The scheduled book database update failed with the following error:
57
58${error instanceof Error ? error.message : 'Unknown error'}

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.

30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database 
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable

45  }
46
47  // Now it's time to upload things to database and blob storage
48  // First, add to database, and get the ID
49  const id = await sqlite.execute(
50    `INSERT INTO ${TABLE_NAME} (title, type, time) VALUES ($title, $type, $time)`,

9- [ ] make it one click to branch off like old jp townie demos
10- [ ] opentownie as a pr bot
11- [ ] give it the ability to see its own client-side and server-side logs by building a middleware that shoves them into a SQL light database date and then give it a tool to access them
12- [ ] do a browser use or screenshot thing to give it access to its own visual output
13- [ ] Have it default to creating a new branch off main