Debug Info

Email: ${email || 'Not logged in'}

Back to app

\n ${email ? '

Logout

' : '

\n \n\n",[],[182,189],{"_103":197,"_95":198,"_152":199,"_154":183,"_155":137,"_156":136,"_158":159,"_105":200,"_100":201,"_161":202,"_163":203,"_164":22,"_165":-5,"_166":204,"_98":205},"c1db2f28-93da-11f0-b241-0224a6c84d84","index.tsx","17c5f262-93d9-11f0-aada-0224a6c84d84",["D",1758122821288],7,"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport { LoginWithGoogleButton } from \"https://esm.town/v/stevekrouse/LoginWithGoogleButton\";\n\ninterface Thread {\n id: number;\n title: string;\n created_at: string;\n updated_at: string;\n}\n\ninterface Message {\n id: number;\n thread_id: number;\n role: 'user' | 'assistant';\n content: string;\n created_at: string;\n}\n\ninterface AppProps {\n initialEmail?: string;\n initialThreads?: Thread[];\n}\n\nfunction App({ initialEmail, initialThreads = [] }: AppProps) {\n const [email, setEmail] = useState(initialEmail || null);\n const [threads, setThreads] = useState(initialThreads);\n const [selectedThreadId, setSelectedThreadId] = useState(null);\n const [messages, setMessages] = useState([]);\n const [loading, setLoading] = useState(false);\n const [sendingMessage, setSendingMessage] = useState(false);\n const [messageInput, setMessageInput] = useState('');\n\n // Fetch threads when user is logged in\n useEffect(() => {\n if (email && threads.length === 0) {\n fetchThreads();\n }\n }, [email]);\n\n // Fetch messages when thread is selected\n useEffect(() => {\n if (selectedThreadId) {\n fetchMessages(selectedThreadId);\n } else {\n setMessages([]);\n }\n }, [selectedThreadId]);\n\n const fetchThreads = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/threads');\n if (response.ok) {\n const data = await response.json();\n setThreads(data.threads);\n }\n } catch (error) {\n console.error('Failed to fetch threads:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const fetchMessages = async (threadId: number) => {\n try {\n const response = await fetch(`/api/threads/${threadId}/messages`);\n if (response.ok) {\n const data = await response.json();\n setMessages(data.messages);\n }\n } catch (error) {\n console.error('Failed to fetch messages:', error);\n }\n };\n\n const sendMessage = async () => {\n if (!messageInput.trim() || !selectedThreadId || sendingMessage) return;\n\n const content = messageInput.trim();\n setMessageInput('');\n setSendingMessage(true);\n\n try {\n const response = await fetch(`/api/threads/${selectedThreadId}/messages`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ content }),\n });\n\n if (response.ok) {\n const data = await response.json();\n // Add both user and assistant messages\n setMessages(prev => [...prev, data.userMessage, data.assistantMessage]);\n \n // Update thread's updated_at in the threads list\n setThreads(prev => prev.map(thread => \n thread.id === selectedThreadId \n ? { ...thread, updated_at: new Date().toISOString() }\n : thread\n ).sort((a, b) => new Date(b.updated_at).getTime() - new Date(a.updated_at).getTime()));\n }\n } catch (error) {\n console.error('Failed to send message:', error);\n } finally {\n setSendingMessage(false);\n }\n };\n\n const handleKeyPress = (e: React.KeyboardEvent) => {\n if (e.key === 'Enter' && !e.shiftKey) {\n e.preventDefault();\n sendMessage();\n }\n };\n\n const createNewThread = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/threads', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n });\n \n if (response.ok) {\n const newThread = await response.json();\n setThreads(prev => [newThread, ...prev]);\n setSelectedThreadId(newThread.threadId);\n }\n } catch (error) {\n console.error('Failed to create thread:', error);\n } finally {\n setLoading(false);\n }\n };\n\n if (!email) {\n return (\n

\n Welcome to ChatGPT Clone\n

\n Please sign in to start chatting\n

\n \n

\n \n via LastLogin\n \n

\n );\n }\n\n return (\n

\n {/* Sidebar */}\n

\n {/* Header */}\n

ChatGPT Clone

{email}

\n\n {/* New Chat Button */}\n

\n \n {loading ? 'Creating...' : '+ New Chat'}\n \n

\n\n {/* Thread List */}\n

\n {threads.length === 0 ? (\n

\n No conversations yet. Create your first chat!\n

\n ) : (\n

\n {threads.map((thread) => (\n setSelectedThreadId(thread.id)}\n className={`w-full text-left p-3 rounded-lg transition-colors ${\n selectedThreadId === thread.id\n ? 'bg-gray-700 text-white'\n : 'text-gray-300 hover:bg-gray-800'\n }`}\n >\n

{thread.title}

\n {new Date(thread.updated_at).toLocaleDateString()}\n

\n \n ))}\n

\n )}\n

\n\n {/* Logout */}\n

\n \n Logout\n \n

\n\n {/* Main Content */}\n

\n {selectedThreadId ? (\n <>\n {/* Chat Messages */}\n

\n {messages.length === 0 ? (\n

Start a conversation

Type a message below to begin chatting with ChatGPT

\n ) : (\n messages.map((message) => (\n \n \n

{message.content}

\n {new Date(message.created_at).toLocaleTimeString()}\n

\n ))\n )}\n \n {/* Loading indicator */}\n {sendingMessage && (\n

\n ChatGPT is typing...\n

\n )}\n

\n\n {/* Message Input */}\n

\n setMessageInput(e.target.value)}\n onKeyPress={handleKeyPress}\n placeholder=\"Type your message here...\"\n disabled={sendingMessage}\n className=\"flex-1 resize-none border border-gray-300 rounded-lg px-4 py-2 focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent disabled:bg-gray-100\"\n rows={3}\n />\n \n {sendingMessage ? 'Sending...' : 'Send'}\n \n

\n \n ) : (\n

Welcome to ChatGPT Clone

Select a conversation or create a new one to get started

\n )}\n \n \n );\n}\n\n// Initialize the app\nfunction initApp() {\n const initialData = (window as any).__INITIAL_DATA__;\n const root = createRoot(document.getElementById('root')!);\n \n root.render(\n \n );\n}\n\n// Start the app when DOM is ready\nif (document.readyState === 'loading') {\n document.addEventListener('DOMContentLoaded', initApp);\n} else {\n initApp();\n}",[],[182,198],[182],{"_103":208,"_95":209,"_152":210,"_154":-5,"_155":137,"_156":211,"_158":159,"_105":212,"_100":213,"_161":192,"_163":214,"_164":22,"_165":-5,"_166":215,"_98":216},"e636b622-93d9-11f0-8664-0224a6c84d84","README.md","f2dc78fe-93d8-11f0-b88d-0224a6c84d84",23,["D",1758122452789],5,"# ChatGPT Clone with LastLogin Authentication\n\nA fullstack React + Hono app that lets you chat with ChatGPT, with user authentication and thread history.\n\n## Features\n\n- 🔐 Authentication via LastLogin (Google OAuth)\n- 💬 Chat with ChatGPT (GPT-4o-mini)\n- 📝 Thread-based conversation history\n- 🗄️ SQLite storage for persistence\n- 📱 Responsive design with TailwindCSS\n\n## Project Structure\n\n```\n├── backend/\n│ └── index.ts # Main Hono server with API routes\n├── frontend/\n│ ├── index.html # Main HTML template\n│ └── index.tsx # React frontend app\n└── README.md\n```\n\n## Current Status: Phase 3 Complete ✅\n\n**Backend Foundation:**\n- ✅ Hono app with LastLogin authentication\n- ✅ SQLite schema for threads and messages\n- ✅ Basic API endpoints for threads CRUD\n- ✅ Static file serving for React frontend\n\n**Frontend Foundation:**\n- ✅ React app with authentication UI\n- ✅ Basic layout with sidebar for threads\n- ✅ Login/logout flow with LoginWithGoogleButton\n- ✅ Thread listing and creation\n- ✅ Responsive design with TailwindCSS\n\n**Chat Interface:**\n- ✅ Chat message display with user/assistant styling\n- ✅ Message input with textarea and send button\n- ✅ OpenAI API integration (GPT-4o-mini)\n- ✅ Real-time message updates\n- ✅ Loading states and typing indicators\n- ✅ Conversation history context\n\n## API Endpoints\n\n- `GET /` - Main React app\n- `GET /api/threads` - List user's threads\n- `POST /api/threads` - Create new thread\n- `GET /api/threads/:id/messages` - Get messages for thread\n- `POST /api/threads/:id/messages` - Send message and get AI response\n\n## Database Schema\n\n**Tables:**\n- `last-login-chat-threads` - User chat threads\n- `last-login-chat-messages` - Individual messages in threads\n\n## Next Steps\n\n- Phase 4: Thread management and auto-titles\n- Phase 5: Final polish and responsive design\n\n## Debug Routes\n\n- `/debug` - Check authentication status\n- `/api/test-create-thread` - Create a test thread (when logged in)",[],[209],"files",[149,168,180,187,196,207],"counts",{"_221":32,"_222":157,"_223":32,"_224":32},"pulls","branches","forks","envVars","contents",[],{"_103":169,"_95":170,"_152":171,"_154":153,"_155":137,"_156":172,"_158":159,"_105":228,"_100":174,"_161":175,"_163":176,"_164":22,"_165":-5,"_98":229},["D",1758122292786],[151,170],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":238,"_192":243,"_246":247,"_287":288,"_299":-7,"_300":32,"_301":22},{"_103":104,"_95":96,"_105":239,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":240,"_131":241,"_134":242,"_146":22},["D",1758121645940],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},{"_103":169,"_95":170,"_152":171,"_154":153,"_155":137,"_156":172,"_158":159,"_105":244,"_100":174,"_161":175,"_163":176,"_164":22,"_165":-5,"_98":245},["D",1758122292786],[151,170],"history",[248,250,255,261,266,270,275,280,284],{"_103":169,"_155":137,"_152":171,"_95":170,"_163":176,"_161":175,"_100":174,"_154":153,"_105":249,"_156":172,"_165":-5},["D",1758122292786],{"_103":251,"_155":137,"_152":171,"_95":170,"_163":252,"_161":175,"_100":201,"_154":153,"_105":253,"_156":254,"_165":-5},"781a56ee-93d9-11f0-8b06-0224a6c84d84","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { lastlogin } from \"https://esm.town/v/stevekrouse/lastlogin_safe\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\n\nconst app = new Hono();\nconst openai = new OpenAI();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database tables\nasync function initDatabase() {\n // Create threads table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-threads\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT 'New Chat',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-messages\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n thread_id INTEGER NOT NULL,\n role TEXT NOT NULL CHECK (role IN ('user', 'assistant')),\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (thread_id) REFERENCES \\`last-login-chat-threads\\`(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Initialize database on startup\nawait initDatabase();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main route - serve React app with initial data\napp.get(\"/\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Prepare initial data\n let initialData: any = { email };\n \n if (email) {\n // Fetch user's threads for initial load\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n initialData.threads = rows;\n } catch (error) {\n console.error('Failed to fetch initial threads:', error);\n initialData.threads = [];\n }\n }\n\n // Inject initial data\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes for threads\napp.get(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n\n return c.json({ threads: rows });\n});\n\n// Test route to create a thread\napp.get(\"/api/test-create-thread\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email, title) VALUES (?, ?)`,\n [email, `Test Thread ${Date.now()}`]\n );\n\n return c.json({ \n message: \"Thread created\", \n threadId: result.lastInsertRowId,\n redirect: \"/api/threads\"\n });\n});\n\n// Debug route to check authentication\napp.get(\"/debug\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n return c.html(`\n \n Debug\n \n

Debug Info

Email: ${email || 'Not logged in'}

Back to app

\n ${email ? '

Logout

' : '

Debug Info

Email: ${email || 'Not logged in'}

Back to app

\n ${email ? '

Logout

' : '

Debug Info

Email: ${email || 'Not logged in'}

Back to app

\n ${email ? '

Logout

' : '

'}\n \n \n `);\n});\n\n// Create new thread\napp.post(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email) VALUES (?)`,\n [email]\n );\n\n const now = new Date().toISOString();\n \n return c.json({ \n threadId: result.lastInsertRowId,\n id: result.lastInsertRowId,\n title: \"New Chat\",\n user_email: email,\n created_at: now,\n updated_at: now\n });\n});\n\n// Get messages for a thread\napp.get(\"/api/threads/:threadId/messages\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const threadId = c.req.param('threadId');\n \n // Verify thread belongs to user\n const { rows: threadRows } = await sqlite.execute(\n `SELECT id FROM \\`last-login-chat-threads\\` WHERE id = ? AND user_email = ?`,\n [threadId, email]\n );\n\n if (threadRows.length === 0) {\n return c.json({ error: \"Thread not found\" }, 404);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-messages\\` WHERE thread_id = ? ORDER BY created_at ASC`,\n [threadId]\n );\n\n return c.json({ messages: rows });\n});\n\nexport default lastlogin(app.fetch);",["D",1758122204961],9,{"_103":267,"_155":137,"_152":171,"_95":170,"_163":268,"_161":175,"_100":184,"_154":153,"_105":269,"_156":174,"_165":-5},"282e99ec-93d9-11f0-97b0-0224a6c84d84","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { lastlogin } from \"https://esm.town/v/stevekrouse/lastlogin_safe\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile, serveFile } 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) => Promise.reject(err));\n\n// Initialize database tables\nasync function initDatabase() {\n // Create threads table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-threads\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT 'New Chat',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-messages\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n thread_id INTEGER NOT NULL,\n role TEXT NOT NULL CHECK (role IN ('user', 'assistant')),\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (thread_id) REFERENCES \\`last-login-chat-threads\\`(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Initialize database on startup\nawait initDatabase();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main route - serve React app with initial data\napp.get(\"/\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Prepare initial data\n let initialData: any = { email };\n \n if (email) {\n // Fetch user's threads for initial load\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n initialData.threads = rows;\n } catch (error) {\n console.error('Failed to fetch initial threads:', error);\n initialData.threads = [];\n }\n }\n\n // Inject initial data\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes for threads\napp.get(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n\n return c.json({ threads: rows });\n});\n\n// Test route to create a thread\napp.get(\"/api/test-create-thread\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email, title) VALUES (?, ?)`,\n [email, `Test Thread ${Date.now()}`]\n );\n\n return c.json({ \n message: \"Thread created\", \n threadId: result.lastInsertRowId,\n redirect: \"/api/threads\"\n });\n});\n\n// Create new thread\napp.post(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email) VALUES (?)`,\n [email]\n );\n\n const now = new Date().toISOString();\n \n return c.json({ \n threadId: result.lastInsertRowId,\n id: result.lastInsertRowId,\n title: \"New Chat\",\n user_email: email,\n created_at: now,\n updated_at: now\n });\n});\n\n// Get messages for a thread\napp.get(\"/api/threads/:threadId/messages\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const threadId = c.req.param('threadId');\n \n // Verify thread belongs to user\n const { rows: threadRows } = await sqlite.execute(\n `SELECT id FROM \\`last-login-chat-threads\\` WHERE id = ? AND user_email = ?`,\n [threadId, email]\n );\n\n if (threadRows.length === 0) {\n return c.json({ error: \"Thread not found\" }, 404);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-messages\\` WHERE thread_id = ? ORDER BY created_at ASC`,\n [threadId]\n );\n\n return c.json({ messages: rows });\n});\n\nexport default lastlogin(app.fetch);",["D",1758122133967],{"_103":271,"_155":137,"_152":171,"_95":170,"_163":272,"_161":175,"_100":273,"_154":153,"_105":274,"_156":201,"_165":-5},"2356331c-93d9-11f0-918d-0224a6c84d84","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { lastlogin } from \"https://esm.town/v/stevekrouse/lastlogin_safe\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile, serveFile } 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) => Promise.reject(err));\n\n// Initialize database tables\nasync function initDatabase() {\n // Create threads table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-threads\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT 'New Chat',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-messages\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n thread_id INTEGER NOT NULL,\n role TEXT NOT NULL CHECK (role IN ('user', 'assistant')),\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (thread_id) REFERENCES \\`last-login-chat-threads\\`(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Initialize database on startup\nawait initDatabase();\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Main route - serve React app with initial data\napp.get(\"/\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Prepare initial data\n let initialData: any = { email };\n \n if (email) {\n // Fetch user's threads for initial load\n try {\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n initialData.threads = rows;\n } catch (error) {\n console.error('Failed to fetch initial threads:', error);\n initialData.threads = [];\n }\n }\n\n // Inject initial data\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes for threads\napp.get(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n\n return c.json({ threads: rows });\n});\n\n// Test route to create a thread\napp.get(\"/api/test-create-thread\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email, title) VALUES (?, ?)`,\n [email, `Test Thread ${Date.now()}`]\n );\n\n return c.json({ \n message: \"Thread created\", \n threadId: result.lastInsertRowId,\n redirect: \"/api/threads\"\n });\n});\n\n// Create new thread\napp.post(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email) VALUES (?)`,\n [email]\n );\n\n return c.json({ \n threadId: result.lastInsertRowId,\n title: \"New Chat\",\n created_at: new Date().toISOString()\n });\n});\n\n// Get messages for a thread\napp.get(\"/api/threads/:threadId/messages\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const threadId = c.req.param('threadId');\n \n // Verify thread belongs to user\n const { rows: threadRows } = await sqlite.execute(\n `SELECT id FROM \\`last-login-chat-threads\\` WHERE id = ? AND user_email = ?`,\n [threadId, email]\n );\n\n if (threadRows.length === 0) {\n return c.json({ error: \"Thread not found\" }, 404);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-messages\\` WHERE thread_id = ? ORDER BY created_at ASC`,\n [threadId]\n );\n\n return c.json({ messages: rows });\n});\n\nexport default lastlogin(app.fetch);",3,["D",1758122125841],{"_103":276,"_155":137,"_152":171,"_95":170,"_163":277,"_161":175,"_100":278,"_154":153,"_105":279,"_156":258,"_165":-5},"1b68163e-93d9-11f0-ac58-0224a6c84d84","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { lastlogin } from \"https://esm.town/v/stevekrouse/lastlogin_safe\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { readFile, serveFile } 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) => Promise.reject(err));\n\n// Initialize database tables\nasync function initDatabase() {\n // Create threads table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-threads\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT 'New Chat',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-messages\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n thread_id INTEGER NOT NULL,\n role TEXT NOT NULL CHECK (role IN ('user', 'assistant')),\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (thread_id) REFERENCES \\`last-login-chat-threads\\`(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Initialize database on startup\nawait initDatabase();\n\n// Test route to verify authentication\napp.get(\"/\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n \n if (!email) {\n return c.html(`\n \n ChatGPT Clone\n \n

Please log in

You need to be logged in to use this app.

\n \n \n `);\n }\n\n return c.html(`\n \n ChatGPT Clone\n \n

Welcome ${email}!

Authentication is working!

Logout

API Test Links:

View your threads
Create test thread

\n \n \n `);\n});\n\n// API Routes for threads\napp.get(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n\n return c.json({ threads: rows });\n});\n\n// Test route to create a thread\napp.get(\"/api/test-create-thread\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email, title) VALUES (?, ?)`,\n [email, `Test Thread ${Date.now()}`]\n );\n\n return c.json({ \n message: \"Thread created\", \n threadId: result.lastInsertRowId,\n redirect: \"/api/threads\"\n });\n});\n\n// Create new thread\napp.post(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email) VALUES (?)`,\n [email]\n );\n\n return c.json({ \n threadId: result.lastInsertRowId,\n title: \"New Chat\",\n created_at: new Date().toISOString()\n });\n});\n\n// Get messages for a thread\napp.get(\"/api/threads/:threadId/messages\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const threadId = c.req.param('threadId');\n \n // Verify thread belongs to user\n const { rows: threadRows } = await sqlite.execute(\n `SELECT id FROM \\`last-login-chat-threads\\` WHERE id = ? AND user_email = ?`,\n [threadId, email]\n );\n\n if (threadRows.length === 0) {\n return c.json({ error: \"Thread not found\" }, 404);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-messages\\` WHERE thread_id = ? ORDER BY created_at ASC`,\n [threadId]\n );\n\n return c.json({ messages: rows });\n});\n\nexport default lastlogin(app.fetch);",2,["D",1758122112522],{"_103":281,"_155":137,"_152":171,"_95":170,"_163":282,"_161":175,"_100":157,"_154":153,"_105":283,"_156":278,"_165":-5},"ea998f9c-93d8-11f0-8d8c-0224a6c84d84","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { lastlogin } from \"https://esm.town/v/stevekrouse/lastlogin_safe\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Initialize database tables\nasync function initDatabase() {\n // Create threads table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-threads\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL DEFAULT 'New Chat',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS \\`last-login-chat-messages\\` (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n thread_id INTEGER NOT NULL,\n role TEXT NOT NULL CHECK (role IN ('user', 'assistant')),\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (thread_id) REFERENCES \\`last-login-chat-threads\\`(id) ON DELETE CASCADE\n )\n `);\n}\n\n// Initialize database on startup\nawait initDatabase();\n\n// Test route to verify authentication\napp.get(\"/\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n \n if (!email) {\n return c.html(`\n \n ChatGPT Clone\n \n

Please log in

You need to be logged in to use this app.

\n \n \n `);\n }\n\n return c.html(`\n \n ChatGPT Clone\n \n

Welcome ${email}!

Authentication is working!

Logout

API Test Links:

View your threads
Create test thread

\n \n \n `);\n});\n\n// API Routes for threads\napp.get(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-threads\\` WHERE user_email = ? ORDER BY updated_at DESC`,\n [email]\n );\n\n return c.json({ threads: rows });\n});\n\n// Test route to create a thread\napp.get(\"/api/test-create-thread\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email, title) VALUES (?, ?)`,\n [email, `Test Thread ${Date.now()}`]\n );\n\n return c.json({ \n message: \"Thread created\", \n threadId: result.lastInsertRowId,\n redirect: \"/api/threads\"\n });\n});\n\n// Create new thread\napp.post(\"/api/threads\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const result = await sqlite.execute(\n `INSERT INTO \\`last-login-chat-threads\\` (user_email) VALUES (?)`,\n [email]\n );\n\n return c.json({ \n threadId: result.lastInsertRowId,\n title: \"New Chat\",\n created_at: new Date().toISOString()\n });\n});\n\n// Get messages for a thread\napp.get(\"/api/threads/:threadId/messages\", async (c) => {\n const email = c.req.header('X-LastLogin-Email');\n if (!email) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n\n const threadId = c.req.param('threadId');\n \n // Verify thread belongs to user\n const { rows: threadRows } = await sqlite.execute(\n `SELECT id FROM \\`last-login-chat-threads\\` WHERE id = ? AND user_email = ?`,\n [threadId, email]\n );\n\n if (threadRows.length === 0) {\n return c.json({ error: \"Thread not found\" }, 404);\n }\n\n const { rows } = await sqlite.execute(\n `SELECT * FROM \\`last-login-chat-messages\\` WHERE thread_id = ? ORDER BY created_at ASC`,\n [threadId]\n );\n\n return c.json({ messages: rows });\n});\n\nexport default lastlogin(app.fetch);",["D",1758122030652],{"_103":285,"_155":137,"_152":171,"_95":170,"_163":282,"_161":202,"_100":32,"_154":153,"_105":286,"_156":157,"_165":-5},"e8ad08b2-93d8-11f0-89f8-0224a6c84d84",["D",1758122027424],"versions",[289,291,292,293,294,295,296,297,298],{"_192":248,"_290":250},"previous",{"_192":250,"_290":255},{"_192":255,"_290":261},{"_192":261,"_290":266},{"_192":266,"_290":270},{"_192":270,"_290":275},{"_192":275,"_290":280},{"_192":280,"_290":284},{"_192":284,"_290":-5},"versionNumber","page","hasNext","actionData","errors"]

History for index.ts