Test Email

This is a test email to verify email functionality is working.

\",\r\n headers: {\r\n ...config.emailConfig.headers,\r\n \"X-Email-Type\": \"test\"\r\n }\r\n });\r\n \r\n log.email(\"test email sent successfully\");\r\n return c.json({ success: true, message: \"Test email sent successfully\" });\r\n}));\r\n\r\n// Debug endpoint for troubleshooting\r\napp.get(\"/api/debug-config\", asyncHandler(async c => {\r\n log.debug(\"debug config requested\");\r\n \r\n return c.json({\r\n tableName: TABLE_NAME,\r\n adminEmail: config.adminEmail,\r\n siteUrl: config.siteUrl,\r\n emailConfigFrom: config.emailConfig.from,\r\n emailConfigReplyTo: config.emailConfig.replyTo,\r\n timestamp: new Date().toISOString()\r\n });\r\n}));\r\n\r\n// Database info endpoint\r\napp.get(\"/api/database-info\", asyncHandler(async c => {\r\n log.db(\"database info requested\");\r\n const dbInfo = await getDatabaseInfo();\r\n return c.json(dbInfo);\r\n}));\r\n\r\n// Test insert endpoint for debugging\r\napp.get(\"/api/test-insert\", asyncHandler(async c => {\r\n log.db(\"testing database insert\");\r\n \r\n const testEmail = `test${Date.now()}@example.com`;\r\n const testResult = await insertQuizSubmission({\r\n email: testEmail,\r\n primaryArchetype: \"The Visionary\",\r\n secondaryArchetype: \"The Nurturer\",\r\n breakdown: {\"The Visionary\": 70, \"The Nurturer\": 30},\r\n answers: [1,2,3,4,5],\r\n completionTime: 30000,\r\n insights: {},\r\n userAgent: \"test-agent\",\r\n ipHash: \"test-hash\",\r\n personalityComplexityScore: 0.85,\r\n responseConsistencyScore: 0.92\r\n });\r\n \r\n log.db(\"test insert completed\", { testEmail: testEmail.substring(0, 10) + '***' });\r\n \r\n // Verify it was inserted\r\n const verifyResult = await sqlite.execute({\r\n sql: `SELECT * FROM ${TABLE_NAME} WHERE email = ?`,\r\n args: [testEmail]\r\n });\r\n \r\n return c.json({\r\n success: true,\r\n insertResult: testResult,\r\n verifyResult: verifyResult,\r\n testEmail: testEmail,\r\n tableName: TABLE_NAME\r\n });\r\n}));\r\n\r\n// Enhanced debug endpoint to check table structure and data\r\napp.get(\"/api/debug-table\", async c => {\r\n try {\r\n // Get table schema\r\n const schemaResult = await sqlite.execute({\r\n sql: `PRAGMA table_info(${TABLE_NAME})`,\r\n args: []\r\n });\r\n const schema = Array.isArray(schemaResult) ? schemaResult : [];\r\n \r\n // Get count\r\n const countResult = await sqlite.execute({\r\n sql: `SELECT COUNT(*) as count FROM ${TABLE_NAME}`,\r\n args: []\r\n });\r\n const count = Array.isArray(countResult) ? countResult : [];\r\n \r\n // Get all entries (limit 10)\r\n const entriesResult = await sqlite.execute({\r\n sql: `SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC LIMIT 10`,\r\n args: []\r\n });\r\n const entries = Array.isArray(entriesResult) ? entriesResult : [];\r\n \r\n // Get all tables\r\n const tablesResult = await sqlite.execute({\r\n sql: `SELECT name FROM sqlite_master WHERE type='table'`,\r\n args: []\r\n });\r\n const tables = Array.isArray(tablesResult) ? tablesResult : [];\r\n \r\n return c.json({\r\n tableName: TABLE_NAME,\r\n tableSchema: schema,\r\n recordCount: count[0]?.count || 0,\r\n recentEntries: entries,\r\n allTables: tables,\r\n timestamp: new Date().toISOString()\r\n });\r\n } catch (error) {\r\n return c.json({ \r\n error: error.message,\r\n tableName: TABLE_NAME,\r\n timestamp: new Date().toISOString()\r\n }, 500);\r\n }\r\n});\r\n\r\n// Get analytics endpoint with proper error handling\r\napp.get(\"/api/analytics\", asyncHandler(async c => {\r\n log.db(\"analytics requested\");\r\n \r\n const stats = await sqlite.execute({\r\n sql: `SELECT \r\n primary_archetype,\r\n COUNT(*) as count,\r\n ROUND(AVG(completion_time), 2) as avg_completion_time,\r\n MIN(timestamp) as first_submission,\r\n MAX(timestamp) as latest_submission\r\n FROM ${TABLE_NAME} \r\n GROUP BY primary_archetype\r\n ORDER BY count DESC`,\r\n args: []\r\n });\r\n\r\n const totalSubmissions = await sqlite.execute({\r\n sql: `SELECT COUNT(*) as total FROM ${TABLE_NAME}`,\r\n args: []\r\n });\r\n\r\n const recentSubmissions = await sqlite.execute({\r\n sql: `SELECT primary_archetype, timestamp, completion_time\r\n FROM ${TABLE_NAME}\r\n ORDER BY timestamp DESC\r\n LIMIT 10`,\r\n args: []\r\n });\r\n \r\n const analytics = {\r\n archetypeDistribution: stats,\r\n totalSubmissions: totalSubmissions[0]?.total || 0,\r\n recentSubmissions,\r\n generatedAt: new Date().toISOString()\r\n };\r\n\r\n log.db(\"analytics generated\", { totalSubmissions: analytics.totalSubmissions });\r\n return c.json(analytics);\r\n}));\r\n\r\n// Enhanced email function following Val Town standards\r\nasync function sendResultsEmail(userEmail: string, results: QuizResults, completionTime?: number) {\r\n const completionTimeText = completionTime \r\n ? `Completion time: ${Math.round(completionTime / 1000)} seconds`\r\n : '';\r\n\r\n const topArchetypes = Object.entries(results.breakdown)\r\n .sort(([,a], [,b]) => b - a)\r\n .slice(0, 3)\r\n .map(([archetype, percentage]) => `${archetype}: ${percentage}%`)\r\n .join('\\n');\r\n\r\n // Generate subject from template\r\n const subject = config.emailConfig.templates.userResultsSubject\r\n .replace('{archetype}', results.primaryArchetype);\r\n\r\n // Enhanced HTML email template following Val Town best practices\r\n const htmlTemplate = `\r\n \r\n \r\n \r\n \r\n \r\n Your Social Archetype Results\r\n \r\n \r\n \r\n

\r\n \r\n \r\n

\r\n

Your ${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? 'Chosen' : 'Primary'} Archetype: ${results.selectedArchetype || results.primaryArchetype}

\r\n

${results.description || 'You have a unique social personality that influences how you connect with others and engage with communities.'}

\r\n ${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? `\r\n

\r\n Note: Your calculated result was \"${results.primaryArchetype}\", but you chose \"${results.selectedArchetype}\" as your preferred archetype.\r\n

\r\n ` : ''}\r\n

\r\n\r\n

\r\n

📊 Your Results Breakdown:

\r\n

${topArchetypes}

\r\n ${completionTimeText ? `

⏱️ ${completionTimeText}

` : ''}\r\n

\r\n\r\n

🌟 What This Means:

\r\n

Your primary archetype reflects your natural social tendencies
Look for events and communities that align with your archetype
Connect with others who share similar values
Consider how your archetype influences your social interactions

\r\n\r\n

\r\n Take Quiz Again\r\n

\r\n

\r\n\r\n \r\n

\r\n \r\n \r\n `;\r\n\r\n // Send email following Val Town documentation standards\r\n await email({\r\n to: userEmail,\r\n from: config.emailConfig.from,\r\n replyTo: config.emailConfig.replyTo,\r\n subject: subject,\r\n html: htmlTemplate,\r\n headers: {\r\n ...config.emailConfig.headers,\r\n \"X-Quiz-Result\": results.primaryArchetype,\r\n \"X-Completion-Time\": completionTime ? Math.round(completionTime / 1000).toString() : \"unknown\"\r\n },\r\n text: `\r\nYour Social Archetype: ${results.selectedArchetype || results.primaryArchetype}\r\n\r\n${results.description || 'You have a unique social personality.'}\r\n\r\n${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? `\r\nNote: Your calculated result was \"${results.primaryArchetype}\", but you chose \"${results.selectedArchetype}\" as your preferred archetype.\r\n` : ''}\r\n\r\nResults Breakdown:\r\n${topArchetypes}\r\n\r\n${completionTimeText}\r\n\r\nWhat This Means:\r\n- Your archetype reflects your natural social tendencies\r\n- Look for events and communities that align with your archetype\r\n- Connect with others who share similar values\r\n- Consider how your archetype influences your social interactions\r\n\r\nThank you for taking the Social Archetype Quiz!\r\n\r\nQuestions? Reply to this email to contact our team.\r\n `\r\n });\r\n}\r\n\r\n// Enhanced admin notification following Val Town patterns\r\nasync function sendAdminNotification(userEmail: string, results: QuizResults, completionTime?: number) {\r\n if (!config.adminEmail) return;\r\n\r\n // Generate subject from template\r\n const subject = config.emailConfig.templates.adminNotificationSubject\r\n .replace('{archetype}', results.primaryArchetype);\r\n\r\n const completionTimeText = completionTime \r\n ? `⏱️ Completion Time: ${Math.round(completionTime / 1000)} seconds`\r\n : '';\r\n\r\n await email({\r\n to: config.adminEmail,\r\n from: config.emailConfig.from,\r\n replyTo: config.emailConfig.replyTo,\r\n subject: subject,\r\n headers: {\r\n ...config.emailConfig.headers,\r\n \"X-Email-Type\": \"admin-notification\",\r\n \"X-User-Email\": userEmail,\r\n \"X-Quiz-Result\": results.primaryArchetype\r\n },\r\n html: `\r\n

\r\n

🎯 New Quiz Submission

\r\n

Social Archetype Quiz Admin Notification

\r\n

\r\n \r\n

\r\n

📋 Submission Details

\r\n

📧 User Email: ${userEmail}

\r\n

🎭 ${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? 'Chosen' : 'Primary'} Archetype: ${results.selectedArchetype || results.primaryArchetype}

\r\n ${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? `

📊 Calculated Archetype: ${results.primaryArchetype}

` : ''}\r\n

📅 Timestamp: ${new Date().toLocaleString()}

\r\n ${completionTimeText ? `

${completionTimeText}

` : ''}\r\n

\r\n \r\n

\r\n

📊 Archetype Breakdown:

\r\n

\r\n ${Object.entries(results.breakdown)\r\n .sort(([,a], [,b]) => b - a)\r\n .map(([archetype, percentage]) => `\r\n

\r\n ${archetype}\r\n ${percentage}%\r\n

\r\n `).join('')}\r\n

\r\n

\r\n \r\n

\r\n

\r\n \r\n 📊 View Admin Dashboard\r\n \r\n

\r\n

\r\n \r\n

\r\n

Sent from ${config.siteName} on Val Town

\r\n

\r\n `,\r\n text: `\r\n🎯 NEW QUIZ SUBMISSION\r\n\r\n📋 Submission Details:\r\n• User Email: ${userEmail}\r\n• ${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? 'Chosen' : 'Primary'} Archetype: ${results.selectedArchetype || results.primaryArchetype}\r\n${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? `• Calculated Archetype: ${results.primaryArchetype}` : ''}\r\n• Timestamp: ${new Date().toLocaleString()}\r\n${completionTimeText ? `• ${completionTimeText}` : ''}\r\n\r\n📊 Archetype Breakdown:\r\n${Object.entries(results.breakdown)\r\n .sort(([,a], [,b]) => b - a)\r\n .map(([archetype, percentage]) => `• ${archetype}: ${percentage}%`)\r\n .join('\\n')}\r\n\r\n📊 Admin Dashboard: ${config.siteUrl}/admin.http\r\n\r\n---\r\nSent from ${config.siteName} on Val Town\r\n `\r\n });\r\n}\r\n\r\n// Utility function to hash IP for privacy compliance\r\nasync function hashIP(ip: string): Promise {\r\n const encoder = new TextEncoder();\r\n const data = encoder.encode(ip + config.hashSalt);\r\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\r\n const hashArray = Array.from(new Uint8Array(hashBuffer));\r\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('').substring(0, 16);\r\n}\r\n\r\n// Export the Hono app as the default export for HTTP val\r\nexport default app.fetch; ","deleted","label","club",[98],"permalink","https://www.val.town/x/all/ssscQuiz/code/index.http.ts","extension","actionData","errors"]

Test Email

🎯 Your Social Archetype Results

${results.primaryArchetype}

Your ${results.selectedArchetype && results.selectedArchetype !== results.primaryArchetype ? 'Chosen' : 'Primary'} Archetype: ${results.selectedArchetype || results.primaryArchetype}

📊 Your Results Breakdown:

🌟 What This Means:

🎯 New Quiz Submission

📋 Submission Details

📊 Archetype Breakdown: