\n \n

🤖 Social Media Content Creator Bot

AI-powered content generation and automated posting

\n\n \n

Total Posts

Successful

Failed

This Week

\n\n \n

\n \n

🎯 Generate Content

\n \n

\n Content Type\n \n

\n \n

\n Topic (optional)\n \n

\n \n

\n Platform\n \n

\n \n \n

\n\n \n

⚡ Quick Actions

\n \n

\n \n \n \n \n \n

\n\n

🔧 Setup Required

\n Add your API keys as environment variables:\n
• OPENAI_API_KEY\n
• TWITTER_API_KEY, TWITTER_API_SECRET\n
• LINKEDIN_ACCESS_TOKEN\n

\n\n \n

📝 Generated Content

\n \n

\n \n \n

\n\n \n

📋 Recent Posts

\n \n

\n\n \n \n

\n\n \n\n",[],[224,231],[224],{"_106":240,"_98":241,"_150":242,"_152":-5,"_153":137,"_154":243,"_156":157,"_108":244,"_103":31,"_159":160,"_161":-5,"_162":27,"_163":-5,"_164":245,"_101":254},"1a24ab3e-3943-11f0-8d1a-9e149126039e","shared","9dc345b4-4b3c-4106-be9f-228b84275cdb",2,["D",1748162081261],[246],{"_106":247,"_98":248,"_150":249,"_152":242,"_153":137,"_154":243,"_156":157,"_108":250,"_103":31,"_159":172,"_161":251,"_162":27,"_163":-5,"_164":252,"_101":253},"1a248cee-3943-11f0-8d1a-9e149126039e","types.ts","1a248dca-3943-11f0-8d1a-9e149126039e",["D",1748162081261],"// Shared types for the social media bot\n\nexport interface ContentPost {\n id: string;\n content: string;\n hashtags: string[];\n platform: SocialPlatform;\n scheduledFor?: Date;\n postedAt?: Date;\n status: 'draft' | 'scheduled' | 'posted' | 'failed';\n engagement?: {\n likes: number;\n shares: number;\n comments: number;\n };\n}\n\nexport type SocialPlatform = 'twitter' | 'linkedin' | 'instagram' | 'facebook';\n\nexport interface ContentTemplate {\n type: ContentType;\n template: string;\n hashtags: string[];\n platforms: SocialPlatform[];\n}\n\nexport type ContentType = \n | 'motivational_quote'\n | 'tech_tip'\n | 'daily_fact'\n | 'industry_insight'\n | 'educational'\n | 'inspirational_story';\n\nexport interface BotConfig {\n contentTypes: ContentType[];\n platforms: SocialPlatform[];\n postingFrequency: 'hourly' | 'daily' | 'weekly';\n maxHashtags: number;\n contentLength: {\n min: number;\n max: number;\n };\n tone: 'professional' | 'casual' | 'inspirational' | 'educational';\n}\n\nexport interface GenerateContentRequest {\n type?: ContentType;\n platform?: SocialPlatform;\n topic?: string;\n customPrompt?: string;\n}\n\nexport interface PostContentRequest {\n content: string;\n platforms: SocialPlatform[];\n hashtags?: string[];\n scheduleFor?: string; // ISO date string\n}",[],[241,248],[241],{"_106":256,"_98":257,"_150":258,"_152":-5,"_153":137,"_154":259,"_156":157,"_108":260,"_103":31,"_159":234,"_161":261,"_162":27,"_163":-5,"_164":262,"_101":263},"1527c90e-3943-11f0-b067-9e149126039e","README.md","1527c9ea-3943-11f0-b067-9e149126039e",1,["D",1748162072894],"# Social Media Content Creator Bot\n\nAn intelligent social media bot that automatically generates and posts engaging content across multiple platforms.\n\n## Features\n\n- 🤖 AI-powered content generation\n- 📅 Automated scheduling with cron jobs\n- 🎯 Multiple content types (quotes, tips, facts, etc.)\n- 🔄 Multi-platform support (Twitter, LinkedIn, etc.)\n- 📊 Content tracking and analytics\n- 🎨 Dynamic hashtag generation\n- ⚙️ Configurable posting frequency\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main HTTP API\n│ ├── content-generator.ts # AI content generation\n│ ├── social-platforms.ts # Platform integrations\n│ └── scheduler.ts # Posting scheduler\n├── cron-poster.ts # Automated posting cron job\n├── shared/\n│ └── types.ts # Shared types and interfaces\n└── README.md\n```\n\n## Setup\n\n1. Set up environment variables:\n - `OPENAI_API_KEY` (for content generation)\n - `TWITTER_API_KEY`, `TWITTER_API_SECRET`, `TWITTER_ACCESS_TOKEN`, `TWITTER_ACCESS_SECRET`\n - `LINKEDIN_ACCESS_TOKEN` (optional)\n\n2. Configure content settings in `backend/content-generator.ts`\n\n3. Set up the cron job schedule in Val Town UI for automated posting\n\n## Usage\n\n- **Manual posting**: Make HTTP requests to trigger content generation and posting\n- **Automated posting**: Cron job runs on schedule to post content automatically\n- **Content management**: View and manage generated content through the API\n\n## API Endpoints\n\n- `GET /` - Dashboard and manual controls\n- `POST /generate` - Generate new content\n- `POST /post` - Post content to social media\n- `GET /content` - View recent content\n- `POST /schedule` - Schedule content for later\n\n## Content Types\n\nThe bot can generate various types of content:\n- Motivational quotes\n- Tech tips and insights\n- Daily facts and trivia\n- Industry news commentary\n- Inspirational stories\n- Educational content\n\nCustomize content types in the configuration to match your brand voice and audience.",[],[257],{"_106":265,"_98":266,"_150":267,"_152":-5,"_153":137,"_154":268,"_156":157,"_108":269,"_103":259,"_159":270,"_161":271,"_162":27,"_163":-5,"_164":272,"_101":273},"8719105e-3943-11f0-979f-9e149126039e","cron-poster.ts","83695554-3943-11f0-9650-9e149126039e",9,["D",1748162264053],"interval","// Automated content posting cron job\n// This will run on a schedule to automatically generate and post content\n\nimport { ContentGenerator } from \"./backend/content-generator.ts\";\nimport { SocialMediaManager } from \"./backend/social-platforms.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Configuration for automated posting\nconst AUTO_POST_CONFIG = {\n platforms: ['twitter'], // Add 'linkedin' when ready\n maxPostsPerDay: 3,\n minHoursBetweenPosts: 4,\n enableEmailNotifications: true\n};\n\nexport default async function() {\n console.log('🤖 Starting automated content posting...');\n \n try {\n // Check if we should post (rate limiting)\n const shouldPost = await checkPostingLimits();\n if (!shouldPost) {\n console.log('⏸️ Skipping post due to rate limits');\n return;\n }\n\n // Initialize services\n const contentGenerator = new ContentGenerator();\n const socialManager = new SocialMediaManager();\n\n // Generate content\n console.log('📝 Generating content...');\n const generated = await contentGenerator.generateContent();\n \n if (!generated.content) {\n throw new Error('No content generated');\n }\n\n console.log('✅ Content generated:', {\n type: generated.type,\n length: generated.content.length,\n hashtags: generated.hashtags.length\n });\n\n // Post to configured platforms\n console.log('📤 Posting to platforms:', AUTO_POST_CONFIG.platforms);\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n AUTO_POST_CONFIG.platforms\n );\n\n // Save results to database\n for (const result of results) {\n const postId = `auto_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null,\n new Date().toISOString()\n ]\n );\n }\n\n // Log results\n const successful = results.filter(r => r.success);\n const failed = results.filter(r => !r.success);\n\n console.log('📊 Posting results:', {\n successful: successful.length,\n failed: failed.length,\n platforms: successful.map(r => r.platform)\n });\n\n // Send email notification if enabled\n if (AUTO_POST_CONFIG.enableEmailNotifications) {\n await sendNotificationEmail(generated, results);\n }\n\n // Return summary\n return {\n success: true,\n content: generated,\n results,\n summary: {\n posted: successful.length,\n failed: failed.length,\n platforms: successful.map(r => r.platform)\n }\n };\n\n } catch (error) {\n console.error('❌ Error in automated posting:', error);\n \n // Send error notification\n if (AUTO_POST_CONFIG.enableEmailNotifications) {\n await sendErrorNotification(error);\n }\n \n throw error;\n }\n}\n\nasync function checkPostingLimits(): Promise {\n try {\n // Check posts in the last 24 hours\n const recentPosts = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLE_NAME} \n WHERE created_at >= datetime('now', '-24 hours') \n AND status = 'posted'`\n );\n \n const postsToday = recentPosts.rows?.[0]?.count || 0;\n \n if (postsToday >= AUTO_POST_CONFIG.maxPostsPerDay) {\n console.log(`📊 Daily limit reached: ${postsToday}/${AUTO_POST_CONFIG.maxPostsPerDay}`);\n return false;\n }\n\n // Check minimum time between posts\n const lastPost = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} \n WHERE status = 'posted' \n ORDER BY created_at DESC \n LIMIT 1`\n );\n \n if (lastPost.rows?.length > 0) {\n const lastPostTime = new Date(lastPost.rows[0].created_at);\n const hoursSinceLastPost = (Date.now() - lastPostTime.getTime()) / (1000 * 60 * 60);\n \n if (hoursSinceLastPost < AUTO_POST_CONFIG.minHoursBetweenPosts) {\n console.log(`⏰ Too soon since last post: ${hoursSinceLastPost.toFixed(1)} hours`);\n return false;\n }\n }\n\n return true;\n } catch (error) {\n console.error('Error checking posting limits:', error);\n return false; // Err on the side of caution\n }\n}\n\nasync function sendNotificationEmail(generated: any, results: any[]) {\n try {\n const successful = results.filter(r => r.success);\n const failed = results.filter(r => !r.success);\n \n const subject = `🤖 Social Bot: ${successful.length} posts published`;\n \n const html = `\n

Social Media Bot Report

\n \n

📝 Generated Content

\n Type: ${generated.type}
\n Content: ${generated.content}
\n Hashtags: ${generated.hashtags.join(' ')}\n

\n \n

📊 Posting Results

✅ Successful: ${successful.length}
❌ Failed: ${failed.length}
🎯 Platforms: ${successful.map(r => r.platform).join(', ')}

\n \n ${failed.length > 0 ? `\n

❌ Errors

${f.platform}: ${f.error}

\n ` : ''}\n \n

Generated at ${new Date().toLocaleString()}

\n `;\n \n await email({\n subject,\n html,\n text: `Social Bot posted ${successful.length} times. Content: ${generated.content}`\n });\n } catch (error) {\n console.error('Error sending notification email:', error);\n }\n}\n\nasync function sendErrorNotification(error: Error) {\n try {\n await email({\n subject: '🚨 Social Bot Error',\n html: `\n

Social Media Bot Error

Error: ${error.message}

Time: ${new Date().toLocaleString()}

${error.stack}

\n `,\n text: `Social Bot error: ${error.message}`\n });\n } catch (emailError) {\n console.error('Error sending error notification:', emailError);\n }\n}",[],[266],"files",[147,166,176,184,194,203,212,222,229,239,246,255,264],"counts",{"_278":31,"_279":259,"_280":31,"_281":31},"pulls","branches","forks","envVars","contents",[],{"_106":185,"_98":186,"_150":187,"_152":151,"_153":137,"_154":136,"_156":157,"_108":285,"_103":189,"_159":190,"_161":191,"_162":27,"_163":-5,"_101":286},["D",1748162966061],[149,186],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_96":97,"_98":99,"_100":42,"_101":102,"_104":293,"_234":297,"_300":301,"_338":339,"_349":-7,"_350":31,"_351":27},{"_106":107,"_98":99,"_108":294,"_110":-5,"_111":27,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":-5,"_118":27,"_119":-5,"_120":31,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_130":27,"_21":295,"_134":296},["D",1748161769385],{"_96":97,"_132":133},{"_103":136,"_98":42,"_106":137,"_138":107,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":99,"_144":97},{"_106":185,"_98":186,"_150":187,"_152":151,"_153":137,"_154":136,"_156":157,"_108":298,"_103":189,"_159":190,"_161":191,"_162":27,"_163":-5,"_101":299},["D",1748162966061],[149,186],"history",[302,304,309,315,320,325,330,335],{"_106":185,"_153":137,"_150":187,"_98":186,"_161":191,"_159":190,"_103":189,"_152":151,"_108":303,"_154":136,"_163":-5},["D",1748162966061],{"_106":305,"_153":137,"_150":187,"_98":186,"_161":306,"_159":190,"_103":226,"_152":151,"_108":307,"_154":308,"_163":-5},"1aa9f5ee-3945-11f0-bbf9-9e149126039e","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ContentGenerator } from \"./content-generator.ts\";\nimport { SocialMediaManager } from \"./social-platforms.ts\";\nimport { ContentScheduler } from \"./scheduler.ts\";\nimport { AutoResponder } from \"./auto-responder.ts\";\nimport { TwitterAPI } from \"./twitter-api.ts\";\nimport type { ContentPost, GenerateContentRequest, PostContentRequest } from \"../shared/types.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.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// CORS is automatically handled by Val Town\n\n// Initialize services\nconst contentGenerator = new ContentGenerator();\nconst socialManager = new SocialMediaManager();\nconst scheduler = new ContentScheduler();\nconst autoResponder = new AutoResponder();\nconst twitterAPI = new TwitterAPI();\n\n// Database setup\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n hashtags TEXT NOT NULL,\n platform TEXT NOT NULL,\n type TEXT NOT NULL,\n scheduled_for TEXT,\n posted_at TEXT,\n status TEXT NOT NULL DEFAULT 'draft',\n post_id TEXT,\n error_message TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// Dashboard - serve the main interface\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get recent posts for dashboard\n const recentPosts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 10`\n );\n \n const initialData = {\n recentPosts: recentPosts.rows || [],\n stats: {\n totalPosts: recentPosts.rows?.length || 0,\n successfulPosts: recentPosts.rows?.filter(p => p.status === 'posted').length || 0\n }\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(`Error loading dashboard: ${error.message}`, 500);\n }\n});\n\n// Generate new content\napp.post(\"/api/generate\", async (c) => {\n try {\n const request: GenerateContentRequest = await c.req.json().catch(() => ({}));\n \n const generated = await contentGenerator.generateContent(request);\n \n // Save to database\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n request.platform || 'twitter',\n generated.type,\n 'draft'\n ]\n );\n \n return c.json({\n success: true,\n post: {\n id: postId,\n ...generated\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Post content to social media\napp.post(\"/api/post\", async (c) => {\n try {\n const request: PostContentRequest = await c.req.json();\n \n if (!request.content || !request.platforms?.length) {\n return c.json({\n success: false,\n error: 'Content and platforms are required'\n }, 400);\n }\n \n const results = await socialManager.postToMultiplePlatforms(\n request.content,\n request.hashtags || [],\n request.platforms\n );\n \n // Save results to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n request.content,\n JSON.stringify(request.hashtags || []),\n result.platform,\n 'manual',\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get content history\napp.get(\"/api/content\", async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '20');\n const offset = parseInt(c.req.query('offset') || '0');\n \n const posts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return c.json({\n success: true,\n posts: posts.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Generate and post immediately\napp.post(\"/api/generate-and-post\", async (c) => {\n try {\n const request = await c.req.json().catch(() => ({}));\n \n // Generate content\n const generated = await contentGenerator.generateContent(request);\n \n // Post to specified platforms\n const platforms = request.platforms || ['twitter'];\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n platforms\n );\n \n // Save to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n content: generated,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get posting statistics\napp.get(\"/api/stats\", async (c) => {\n try {\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN status = 'posted' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN created_at >= date('now', '-7 days') THEN 1 END) as posts_this_week\n FROM ${TABLE_NAME}\n `);\n \n const platformStats = await sqlite.execute(`\n SELECT platform, COUNT(*) as count \n FROM ${TABLE_NAME} \n WHERE status = 'posted' \n GROUP BY platform\n `);\n \n return c.json({\n success: true,\n stats: stats.rows?.[0] || {},\n platformStats: platformStats.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", (c) => {\n return c.json({\n success: true,\n status: \"healthy\",\n timestamp: new Date().toISOString()\n });\n});\n\nexport default app.fetch;",["D",1748162941127],17,{"_106":310,"_153":137,"_150":187,"_98":186,"_161":311,"_159":190,"_103":312,"_152":151,"_108":313,"_154":314,"_163":-5},"17bcf5b6-3945-11f0-a683-9e149126039e","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ContentGenerator } from \"./content-generator.ts\";\nimport { SocialMediaManager } from \"./social-platforms.ts\";\nimport { ContentScheduler } from \"./scheduler.ts\";\nimport { AutoResponder } from \"./auto-responder.ts\";\nimport { TwitterAPI } from \"./twitter-api.ts\";\nimport type { ContentPost, GenerateContentRequest, PostContentRequest } from \"../shared/types.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.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// CORS is automatically handled by Val Town\n\n// Initialize services\nconst contentGenerator = new ContentGenerator();\nconst socialManager = new SocialMediaManager();\n\n// Database setup\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n hashtags TEXT NOT NULL,\n platform TEXT NOT NULL,\n type TEXT NOT NULL,\n scheduled_for TEXT,\n posted_at TEXT,\n status TEXT NOT NULL DEFAULT 'draft',\n post_id TEXT,\n error_message TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// Dashboard - serve the main interface\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get recent posts for dashboard\n const recentPosts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 10`\n );\n \n const initialData = {\n recentPosts: recentPosts.rows || [],\n stats: {\n totalPosts: recentPosts.rows?.length || 0,\n successfulPosts: recentPosts.rows?.filter(p => p.status === 'posted').length || 0\n }\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(`Error loading dashboard: ${error.message}`, 500);\n }\n});\n\n// Generate new content\napp.post(\"/api/generate\", async (c) => {\n try {\n const request: GenerateContentRequest = await c.req.json().catch(() => ({}));\n \n const generated = await contentGenerator.generateContent(request);\n \n // Save to database\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n request.platform || 'twitter',\n generated.type,\n 'draft'\n ]\n );\n \n return c.json({\n success: true,\n post: {\n id: postId,\n ...generated\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Post content to social media\napp.post(\"/api/post\", async (c) => {\n try {\n const request: PostContentRequest = await c.req.json();\n \n if (!request.content || !request.platforms?.length) {\n return c.json({\n success: false,\n error: 'Content and platforms are required'\n }, 400);\n }\n \n const results = await socialManager.postToMultiplePlatforms(\n request.content,\n request.hashtags || [],\n request.platforms\n );\n \n // Save results to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n request.content,\n JSON.stringify(request.hashtags || []),\n result.platform,\n 'manual',\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get content history\napp.get(\"/api/content\", async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '20');\n const offset = parseInt(c.req.query('offset') || '0');\n \n const posts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return c.json({\n success: true,\n posts: posts.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Generate and post immediately\napp.post(\"/api/generate-and-post\", async (c) => {\n try {\n const request = await c.req.json().catch(() => ({}));\n \n // Generate content\n const generated = await contentGenerator.generateContent(request);\n \n // Post to specified platforms\n const platforms = request.platforms || ['twitter'];\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n platforms\n );\n \n // Save to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n content: generated,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get posting statistics\napp.get(\"/api/stats\", async (c) => {\n try {\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN status = 'posted' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN created_at >= date('now', '-7 days') THEN 1 END) as posts_this_week\n FROM ${TABLE_NAME}\n `);\n \n const platformStats = await sqlite.execute(`\n SELECT platform, COUNT(*) as count \n FROM ${TABLE_NAME} \n WHERE status = 'posted' \n GROUP BY platform\n `);\n \n return c.json({\n success: true,\n stats: stats.rows?.[0] || {},\n platformStats: platformStats.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", (c) => {\n return c.json({\n success: true,\n status: \"healthy\",\n timestamp: new Date().toISOString()\n });\n});\n\nexport default app.fetch;",5,["D",1748162936221],16,{"_106":316,"_153":137,"_150":187,"_98":186,"_161":317,"_159":190,"_103":207,"_152":151,"_108":318,"_154":319,"_163":-5},"c2ddcd72-3944-11f0-b334-9e149126039e","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ContentGenerator } from \"./content-generator.ts\";\nimport { SocialMediaManager } from \"./social-platforms.ts\";\nimport type { ContentPost, GenerateContentRequest, PostContentRequest } from \"../shared/types.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.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// CORS is automatically handled by Val Town\n\n// Initialize services\nconst contentGenerator = new ContentGenerator();\nconst socialManager = new SocialMediaManager();\n\n// Database setup\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n hashtags TEXT NOT NULL,\n platform TEXT NOT NULL,\n type TEXT NOT NULL,\n scheduled_for TEXT,\n posted_at TEXT,\n status TEXT NOT NULL DEFAULT 'draft',\n post_id TEXT,\n error_message TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// Dashboard - serve the main interface\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get recent posts for dashboard\n const recentPosts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 10`\n );\n \n const initialData = {\n recentPosts: recentPosts.rows || [],\n stats: {\n totalPosts: recentPosts.rows?.length || 0,\n successfulPosts: recentPosts.rows?.filter(p => p.status === 'posted').length || 0\n }\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(`Error loading dashboard: ${error.message}`, 500);\n }\n});\n\n// Generate new content\napp.post(\"/api/generate\", async (c) => {\n try {\n const request: GenerateContentRequest = await c.req.json().catch(() => ({}));\n \n const generated = await contentGenerator.generateContent(request);\n \n // Save to database\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n request.platform || 'twitter',\n generated.type,\n 'draft'\n ]\n );\n \n return c.json({\n success: true,\n post: {\n id: postId,\n ...generated\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Post content to social media\napp.post(\"/api/post\", async (c) => {\n try {\n const request: PostContentRequest = await c.req.json();\n \n if (!request.content || !request.platforms?.length) {\n return c.json({\n success: false,\n error: 'Content and platforms are required'\n }, 400);\n }\n \n const results = await socialManager.postToMultiplePlatforms(\n request.content,\n request.hashtags || [],\n request.platforms\n );\n \n // Save results to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n request.content,\n JSON.stringify(request.hashtags || []),\n result.platform,\n 'manual',\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get content history\napp.get(\"/api/content\", async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '20');\n const offset = parseInt(c.req.query('offset') || '0');\n \n const posts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return c.json({\n success: true,\n posts: posts.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Generate and post immediately\napp.post(\"/api/generate-and-post\", async (c) => {\n try {\n const request = await c.req.json().catch(() => ({}));\n \n // Generate content\n const generated = await contentGenerator.generateContent(request);\n \n // Post to specified platforms\n const platforms = request.platforms || ['twitter'];\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n platforms\n );\n \n // Save to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n content: generated,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get posting statistics\napp.get(\"/api/stats\", async (c) => {\n try {\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN status = 'posted' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN created_at >= date('now', '-7 days') THEN 1 END) as posts_this_week\n FROM ${TABLE_NAME}\n `);\n \n const platformStats = await sqlite.execute(`\n SELECT platform, COUNT(*) as count \n FROM ${TABLE_NAME} \n WHERE status = 'posted' \n GROUP BY platform\n `);\n \n return c.json({\n success: true,\n stats: stats.rows?.[0] || {},\n platformStats: platformStats.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", (c) => {\n return c.json({\n success: true,\n status: \"healthy\",\n timestamp: new Date().toISOString()\n });\n});\n\nexport default app.fetch;",["D",1748162793830],12,{"_106":321,"_153":137,"_150":187,"_98":186,"_161":322,"_159":190,"_103":155,"_152":151,"_108":323,"_154":324,"_163":-5},"b3c7a36c-3944-11f0-91e2-9e149126039e","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ContentGenerator } from \"./content-generator.ts\";\nimport { SocialMediaManager } from \"./social-platforms.ts\";\nimport type { ContentPost, GenerateContentRequest, PostContentRequest } from \"../shared/types.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.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// CORS is automatically handled by Val Town\n\n// Initialize services\nconst contentGenerator = new ContentGenerator();\nconst socialManager = new SocialMediaManager();\n\n// Database setup\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n hashtags TEXT NOT NULL,\n platform TEXT NOT NULL,\n type TEXT NOT NULL,\n scheduled_for TEXT,\n posted_at TEXT,\n status TEXT NOT NULL DEFAULT 'draft',\n post_id TEXT,\n error_message TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// Dashboard - serve the main interface\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get recent posts for dashboard\n const recentPosts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 10`\n );\n \n const initialData = {\n recentPosts: recentPosts.rows || [],\n stats: {\n totalPosts: recentPosts.rows?.length || 0,\n successfulPosts: recentPosts.rows?.filter(p => p.status === 'posted').length || 0\n }\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(`Error loading dashboard: ${error.message}`, 500);\n }\n});\n\n// Generate new content\napp.post(\"/api/generate\", async (c) => {\n try {\n const request: GenerateContentRequest = await c.req.json().catch(() => ({}));\n \n const generated = await contentGenerator.generateContent(request);\n \n // Save to database\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n request.platform || 'twitter',\n generated.type,\n 'draft'\n ]\n );\n \n return c.json({\n success: true,\n post: {\n id: postId,\n ...generated\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Post content to social media\napp.post(\"/api/post\", async (c) => {\n try {\n const request: PostContentRequest = await c.req.json();\n \n if (!request.content || !request.platforms?.length) {\n return c.json({\n success: false,\n error: 'Content and platforms are required'\n }, 400);\n }\n \n const results = await socialManager.postToMultiplePlatforms(\n request.content,\n request.hashtags || [],\n request.platforms\n );\n \n // Save results to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n request.content,\n JSON.stringify(request.hashtags || []),\n result.platform,\n 'manual',\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get content history\napp.get(\"/api/content\", async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '20');\n const offset = parseInt(c.req.query('offset') || '0');\n \n const posts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return c.json({\n success: true,\n posts: posts.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Generate and post immediately\napp.post(\"/api/generate-and-post\", async (c) => {\n try {\n const request = await c.req.json().catch(() => ({}));\n \n // Generate content\n const generated = await contentGenerator.generateContent(request);\n \n // Post to specified platforms\n const platforms = request.platforms || ['twitter'];\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n platforms\n );\n \n // Save to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n content: generated,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get posting statistics\napp.get(\"/api/stats\", async (c) => {\n try {\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN status = 'posted' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN created_at >= date('now', '-7 days') THEN 1 END) as posts_this_week\n FROM ${TABLE_NAME}\n `);\n \n const platformStats = await sqlite.execute(`\n SELECT platform, COUNT(*) as count \n FROM ${TABLE_NAME} \n WHERE status = 'posted' \n GROUP BY platform\n `);\n \n return c.json({\n success: true,\n stats: stats.rows?.[0] || {},\n platformStats: platformStats.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", (c) => {\n return c.json({\n success: true,\n status: \"healthy\",\n timestamp: new Date().toISOString()\n });\n});\n\nexport default app;",["D",1748162768514],11,{"_106":326,"_153":137,"_150":187,"_98":186,"_161":327,"_159":190,"_103":243,"_152":151,"_108":328,"_154":329,"_163":-5},"94e48916-3943-11f0-bd5b-9e149126039e","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ContentGenerator } from \"./content-generator.ts\";\nimport { SocialMediaManager } from \"./social-platforms.ts\";\nimport type { ContentPost, GenerateContentRequest, PostContentRequest } from \"../shared/types.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.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\napp.use(\"*\", cors());\n\n// Initialize services\nconst contentGenerator = new ContentGenerator();\nconst socialManager = new SocialMediaManager();\n\n// Database setup\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n hashtags TEXT NOT NULL,\n platform TEXT NOT NULL,\n type TEXT NOT NULL,\n scheduled_for TEXT,\n posted_at TEXT,\n status TEXT NOT NULL DEFAULT 'draft',\n post_id TEXT,\n error_message TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// Dashboard - serve the main interface\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get recent posts for dashboard\n const recentPosts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 10`\n );\n \n const initialData = {\n recentPosts: recentPosts.rows || [],\n stats: {\n totalPosts: recentPosts.rows?.length || 0,\n successfulPosts: recentPosts.rows?.filter(p => p.status === 'posted').length || 0\n }\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(`Error loading dashboard: ${error.message}`, 500);\n }\n});\n\n// Generate new content\napp.post(\"/api/generate\", async (c) => {\n try {\n const request: GenerateContentRequest = await c.req.json().catch(() => ({}));\n \n const generated = await contentGenerator.generateContent(request);\n \n // Save to database\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n request.platform || 'twitter',\n generated.type,\n 'draft'\n ]\n );\n \n return c.json({\n success: true,\n post: {\n id: postId,\n ...generated\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Post content to social media\napp.post(\"/api/post\", async (c) => {\n try {\n const request: PostContentRequest = await c.req.json();\n \n if (!request.content || !request.platforms?.length) {\n return c.json({\n success: false,\n error: 'Content and platforms are required'\n }, 400);\n }\n \n const results = await socialManager.postToMultiplePlatforms(\n request.content,\n request.hashtags || [],\n request.platforms\n );\n \n // Save results to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n request.content,\n JSON.stringify(request.hashtags || []),\n result.platform,\n 'manual',\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get content history\napp.get(\"/api/content\", async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '20');\n const offset = parseInt(c.req.query('offset') || '0');\n \n const posts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return c.json({\n success: true,\n posts: posts.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Generate and post immediately\napp.post(\"/api/generate-and-post\", async (c) => {\n try {\n const request = await c.req.json().catch(() => ({}));\n \n // Generate content\n const generated = await contentGenerator.generateContent(request);\n \n // Post to specified platforms\n const platforms = request.platforms || ['twitter'];\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n platforms\n );\n \n // Save to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n content: generated,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get posting statistics\napp.get(\"/api/stats\", async (c) => {\n try {\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN status = 'posted' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN created_at >= date('now', '-7 days') THEN 1 END) as posts_this_week\n FROM ${TABLE_NAME}\n `);\n \n const platformStats = await sqlite.execute(`\n SELECT platform, COUNT(*) as count \n FROM ${TABLE_NAME} \n WHERE status = 'posted' \n GROUP BY platform\n `);\n \n return c.json({\n success: true,\n stats: stats.rows?.[0] || {},\n platformStats: platformStats.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", (c) => {\n return c.json({\n success: true,\n status: \"healthy\",\n timestamp: new Date().toISOString()\n });\n});\n\nexport default app;",["D",1748162287202],10,{"_106":331,"_153":137,"_150":187,"_98":186,"_161":332,"_159":190,"_103":259,"_152":151,"_108":333,"_154":334,"_163":-5},"853382ba-3943-11f0-870c-9e149126039e","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ContentGenerator } from \"./content-generator.ts\";\nimport { SocialMediaManager } from \"./social-platforms.ts\";\nimport type { ContentPost, GenerateContentRequest, PostContentRequest } from \"../shared/types.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.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\napp.use(\"*\", cors());\n\n// Initialize services\nconst contentGenerator = new ContentGenerator();\nconst socialManager = new SocialMediaManager();\n\n// Database setup\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Initialize database\nasync function initDatabase() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n hashtags TEXT NOT NULL,\n platform TEXT NOT NULL,\n type TEXT NOT NULL,\n scheduled_for TEXT,\n posted_at TEXT,\n status TEXT NOT NULL DEFAULT 'draft',\n post_id TEXT,\n error_message TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// Dashboard - serve the main interface\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get recent posts for dashboard\n const recentPosts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 10`\n );\n \n const initialData = {\n recentPosts: recentPosts.rows || [],\n stats: {\n totalPosts: recentPosts.rows?.length || 0,\n successfulPosts: recentPosts.rows?.filter(p => p.status === 'posted').length || 0\n }\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(`Error loading dashboard: ${error.message}`, 500);\n }\n});\n\n// Generate new content\napp.post(\"/api/generate\", async (c) => {\n try {\n const request: GenerateContentRequest = await c.req.json().catch(() => ({}));\n \n const generated = await contentGenerator.generateContent(request);\n \n // Save to database\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n request.platform || 'twitter',\n generated.type,\n 'draft'\n ]\n );\n \n return c.json({\n success: true,\n post: {\n id: postId,\n ...generated\n }\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Post content to social media\napp.post(\"/api/post\", async (c) => {\n try {\n const request: PostContentRequest = await c.req.json();\n \n if (!request.content || !request.platforms?.length) {\n return c.json({\n success: false,\n error: 'Content and platforms are required'\n }, 400);\n }\n \n const results = await socialManager.postToMultiplePlatforms(\n request.content,\n request.hashtags || [],\n request.platforms\n );\n \n // Save results to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n request.content,\n JSON.stringify(request.hashtags || []),\n result.platform,\n 'manual',\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get content history\napp.get(\"/api/content\", async (c) => {\n try {\n const limit = parseInt(c.req.query('limit') || '20');\n const offset = parseInt(c.req.query('offset') || '0');\n \n const posts = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return c.json({\n success: true,\n posts: posts.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Generate and post immediately\napp.post(\"/api/generate-and-post\", async (c) => {\n try {\n const request = await c.req.json().catch(() => ({}));\n \n // Generate content\n const generated = await contentGenerator.generateContent(request);\n \n // Post to specified platforms\n const platforms = request.platforms || ['twitter'];\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n platforms\n );\n \n // Save to database\n for (const result of results) {\n const postId = `post_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null\n ]\n );\n }\n \n return c.json({\n success: true,\n content: generated,\n results\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Get posting statistics\napp.get(\"/api/stats\", async (c) => {\n try {\n const stats = await sqlite.execute(`\n SELECT \n COUNT(*) as total_posts,\n COUNT(CASE WHEN status = 'posted' THEN 1 END) as successful_posts,\n COUNT(CASE WHEN status = 'failed' THEN 1 END) as failed_posts,\n COUNT(CASE WHEN created_at >= date('now', '-7 days') THEN 1 END) as posts_this_week\n FROM ${TABLE_NAME}\n `);\n \n const platformStats = await sqlite.execute(`\n SELECT platform, COUNT(*) as count \n FROM ${TABLE_NAME} \n WHERE status = 'posted' \n GROUP BY platform\n `);\n \n return c.json({\n success: true,\n stats: stats.rows?.[0] || {},\n platformStats: platformStats.rows || []\n });\n } catch (error) {\n return c.json({\n success: false,\n error: error.message\n }, 500);\n }\n});\n\n// Health check\napp.get(\"/api/health\", (c) => {\n return c.json({\n success: true,\n status: \"healthy\",\n timestamp: new Date().toISOString()\n });\n});\n\nexport default app;",["D",1748162260871],8,{"_106":336,"_153":137,"_150":187,"_98":186,"_161":332,"_159":172,"_103":31,"_152":151,"_108":337,"_154":312,"_163":-5},"4da931a0-3943-11f0-902c-9e149126039e",["D",1748162167692],"versions",[340,342,343,344,345,346,347,348],{"_234":302,"_341":304},"previous",{"_234":304,"_341":309},{"_234":309,"_341":315},{"_234":315,"_341":320},{"_234":320,"_341":325},{"_234":325,"_341":330},{"_234":330,"_341":335},{"_234":335,"_341":-5},"versionNumber","page","hasNext","routes/_app","actionData","errors"]

History for index.ts