98bb34f094
- Fix AttributeError crash on empty request body in md5, hasher, textdiff,
jwtdecoder, timestamp, passwordgen (get_json without silent=True / or {})
- Fix memory exhaustion in ipcalc: replace list(network.hosts()) with direct
arithmetic — safe for /8 and larger networks
- Fix O(1M) loop in cronexplainer.get_next_runs: rewrite to skip by
month/day/hour instead of iterating every minute
- Fix connection leak in notes.ensure_table: add try/finally around conn.close
- Fix admin._ensure_tables / notes._ensure_table running DDL on every request:
guard with module-level flags (_tables_initialized, _table_ready)
- Fix update_website returning 200 when no row matched; delete_website returning
success when nothing was deleted; add rowcount checks for both
- Add role validation in admin create_user / update_user (_VALID_ROLES guard)
- Add delimiter length guard in csvviewer (csv.reader requires single char)
- Fix loremipsum: wrap int(count) in try/except ValueError → 400 response
- Fix auth/token: use auth_header[7:] instead of fragile .replace()
- Fix app.py: remove duplicate import sys; cache DB liveness check with 30s TTL
to avoid a new TCP connection on every frontend page load; move api/setup
path guard before DB check
- Replace FileHandler with RotatingFileHandler (5 MB / 3 backups) in logger;
fix relative log paths to absolute paths anchored to __file__
- Wrap all DB connections in try/finally conn.close() throughout admin and notes
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
47 lines
1.5 KiB
Python
47 lines
1.5 KiB
Python
from flask import Blueprint, request, jsonify
|
|
from datetime import datetime, timezone
|
|
from util.logger import logger
|
|
from auth.token import verify_token
|
|
|
|
timestamp_blueprint = Blueprint('timestamp_tool', __name__)
|
|
|
|
_DATE_FORMATS = [
|
|
"%Y-%m-%dT%H:%M:%S",
|
|
"%Y-%m-%d %H:%M:%S",
|
|
"%Y-%m-%d",
|
|
"%d.%m.%Y %H:%M:%S",
|
|
"%d.%m.%Y",
|
|
]
|
|
|
|
|
|
@timestamp_blueprint.route('/api/timestamp/convert', methods=['POST'])
|
|
def convert_timestamp():
|
|
user = verify_token()
|
|
if not user:
|
|
return jsonify({"message": "Nicht autorisiert"}), 401
|
|
try:
|
|
data = request.get_json(silent=True) or {}
|
|
value = data.get("value", "").strip()
|
|
direction = data.get("direction", "unix_to_date")
|
|
|
|
if direction == "unix_to_date":
|
|
ts = float(value)
|
|
dt_utc = datetime.fromtimestamp(ts, tz=timezone.utc)
|
|
return jsonify({"utc": dt_utc.isoformat(), "unix": int(ts)})
|
|
|
|
dt = None
|
|
for fmt in _DATE_FORMATS:
|
|
try:
|
|
dt = datetime.strptime(value, fmt).replace(tzinfo=timezone.utc)
|
|
break
|
|
except ValueError:
|
|
continue
|
|
if dt is None:
|
|
return jsonify({"message": "Ungültiges Datumsformat"}), 400
|
|
|
|
logger.info(f"Timestamp konvertiert von {user['username']}")
|
|
return jsonify({"unix": int(dt.timestamp()), "utc": dt.isoformat()})
|
|
except Exception as e:
|
|
logger.error(f"Fehler Timestamp: {e}")
|
|
return jsonify({"message": "Ungültiger Wert"}), 400
|