File size: 1,728 Bytes
7caa980 a2fcbc9 7caa980 |
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 |
# space/tools/report_tool.py
import os
from typing import Optional, Dict, Any
import pandas as pd
from jinja2 import Environment, FileSystemLoader
from utils.tracing import Tracer
from utils.config import AppConfig
class ReportTool:
def __init__(self, cfg: AppConfig, tracer: Tracer):
self.cfg = cfg
self.tracer = tracer
templates_dir = os.path.abspath(os.path.join(os.path.dirname(__file__), "..", "templates"))
self.env = Environment(loader=FileSystemLoader(templates_dir), autoescape=False)
def render_and_save(
self,
user_query: str,
sql_preview: Optional[pd.DataFrame],
predict_preview: Optional[pd.DataFrame],
explain_images: Dict[str, str],
plan: Dict[str, Any],
) -> str:
tmpl = self.env.get_template("report_template.md")
html_body = tmpl.render(
user_query=user_query,
plan=plan,
sql_preview=sql_preview.to_markdown(index=False) if isinstance(sql_preview, pd.DataFrame) else "",
predict_preview=predict_preview.to_markdown(index=False) if isinstance(predict_preview, pd.DataFrame) else "",
explain_images=explain_images or {},
)
out_name = f"report_{pd.Timestamp.utcnow().strftime('%Y%m%d_%H%M%S')}.html"
out_path = os.path.abspath(os.path.join(os.getcwd(), out_name))
css_link = "templates/report_styles.css"
html = f'<link rel="stylesheet" href="{css_link}">\n' + html_body
with open(out_path, "w", encoding="utf-8") as f:
f.write(html)
try:
self.tracer.trace_event("report", {"path": out_name})
except Exception:
pass
return out_name
|