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
logs.html · 23.0 KB · 595 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>Logs - 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 active">
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">
57 <div class="content-header">
58 <div>
59 <h1>Logs</h1>
60 <div class="breadcrumb">Home / Logs</div>
61 </div>
62 <div class="header-actions">
63 <button class="btn-secondary">⬇️ Download</button>
64 <button class="btn-secondary">🗑️ Clear Old</button>
65 </div>
66 </div>
67
68 <!-- Log Filters -->
69 <div class="card filters-card">
70 <div class="filters-row">
71 <select class="filter-select">
72 <option>All Levels</option>
73 <option>Error</option>
74 <option>Warning</option>
75 <option>Info</option>
76 <option>Debug</option>
77 </select>
78 <select class="filter-select">
79 <option>All Sources</option>
80 <option>Application</option>
81 <option>Database</option>
82 <option>HTTP</option>
83 <option>System</option>
84 </select>
85 <input type="search" placeholder="Search logs..." class="search-input">
86 <input type="datetime-local" class="filter-select" placeholder="From">
87 <input type="datetime-local" class="filter-select" placeholder="To">
88 <button class="btn-primary">Filter</button>
89 </div>
90 </div>
91
92 <!-- Live Logs -->
93 <div class="card">
94 <div class="log-header">
95 <div>
96 <h2>Live Logs</h2>
97 <div class="log-meta">Last updated: Just now • Auto-refresh: ON</div>
98 </div>
99 <div class="log-controls">
100 <button class="btn-icon" title="Pause">⏸️</button>
101 <button class="btn-icon" title="Clear">🗑️</button>
102 <button class="btn-icon" title="Settings">⚙️</button>
103 </div>
104 </div>
105
106 <div class="log-viewer">
107 <div class="log-entry log-info">
108 <div class="log-time">2025-01-15 14:23:45</div>
109 <div class="log-level log-level-info">INFO</div>
110 <div class="log-source">HTTP</div>
111 <div class="log-message">
112 <span class="log-method">GET</span>
113 <span class="log-path">/admin/posts</span>
114 <span class="log-status status-200">200</span>
115 <span class="log-duration">12ms</span>
116 </div>
117 </div>
118
119 <div class="log-entry log-info">
120 <div class="log-time">2025-01-15 14:23:42</div>
121 <div class="log-level log-level-info">INFO</div>
122 <div class="log-source">DB</div>
123 <div class="log-message">
124 Query: SELECT * FROM posts WHERE published = true
125 <span class="log-meta">• 145 rows • 3ms</span>
126 </div>
127 </div>
128
129 <div class="log-entry log-warning">
130 <div class="log-time">2025-01-15 14:23:30</div>
131 <div class="log-level log-level-warning">WARN</div>
132 <div class="log-source">APP</div>
133 <div class="log-message">
134 Slow query detected: /api/search
135 <span class="log-meta">• 892ms</span>
136 </div>
137 </div>
138
139 <div class="log-entry log-info">
140 <div class="log-time">2025-01-15 14:23:15</div>
141 <div class="log-level log-level-info">INFO</div>
142 <div class="log-source">HTTP</div>
143 <div class="log-message">
144 <span class="log-method">POST</span>
145 <span class="log-path">/admin/posts/123</span>
146 <span class="log-status status-200">200</span>
147 <span class="log-duration">45ms</span>
148 </div>
149 </div>
150
151 <div class="log-entry log-error">
152 <div class="log-time">2025-01-15 14:22:58</div>
153 <div class="log-level log-level-error">ERROR</div>
154 <div class="log-source">APP</div>
155 <div class="log-message">
156 Failed to upload image: disk quota exceeded
157 <details class="log-details">
158 <summary>Stack trace</summary>
159 <pre>File "/usr/local/lib/python3.12/site-packages/dbbasic/upload.py", line 42
160 upload.save(file, path)
161OSError: [Errno 28] No space left on device</pre>
162 </details>
163 </div>
164 </div>
165
166 <div class="log-entry log-info">
167 <div class="log-time">2025-01-15 14:22:45</div>
168 <div class="log-level log-level-info">INFO</div>
169 <div class="log-source">SYS</div>
170 <div class="log-message">
171 Background job started: resize_images
172 <span class="log-meta">• PID: 12345</span>
173 </div>
174 </div>
175
176 <div class="log-entry log-debug">
177 <div class="log-time">2025-01-15 14:22:30</div>
178 <div class="log-level log-level-debug">DEBUG</div>
179 <div class="log-source">APP</div>
180 <div class="log-message">
181 Cache hit: posts_list_page_1
182 <span class="log-meta">• 0.2ms</span>
183 </div>
184 </div>
185
186 <div class="log-entry log-info">
187 <div class="log-time">2025-01-15 14:22:15</div>
188 <div class="log-level log-level-info">INFO</div>
189 <div class="log-source">HTTP</div>
190 <div class="log-message">
191 <span class="log-method">GET</span>
192 <span class="log-path">/blog/getting-started</span>
193 <span class="log-status status-200">200</span>
194 <span class="log-duration">8ms</span>
195 </div>
196 </div>
197
198 <div class="log-entry log-info">
199 <div class="log-time">2025-01-15 14:21:52</div>
200 <div class="log-level log-level-info">INFO</div>
201 <div class="log-source">AUTH</div>
202 <div class="log-message">
203 User logged in: john@example.com
204 <span class="log-meta">• Session: abc123</span>
205 </div>
206 </div>
207
208 <div class="log-entry log-warning">
209 <div class="log-time">2025-01-15 14:21:30</div>
210 <div class="log-level log-level-warning">WARN</div>
211 <div class="log-source">AUTH</div>
212 <div class="log-message">
213 Failed login attempt: admin@example.com
214 <span class="log-meta">• IP: 192.168.1.100</span>
215 </div>
216 </div>
217 </div>
218
219 <div class="log-footer">
220 <div class="log-stats">
221 Showing last 100 entries • 2,456 total today
222 </div>
223 <button class="btn-secondary">Load More</button>
224 </div>
225 </div>
226
227 <!-- Log Statistics -->
228 <div class="card">
229 <h2>Statistics (Last 24 Hours)</h2>
230 <div class="stats-grid">
231 <div class="stat-item">
232 <div class="stat-label">Total Requests</div>
233 <div class="stat-number">12,456</div>
234 </div>
235 <div class="stat-item">
236 <div class="stat-label">Errors</div>
237 <div class="stat-number" style="color: var(--color-danger)">23</div>
238 </div>
239 <div class="stat-item">
240 <div class="stat-label">Warnings</div>
241 <div class="stat-number" style="color: var(--color-warning)">145</div>
242 </div>
243 <div class="stat-item">
244 <div class="stat-label">Avg Response</div>
245 <div class="stat-number">24ms</div>
246 </div>
247 </div>
248 </div>
249
250 <!-- Quick Commands -->
251 <div class="card">
252 <h2>Quick Commands</h2>
253 <div class="command-grid">
254 <div class="command-item">
255 <div class="command-title">View Error Logs</div>
256 <code class="command-code">grep "ERROR" data/logs/app.log</code>
257 <button class="btn-secondary-small">Copy</button>
258 </div>
259 <div class="command-item">
260 <div class="command-title">Tail Live Logs</div>
261 <code class="command-code">tail -f data/logs/app.log</code>
262 <button class="btn-secondary-small">Copy</button>
263 </div>
264 <div class="command-item">
265 <div class="command-title">Count by Level</div>
266 <code class="command-code">cut -f2 data/logs/app.log | sort | uniq -c</code>
267 <button class="btn-secondary-small">Copy</button>
268 </div>
269 <div class="command-item">
270 <div class="command-title">Find Slow Requests</div>
271 <code class="command-code">awk -F'\t' '$5 > 1000' data/logs/http.log</code>
272 <button class="btn-secondary-small">Copy</button>
273 </div>
274 </div>
275 </div>
276
277 <!-- Log Files -->
278 <div class="card">
279 <h2>Log Files</h2>
280 <div class="file-list">
281 <div class="file-item">
282 <div class="file-icon">📄</div>
283 <div class="file-info">
284 <div class="file-name">data/logs/app.log</div>
285 <div class="file-meta">Application logs • 4.2 MB • Updated 1s ago</div>
286 </div>
287 <div class="file-actions">
288 <button class="btn-secondary-small">View</button>
289 <button class="btn-secondary-small">Download</button>
290 </div>
291 </div>
292
293 <div class="file-item">
294 <div class="file-icon">📄</div>
295 <div class="file-info">
296 <div class="file-name">data/logs/http.log</div>
297 <div class="file-meta">HTTP access logs • 8.1 MB • Updated 1s ago</div>
298 </div>
299 <div class="file-actions">
300 <button class="btn-secondary-small">View</button>
301 <button class="btn-secondary-small">Download</button>
302 </div>
303 </div>
304
305 <div class="file-item">
306 <div class="file-icon">📄</div>
307 <div class="file-info">
308 <div class="file-name">data/logs/errors.log</div>
309 <div class="file-meta">Error logs only • 234 KB • Updated 5m ago</div>
310 </div>
311 <div class="file-actions">
312 <button class="btn-secondary-small">View</button>
313 <button class="btn-secondary-small">Download</button>
314 </div>
315 </div>
316
317 <div class="file-item">
318 <div class="file-icon">📄</div>
319 <div class="file-info">
320 <div class="file-name">data/logs/jobs.log</div>
321 <div class="file-meta">Background jobs • 1.2 MB • Updated 10m ago</div>
322 </div>
323 <div class="file-actions">
324 <button class="btn-secondary-small">View</button>
325 <button class="btn-secondary-small">Download</button>
326 </div>
327 </div>
328 </div>
329 </div>
330 </main>
331
332 <aside class="ai-assistant">
333 <div class="ai-header">
334 <span class="ai-icon">🤖</span>
335 <span class="ai-title">AI Assistant</span>
336 <button class="ai-toggle">−</button>
337 </div>
338
339 <div class="ai-content">
340 <div class="ai-messages">
341 <div class="ai-message ai-message-assistant">
342 <div class="message-content">
343 I can help you analyze logs, find errors, or set up monitoring. What would you like to do?
344 </div>
345 </div>
346 </div>
347
348 <div class="ai-suggestions">
349 <div class="suggestion-title">Try asking:</div>
350 <button class="suggestion-btn">"Show me all errors today"</button>
351 <button class="suggestion-btn">"Find slow requests"</button>
352 <button class="suggestion-btn">"Set up error alerts"</button>
353 </div>
354
355 <div class="ai-input">
356 <textarea placeholder="Ask AI about logs..." rows="3"></textarea>
357 <button class="btn-primary">Send</button>
358 </div>
359 </div>
360 </aside>
361 </div>
362 </div>
363
364 <style>
365 .log-header {
366 display: flex;
367 justify-content: space-between;
368 align-items: flex-start;
369 margin-bottom: 1rem;
370 }
371
372 .log-meta {
373 font-size: 0.75rem;
374 color: var(--color-text-muted);
375 margin-top: 0.25rem;
376 }
377
378 .log-controls {
379 display: flex;
380 gap: 0.5rem;
381 }
382
383 .log-viewer {
384 background: #0f172a;
385 color: #e2e8f0;
386 border-radius: 0.5rem;
387 padding: 1rem;
388 font-family: 'Monaco', 'Menlo', monospace;
389 font-size: 0.875rem;
390 max-height: 600px;
391 overflow-y: auto;
392 }
393
394 .log-entry {
395 display: grid;
396 grid-template-columns: 150px 80px 80px 1fr;
397 gap: 1rem;
398 padding: 0.5rem;
399 border-bottom: 1px solid #1e293b;
400 align-items: start;
401 }
402
403 .log-entry:last-child {
404 border-bottom: none;
405 }
406
407 .log-entry.log-error {
408 background: rgba(239, 68, 68, 0.1);
409 }
410
411 .log-entry.log-warning {
412 background: rgba(245, 158, 11, 0.1);
413 }
414
415 .log-time {
416 color: #64748b;
417 font-size: 0.75rem;
418 }
419
420 .log-level {
421 font-weight: 600;
422 font-size: 0.75rem;
423 text-align: center;
424 padding: 0.125rem 0.5rem;
425 border-radius: 0.25rem;
426 }
427
428 .log-level-info {
429 background: rgba(59, 130, 246, 0.2);
430 color: #60a5fa;
431 }
432
433 .log-level-warning {
434 background: rgba(245, 158, 11, 0.2);
435 color: #fbbf24;
436 }
437
438 .log-level-error {
439 background: rgba(239, 68, 68, 0.2);
440 color: #f87171;
441 }
442
443 .log-level-debug {
444 background: rgba(100, 116, 139, 0.2);
445 color: #94a3b8;
446 }
447
448 .log-source {
449 color: #94a3b8;
450 font-size: 0.75rem;
451 }
452
453 .log-message {
454 color: #e2e8f0;
455 line-height: 1.6;
456 }
457
458 .log-method {
459 font-weight: 600;
460 color: #60a5fa;
461 }
462
463 .log-path {
464 color: #e2e8f0;
465 }
466
467 .log-status {
468 padding: 0.125rem 0.375rem;
469 border-radius: 0.25rem;
470 font-weight: 600;
471 font-size: 0.75rem;
472 }
473
474 .status-200 {
475 background: rgba(16, 185, 129, 0.2);
476 color: #34d399;
477 }
478
479 .log-duration {
480 color: #64748b;
481 font-size: 0.75rem;
482 }
483
484 .log-meta {
485 color: #64748b;
486 font-size: 0.75rem;
487 }
488
489 .log-details {
490 margin-top: 0.5rem;
491 }
492
493 .log-details summary {
494 cursor: pointer;
495 color: #60a5fa;
496 font-size: 0.75rem;
497 }
498
499 .log-details pre {
500 background: #1e293b;
501 padding: 0.5rem;
502 border-radius: 0.25rem;
503 margin-top: 0.5rem;
504 font-size: 0.75rem;
505 overflow-x: auto;
506 }
507
508 .log-footer {
509 display: flex;
510 justify-content: space-between;
511 align-items: center;
512 margin-top: 1rem;
513 padding-top: 1rem;
514 border-top: 1px solid var(--color-border);
515 }
516
517 .log-stats {
518 font-size: 0.875rem;
519 color: var(--color-text-muted);
520 }
521
522 .command-grid {
523 display: grid;
524 grid-template-columns: repeat(2, 1fr);
525 gap: 1rem;
526 }
527
528 .command-item {
529 background: var(--color-bg);
530 border: 1px solid var(--color-border);
531 border-radius: 0.5rem;
532 padding: 1rem;
533 }
534
535 .command-title {
536 font-weight: 500;
537 margin-bottom: 0.5rem;
538 }
539
540 .command-code {
541 display: block;
542 background: #1e293b;
543 color: #e2e8f0;
544 padding: 0.5rem;
545 border-radius: 0.25rem;
546 font-family: monospace;
547 font-size: 0.75rem;
548 margin-bottom: 0.5rem;
549 overflow-x: auto;
550 white-space: nowrap;
551 }
552
553 .file-list {
554 display: flex;
555 flex-direction: column;
556 gap: 0.75rem;
557 }
558
559 .file-item {
560 display: flex;
561 align-items: center;
562 gap: 1rem;
563 padding: 1rem;
564 background: var(--color-bg);
565 border: 1px solid var(--color-border);
566 border-radius: 0.5rem;
567 }
568
569 .file-icon {
570 font-size: 1.5rem;
571 }
572
573 .file-info {
574 flex: 1;
575 }
576
577 .file-name {
578 font-weight: 500;
579 font-family: monospace;
580 font-size: 0.875rem;
581 }
582
583 .file-meta {
584 font-size: 0.75rem;
585 color: var(--color-text-muted);
586 margin-top: 0.25rem;
587 }
588
589 .file-actions {
590 display: flex;
591 gap: 0.5rem;
592 }
593 </style>
594</body>
595</html>