🚀 Manual N2B Scheduler Test

📋 Instructions:

Make sure you have a post in Notion with Status = \"Scheduled\"
Set the Scheduled Date to a time in the past or very soon
Click the button below to run the scheduler manually

\n \n \n \n

Click the button above to test the scheduler

\n \n \n \n \n `;\n\n const url = new URL(req.url);\n \n if (url.pathname === '/api/run') {\n return new Response(JSON.stringify(await runSchedulerTest()), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n return new Response(html, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nasync function runSchedulerTest() {\n try {\n console.log('🚀 Manual N2B Scheduler test starting...', new Date().toISOString());\n\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n const cleanHandle = blueskyHandle\n .replace(/[^\\w.-]/g, '')\n .replace(/^@+/, '');\n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n return {\n success: true,\n message: 'No posts scheduled for now',\n details: 'Make sure you have a post with Status=\"Scheduled\" and Scheduled Date in the past or very soon'\n };\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n \n const results = [];\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky (with media if available)\n const blueskyUrl = await bluesky.createPost(post.text, post.media);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n results.push({\n title: post.title,\n success: true,\n blueskyUrl: blueskyUrl\n });\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n results.push({\n title: post.title,\n success: false,\n error: error.message\n });\n }\n }\n\n const successCount = results.filter(r => r.success).length;\n const failCount = results.filter(r => !r.success).length;\n\n return {\n success: failCount === 0,\n message: `Processed ${results.length} post(s): ${successCount} successful, ${failCount} failed`,\n details: JSON.stringify(results, null, 2)\n };\n\n } catch (error) {\n console.error('💥 Manual scheduler test failed:', error);\n return {\n success: false,\n message: error.message,\n details: error.stack\n };\n }\n}",[],[223],{"_107":231,"_100":232,"_155":233,"_157":-5,"_158":141,"_159":234,"_161":162,"_109":235,"_104":236,"_164":237,"_166":238,"_167":27,"_168":-5,"_169":239,"_103":240},"df3df13e-3932-11f0-9e10-9e149126039e","scheduler.ts","37bb4522-3916-11f0-a786-9e149126039e",28,["D",1748155110493],6,"interval","import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * N2B Scheduler - Notion to Bluesky Auto Poster\n * \n * This cron job runs every 15 minutes to check for scheduled posts\n * in Notion and publishes them to Bluesky when their time comes.\n */\nexport default async function() {\n console.log('🚀 N2B Scheduler starting...', new Date().toISOString());\n\n try {\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables. Please set: NOTION_TOKEN, NOTION_DATABASE_ID, BLUESKY_HANDLE, BLUESKY_APP_PASSWORD');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n // Clean up handle - remove @ symbol, spaces, and invisible Unicode characters\n const cleanHandle = blueskyHandle\n .replace(/[^\\w.-]/g, '') // Keep only word chars, dots, and hyphens\n .replace(/^@+/, ''); // Remove any @ symbols at the start\n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n console.log('✅ No posts scheduled for now');\n return;\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky (with media if available)\n const blueskyUrl = await bluesky.createPost(post.text, post.media);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n // Continue with other posts even if one fails\n }\n }\n\n console.log('🎉 N2B Scheduler completed successfully');\n\n } catch (error) {\n console.error('💥 N2B Scheduler failed:', error);\n throw error; // Re-throw to ensure cron job shows as failed\n }\n}",[],[232],{"_107":242,"_100":243,"_155":244,"_157":-5,"_158":141,"_159":245,"_161":162,"_109":246,"_104":124,"_164":217,"_166":247,"_167":27,"_168":-5,"_169":248,"_103":249},"4f5a433a-3917-11f0-99bb-9e149126039e","test.ts","4da7e3c6-3917-11f0-a2ae-9e149126039e",8,["D",1748143272641],"import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * Test function to verify the N2B Scheduler setup\n * This will check your environment variables and test the connections\n */\nexport default async function(req: Request) {\n const html = `\n \n \n \n N2B Scheduler Test\n \n \n \n

🧪 N2B Scheduler Test

🔄 Running tests...

\n \n \n \n \n `;\n\n const url = new URL(req.url);\n \n if (url.pathname === '/api/test') {\n return new Response(JSON.stringify(await runTestSuite()), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n return new Response(html, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nasync function runTestSuite() {\n const tests = [];\n \n // Test 1: Environment Variables\n try {\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n const missing = [];\n if (!notionToken) missing.push('NOTION_TOKEN');\n if (!notionDatabaseId) missing.push('NOTION_DATABASE_ID');\n if (!blueskyHandle) missing.push('BLUESKY_HANDLE');\n if (!blueskyAppPassword) missing.push('BLUESKY_APP_PASSWORD');\n\n if (missing.length > 0) {\n tests.push({\n name: 'Environment Variables',\n success: false,\n message: `Missing environment variables: ${missing.join(', ')}`,\n });\n } else {\n // Clean up the handle (remove @ if present)\n const cleanHandle = blueskyHandle.startsWith('@') ? blueskyHandle.slice(1) : blueskyHandle;\n \n tests.push({\n name: 'Environment Variables',\n success: true,\n message: 'All required environment variables are set',\n details: `Handle: ${cleanHandle}\\nDatabase ID: ${notionDatabaseId.substring(0, 8)}...`\n });\n }\n } catch (error) {\n tests.push({\n name: 'Environment Variables',\n success: false,\n message: `Error checking environment variables: ${error.message}`,\n });\n }\n\n // Test 2: Notion Connection\n try {\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (notionToken && notionDatabaseId) {\n const notion = new NotionClient(notionToken, notionDatabaseId);\n const posts = await notion.getScheduledPosts();\n \n tests.push({\n name: 'Notion Connection',\n success: true,\n message: `Successfully connected to Notion database`,\n details: `Found ${posts.length} scheduled posts ready to publish`\n });\n }\n } catch (error) {\n tests.push({\n name: 'Notion Connection',\n success: false,\n message: `Failed to connect to Notion: ${error.message}`,\n details: 'Check your NOTION_TOKEN and NOTION_DATABASE_ID. Make sure the integration has access to the database.'\n });\n }\n\n // Test 3: Bluesky Authentication\n try {\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n \n if (blueskyHandle && blueskyAppPassword) {\n // Clean up the handle (remove @ if present)\n const cleanHandle = blueskyHandle.startsWith('@') ? blueskyHandle.slice(1) : blueskyHandle;\n \n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n await bluesky.authenticate();\n \n tests.push({\n name: 'Bluesky Authentication',\n success: true,\n message: `Successfully authenticated with Bluesky as ${cleanHandle}`,\n });\n }\n } catch (error) {\n tests.push({\n name: 'Bluesky Authentication',\n success: false,\n message: `Failed to authenticate with Bluesky: ${error.message}`,\n details: 'Check your BLUESKY_HANDLE and BLUESKY_APP_PASSWORD. Make sure the app password is correct.'\n });\n }\n\n // Test 4: Database Schema Check\n try {\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (notionToken && notionDatabaseId) {\n const response = await fetch(`https://api.notion.com/v1/databases/${notionDatabaseId}`, {\n headers: {\n 'Authorization': `Bearer ${notionToken}`,\n 'Notion-Version': '2022-06-28',\n },\n });\n \n if (response.ok) {\n const database = await response.json();\n const properties = database.properties;\n \n const requiredFields = ['Title', 'Text', 'Scheduled Date', 'Status', 'URL'];\n const missingFields = requiredFields.filter(field => !properties[field]);\n \n if (missingFields.length > 0) {\n tests.push({\n name: 'Database Schema',\n success: false,\n message: `Missing required fields: ${missingFields.join(', ')}`,\n details: `Available fields: ${Object.keys(properties).join(', ')}`\n });\n } else {\n tests.push({\n name: 'Database Schema',\n success: true,\n message: 'All required database fields are present',\n details: `Fields: ${Object.keys(properties).join(', ')}`\n });\n }\n } else {\n throw new Error(`HTTP ${response.status}`);\n }\n }\n } catch (error) {\n tests.push({\n name: 'Database Schema',\n success: false,\n message: `Failed to check database schema: ${error.message}`,\n });\n }\n\n return { tests };\n}",[],[243],"files",[152,171,182,191,201,211,221,230,241],"counts",{"_254":31,"_255":124,"_256":31,"_257":258},"pulls","branches","forks","envVars",4,"contents",[261,264,267,270,273,276],{"_107":153,"_100":154,"_155":156,"_157":-5,"_158":141,"_159":160,"_161":162,"_109":262,"_104":31,"_164":165,"_166":-5,"_167":27,"_168":-5,"_103":263},["D",1748142768743],[154],{"_107":202,"_100":203,"_155":204,"_157":-5,"_158":141,"_159":140,"_161":162,"_109":265,"_104":206,"_164":207,"_166":208,"_167":27,"_168":-5,"_103":266},["D",1748290729561],[203],{"_107":212,"_100":213,"_155":214,"_157":-5,"_158":141,"_159":215,"_161":162,"_109":268,"_104":124,"_164":217,"_166":218,"_167":27,"_168":-5,"_103":269},["D",1748143306749],[213],{"_107":222,"_100":223,"_155":224,"_157":-5,"_158":141,"_159":225,"_161":162,"_109":271,"_104":160,"_164":217,"_166":227,"_167":27,"_168":-5,"_103":272},["D",1748143917789],[223],{"_107":231,"_100":232,"_155":233,"_157":-5,"_158":141,"_159":234,"_161":162,"_109":274,"_104":236,"_164":237,"_166":238,"_167":27,"_168":-5,"_103":275},["D",1748155110493],[232],{"_107":242,"_100":243,"_155":244,"_157":-5,"_158":141,"_159":245,"_161":162,"_109":277,"_104":124,"_164":217,"_166":247,"_167":27,"_168":-5,"_103":278},["D",1748143272641],[243],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.environment-variables",{"_98":99,"_100":101,"_105":285,"_257":289},{"_107":108,"_100":101,"_109":286,"_111":-5,"_112":27,"_113":114,"_115":116,"_117":118,"_12":119,"_120":-5,"_121":27,"_122":-5,"_123":124,"_14":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_21":287,"_138":288,"_149":27},["D",1748141278512],{"_98":99,"_136":137},{"_104":140,"_100":42,"_107":141,"_142":108,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":101,"_148":99},[290,296,300,303],{"_291":292,"_109":293,"_294":-5,"_115":73,"_295":27},"key","BLUESKY_APP_PASSWORD",["D",1748143149928],"updatedAt","isEmpty",{"_291":297,"_109":298,"_294":299,"_115":73,"_295":27},"BLUESKY_HANDLE",["D",1748143048708],["D",1748143328942],{"_291":301,"_109":302,"_294":-5,"_115":73,"_295":27},"NOTION_DATABASE_ID",["D",1748142996615],{"_291":304,"_109":305,"_294":-5,"_115":73,"_295":27},"NOTION_TOKEN",["D",1748142930358],"routes/_app","actionData","errors"]

Key	Description
BLUESKY_APP_PASSWORD
BLUESKY_HANDLE
NOTION_DATABASE_ID
NOTION_TOKEN

Environment variables