askrobots / dbbasic-admin
Public
An admin interface that builds itself from the dbbasic modules you install; its pages follow file paths, like CGI.
ai.html · 16.2 KB · 330 lines
| 1 | <!DOCTYPE html> |
| 2 | <html lang="en"> |
| 3 | <head> |
| 4 | <meta charset="UTF-8"> |
| 5 | <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| 6 | <title>AI Assistant - DBBASIC Studio</title> |
| 7 | <link rel="stylesheet" href="../../static/css/admin.css"> |
| 8 | </head> |
| 9 | <body> |
| 10 | <div class="studio-container"> |
| 11 | <header class="studio-header"> |
| 12 | <div class="logo"> |
| 13 | <span class="logo-icon">⚡</span> |
| 14 | <span class="logo-text">DBBASIC Studio</span> |
| 15 | </div> |
| 16 | <div class="header-actions"> |
| 17 | <span class="project-name">myblog/</span> |
| 18 | <button class="btn-icon" title="Deploy">🚀</button> |
| 19 | <button class="btn-icon" title="Settings">⚙️</button> |
| 20 | </div> |
| 21 | </header> |
| 22 | |
| 23 | <div class="studio-layout"> |
| 24 | <nav class="sidebar"> |
| 25 | <a href="../../index.html" class="nav-item"> |
| 26 | <span class="nav-icon">📊</span> |
| 27 | <span class="nav-label">Dashboard</span> |
| 28 | </a> |
| 29 | <a href="database.html" class="nav-item"> |
| 30 | <span class="nav-icon">🗄️</span> |
| 31 | <span class="nav-label">Database</span> |
| 32 | </a> |
| 33 | <a href="posts/list.html" class="nav-item"> |
| 34 | <span class="nav-icon">📝</span> |
| 35 | <span class="nav-label">Posts</span> |
| 36 | </a> |
| 37 | <a href="users/list.html" class="nav-item"> |
| 38 | <span class="nav-icon">👥</span> |
| 39 | <span class="nav-label">Users</span> |
| 40 | </a> |
| 41 | <div class="nav-divider"></div> |
| 42 | <a href="jobs.html" class="nav-item"> |
| 43 | <span class="nav-icon">⏰</span> |
| 44 | <span class="nav-label">Jobs</span> |
| 45 | </a> |
| 46 | <a href="logs.html" class="nav-item"> |
| 47 | <span class="nav-icon">📋</span> |
| 48 | <span class="nav-label">Logs</span> |
| 49 | </a> |
| 50 | <a href="deploy.html" class="nav-item"> |
| 51 | <span class="nav-icon">🚀</span> |
| 52 | <span class="nav-label">Deploy</span> |
| 53 | </a> |
| 54 | </nav> |
| 55 | |
| 56 | <main class="main-content ai-main"> |
| 57 | <div class="content-header"> |
| 58 | <div> |
| 59 | <h1>🤖 AI Assistant</h1> |
| 60 | <div class="breadcrumb">Home / AI Assistant</div> |
| 61 | </div> |
| 62 | </div> |
| 63 | |
| 64 | <!-- AI Chat Interface --> |
| 65 | <div class="ai-chat-container"> |
| 66 | <div class="ai-chat-messages"> |
| 67 | <!-- Welcome Message --> |
| 68 | <div class="ai-chat-message ai-message"> |
| 69 | <div class="message-avatar">🤖</div> |
| 70 | <div class="message-bubble"> |
| 71 | <div class="message-header"> |
| 72 | <strong>AI Assistant</strong> |
| 73 | <span class="message-time">Now</span> |
| 74 | </div> |
| 75 | <div class="message-text"> |
| 76 | <p>Hi! I'm your DBBASIC AI Assistant. I can help you:</p> |
| 77 | <ul> |
| 78 | <li>🏗️ <strong>Build features</strong> - "Add image uploads to posts"</li> |
| 79 | <li>🗄️ <strong>Modify database</strong> - "Create a comments table"</li> |
| 80 | <li>✏️ <strong>Edit code</strong> - "Add validation to user emails"</li> |
| 81 | <li>🚀 <strong>Deploy</strong> - "Deploy to production"</li> |
| 82 | <li>🐛 <strong>Debug</strong> - "Why are my posts not showing?"</li> |
| 83 | </ul> |
| 84 | <p>What would you like to build?</p> |
| 85 | </div> |
| 86 | </div> |
| 87 | </div> |
| 88 | |
| 89 | <!-- Example: User asks about feature --> |
| 90 | <div class="ai-chat-message user-message"> |
| 91 | <div class="message-bubble"> |
| 92 | <div class="message-header"> |
| 93 | <strong>You</strong> |
| 94 | <span class="message-time">Just now</span> |
| 95 | </div> |
| 96 | <div class="message-text"> |
| 97 | Add image uploads to posts with automatic resizing |
| 98 | </div> |
| 99 | </div> |
| 100 | <div class="message-avatar">👤</div> |
| 101 | </div> |
| 102 | |
| 103 | <!-- AI Response with Actions --> |
| 104 | <div class="ai-chat-message ai-message"> |
| 105 | <div class="message-avatar">🤖</div> |
| 106 | <div class="message-bubble"> |
| 107 | <div class="message-header"> |
| 108 | <strong>AI Assistant</strong> |
| 109 | <span class="message-time">Just now</span> |
| 110 | </div> |
| 111 | <div class="message-text"> |
| 112 | <p>I'll add image upload functionality to your posts. Here's what I'll do:</p> |
| 113 | |
| 114 | <div class="ai-plan"> |
| 115 | <div class="plan-step completed"> |
| 116 | <span class="step-icon">✅</span> |
| 117 | <div class="step-content"> |
| 118 | <strong>Create uploads table</strong> |
| 119 | <code>data/uploads.tsv</code> |
| 120 | </div> |
| 121 | </div> |
| 122 | <div class="plan-step completed"> |
| 123 | <span class="step-icon">✅</span> |
| 124 | <div class="step-content"> |
| 125 | <strong>Add upload route</strong> |
| 126 | <code>routes/admin/upload.py</code> |
| 127 | </div> |
| 128 | </div> |
| 129 | <div class="plan-step completed"> |
| 130 | <span class="step-icon">✅</span> |
| 131 | <div class="step-content"> |
| 132 | <strong>Create image processing job</strong> |
| 133 | <code>jobs/resize_images.py</code> |
| 134 | </div> |
| 135 | </div> |
| 136 | <div class="plan-step completed"> |
| 137 | <span class="step-icon">✅</span> |
| 138 | <div class="step-content"> |
| 139 | <strong>Update post editor</strong> |
| 140 | Added image picker to <code>templates/admin/posts/edit.html</code> |
| 141 | </div> |
| 142 | </div> |
| 143 | </div> |
| 144 | |
| 145 | <div class="ai-result"> |
| 146 | <p>✨ Done! Image uploads are now active.</p> |
| 147 | <p>Images will be automatically resized to 800px wide, with thumbnails at 300px.</p> |
| 148 | </div> |
| 149 | |
| 150 | <div class="ai-actions"> |
| 151 | <button class="btn-secondary-small">View Changes</button> |
| 152 | <button class="btn-secondary-small">Undo</button> |
| 153 | <button class="btn-primary-small">Test Upload</button> |
| 154 | </div> |
| 155 | </div> |
| 156 | </div> |
| 157 | </div> |
| 158 | |
| 159 | <!-- Code Preview --> |
| 160 | <div class="ai-chat-message ai-message"> |
| 161 | <div class="message-avatar">🤖</div> |
| 162 | <div class="message-bubble"> |
| 163 | <div class="message-header"> |
| 164 | <strong>AI Assistant</strong> |
| 165 | <span class="message-time">Just now</span> |
| 166 | </div> |
| 167 | <div class="message-text"> |
| 168 | <p>Here's the upload handler I created:</p> |
| 169 | <div class="code-preview"> |
| 170 | <div class="code-header"> |
| 171 | <span class="code-file">routes/admin/upload.py</span> |
| 172 | <button class="btn-icon-small">📋 Copy</button> |
| 173 | </div> |
| 174 | <pre><code>from dbbasic import router, upload, tsv |
| 175 | from PIL import Image |
| 176 | |
| 177 | @router.post("/admin/upload") |
| 178 | def handle_upload(file): |
| 179 | # Save original |
| 180 | path = upload.save(file, "uploads/") |
| 181 | |
| 182 | # Resize for web |
| 183 | img = Image.open(path) |
| 184 | img.thumbnail((800, 800)) |
| 185 | web_path = upload.save_resized(img, "uploads/web/") |
| 186 | |
| 187 | # Create thumbnail |
| 188 | img.thumbnail((300, 300)) |
| 189 | thumb_path = upload.save_resized(img, "uploads/thumbs/") |
| 190 | |
| 191 | # Store metadata |
| 192 | tsv.insert("uploads", { |
| 193 | "filename": file.filename, |
| 194 | "original": path, |
| 195 | "web": web_path, |
| 196 | "thumbnail": thumb_path, |
| 197 | "size": file.size |
| 198 | }) |
| 199 | |
| 200 | return {"url": web_path}</code></pre> |
| 201 | </div> |
| 202 | </div> |
| 203 | </div> |
| 204 | </div> |
| 205 | </div> |
| 206 | |
| 207 | <!-- Input Area --> |
| 208 | <div class="ai-chat-input"> |
| 209 | <div class="chat-suggestions"> |
| 210 | <button class="suggestion-chip">"Add comments to posts"</button> |
| 211 | <button class="suggestion-chip">"Create a contact form"</button> |
| 212 | <button class="suggestion-chip">"Add RSS feed"</button> |
| 213 | <button class="suggestion-chip">"Set up email notifications"</button> |
| 214 | </div> |
| 215 | <div class="chat-input-row"> |
| 216 | <textarea placeholder="Describe what you want to build..." rows="2"></textarea> |
| 217 | <button class="btn-primary btn-send"> |
| 218 | <span>Send</span> |
| 219 | <span class="keyboard-hint">⌘↵</span> |
| 220 | </button> |
| 221 | </div> |
| 222 | <div class="chat-input-footer"> |
| 223 | <div class="chat-context"> |
| 224 | Context: <span class="context-badge">Full project</span> |
| 225 | </div> |
| 226 | <div class="chat-tips"> |
| 227 | 💡 Tip: Be specific for better results |
| 228 | </div> |
| 229 | </div> |
| 230 | </div> |
| 231 | </div> |
| 232 | </main> |
| 233 | |
| 234 | <!-- Context Sidebar --> |
| 235 | <aside class="ai-assistant context-sidebar"> |
| 236 | <div class="ai-header"> |
| 237 | <span class="ai-icon">📋</span> |
| 238 | <span class="ai-title">Context</span> |
| 239 | <button class="ai-toggle">−</button> |
| 240 | </div> |
| 241 | |
| 242 | <div class="ai-content"> |
| 243 | <div class="context-section"> |
| 244 | <h3>Project Info</h3> |
| 245 | <div class="context-item"> |
| 246 | <span class="context-label">Name</span> |
| 247 | <span class="context-value">myblog</span> |
| 248 | </div> |
| 249 | <div class="context-item"> |
| 250 | <span class="context-label">Framework</span> |
| 251 | <span class="context-value">DBBASIC 0.1.0</span> |
| 252 | </div> |
| 253 | <div class="context-item"> |
| 254 | <span class="context-label">Python</span> |
| 255 | <span class="context-value">3.12</span> |
| 256 | </div> |
| 257 | </div> |
| 258 | |
| 259 | <div class="context-section"> |
| 260 | <h3>Database Tables</h3> |
| 261 | <div class="context-list"> |
| 262 | <div class="context-list-item"> |
| 263 | <span class="context-icon">📝</span> |
| 264 | <span>posts.tsv (145 rows)</span> |
| 265 | </div> |
| 266 | <div class="context-list-item"> |
| 267 | <span class="context-icon">👥</span> |
| 268 | <span>users.tsv (23 rows)</span> |
| 269 | </div> |
| 270 | <div class="context-list-item"> |
| 271 | <span class="context-icon">💬</span> |
| 272 | <span>comments.tsv (892 rows)</span> |
| 273 | </div> |
| 274 | <div class="context-list-item"> |
| 275 | <span class="context-icon">🖼️</span> |
| 276 | <span>uploads.tsv (67 rows)</span> |
| 277 | </div> |
| 278 | </div> |
| 279 | </div> |
| 280 | |
| 281 | <div class="context-section"> |
| 282 | <h3>Recent Changes</h3> |
| 283 | <div class="context-timeline"> |
| 284 | <div class="timeline-item"> |
| 285 | <div class="timeline-icon">✅</div> |
| 286 | <div class="timeline-content"> |
| 287 | <div class="timeline-title">Image uploads added</div> |
| 288 | <div class="timeline-time">Just now</div> |
| 289 | </div> |
| 290 | </div> |
| 291 | <div class="timeline-item"> |
| 292 | <div class="timeline-icon">📝</div> |
| 293 | <div class="timeline-content"> |
| 294 | <div class="timeline-title">Post created</div> |
| 295 | <div class="timeline-time">2 hours ago</div> |
| 296 | </div> |
| 297 | </div> |
| 298 | <div class="timeline-item"> |
| 299 | <div class="timeline-icon">🚀</div> |
| 300 | <div class="timeline-content"> |
| 301 | <div class="timeline-title">Deployed v1.2.3</div> |
| 302 | <div class="timeline-time">1 day ago</div> |
| 303 | </div> |
| 304 | </div> |
| 305 | </div> |
| 306 | </div> |
| 307 | |
| 308 | <div class="context-section"> |
| 309 | <h3>AI Settings</h3> |
| 310 | <div class="context-settings"> |
| 311 | <label class="checkbox-label"> |
| 312 | <input type="checkbox" checked> |
| 313 | <span>Auto-apply changes</span> |
| 314 | </label> |
| 315 | <label class="checkbox-label"> |
| 316 | <input type="checkbox" checked> |
| 317 | <span>Show code previews</span> |
| 318 | </label> |
| 319 | <label class="checkbox-label"> |
| 320 | <input type="checkbox"> |
| 321 | <span>Verbose explanations</span> |
| 322 | </label> |
| 323 | </div> |
| 324 | </div> |
| 325 | </div> |
| 326 | </aside> |
| 327 | </div> |
| 328 | </div> |
| 329 | </body> |
| 330 | </html> |