Function _dm_store_remote_gif_tx

Scripts/ButSystem.py:12740–12810

Download and store a remote GIF using an existing DB connection/transaction.

(conn, dm_id: int, gif_url: str)

        if is_encrypted_file(target):
            response = Response(aesgcm_decrypt_generator(target), mimetype=mime); response.headers["Content-Disposition"] = f'attachment; filename="{os.path.basename(target)}"'
        else: response = send_file(target, mimetype=mime, as_attachment=True, download_name=os.path.basename(target), conditional=True, max_age=0)
        response.headers["Cache-Control"] = "no-store"; return response
    except Exception as exc:
        if getattr(exc, "code", None) == 404: raise
        log.exception("Download failed: %s", exc); flash("Download failed."); return redirect(url_for("files"))


@app.route("/files/details")
@login_required
def file_details():
    rel = request.args.get("p", "") or ""
    try:
        rel = safe_relpath(rel); target = abs_user_path(current_user(), rel); st = os.stat(target)
        if not rel: raise ValueError
    except Exception: abort(404)
    is_dir = os.path.isdir(target); size = _folder_size(target) if is_dir else st.st_size; category = _file_category(target, is_dir)
    checksum = _sha256_file(target) if request.args.get("checksum") == "1" and not is_dir else ""
    conn = db_connect(); comments = conn.execute("SELECT id, author, body, created_at FROM file_comments WHERE owner=? AND relpath=? ORDER BY id DESC", (current_user(), rel)).fetchall(); shares_rows = conn.execute("SELECT id, token, pw_hash, expires_at FROM file_shares WHERE owner=? AND relpath=? AND revoked=0 ORDER BY id DESC", (current_user(), rel)).fetchall(); conn.close()
    now = datetime.now(timezone.utc)
    shares = []
    for row in shares_rows:
        expired = False
        try: expired = bool(row["expires_at"] and datetime.fromisoformat(row["expires_at"].replace("Z", "+00:00")) <= now)
        except Exception: expired = False
        if not expired: shares.append(type("Obj", (), {"id": row["id"], "url": url_for("public_share", token=row["token"], _external=True), "protected": bool(row["pw_hash"]), "expires_at": row["expires_at"]})())
    info = type("Obj", (), {"name": os.path.basename(target), "is_dir": is_dir, "kind": "Folder" if is_dir else "File", "category": _category_label(category), "mime": "inode/directory" if is_dir else guess_mime(target), "size": size, "size_h": human_size(size), "created": datetime.fromtimestamp(getattr(st, "st_birthtime", st.st_ctime)).isoformat(sep=" ", timespec="seconds"), "modified": datetime.fromtimestamp(st.st_mtime).isoformat(sep=" ", timespec="seconds")})()
    return render_template("file_details.html", relpath=rel, parent_relpath="/".join(rel.split("/")[:-1]), info=info, checksum=checksum, comments=comments, shares=shares)


@app.route("/files/comments/add", methods=["POST"])
@login_required
def file_comment_add():
    rel = safe_relpath(request.form.get("p", "") or ""); body = (request.form.get("body") or "").strip()
    try:
        if not body or len(body) > 2000 or not os.path.exists(abs_user_path(current_user(), rel)): raise ValueError
        conn = db_connect(); conn.execute("INSERT INTO file_comments(owner, relpath, author, body, created_at) VALUES(?,?,?,?,?)", (current_user(), rel, current_user(), body, now_z())); conn.commit(); conn.close(); _log_file_activity(current_user(), "comment_added", rel); flash("Comment added.")
    except Exception: flash("Could not add comment.")
    return redirect(url_for("file_details", p=rel))


@app.route("/files/comments/<int:cid>/delete", methods=["POST"])
@login_required
def file_comment_delete(cid: int):
    rel = safe_relpath(request.form.get("p", "") or ""); conn = db_connect(); conn.execute("DELETE FROM file_comments WHERE id=? AND owner=?", (cid, current_user())); conn.commit(); conn.close(); _log_file_activity(current_user(), "comment_deleted", rel); flash("Comment deleted."); return redirect(url_for("file_details", p=rel))


@app.route("/files/share/create", methods=["POST"])
@login_required
def file_share_create():
    rel = safe_relpath(request.form.get("p", "") or "")
    try:
        if not rel or not os.path.exists(abs_user_path(current_user(), rel)): raise ValueError
        hours = max(1, min(720, int(request.form.get("hours") or 24))); password = request.form.get("password") or ""; token = secrets.token_urlsafe(32); expires = (datetime.now(timezone.utc) + timedelta(hours=hours)).isoformat(timespec="seconds").replace("+00:00", "Z")
        conn = db_connect(); conn.execute("INSERT INTO file_shares(token, owner, relpath, pw_hash, expires_at, created_at, revoked) VALUES(?,?,?,?,?,?,0)", (token, current_user(), rel, generate_password_hash(password) if password else None, expires, now_z())); conn.commit(); conn.close(); _log_file_activity(current_user(), "share_created", rel, f"expires {expires}"); flash("Share link created.")
    except Exception: flash("Could not create share link.")
    return redirect(url_for("file_details", p=rel))