1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
|
"""
PodcastItLater Admin Handlers.
Route handlers for admin actions.
"""
# : out podcastitlater-admin-handlers
# : dep ludic
# : dep starlette
import Biz.PodcastItLater.Admin.Views as Views
import Biz.PodcastItLater.Core as Core
import ludic.html as html
from ludic.web import Request
from ludic.web.datastructures import FormData
from ludic.web.responses import Response
def admin_queue_status(
request: Request,
) -> Views.AdminView | Response | html.div:
"""Return admin view showing all queue items and episodes."""
# Check if user is logged in
user_id = request.session.get("user_id")
if not user_id:
# Redirect to login
return Response(
"",
status_code=302,
headers={"Location": "/"},
)
user = Core.Database.get_user_by_id(
user_id,
)
if not user:
# Invalid session
return Response(
"",
status_code=302,
headers={"Location": "/"},
)
# Check if user is admin
if not Core.is_admin(user):
# Forbidden - redirect to home with error
return Response(
"",
status_code=302,
headers={"Location": "/?error=forbidden"},
)
# Admins can see all data (excluding completed items)
all_queue_items = [
item
for item in Core.Database.get_all_queue_items(None)
if item.get("status") != "completed"
]
all_episodes = Core.Database.get_all_episodes(
None,
)
# Get overall status counts for all users
status_counts: dict[str, int] = {}
for item in all_queue_items:
status = item.get("status", "unknown")
status_counts[status] = status_counts.get(status, 0) + 1
# Check if this is an HTMX request for auto-update
if request.headers.get("HX-Request") == "true":
# Return just the content div for HTMX updates
content = Views.AdminView.render_content(
all_queue_items,
all_episodes,
status_counts,
)
return html.div(
content,
hx_get="/admin",
hx_trigger="every 10s",
hx_swap="innerHTML",
)
return Views.AdminView(
queue_items=all_queue_items,
episodes=all_episodes,
status_counts=status_counts,
user=user,
)
def retry_queue_item(request: Request, job_id: int) -> Response:
"""Retry a failed queue item."""
try:
# Check if user owns this job or is admin
user_id = request.session.get("user_id")
if not user_id:
return Response("Unauthorized", status_code=401)
job = Core.Database.get_job_by_id(
job_id,
)
if job is None:
return Response("Job not found", status_code=404)
# Check ownership or admin status
user = Core.Database.get_user_by_id(user_id)
if job.get("user_id") != user_id and not Core.is_admin(user):
return Response("Forbidden", status_code=403)
Core.Database.retry_job(job_id)
# Check if request is from admin page via referer header
is_from_admin = "/admin" in request.headers.get("referer", "")
# Redirect to admin if from admin page, trigger update otherwise
if is_from_admin:
return Response(
"",
status_code=200,
headers={"HX-Redirect": "/admin"},
)
return Response(
"",
status_code=200,
headers={"HX-Trigger": "queue-updated"},
)
except (ValueError, KeyError) as e:
return Response(
f"Error retrying job: {e!s}",
status_code=500,
)
def delete_queue_item(request: Request, job_id: int) -> Response:
"""Delete a queue item."""
try:
# Check if user owns this job or is admin
user_id = request.session.get("user_id")
if not user_id:
return Response("Unauthorized", status_code=401)
job = Core.Database.get_job_by_id(
job_id,
)
if job is None:
return Response("Job not found", status_code=404)
# Check ownership or admin status
user = Core.Database.get_user_by_id(user_id)
if job.get("user_id") != user_id and not Core.is_admin(user):
return Response("Forbidden", status_code=403)
Core.Database.delete_job(job_id)
# Check if request is from admin page via referer header
is_from_admin = "/admin" in request.headers.get("referer", "")
# Redirect to admin if from admin page, trigger update otherwise
if is_from_admin:
return Response(
"",
status_code=200,
headers={"HX-Redirect": "/admin"},
)
return Response(
"",
status_code=200,
headers={"HX-Trigger": "queue-updated"},
)
except (ValueError, KeyError) as e:
return Response(
f"Error deleting job: {e!s}",
status_code=500,
)
def admin_users(request: Request) -> Views.AdminUsers | Response:
"""Admin page for managing users."""
# Check if user is logged in and is admin
user_id = request.session.get("user_id")
if not user_id:
return Response(
"",
status_code=302,
headers={"Location": "/"},
)
user = Core.Database.get_user_by_id(
user_id,
)
if not user or not Core.is_admin(user):
return Response(
"",
status_code=302,
headers={"Location": "/?error=forbidden"},
)
# Get all users
with Core.Database.get_connection() as conn:
cursor = conn.cursor()
cursor.execute(
"SELECT id, email, created_at, status FROM users "
"ORDER BY created_at DESC",
)
rows = cursor.fetchall()
users = [dict(row) for row in rows]
return Views.AdminUsers(users=users, user=user)
def update_user_status(
request: Request,
user_id: int,
data: FormData,
) -> Response:
"""Update user account status."""
# Check if user is logged in and is admin
session_user_id = request.session.get("user_id")
if not session_user_id:
return Response("Unauthorized", status_code=401)
user = Core.Database.get_user_by_id(
session_user_id,
)
if not user or not Core.is_admin(user):
return Response("Forbidden", status_code=403)
# Get new status from form data
new_status_raw = data.get("status", "pending")
new_status = (
new_status_raw if isinstance(new_status_raw, str) else "pending"
)
if new_status not in {"pending", "active", "disabled"}:
return Response("Invalid status", status_code=400)
# Update user status
Core.Database.update_user_status(
user_id,
new_status,
)
# Redirect back to users page
return Response(
"",
status_code=200,
headers={"HX-Redirect": "/admin/users"},
)
def toggle_episode_public(request: Request, episode_id: int) -> Response:
"""Toggle episode public/private status."""
# Check if user is logged in and is admin
session_user_id = request.session.get("user_id")
if not session_user_id:
return Response("Unauthorized", status_code=401)
user = Core.Database.get_user_by_id(
session_user_id,
)
if not user or not Core.is_admin(user):
return Response("Forbidden", status_code=403)
# Toggle the episode public status
Core.Database.toggle_episode_public(episode_id)
# Redirect back to admin
return Response(
"",
status_code=200,
headers={"HX-Redirect": "/admin"},
)
def admin_metrics(request: Request) -> Views.MetricsDashboard | Response:
"""Admin metrics dashboard."""
# Check if user is logged in and is admin
user_id = request.session.get("user_id")
if not user_id:
return Response(
"",
status_code=302,
headers={"Location": "/"},
)
user = Core.Database.get_user_by_id(
user_id,
)
if not user or not Core.is_admin(user):
return Response(
"",
status_code=302,
headers={"Location": "/?error=forbidden"},
)
# Get metrics data
metrics = Core.Database.get_metrics_summary()
return Views.MetricsDashboard(metrics=metrics, user=user)
|
