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
code.html · 27.7 KB · 687 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>Code - 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="code.html" class="nav-item active">
30 <span class="nav-icon">💻</span>
31 <span class="nav-label">Code</span>
32 </a>
33 <a href="database.html" class="nav-item">
34 <span class="nav-icon">🗄️</span>
35 <span class="nav-label">Database</span>
36 </a>
37 <a href="posts/list.html" class="nav-item">
38 <span class="nav-icon">📝</span>
39 <span class="nav-label">Posts</span>
40 </a>
41 <a href="users/list.html" class="nav-item">
42 <span class="nav-icon">👥</span>
43 <span class="nav-label">Users</span>
44 </a>
45 <div class="nav-divider"></div>
46 <a href="jobs.html" class="nav-item">
47 <span class="nav-icon">⏰</span>
48 <span class="nav-label">Jobs</span>
49 </a>
50 <a href="logs.html" class="nav-item">
51 <span class="nav-icon">📋</span>
52 <span class="nav-label">Logs</span>
53 </a>
54 <a href="deploy.html" class="nav-item">
55 <span class="nav-icon">🚀</span>
56 <span class="nav-label">Deploy</span>
57 </a>
58 </nav>
59
60 <main class="main-content code-main">
61 <div class="content-header">
62 <div>
63 <h1>Code & Files</h1>
64 <div class="breadcrumb">Home / Code</div>
65 </div>
66 <div class="header-actions">
67 <button class="btn-secondary">🔍 Search Files</button>
68 <button class="btn-primary">+ New File</button>
69 </div>
70 </div>
71
72 <div class="code-layout">
73 <!-- File Tree -->
74 <div class="file-tree">
75 <div class="file-tree-header">
76 <h3>Project Files</h3>
77 <button class="btn-icon" title="Collapse All">⊟</button>
78 </div>
79
80 <div class="tree-container">
81 <div class="tree-folder expanded">
82 <div class="tree-item folder-item">
83 <span class="tree-icon">📁</span>
84 <span class="tree-label">routes/</span>
85 </div>
86 <div class="tree-children">
87 <div class="tree-folder expanded">
88 <div class="tree-item folder-item">
89 <span class="tree-icon">📁</span>
90 <span class="tree-label">admin/</span>
91 </div>
92 <div class="tree-children">
93 <div class="tree-item file-item active">
94 <span class="tree-icon">🐍</span>
95 <span class="tree-label">posts.py</span>
96 </div>
97 <div class="tree-item file-item">
98 <span class="tree-icon">🐍</span>
99 <span class="tree-label">users.py</span>
100 </div>
101 <div class="tree-item file-item">
102 <span class="tree-icon">🐍</span>
103 <span class="tree-label">upload.py</span>
104 </div>
105 </div>
106 </div>
107 <div class="tree-item file-item">
108 <span class="tree-icon">🐍</span>
109 <span class="tree-label">api.py</span>
110 </div>
111 <div class="tree-item file-item">
112 <span class="tree-icon">🐍</span>
113 <span class="tree-label">main.py</span>
114 </div>
115 </div>
116 </div>
117
118 <div class="tree-folder expanded">
119 <div class="tree-item folder-item">
120 <span class="tree-icon">📁</span>
121 <span class="tree-label">templates/</span>
122 </div>
123 <div class="tree-children">
124 <div class="tree-folder">
125 <div class="tree-item folder-item">
126 <span class="tree-icon">📁</span>
127 <span class="tree-label">admin/</span>
128 </div>
129 </div>
130 <div class="tree-folder">
131 <div class="tree-item folder-item">
132 <span class="tree-icon">📁</span>
133 <span class="tree-label">blog/</span>
134 </div>
135 </div>
136 <div class="tree-item file-item">
137 <span class="tree-icon">📄</span>
138 <span class="tree-label">base.html</span>
139 </div>
140 </div>
141 </div>
142
143 <div class="tree-folder">
144 <div class="tree-item folder-item">
145 <span class="tree-icon">📁</span>
146 <span class="tree-label">data/</span>
147 </div>
148 <div class="tree-children">
149 <div class="tree-item file-item">
150 <span class="tree-icon">📊</span>
151 <span class="tree-label">posts.tsv</span>
152 </div>
153 <div class="tree-item file-item">
154 <span class="tree-icon">📊</span>
155 <span class="tree-label">users.tsv</span>
156 </div>
157 <div class="tree-item file-item">
158 <span class="tree-icon">📊</span>
159 <span class="tree-label">comments.tsv</span>
160 </div>
161 </div>
162 </div>
163
164 <div class="tree-folder">
165 <div class="tree-item folder-item">
166 <span class="tree-icon">📁</span>
167 <span class="tree-label">static/</span>
168 </div>
169 </div>
170
171 <div class="tree-folder">
172 <div class="tree-item folder-item">
173 <span class="tree-icon">📁</span>
174 <span class="tree-label">jobs/</span>
175 </div>
176 </div>
177
178 <div class="tree-item file-item">
179 <span class="tree-icon">⚙️</span>
180 <span class="tree-label">config.py</span>
181 </div>
182
183 <div class="tree-item file-item">
184 <span class="tree-icon">📄</span>
185 <span class="tree-label">requirements.txt</span>
186 </div>
187
188 <div class="tree-item file-item">
189 <span class="tree-icon">📄</span>
190 <span class="tree-label">README.md</span>
191 </div>
192 </div>
193 </div>
194
195 <!-- Code Editor -->
196 <div class="code-editor">
197 <div class="editor-tabs">
198 <div class="editor-tab active">
199 <span class="tab-icon">🐍</span>
200 <span class="tab-label">routes/admin/posts.py</span>
201 <button class="tab-close">×</button>
202 </div>
203 <div class="editor-tab">
204 <span class="tab-icon">🐍</span>
205 <span class="tab-label">routes/main.py</span>
206 <button class="tab-close">×</button>
207 </div>
208 </div>
209
210 <div class="editor-content">
211 <div class="editor-toolbar">
212 <div class="editor-path">
213 routes/admin/posts.py
214 </div>
215 <div class="editor-actions">
216 <button class="btn-icon-small" title="Format Code">✨</button>
217 <button class="btn-icon-small" title="Find">🔍</button>
218 <button class="btn-icon-small" title="Run">▶️</button>
219 <button class="btn-primary-small">Save</button>
220 </div>
221 </div>
222
223 <div class="code-view">
224 <div class="line-numbers">
225 <div class="line-number">1</div>
226 <div class="line-number">2</div>
227 <div class="line-number">3</div>
228 <div class="line-number">4</div>
229 <div class="line-number">5</div>
230 <div class="line-number">6</div>
231 <div class="line-number">7</div>
232 <div class="line-number">8</div>
233 <div class="line-number">9</div>
234 <div class="line-number">10</div>
235 <div class="line-number">11</div>
236 <div class="line-number">12</div>
237 <div class="line-number">13</div>
238 <div class="line-number">14</div>
239 <div class="line-number">15</div>
240 <div class="line-number">16</div>
241 <div class="line-number">17</div>
242 <div class="line-number">18</div>
243 <div class="line-number">19</div>
244 <div class="line-number">20</div>
245 <div class="line-number">21</div>
246 <div class="line-number">22</div>
247 <div class="line-number">23</div>
248 <div class="line-number">24</div>
249 <div class="line-number">25</div>
250 <div class="line-number">26</div>
251 <div class="line-number">27</div>
252 <div class="line-number">28</div>
253 <div class="line-number">29</div>
254 <div class="line-number">30</div>
255 </div>
256
257 <pre class="code-content"><code><span class="keyword">from</span> dbbasic <span class="keyword">import</span> router, tsv, render
258<span class="keyword">from</span> datetime <span class="keyword">import</span> datetime
259
260<span class="comment"># Posts Admin Routes</span>
261<span class="comment"># AI-generated admin interface for posts management</span>
262
263<span class="decorator">@router.get</span>(<span class="string">"/admin/posts"</span>)
264<span class="keyword">def</span> <span class="function">list_posts</span>():
265 <span class="string">"""List all posts with pagination"""</span>
266 posts = tsv.<span class="function">query</span>(
267 <span class="string">"posts"</span>,
268 order_by=<span class="string">"created_at DESC"</span>,
269 limit=<span class="number">50</span>
270 )
271 <span class="keyword">return</span> <span class="function">render</span>(<span class="string">"admin/posts/list.html"</span>, posts=posts)
272
273
274<span class="decorator">@router.get</span>(<span class="string">"/admin/posts/:id"</span>)
275<span class="keyword">def</span> <span class="function">edit_post</span>(id: <span class="type">str</span>):
276 <span class="string">"""Edit a single post"""</span>
277 post = tsv.<span class="function">get</span>(<span class="string">"posts"</span>, id)
278 <span class="keyword">return</span> <span class="function">render</span>(<span class="string">"admin/posts/edit.html"</span>, post=post)
279
280
281<span class="decorator">@router.post</span>(<span class="string">"/admin/posts/:id"</span>)
282<span class="keyword">def</span> <span class="function">update_post</span>(id: <span class="type">str</span>, form: <span class="type">dict</span>):
283 <span class="string">"""Update post data"""</span>
284 tsv.<span class="function">update</span>(<span class="string">"posts"</span>, id, form)
285 <span class="keyword">return</span> <span class="function">redirect</span>(<span class="string">"/admin/posts"</span>)</code></pre>
286 </div>
287 </div>
288
289 <!-- File Info Panel -->
290 <div class="file-info-panel">
291 <div class="info-section">
292 <h4>File Info</h4>
293 <div class="info-grid">
294 <div class="info-item">
295 <span class="info-label">Type</span>
296 <span class="info-value">Python</span>
297 </div>
298 <div class="info-item">
299 <span class="info-label">Size</span>
300 <span class="info-value">1.2 KB</span>
301 </div>
302 <div class="info-item">
303 <span class="info-label">Lines</span>
304 <span class="info-value">30</span>
305 </div>
306 <div class="info-item">
307 <span class="info-label">Modified</span>
308 <span class="info-value">2h ago</span>
309 </div>
310 </div>
311 </div>
312
313 <div class="info-section">
314 <h4>Git Status</h4>
315 <div class="git-status-badge modified">
316 <span class="status-icon">M</span>
317 <span>Modified</span>
318 </div>
319 <div class="git-info">
320 <div>Last commit: 2 hours ago</div>
321 <div>By: John Doe</div>
322 </div>
323 </div>
324
325 <div class="info-section">
326 <h4>AI Analysis</h4>
327 <div class="ai-insights">
328 <div class="insight-item">
329 <span class="insight-icon">✓</span>
330 <span>Clean code structure</span>
331 </div>
332 <div class="insight-item">
333 <span class="insight-icon">✓</span>
334 <span>Good documentation</span>
335 </div>
336 <div class="insight-item warning">
337 <span class="insight-icon">⚠</span>
338 <span>Consider error handling</span>
339 </div>
340 </div>
341 <button class="btn-secondary-small">Ask AI to Improve</button>
342 </div>
343 </div>
344 </div>
345 </div>
346
347 <!-- Quick Actions -->
348 <div class="card">
349 <h2>Quick Actions</h2>
350 <div class="action-grid">
351 <button class="action-btn">
352 <span class="action-icon">🔍</span>
353 <span>Search in Files</span>
354 </button>
355 <button class="action-btn">
356 <span class="action-icon">📝</span>
357 <span>Create Route</span>
358 </button>
359 <button class="action-btn">
360 <span class="action-icon">🎨</span>
361 <span>Create Template</span>
362 </button>
363 <button class="action-btn">
364 <span class="action-icon">🔧</span>
365 <span>Run Tests</span>
366 </button>
367 </div>
368 </div>
369 </main>
370
371 <aside class="ai-assistant">
372 <div class="ai-header">
373 <span class="ai-icon">🤖</span>
374 <span class="ai-title">AI Assistant</span>
375 <button class="ai-toggle">−</button>
376 </div>
377
378 <div class="ai-content">
379 <div class="ai-messages">
380 <div class="ai-message ai-message-assistant">
381 <div class="message-content">
382 I can help you write code, refactor, add features, or explain what this file does. What would you like?
383 </div>
384 </div>
385 </div>
386
387 <div class="ai-suggestions">
388 <div class="suggestion-title">Try asking:</div>
389 <button class="suggestion-btn">"Add error handling"</button>
390 <button class="suggestion-btn">"Add pagination"</button>
391 <button class="suggestion-btn">"Explain this code"</button>
392 <button class="suggestion-btn">"Add input validation"</button>
393 </div>
394
395 <div class="ai-input">
396 <textarea placeholder="Ask AI about this code..." rows="3"></textarea>
397 <button class="btn-primary">Send</button>
398 </div>
399 </div>
400 </aside>
401 </div>
402 </div>
403
404 <style>
405 .code-main {
406 padding: 0;
407 }
408
409 .code-main .content-header {
410 padding: 2rem;
411 padding-bottom: 1rem;
412 }
413
414 .code-layout {
415 display: grid;
416 grid-template-columns: 250px 1fr;
417 height: calc(100vh - 180px);
418 }
419
420 .file-tree {
421 border-right: 1px solid var(--color-border);
422 background: var(--color-surface);
423 overflow-y: auto;
424 }
425
426 .file-tree-header {
427 display: flex;
428 justify-content: space-between;
429 align-items: center;
430 padding: 1rem;
431 border-bottom: 1px solid var(--color-border);
432 }
433
434 .file-tree-header h3 {
435 font-size: 0.875rem;
436 font-weight: 600;
437 margin: 0;
438 }
439
440 .tree-container {
441 padding: 0.5rem;
442 }
443
444 .tree-folder {
445 margin-bottom: 0.25rem;
446 }
447
448 .tree-item {
449 display: flex;
450 align-items: center;
451 gap: 0.5rem;
452 padding: 0.375rem 0.5rem;
453 cursor: pointer;
454 border-radius: 0.25rem;
455 font-size: 0.875rem;
456 }
457
458 .tree-item:hover {
459 background: var(--color-bg);
460 }
461
462 .tree-item.active {
463 background: var(--color-primary);
464 color: white;
465 }
466
467 .tree-icon {
468 font-size: 1rem;
469 }
470
471 .tree-children {
472 padding-left: 1rem;
473 }
474
475 .code-editor {
476 display: flex;
477 flex-direction: column;
478 background: var(--color-surface);
479 }
480
481 .editor-tabs {
482 display: flex;
483 gap: 0.25rem;
484 padding: 0.5rem;
485 background: var(--color-bg);
486 border-bottom: 1px solid var(--color-border);
487 overflow-x: auto;
488 }
489
490 .editor-tab {
491 display: flex;
492 align-items: center;
493 gap: 0.5rem;
494 padding: 0.5rem 1rem;
495 background: var(--color-surface);
496 border: 1px solid var(--color-border);
497 border-radius: 0.375rem 0.375rem 0 0;
498 cursor: pointer;
499 font-size: 0.875rem;
500 }
501
502 .editor-tab.active {
503 background: var(--color-surface);
504 border-bottom-color: var(--color-surface);
505 }
506
507 .tab-close {
508 background: none;
509 border: none;
510 cursor: pointer;
511 color: var(--color-text-muted);
512 font-size: 1.25rem;
513 line-height: 1;
514 padding: 0;
515 }
516
517 .tab-close:hover {
518 color: var(--color-danger);
519 }
520
521 .editor-content {
522 flex: 1;
523 display: flex;
524 flex-direction: column;
525 overflow: hidden;
526 }
527
528 .editor-toolbar {
529 display: flex;
530 justify-content: space-between;
531 align-items: center;
532 padding: 0.75rem 1rem;
533 background: var(--color-bg);
534 border-bottom: 1px solid var(--color-border);
535 }
536
537 .editor-path {
538 font-size: 0.875rem;
539 color: var(--color-text-muted);
540 font-family: monospace;
541 }
542
543 .editor-actions {
544 display: flex;
545 gap: 0.5rem;
546 align-items: center;
547 }
548
549 .code-view {
550 flex: 1;
551 display: flex;
552 overflow: auto;
553 background: #0f172a;
554 }
555
556 .line-numbers {
557 padding: 1rem 0.5rem;
558 background: #1e293b;
559 color: #64748b;
560 text-align: right;
561 font-family: 'Monaco', 'Menlo', monospace;
562 font-size: 0.875rem;
563 line-height: 1.6;
564 user-select: none;
565 border-right: 1px solid #334155;
566 }
567
568 .line-number {
569 padding: 0 0.5rem;
570 }
571
572 .code-content {
573 flex: 1;
574 padding: 1rem;
575 margin: 0;
576 color: #e2e8f0;
577 font-family: 'Monaco', 'Menlo', monospace;
578 font-size: 0.875rem;
579 line-height: 1.6;
580 overflow-x: auto;
581 }
582
583 .code-content code {
584 background: none;
585 padding: 0;
586 }
587
588 .keyword { color: #c792ea; }
589 .function { color: #82aaff; }
590 .string { color: #c3e88d; }
591 .number { color: #f78c6c; }
592 .comment { color: #676e95; font-style: italic; }
593 .decorator { color: #89ddff; }
594 .type { color: #ffcb6b; }
595
596 .file-info-panel {
597 padding: 1rem;
598 background: var(--color-bg);
599 border-top: 1px solid var(--color-border);
600 }
601
602 .info-section {
603 margin-bottom: 1.5rem;
604 }
605
606 .info-section:last-child {
607 margin-bottom: 0;
608 }
609
610 .info-section h4 {
611 font-size: 0.875rem;
612 font-weight: 600;
613 margin-bottom: 0.75rem;
614 }
615
616 .info-grid {
617 display: grid;
618 grid-template-columns: repeat(2, 1fr);
619 gap: 0.75rem;
620 }
621
622 .info-item {
623 display: flex;
624 flex-direction: column;
625 gap: 0.25rem;
626 }
627
628 .info-label {
629 font-size: 0.75rem;
630 color: var(--color-text-muted);
631 }
632
633 .info-value {
634 font-weight: 500;
635 font-size: 0.875rem;
636 }
637
638 .git-status-badge {
639 display: inline-flex;
640 align-items: center;
641 gap: 0.5rem;
642 padding: 0.375rem 0.75rem;
643 background: #fef3c7;
644 color: #92400e;
645 border-radius: 0.25rem;
646 font-size: 0.75rem;
647 font-weight: 600;
648 margin-bottom: 0.5rem;
649 }
650
651 .git-status-badge.modified {
652 background: #fef3c7;
653 color: #92400e;
654 }
655
656 .git-info {
657 font-size: 0.75rem;
658 color: var(--color-text-muted);
659 display: flex;
660 flex-direction: column;
661 gap: 0.25rem;
662 }
663
664 .ai-insights {
665 display: flex;
666 flex-direction: column;
667 gap: 0.5rem;
668 margin-bottom: 0.75rem;
669 }
670
671 .insight-item {
672 display: flex;
673 align-items: center;
674 gap: 0.5rem;
675 font-size: 0.875rem;
676 }
677
678 .insight-item.warning {
679 color: var(--color-warning);
680 }
681
682 .insight-icon {
683 font-size: 1rem;
684 }
685 </style>
686</body>
687</html>