Function profiler

Scripts/ButSystem.py:15898–15948

profiler. Route handler or application helper. This docstring was expanded to make future maintenance easier. Returns: Varies.

()

            LIMIT 80
            """,
            (gid, after_id),
        ).fetchall()

        items = []
        for r in rows:
            v = conn.execute("SELECT id, mime FROM group_voice WHERE gm_id=? ORDER BY id DESC LIMIT 1", (r["id"],)).fetchone()
            has_voice = bool(v)
            try:
                body_txt = aesgcm_decrypt_text(r["body_enc"])
            except Exception:
                body_txt = "[decrypt failed]"
            items.append({
                "id": int(r["id"]),
                "sender": r["sender"],
                "kind": "voice" if has_voice else "text",
                "body": body_txt if not has_voice else "",
                "created_at_local": _local_time_str(r["created_at"]),
                "created_at_utc": r["created_at"],
                "voice_id": v["id"] if v else None,
                "voice_mime": v["mime"] if v else "audio/webm",
                "voice_url": (url_for("group_voice_stream", vid=v["id"]) if v else None),
            })
        return jsonify(ok=True, items=items)
    finally:
        try:
            conn.close()
        except Exception:
            pass

@app.route("/group/voice/<int:vid>")
@login_required
def group_voice_stream(vid: int):
    """Stream a group voice message."""
    me = current_user()
    conn = db_connect()
    row = conn.execute("""
        SELECT v.id, v.mime, v.stored_path, m.group_id
        FROM group_voice v
        JOIN group_messages m ON m.id=v.gm_id
        WHERE v.id=?
    """, (vid,)).fetchone()
    conn.close()
    if not row:
        abort(404)
    if not group_role(int(row["group_id"]), me):
        abort(403)
    if not _chat_lock_is_unlocked(me, "group", int(row["group_id"])):
        return redirect(url_for("group_chat", gid=int(row["group_id"])))

    sp = row["stored_path"]
    if not sp or not os.path.exists(sp):
        abort(404)

    mime = row["mime"] or "audio/webm"