Database Debug View

\n \n

Users (${Array.isArray(users) ? users.length : 0} records)

\n \n \n \n \n \n \n \n \n \n \n ${Array.isArray(users) ? users.map(user => `\n \n \n \n \n \n \n \n \n \n `).join('') : ''}\n

ID	Email	Nome	Cargo	Empresa	Has Password	Created At
${user.id}	${user.email}	${user.nome}	${user.cargo}	${user.tipo_empresa}	${user.password_hash ? '✅' : '❌'}	${user.created_at}
No users found

\n \n

Sessions (${Array.isArray(sessions) ? sessions.length : 0} records)

\n \n \n \n \n \n \n \n \n ${Array.isArray(sessions) ? sessions.map(session => `\n \n \n \n \n \n \n \n `).join('') : ''}\n

ID	User ID	Challenge	Status	Created At
${session.id}	${session.user_id}	${session.initial_challenge?.substring(0, 50)}...	${session.status}	${session.created_at}
No sessions found

\n \n

Messages (${Array.isArray(messages) ? messages.length : 0} records)

\n \n \n \n \n \n \n \n \n ${Array.isArray(messages) ? messages.map(message => `\n \n \n \n \n \n \n \n `).join('') : ''}\n

ID	Session ID	Role	Content Preview	Created At
${message.id}	${message.session_id}	${message.role}	${message.content?.substring(0, 100)}...	${message.created_at}
No messages found

\n \n

HMW Questions (${Array.isArray(hmwQuestions) ? hmwQuestions.length : 0} records)

\n \n \n \n \n \n \n \n \n ${Array.isArray(hmwQuestions) ? hmwQuestions.map(q => `\n \n \n \n \n \n \n \n `).join('') : ''}\n

ID	Session ID	Question	Category	Created At
${q.id}	${q.session_id}	${q.question}	${q.category}	${q.created_at}
No HMW questions found

\n \n

Test Database Connection

✅ Database connection successful

\n \n

Actions

\n \n \n Go to Signup\n Go to App\n \n \n \n \n `;\n \n return c.html(html);\n } catch (error) {\n return c.html(`\n \n \n

Database Error

Error: ${error.message}

${error.stack}

\n \n \n `);\n }\n});\n\n// Clear users for testing\napp.post(\"/debug/clear-users\", async c => {\n try {\n // Delete all data in correct order\n await sqlite.execute(\"DELETE FROM hmw_questions\");\n await sqlite.execute(\"DELETE FROM messages\");\n await sqlite.execute(\"DELETE FROM sessions\");\n await sqlite.execute(\"DELETE FROM users\");\n \n return c.json({ success: true });\n } catch (error) {\n console.error(\"Clear users error:\", error);\n return c.json({ error: error.message }, 500);\n }\n});\n\n// Sessions API\napp.get(\"/api/sessions\", async c => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ error: \"Não autorizado\" }, 401);\n \n const sessions = await sqlite.execute(`\n SELECT s.*, \n (SELECT content FROM messages WHERE session_id = s.id AND role = 'user' ORDER BY created_at LIMIT 1) as first_message\n FROM sessions s \n WHERE s.user_id = ? \n ORDER BY s.created_at DESC\n `, [user.id]);\n \n return c.json(sessions);\n});\n\napp.post(\"/api/sessions\", async c => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ error: \"Não autorizado\" }, 401);\n \n const { initial_challenge } = await c.req.json();\n \n const result = await sqlite.execute(\n \"INSERT INTO sessions (user_id, initial_challenge) VALUES (?, ?)\",\n [user.id, initial_challenge]\n );\n \n return c.json({ id: result.lastInsertRowid, initial_challenge });\n});\n\napp.get(\"/api/sessions/:id\", async c => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ error: \"Não autorizado\" }, 401);\n \n const sessionId = c.req.param(\"id\");\n \n const session = await sqlite.execute(\n \"SELECT * FROM sessions WHERE id = ? AND user_id = ?\",\n [sessionId, user.id]\n );\n \n if (session.length === 0) {\n return c.json({ error: \"Sessão não encontrada\" }, 404);\n }\n \n const messages = await sqlite.execute(\n \"SELECT * FROM messages WHERE session_id = ? ORDER BY created_at\",\n [sessionId]\n );\n \n const hmwQuestions = await sqlite.execute(\n \"SELECT * FROM hmw_questions WHERE session_id = ? ORDER BY created_at\",\n [sessionId]\n );\n \n return c.json({\n session: session[0],\n messages,\n hmwQuestions\n });\n});\n\napp.post(\"/api/sessions/:id/messages\", async c => {\n const user = await getCurrentUser(c);\n if (!user) return c.json({ error: \"Não autorizado\" }, 401);\n \n const sessionId = c.req.param(\"id\");\n const { content } = await c.req.json();\n \n // Verify session belongs to user\n const session = await sqlite.execute(\n \"SELECT * FROM sessions WHERE id = ? AND user_id = ?\",\n [sessionId, user.id]\n );\n \n if (session.length === 0) {\n return c.json({ error: \"Sessão não encontrada\" }, 404);\n }\n \n // Save user message\n await sqlite.execute(\n \"INSERT INTO messages (session_id, role, content) VALUES (?, 'user', ?)\",\n [sessionId, content]\n );\n \n // Get conversation history\n const messages = await sqlite.execute(\n \"SELECT * FROM messages WHERE session_id = ? ORDER BY created_at\",\n [sessionId]\n );\n \n // Generate AI response\n const aiResponse = await generateAIResponse(messages, session[0].initial_challenge);\n \n // Save AI response\n await sqlite.execute(\n \"INSERT INTO messages (session_id, role, content) VALUES (?, 'assistant', ?)\",\n [sessionId, aiResponse.content]\n );\n \n // Save HMW questions if any\n if (aiResponse.hmwQuestions) {\n for (const question of aiResponse.hmwQuestions) {\n await sqlite.execute(\n \"INSERT INTO hmw_questions (session_id, question, category) VALUES (?, ?, ?)\",\n [sessionId, question.text, question.category]\n );\n }\n }\n \n return c.json({ content: aiResponse.content, hmwQuestions: aiResponse.hmwQuestions });\n});\n\n// Helper functions\nasync function initializeDatabase() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n nome TEXT,\n empresa TEXT,\n cargo TEXT,\n telefone TEXT,\n como_conheceu TEXT,\n tipo_empresa TEXT,\n num_funcionarios TEXT,\n site TEXT,\n contratar_seo TEXT,\n password_hash TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n \n // Brainstorming sessions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER,\n initial_challenge TEXT NOT NULL,\n status TEXT DEFAULT 'active',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n \n // Chat messages\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n session_id INTEGER,\n role TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n \n // How Might We questions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS hmw_questions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n session_id INTEGER,\n question TEXT NOT NULL,\n category TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n \n console.log(\"Database initialized successfully\");\n}\n\nasync function hashPassword(password: string): Promise {\n // Simple hash for demo - use bcrypt in production\n const encoder = new TextEncoder();\n const data = encoder.encode(password + \"salt\");\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nasync function verifyPassword(password: string, hash: string): Promise {\n const passwordHash = await hashPassword(password);\n return passwordHash === hash;\n}\n\nfunction generateRandomPassword(): string {\n return Math.random().toString(36).slice(-8);\n}\n\nasync function getUserById(userId: number) {\n const result = await sqlite.execute(\n \"SELECT * FROM users WHERE id = ?\",\n [userId]\n );\n const users = result.rows || result;\n \n return users.length > 0 ? users[0] : null;\n}\n\nasync function getCurrentUser(c: any) {\n const userId = getCookie(c, \"user_id\");\n if (!userId) return null;\n \n return await getUserById(parseInt(userId));\n}\n\nasync function generateAIResponse(messages: any[], initialChallenge: string) {\n const genAI = new GoogleGenerativeAI(Deno.env.get(\"GEMINI_API_KEY\") || \"\");\n const model = genAI.getGenerativeModel({ model: \"gemini-2.0-flash-exp\" });\n \n const systemPrompt = `Você é um especialista em inovação e facilitador de brainstorming usando a metodologia \"How Might We\" (Como Poderíamos).\n\nSeu objetivo é ajudar o usuário a explorar desafios de diferentes perspectivas gerando perguntas HMW estratégicas.\n\nProcesso:\n1. Analise o desafio apresentado\n2. Gere 5-7 perguntas \"Como poderíamos...\" que abordem diferentes aspectos\n3. Categorize as perguntas (ex: Tecnologia, Pessoas, Processos, Modelo de Negócio)\n4. Para cada pergunta, sugira 2-3 direções iniciais de exploração\n\nFormato de resposta:\n- Comece com uma breve análise do desafio (2-3 frases)\n- Liste as perguntas HMW com suas categorias\n- Pergunte qual direção o usuário gostaria de explorar primeiro\n- Use emojis relevantes para tornar a conversa mais engaging\n\nMantenha um tom profissional mas acessível, como um consultor de inovação.\n\nDesafio inicial: ${initialChallenge}`;\n \n const conversationHistory = messages.map(msg => ({\n role: msg.role === 'assistant' ? 'model' : 'user',\n parts: [{ text: msg.content }]\n }));\n \n const chat = model.startChat({\n history: [\n {\n role: 'user',\n parts: [{ text: systemPrompt }]\n },\n {\n role: 'model',\n parts: [{ text: 'Entendi! Estou pronto para ajudar com o brainstorming usando a metodologia How Might We. Vou analisar o desafio e gerar perguntas estratégicas para explorar diferentes perspectivas.' }]\n },\n ...conversationHistory.slice(0, -1) // Exclude the last message as it will be sent separately\n ]\n });\n \n const lastMessage = messages[messages.length - 1];\n const result = await chat.sendMessage(lastMessage.content);\n const response = result.response.text();\n \n // Extract HMW questions from response (simple regex approach)\n const hmwRegex = /Como poderíamos[^?]*\\?/gi;\n const hmwMatches = response.match(hmwRegex) || [];\n \n const hmwQuestions = hmwMatches.map((question, index) => ({\n text: question,\n category: extractCategory(response, question) || `Categoria ${index + 1}`\n }));\n \n return {\n content: response,\n hmwQuestions: hmwQuestions.length > 0 ? hmwQuestions : null\n };\n}\n\nfunction extractCategory(text: string, question: string): string | null {\n // Simple category extraction based on keywords\n const categories = {\n 'Tecnologia': ['tecnologia', 'digital', 'sistema', 'plataforma', 'app', 'software'],\n 'Pessoas': ['pessoas', 'usuário', 'cliente', 'equipe', 'colaborador', 'humano'],\n 'Processos': ['processo', 'fluxo', 'método', 'procedimento', 'operação'],\n 'Modelo de Negócio': ['negócio', 'receita', 'monetização', 'valor', 'mercado'],\n 'Experiência': ['experiência', 'jornada', 'interface', 'usabilidade', 'satisfação']\n };\n \n const questionLower = question.toLowerCase();\n \n for (const [category, keywords] of Object.entries(categories)) {\n if (keywords.some(keyword => questionLower.includes(keyword))) {\n return category;\n }\n }\n \n return null;\n}\n\nexport default app.fetch;","deleted","label",[169,153],"backend","permalink","https://www.val.town/x/diegoivo/brainstorming/code/backend/index.ts","extension","actionData","errors"]