[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_218":219,"_220":221},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":61,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":61,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",51,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/notion.ts","latestPath","fileId","62edf002-375c-11f0-8c16-9e149126039e","name","notion.ts","fileType","script","content","/**\n * Notion API integration for book database\n */\n\nexport interface NotionBookRecord {\n id: string;\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n // Additional Google Books metadata\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: string; // Store as JSON string\n // Status tracking\n processed?: boolean;\n lastUpdated?: string;\n}\n\nexport interface BookMetadata {\n // Core fields (mapped to Notion database)\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n \n // Additional Google Books fields (available for future use)\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: {\n smallThumbnail?: string;\n thumbnail?: string;\n small?: string;\n medium?: string;\n large?: string;\n extraLarge?: string;\n };\n}\n\nconst NOTION_API_BASE = 'https://api.notion.com/v1';\n\n/**\n * Get records from Notion database that need metadata enrichment\n */\nexport async function getIncompleteRecords(): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (!token || !databaseId) {\n throw new Error('Missing NOTION_API_TOKEN or NOTION_DATABASE_ID environment variables');\n }\n\n console.log('Debug info:', {\n tokenPrefix: token.substring(0, 10) + '...',\n databaseIdLength: databaseId.length,\n databaseIdPrefix: databaseId.substring(0, 8) + '...'\n });\n\n const response = await fetch(`${NOTION_API_BASE}/databases/${databaseId}/query`, {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n filter: {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Processed',\n checkbox: {\n equals: false\n }\n }\n ]\n }\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error('Notion API Error Details:', {\n status: response.status,\n statusText: response.statusText,\n errorText,\n headers: Object.fromEntries(response.headers.entries())\n });\n throw new Error(`Notion API error: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n const data = await response.json();\n \n return data.results.map((page: any) => ({\n id: page.id,\n title: page.properties.Title?.title?.[0]?.text?.content,\n author: page.properties.Author?.rich_text?.[0]?.text?.content,\n isbn: page.properties.ISBN?.rich_text?.[0]?.text?.content,\n yearPublished: page.properties['Year Published']?.number,\n pageCount: page.properties['Page Count']?.number,\n publisher: page.properties.Publisher?.rich_text?.[0]?.text?.content,\n subtitle: page.properties.Subtitle?.rich_text?.[0]?.text?.content,\n description: page.properties.Description?.rich_text?.[0]?.text?.content,\n categories: page.properties.Categories?.multi_select?.map((cat: any) => cat.name),\n averageRating: page.properties['Average Rating']?.number,\n ratingsCount: page.properties['Ratings Count']?.number,\n language: page.properties.Language?.rich_text?.[0]?.text?.content,\n publishedDate: page.properties['Published Date']?.rich_text?.[0]?.text?.content,\n previewLink: page.properties['Preview Link']?.url,\n infoLink: page.properties['Info Link']?.url,\n imageLinks: page.properties['Image Links']?.rich_text?.[0]?.text?.content,\n processed: page.properties.Processed?.checkbox,\n lastUpdated: page.properties['Last Updated']?.last_edited_time,\n }));\n}\n\n/**\n * Update a Notion record with book metadata\n */\nexport async function updateBookRecord(recordId: string, metadata: BookMetadata): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n \n if (!token) {\n throw new Error('Missing NOTION_API_TOKEN environment variable');\n }\n\n const properties: any = {};\n\n if (metadata.isbn) {\n properties.ISBN = {\n rich_text: [\n {\n text: {\n content: metadata.isbn\n }\n }\n ]\n };\n }\n\n if (metadata.yearPublished) {\n properties['Year Published'] = {\n number: metadata.yearPublished\n };\n }\n\n if (metadata.pageCount) {\n properties['Page Count'] = {\n number: metadata.pageCount\n };\n }\n\n if (metadata.publisher) {\n properties.Publisher = {\n rich_text: [\n {\n text: {\n content: metadata.publisher\n }\n }\n ]\n };\n }\n\n const response = await fetch(`${NOTION_API_BASE}/pages/${recordId}`, {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n properties\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to update Notion record: ${response.status} ${response.statusText} - ${errorText}`);\n }\n}","/**\n * Notion API integration for book database\n */\n\nexport interface NotionBookRecord {\n id: string;\n title?: string;\n author?: string;\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n // Additional Google Books metadata\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: string; // Store as JSON string\n // Status tracking\n processed?: boolean;\n lastUpdated?: string;\n}\n\nexport interface BookMetadata {\n // Core fields (mapped to Notion database)\n isbn?: string;\n yearPublished?: number;\n pageCount?: number;\n publisher?: string;\n \n // Additional Google Books fields (available for future use)\n subtitle?: string;\n description?: string;\n categories?: string[];\n averageRating?: number;\n ratingsCount?: number;\n language?: string;\n publishedDate?: string;\n previewLink?: string;\n infoLink?: string;\n imageLinks?: {\n smallThumbnail?: string;\n thumbnail?: string;\n small?: string;\n medium?: string;\n large?: string;\n extraLarge?: string;\n };\n}\n\nconst NOTION_API_BASE = 'https://api.notion.com/v1';\n\n/**\n * Get records from Notion database that need metadata enrichment\n */\nexport async function getIncompleteRecords(): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (!token || !databaseId) {\n throw new Error('Missing NOTION_API_TOKEN or NOTION_DATABASE_ID environment variables');\n }\n\n console.log('Debug info:', {\n tokenPrefix: token.substring(0, 10) + '...',\n databaseIdLength: databaseId.length,\n databaseIdPrefix: databaseId.substring(0, 8) + '...'\n });\n\n const response = await fetch(`${NOTION_API_BASE}/databases/${databaseId}/query`, {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n filter: {\n and: [\n {\n property: 'Title',\n title: {\n is_not_empty: true\n }\n },\n {\n property: 'Author',\n rich_text: {\n is_not_empty: true\n }\n },\n {\n property: 'Processed',\n checkbox: {\n equals: false\n }\n }\n ]\n }\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n console.error('Notion API Error Details:', {\n status: response.status,\n statusText: response.statusText,\n errorText,\n headers: Object.fromEntries(response.headers.entries())\n });\n throw new Error(`Notion API error: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n const data = await response.json();\n \n return data.results.map((page: any) => ({\n id: page.id,\n title: page.properties.Title?.title?.[0]?.text?.content,\n author: page.properties.Author?.rich_text?.[0]?.text?.content,\n isbn: page.properties.ISBN?.rich_text?.[0]?.text?.content,\n yearPublished: page.properties['Year Published']?.number,\n pageCount: page.properties['Page Count']?.number,\n publisher: page.properties.Publisher?.rich_text?.[0]?.text?.content,\n subtitle: page.properties.Subtitle?.rich_text?.[0]?.text?.content,\n description: page.properties.Description?.rich_text?.[0]?.text?.content,\n categories: page.properties.Categories?.multi_select?.map((cat: any) => cat.name),\n averageRating: page.properties['Average Rating']?.number,\n ratingsCount: page.properties['Ratings Count']?.number,\n language: page.properties.Language?.rich_text?.[0]?.text?.content,\n publishedDate: page.properties['Published Date']?.rich_text?.[0]?.text?.content,\n previewLink: page.properties['Preview Link']?.url,\n infoLink: page.properties['Info Link']?.url,\n imageLinks: page.properties['Image Links']?.rich_text?.[0]?.text?.content,\n processed: page.properties.Processed?.checkbox,\n lastUpdated: page.properties['Last Updated']?.last_edited_time,\n }));\n}\n\n/**\n * Update a Notion record with book metadata\n */\nexport async function updateBookRecord(recordId: string, metadata: BookMetadata): Promise {\n const token = Deno.env.get('NOTION_API_TOKEN');\n \n if (!token) {\n throw new Error('Missing NOTION_API_TOKEN environment variable');\n }\n\n const properties: any = {};\n\n // Core metadata fields\n if (metadata.isbn) {\n properties.ISBN = {\n rich_text: [\n {\n text: {\n content: metadata.isbn\n }\n }\n ]\n };\n }\n\n if (metadata.yearPublished) {\n properties['Year Published'] = {\n number: metadata.yearPublished\n };\n }\n\n if (metadata.pageCount) {\n properties['Page Count'] = {\n number: metadata.pageCount\n };\n }\n\n if (metadata.publisher) {\n properties.Publisher = {\n rich_text: [\n {\n text: {\n content: metadata.publisher\n }\n }\n ]\n };\n }\n\n // Additional Google Books metadata\n if (metadata.subtitle) {\n properties.Subtitle = {\n rich_text: [\n {\n text: {\n content: metadata.subtitle\n }\n }\n ]\n };\n }\n\n if (metadata.description) {\n // Truncate description to fit Notion's limits\n const truncatedDescription = metadata.description.length > 2000 \n ? metadata.description.substring(0, 1997) + \"...\"\n : metadata.description;\n \n properties.Description = {\n rich_text: [\n {\n text: {\n content: truncatedDescription\n }\n }\n ]\n };\n }\n\n if (metadata.categories && metadata.categories.length > 0) {\n properties.Categories = {\n multi_select: metadata.categories.slice(0, 10).map(cat => ({ name: cat }))\n };\n }\n\n if (metadata.averageRating) {\n properties['Average Rating'] = {\n number: metadata.averageRating\n };\n }\n\n if (metadata.ratingsCount) {\n properties['Ratings Count'] = {\n number: metadata.ratingsCount\n };\n }\n\n if (metadata.language) {\n properties.Language = {\n rich_text: [\n {\n text: {\n content: metadata.language\n }\n }\n ]\n };\n }\n\n if (metadata.publishedDate) {\n properties['Published Date'] = {\n rich_text: [\n {\n text: {\n content: metadata.publishedDate\n }\n }\n ]\n };\n }\n\n if (metadata.previewLink) {\n properties['Preview Link'] = {\n url: metadata.previewLink\n };\n }\n\n if (metadata.infoLink) {\n properties['Info Link'] = {\n url: metadata.infoLink\n };\n }\n\n if (metadata.imageLinks) {\n properties['Image Links'] = {\n rich_text: [\n {\n text: {\n content: JSON.stringify(metadata.imageLinks)\n }\n }\n ]\n };\n }\n\n // Mark as processed\n properties.Processed = {\n checkbox: true\n };\n\n const response = await fetch(`${NOTION_API_BASE}/pages/${recordId}`, {\n method: 'PATCH',\n headers: {\n 'Authorization': `Bearer ${token}`,\n 'Content-Type': 'application/json',\n 'Notion-Version': '2022-06-28',\n },\n body: JSON.stringify({\n properties\n })\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to update Notion record: ${response.status} ${response.statusText} - ${errorText}`);\n }\n}","createdAt",["D",1747959241844],"branchVersion","branchId","e2a912a0-375b-11f0-b362-9e149126039e","id","e2a8e384-375b-11f0-b362-9e149126039e","book-lookup-notion",["D",1747952823274],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","use google book api to look up bibliographic metadata elements","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/b264b89e-466c-4d55-8eb9-e8a9baa1af00/square512?exp=1789617172&sig=68b72ca5857a64a636b0431e98223920f2ef7989e18d65be0b8eddf77a0338ff","56a0f9e0-375a-11f0-a39d-3380429e1c83","pinnedFileId","866870fc-375c-11f0-a2c2-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","c07a30e6-b724-410c-b54c-45df602d6743","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":57,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",81,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nucky","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4VHNLcXVkc2Yxc3RjbzRvSloxRW5OQ1FYRCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":214,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":61,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":215,"_83":216,"_85":217,"_87":25},"tree",[169,174,175],"files",[169,170,171,172,173,174,175],"counts",{"_159":156,"_160":65,"_161":65,"_162":163,"_164":165},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":151,"_32":152,"_30":153,"_135":-5,"_42":43,"_41":154,"_137":61,"_39":155,"_13":156,"_34":157,"_36":-5,"_24":25,"_141":-5,"_27":158},{"_44":143,"_32":144,"_30":145,"_135":-5,"_42":43,"_41":146,"_137":25,"_39":147,"_13":148,"_34":20,"_36":149,"_24":25,"_141":-5,"_27":150},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":25,"_39":138,"_13":65,"_34":139,"_36":140,"_24":25,"_141":-5,"_27":142},"8fed221c-375c-11f0-b7b7-9e149126039e","cron-processor.ts","8eac3a0a-375c-11f0-8790-9e149126039e","parentId",8,"latest",["D",1747953113960],"interval","/**\n * Cron job for automatic book metadata enrichment\n * This will run on a schedule to automatically process new book entries\n */\n\nimport { processIncompleteRecords } from './backend/processor.ts';\nimport { email } from \"https://esm.town/v/std/email\";\n\nexport default async function() {\n try {\n console.log('Starting scheduled book metadata enrichment...');\n const result = await processIncompleteRecords();\n \n // Only send email if there were records processed\n if (result.totalProcessed > 0) {\n const summary = `\n📚 Book Database Update Complete\n\n📊 Summary:\n• Total processed: ${result.totalProcessed}\n• Successful: ${result.successful}\n• Failed: ${result.failed}\n• Skipped: ${result.skipped}\n\n${result.successful > 0 ? `✅ Successfully updated books:\n${result.details\n .filter(d => d.status === 'success')\n .map(d => `• \"${d.title}\" by ${d.author}`)\n .join('\\n')}` : ''}\n\n${result.failed > 0 ? `❌ Failed to update:\n${result.details\n .filter(d => d.status === 'failed')\n .map(d => `• \"${d.title}\" by ${d.author} - ${d.error}`)\n .join('\\n')}` : ''}\n\nTime: ${new Date().toISOString()}\n `.trim();\n\n await email({\n subject: `📚 Book Database Updated - ${result.successful} books enriched`,\n text: summary\n });\n }\n \n console.log('Scheduled processing completed successfully');\n console.log(`Processed: ${result.totalProcessed}, Successful: ${result.successful}, Failed: ${result.failed}, Skipped: ${result.skipped}`);\n \n } catch (error) {\n console.error('Error in scheduled processing:', error);\n \n // Send error notification\n await email({\n subject: '❌ Book Database Update Failed',\n text: `\nThe scheduled book database update failed with the following error:\n\n${error instanceof Error ? error.message : 'Unknown error'}\n\nTime: ${new Date().toISOString()}\n\nPlease check the logs and configuration.\n `.trim()\n });\n \n throw error;\n }\n}","label",[133],"35f802c8-376a-11f0-a8d3-9e149126039e","README.md","58f49894-375c-11f0-a0b7-9e149126039e",38,["D",1747958975993],4,"# Notion Book Database Auto-Populator\n\nThis Val automatically enriches your Notion book database by fetching comprehensive metadata from Google Books API.\n\n## Features\n\n- Monitors Notion database for new entries with title and author\n- Automatically fetches and populates:\n - ISBN (ISBN-13 preferred, ISBN-10 as fallback)\n - Year Published\n - Page Count\n - Publisher\n- Retrieves comprehensive metadata including:\n - Subtitle, description, categories\n - Average rating and ratings count\n - Language, publication date\n - Preview and info links\n - Cover image links\n- Uses Google Books API (no API key required)\n- Handles multiple book matches intelligently\n- Smart matching algorithm for best results\n- Only updates empty fields (won't overwrite existing data)\n\n## Setup Instructions\n\n### Step 1: Create Notion Integration\n1. Go to [https://www.notion.so/my-integrations](https://www.notion.so/my-integrations)\n2. Click \"New integration\"\n3. Give it a name like \"Book Auto-Populator\"\n4. Select your workspace\n5. Copy the \"Internal Integration Token\"\n\n### Step 2: Configure Your Database\nYour Notion database should have these properties:\n- **Title** (Title type) - Required\n- **Author** (Rich text) - Required \n- **Published** (Number) - Will be populated with publication year\n- **Pg** (Number) - Will be populated with page count\n- **Publisher** (Rich text) - Will be populated\n\nOptional properties (won't be modified):\n- Rating, Progress, Start, Finish, Form, Medium, POV, etc.\n\n### Step 3: Share Database with Integration\n1. Open your book database in Notion\n2. Click the \"Share\" button (top right)\n3. Click \"Invite\" and search for your integration name\n4. Give it \"Edit\" permissions\n\n### Step 4: Get Database ID\n1. Open your database in Notion\n2. Copy the URL - it looks like: `https://notion.so/workspace/DATABASE_ID?v=...`\n3. The DATABASE_ID is the long string of letters/numbers between the last `/` and `?`\n\n### Step 5: Set Environment Variables\nIn Val Town, set these environment variables:\n- `NOTION_API_TOKEN`: Your integration token from Step 1\n- `NOTION_DATABASE_ID`: Your database ID from Step 4\n\n## Usage\n\n### Manual Processing\nVisit the HTTP endpoint to manually trigger processing:\n- Main endpoint: Process all incomplete records\n- `/status`: Check configuration\n- `/help`: View all available endpoints\n\n### Automatic Processing (Recommended)\nThe cron job (`/cron-processor.ts`) can run automatically:\n1. Set it to run daily or weekly in Val Town\n2. It will email you a summary of updates\n3. Only processes records missing metadata\n\n## API Endpoints\n\n- `GET /` - Process all incomplete records\n- `GET /status` - Check system configuration and status \n- `GET /process/:recordId` - Process a specific record by ID\n- `GET /health` - Health check\n- `GET /help` - Usage instructions and setup guide\n\n## How It Works\n\n1. **Detection**: Finds records with Title and Author but missing ISBN, Year, Pages, or Publisher\n2. **Search**: Queries Google Books API with title and author\n3. **Matching**: Uses smart algorithm to find best match\n4. **Update**: Only populates empty fields in Notion\n5. **Reporting**: Logs results and sends email summaries (cron mode)\n\n## Files\n\n- `/backend/index.ts` - Main HTTP handler and API endpoints\n- `/backend/notion.ts` - Notion API integration and database operations\n- `/backend/books.ts` - Google Books API integration and search logic\n- `/backend/processor.ts` - Main processing logic and orchestration\n- `/cron-processor.ts` - Scheduled automatic processing with email reports\n\n## Troubleshooting\n\n- Check `/status` endpoint to verify configuration\n- Ensure database properties have exact names and types\n- Verify integration has access to your database\n- Check Val Town logs for detailed error messages",[144],"62ee15c8-375c-11f0-8c16-9e149126039e","backend","ba931684-cf88-4b01-bc83-bc2015e23f85",2,["D",1747953038469],0,"directory",[152],"pulls","branches","forks","envVars",{"_166":154,"_168":156},"connections",{"_166":156,"_167":156},"count","unfilledCount","emptyCount",{"_44":151,"_32":152,"_30":153,"_135":-5,"_42":43,"_41":154,"_137":61,"_39":211,"_13":156,"_34":157,"_36":-5,"_24":25,"_141":-5,"_177":212,"_27":213},{"_44":203,"_32":204,"_30":205,"_135":153,"_42":43,"_41":192,"_137":25,"_39":206,"_13":207,"_34":35,"_36":208,"_24":25,"_141":-5,"_177":209,"_27":210},{"_44":195,"_32":196,"_30":59,"_135":153,"_42":43,"_41":197,"_137":25,"_39":198,"_13":148,"_34":199,"_36":200,"_24":25,"_141":-5,"_177":201,"_27":202},{"_44":190,"_32":33,"_30":31,"_135":153,"_42":43,"_41":14,"_137":25,"_39":191,"_13":192,"_34":35,"_36":38,"_24":25,"_141":-5,"_177":193,"_27":194},{"_44":183,"_32":184,"_30":185,"_135":153,"_42":43,"_41":148,"_137":25,"_39":186,"_13":156,"_34":35,"_36":187,"_24":25,"_141":-5,"_177":188,"_27":189},{"_44":143,"_32":144,"_30":145,"_135":-5,"_42":43,"_41":146,"_137":25,"_39":180,"_13":148,"_34":20,"_36":149,"_24":25,"_141":-5,"_177":181,"_27":182},{"_44":132,"_32":133,"_30":134,"_135":-5,"_42":43,"_41":136,"_137":25,"_39":176,"_13":65,"_34":139,"_36":140,"_24":25,"_141":-5,"_177":178,"_27":179},["D",1747953113960],"children",[],[133],["D",1747958975993],[],[144],"7ba8aa06-375c-11f0-9948-9e149126039e","processor.ts","7ba8aaa6-375c-11f0-9948-9e149126039e",["D",1747953079959],"/**\n * Main processing logic for enriching book records\n */\n\nimport { getIncompleteRecords, updateBookRecord, NotionBookRecord, BookMetadata } from './notion.ts';\nimport { searchBookMetadata, searchBookMetadataRelaxed } from './books.ts';\n\nexport interface ProcessingResult {\n totalProcessed: number;\n successful: number;\n failed: number;\n skipped: number;\n details: Array<{\n id: string;\n title: string;\n author: string;\n status: 'success' | 'failed' | 'skipped';\n metadata?: BookMetadata;\n error?: string;\n }>;\n}\n\n/**\n * Process all incomplete book records\n */\nexport async function processIncompleteRecords(): Promise {\n const result: ProcessingResult = {\n totalProcessed: 0,\n successful: 0,\n failed: 0,\n skipped: 0,\n details: []\n };\n\n try {\n console.log('Fetching incomplete records from Notion...');\n const records = await getIncompleteRecords();\n \n console.log(`Found ${records.length} records to process`);\n result.totalProcessed = records.length;\n\n for (const record of records) {\n if (!record.title || !record.author) {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title || 'Unknown',\n author: record.author || 'Unknown',\n status: 'skipped',\n error: 'Missing title or author'\n });\n continue;\n }\n\n try {\n console.log(`Processing: \"${record.title}\" by \"${record.author}\"`);\n \n // Try exact search first\n let metadata = await searchBookMetadata(record.title, record.author);\n \n // If no results, try relaxed search\n if (!metadata) {\n console.log('Exact search failed, trying relaxed search...');\n metadata = await searchBookMetadataRelaxed(record.title, record.author);\n }\n\n if (!metadata) {\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'failed',\n error: 'No metadata found'\n });\n continue;\n }\n\n // Only update fields that are currently empty\n const updateMetadata: BookMetadata = {};\n \n if (!record.isbn && metadata.isbn) {\n updateMetadata.isbn = metadata.isbn;\n }\n \n if (!record.yearPublished && metadata.yearPublished) {\n updateMetadata.yearPublished = metadata.yearPublished;\n }\n \n if (!record.pageCount && metadata.pageCount) {\n updateMetadata.pageCount = metadata.pageCount;\n }\n \n if (!record.publisher && metadata.publisher) {\n updateMetadata.publisher = metadata.publisher;\n }\n\n // Only update if we have something to update\n if (Object.keys(updateMetadata).length > 0) {\n await updateBookRecord(record.id, updateMetadata);\n console.log(`Successfully updated: \"${record.title}\"`);\n \n result.successful++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'success',\n metadata: updateMetadata\n });\n } else {\n result.skipped++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'skipped',\n error: 'All fields already populated'\n });\n }\n\n // Add a small delay to be respectful to APIs\n await new Promise(resolve => setTimeout(resolve, 500));\n\n } catch (error) {\n console.error(`Error processing \"${record.title}\":`, error);\n result.failed++;\n result.details.push({\n id: record.id,\n title: record.title,\n author: record.author,\n status: 'failed',\n error: error instanceof Error ? error.message : 'Unknown error'\n });\n }\n }\n\n console.log(`Processing complete: ${result.successful} successful, ${result.failed} failed, ${result.skipped} skipped`);\n return result;\n\n } catch (error) {\n console.error('Error in processIncompleteRecords:', error);\n throw error;\n }\n}\n\n/**\n * Process a single book record by ID\n */\nexport async function processSingleRecord(recordId: string): Promise {\n // This would require fetching a single record from Notion\n // For now, we'll process all and filter, but this could be optimized\n const allResults = await processIncompleteRecords();\n \n const singleResult = allResults.details.find(detail => detail.id === recordId);\n \n if (!singleResult) {\n return {\n totalProcessed: 0,\n successful: 0,\n failed: 1,\n skipped: 0,\n details: [{\n id: recordId,\n title: 'Unknown',\n author: 'Unknown',\n status: 'failed',\n error: 'Record not found or already complete'\n }]\n };\n }\n\n return {\n totalProcessed: 1,\n successful: singleResult.status === 'success' ? 1 : 0,\n failed: singleResult.status === 'failed' ? 1 : 0,\n skipped: singleResult.status === 'skipped' ? 1 : 0,\n details: [singleResult]\n };\n}",[],[152,184],"d46e5164-376a-11f0-bc17-9e149126039e",["D",1747959241844],25,[],[152,33],"b382fa38-3763-11f0-9b4d-9e149126039e","index.ts",24,["D",1747956180137],"http","/**\n * Notion Book Database Auto-Populator\n * Main HTTP handler and API endpoints\n */\n\nimport { Hono } from 'https://esm.sh/hono@3.11.7';\nimport { processIncompleteRecords, processSingleRecord } from './processor.ts';\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n/**\n * Main endpoint - process all incomplete records\n */\napp.get('/', async (c) => {\n try {\n console.log('Starting book metadata enrichment process...');\n const result = await processIncompleteRecords();\n \n return c.json({\n success: true,\n message: 'Processing completed',\n result,\n timestamp: new Date().toISOString()\n });\n } catch (error) {\n console.error('Error in main process:', error);\n \n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n timestamp: new Date().toISOString()\n }, 500);\n }\n});\n\n/**\n * Status endpoint - check configuration and system status\n */\napp.get('/status', async (c) => {\n const hasNotionToken = !!Deno.env.get('NOTION_API_TOKEN');\n const hasNotionDatabase = !!Deno.env.get('NOTION_DATABASE_ID');\n \n const status = {\n configured: hasNotionToken && hasNotionDatabase,\n notion_token: hasNotionToken ? 'Set' : 'Missing',\n notion_database: hasNotionDatabase ? 'Set' : 'Missing',\n timestamp: new Date().toISOString()\n };\n\n if (!status.configured) {\n return c.json({\n success: false,\n message: 'System not properly configured',\n status,\n setup_instructions: {\n notion_token: 'Set NOTION_API_TOKEN environment variable with your Notion integration token',\n notion_database: 'Set NOTION_DATABASE_ID environment variable with your book database ID'\n }\n }, 400);\n }\n\n return c.json({\n success: true,\n message: 'System ready',\n status\n });\n});\n\n/**\n * Process a specific record by ID\n */\napp.get('/process/:recordId', async (c) => {\n const recordId = c.req.param('recordId');\n \n if (!recordId) {\n return c.json({\n success: false,\n error: 'Record ID is required'\n }, 400);\n }\n\n try {\n const result = await processSingleRecord(recordId);\n \n return c.json({\n success: true,\n message: 'Record processing completed',\n result,\n timestamp: new Date().toISOString()\n });\n } catch (error) {\n console.error(`Error processing record ${recordId}:`, error);\n \n return c.json({\n success: false,\n error: error instanceof Error ? error.message : 'Unknown error',\n timestamp: new Date().toISOString()\n }, 500);\n }\n});\n\n/**\n * Debug endpoint - check environment variables (remove in production)\n */\napp.get('/debug', (c) => {\n const token = Deno.env.get('NOTION_API_TOKEN');\n const databaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n return c.json({\n token_info: {\n exists: !!token,\n length: token?.length || 0,\n prefix: token?.substring(0, 10) + '...' || 'N/A'\n },\n database_info: {\n exists: !!databaseId,\n length: databaseId?.length || 0,\n prefix: databaseId?.substring(0, 8) + '...' || 'N/A'\n }\n });\n});\n\n/**\n * Test Open Library endpoint for debugging\n */\napp.get('/test-worldcat/:title/:author', async (c) => {\n const title = c.req.param('title');\n const author = c.req.param('author');\n \n try {\n const query = `title:\"${title.trim()}\" author:\"${author.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://openlibrary.org/search.json?q=${encodedQuery}&limit=5`\n );\n\n const data = await response.json();\n \n return c.json({\n query,\n status: response.status,\n resultCount: data.docs?.length || 0,\n firstResult: data.docs?.[0] || null\n });\n } catch (error) {\n return c.json({\n error: error instanceof Error ? error.message : 'Unknown error'\n }, 500);\n }\n});\n\n/**\n * Health check endpoint\n */\napp.get('/health', (c) => {\n return c.json({\n status: 'healthy',\n timestamp: new Date().toISOString()\n });\n});\n\n/**\n * Help endpoint with usage instructions\n */\napp.get('/help', (c) => {\n return c.json({\n title: 'Notion Book Database Auto-Populator',\n description: 'Automatically enriches your Notion book database with metadata from Google Books API',\n endpoints: {\n 'GET /': 'Process all incomplete records',\n 'GET /status': 'Check system configuration and status',\n 'GET /process/:recordId': 'Process a specific record by ID',\n 'GET /health': 'Health check',\n 'GET /help': 'This help message'\n },\n setup: {\n step1: 'Create a Notion integration at https://www.notion.so/my-integrations',\n step2: 'Copy the integration token and set it as NOTION_API_TOKEN environment variable',\n step3: 'Share your book database with the integration',\n step4: 'Copy the database ID from the URL and set it as NOTION_DATABASE_ID environment variable',\n step5: 'Ensure your database has these properties: Title (title), Author (rich text), ISBN (rich text), Year Published (number), Page Count (number), Publisher (rich text)'\n },\n database_properties: {\n required: ['Title (title)', 'Author (rich text)'],\n populated: ['ISBN (rich text)', 'Year Published (number)', 'Page Count (number)', 'Publisher (rich text)'],\n optional: ['Rating (number)', 'Progress (select)', 'Start Date (date)', 'Finish Date (date)', 'Notes (rich text)']\n }\n });\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[152,196],"3e3e0c46-3767-11f0-8087-9e149126039e","books.ts","70297fca-375c-11f0-b228-9e149126039e",["D",1747957701382],11,"/**\n * Google Books API integration for comprehensive book metadata\n */\n\nimport { BookMetadata } from './notion.ts';\n\n/**\n * Search for book metadata using Google Books API\n */\nexport async function searchBookMetadata(title: string, author: string): Promise {\n return await searchGoogleBooks(title, author);\n}\n\n/**\n * Search Google Books API for comprehensive book data\n */\nasync function searchGoogleBooks(title: string, author: string): Promise {\n try {\n console.log(`Searching Google Books for: \"${title}\" by \"${author}\"`);\n \n // Google Books API search with title and author\n const query = `intitle:\"${title.trim()}\" inauthor:\"${author.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=${encodedQuery}&maxResults=20&printType=books`\n );\n\n if (!response.ok) {\n console.error(`Google Books API error: ${response.status} ${response.statusText}`);\n return null;\n }\n\n const data = await response.json();\n console.log(`Google Books found ${data.totalItems || 0} results`);\n \n if (!data.items || data.items.length === 0) {\n console.log(`No books found for: \"${title}\" by \"${author}\"`);\n return null;\n }\n\n return findBestGoogleBooksMatch(data.items, title, author);\n } catch (error) {\n console.error('Error searching Google Books:', error);\n return null;\n }\n}\n\n/**\n * Find the best matching book from Google Books results\n */\nfunction findBestGoogleBooksMatch(items: any[], targetTitle: string, targetAuthor: string): BookMetadata | null {\n const normalize = (s: string) => s.toLowerCase().replace(/[^\\w\\s]/g, '').trim();\n const normalizedTargetTitle = normalize(targetTitle);\n const normalizedTargetAuthor = normalize(targetAuthor);\n\n const candidates = [];\n\n for (const item of items) {\n const volumeInfo = item.volumeInfo;\n if (!volumeInfo.title || !volumeInfo.authors) continue;\n\n const bookTitle = normalize(volumeInfo.title);\n const bookAuthors = volumeInfo.authors.map((author: string) => normalize(author));\n\n // Check for title and author match\n const titleMatch = bookTitle.includes(normalizedTargetTitle) || normalizedTargetTitle.includes(bookTitle);\n const authorMatch = bookAuthors.some((author: string) => \n author.includes(normalizedTargetAuthor) || normalizedTargetAuthor.includes(author)\n );\n\n if (titleMatch && authorMatch) {\n // Extract all available metadata\n const publishedDate = volumeInfo.publishedDate;\n let year = null;\n if (publishedDate) {\n const yearMatch = publishedDate.match(/^\\d{4}/);\n if (yearMatch) {\n year = parseInt(yearMatch[0]);\n }\n }\n\n // Get ISBN (prefer ISBN-13, fallback to ISBN-10)\n let isbn = null;\n if (volumeInfo.industryIdentifiers) {\n const isbn13 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_13');\n const isbn10 = volumeInfo.industryIdentifiers.find((id: any) => id.type === 'ISBN_10');\n isbn = isbn13?.identifier || isbn10?.identifier;\n }\n\n candidates.push({\n title: volumeInfo.title,\n subtitle: volumeInfo.subtitle,\n authors: volumeInfo.authors,\n publisher: volumeInfo.publisher,\n publishedDate: volumeInfo.publishedDate,\n year: year,\n description: volumeInfo.description,\n pageCount: volumeInfo.pageCount,\n categories: volumeInfo.categories,\n averageRating: volumeInfo.averageRating,\n ratingsCount: volumeInfo.ratingsCount,\n maturityRating: volumeInfo.maturityRating,\n language: volumeInfo.language,\n previewLink: volumeInfo.previewLink,\n infoLink: volumeInfo.infoLink,\n canonicalVolumeLink: volumeInfo.canonicalVolumeLink,\n isbn: isbn,\n imageLinks: volumeInfo.imageLinks,\n score: (titleMatch ? 2 : 0) + (authorMatch ? 2 : 0)\n });\n\n console.log(`Candidate: \"${volumeInfo.title}\" by ${volumeInfo.authors?.[0]} (${year}, ${volumeInfo.publisher})`);\n }\n }\n\n if (candidates.length === 0) {\n return null;\n }\n\n // Sort by score first, then by publication year (prefer earlier for classics)\n candidates.sort((a, b) => {\n if (a.score !== b.score) return b.score - a.score;\n if (!a.year && !b.year) return 0;\n if (!a.year) return 1;\n if (!b.year) return -1;\n return a.year - b.year;\n });\n\n const best = candidates[0];\n console.log(`Selected: \"${best.title}\" by ${best.authors?.[0]} (${best.year}, ${best.publisher})`);\n\n // Return comprehensive metadata object\n const metadata: BookMetadata = {};\n \n if (best.year) {\n metadata.yearPublished = best.year;\n }\n \n if (best.publisher) {\n metadata.publisher = best.publisher;\n }\n\n if (best.pageCount) {\n metadata.pageCount = best.pageCount;\n }\n\n if (best.isbn) {\n metadata.isbn = best.isbn;\n }\n\n // Additional fields that might be useful\n if (best.subtitle) {\n metadata.subtitle = best.subtitle;\n }\n\n if (best.description) {\n metadata.description = best.description;\n }\n\n if (best.categories && best.categories.length > 0) {\n metadata.categories = best.categories;\n }\n\n if (best.averageRating) {\n metadata.averageRating = best.averageRating;\n }\n\n if (best.ratingsCount) {\n metadata.ratingsCount = best.ratingsCount;\n }\n\n if (best.language) {\n metadata.language = best.language;\n }\n\n if (best.publishedDate) {\n metadata.publishedDate = best.publishedDate;\n }\n\n if (best.previewLink) {\n metadata.previewLink = best.previewLink;\n }\n\n if (best.infoLink) {\n metadata.infoLink = best.infoLink;\n }\n\n if (best.imageLinks) {\n metadata.imageLinks = best.imageLinks;\n }\n\n return metadata;\n}\n\n/**\n * Alternative search with relaxed criteria if exact search fails\n */\nexport async function searchBookMetadataRelaxed(title: string, author: string): Promise {\n try {\n console.log(`Relaxed Google Books search for: \"${title}\"`);\n \n // Try with just the title\n const query = `intitle:\"${title.trim()}\"`;\n const encodedQuery = encodeURIComponent(query);\n \n const response = await fetch(\n `https://www.googleapis.com/books/v1/volumes?q=${encodedQuery}&maxResults=30&printType=books`\n );\n\n if (!response.ok) {\n return null;\n }\n\n const data = await response.json();\n \n if (!data.items || data.items.length === 0) {\n return null;\n }\n\n return findBestGoogleBooksMatch(data.items, title, author);\n } catch (error) {\n console.error('Error in relaxed Google Books search:', error);\n return null;\n }\n}",[],[152,204],["D",1747953038469],[170,171,172,173],[152],["D",1747952823274],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":57,"_103":104,"_105":25},{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_126":251,"_252":253,"_254":255,"_256":25,"_257":25,"_258":25,"_259":61,"_260":-5,"_261":-7,"_262":-7,"_263":156,"_264":25,"_265":25,"_266":-5,"_267":25,"_268":25,"_269":25,"_270":-5},"ENV",{"_222":223,"_224":225,"_226":89,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v51