server.py

import os
import sqlite3
import json
from flask import Flask, render_template, jsonify
from datetime import datetime

app = Flask(__name__)
DB_PATH = "/data/eflog.db"

@app.route("/")
def index():
    return render_template("index.html")

@app.route("/logs.json")
def logs():
    conn = sqlite3.connect(DB_PATH)
    cursor = conn.cursor()
    try:
        cursor.execute("SELECT timestamp, status_code, data FROM status_log")
        rows = cursor.fetchall()
        result = []
        for ts, status, raw in rows:
            try:
                data = json.loads(raw.replace("'", """))
            except:
                data = {}
            result.append({
                "timestamp": ts,
                "status": status,
                "data": data
            })
        return jsonify(result)
    finally:
        conn.close()

if __name__ == "__main__":
    app.run(host="0.0.0.0", port=5000)