An admin interface that builds itself from the dbbasic modules you install; its pages follow file paths, like CGI.

0 downloads

Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-admin.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-admin.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-admin.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

danq9 Add automatic TSV discovery and admin handlers 5e2fd8f 1 year, 1 month ago History
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
175from PIL import Image
176
177@router.post("/admin/upload")
178def 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>