pip install -r requirements.txt

from unified_pipeline import analyze_file

# 文件 → SQL → 图表 → 洞察 → 报告
result = analyze_file(
    "sales.csv",
    sql="SELECT region, SUM(sales) as total FROM data GROUP BY region",
    charts=[{"type":"bar","x":"region","y":"total","title":"区域销售"}],
    output="report.html"
)
print(result.log())

from database_connector import DatabaseConnector

# 连接 MySQL
conn = DatabaseConnector(
    dialect="mysql+pymysql",
    host="localhost", port=3306,
    username="root", password="xxx",
    database="sales_db"
)
result = conn.execute("SELECT * FROM orders WHERE amount > 1000")
print(result.df)

from interactive_charts import InteractiveChartFactory

factory = InteractiveChartFactory(theme="powerbi")
html = factory.create_line({
    "categories": ["1月","2月","3月"],
    "series": [{"name":"销售额","data":[100,120,150]}]
})
factory.save_html(html, "chart.html")

from ai_insights import quick_insights

report = quick_insights(df, date_col="date", value_cols=["sales","profit"])
for insight in report.insights:
    print(f"{insight.title}: {insight.description}")

from unified_pipeline import UnifiedPipeline

# 创建 Pipeline
p = UnifiedPipeline("销售分析").set_theme("powerbi")

# 加载数据
p.from_file("sales.csv")

# SQL 查询
p.query("SELECT region, SUM(amount) as total FROM data GROUP BY region")

# 生成交互式图表
p.interactive_chart("bar", x_col="region", y_col="total", title="区域销售")
p.interactive_chart("pie", x_col="region", y_col="total", title="区域占比")

# AI 洞察
p.insights(value_cols=["total"])

# 生成完整报告
p.report(title="销售分析报告", output="report.html")

# 打印日志
print(p.log())

from database_connector import DatabaseConnector
from interactive_charts import InteractiveChartFactory

# 查询数据
conn = DatabaseConnector(dialect="sqlite", database="sales.db")
df = conn.execute("SELECT month, sales FROM monthly_sales").df

# 生成图表
factory = InteractiveChartFactory()
html = factory.create_line({
    "categories": df["month"].tolist(),
    "series": [{"name": "销售额", "data": df["sales"].tolist()}]
}, title="月度销售趋势")
factory.save_html(html, "trend.html")

from interactive_charts import DashboardBuilder, InteractiveChartFactory

builder = DashboardBuilder(title="销售看板", theme="powerbi")

# KPI 卡片
builder.add_kpi_cards([
    {"title": "GMV", "value": "¥1,234万", "change": "+18%"},
    {"title": "订单量", "value": "45,678", "change": "+12%"},
])

# 添加图表
factory = InteractiveChartFactory()
line_html = factory.create_line({...})
builder.add_chart(line_html, title="趋势", cols=2)

# 生成
builder.build("dashboard.html")

from dashboard_templates import get_template

# 获取电商概览模板
template = get_template("ecommerce_overview")

# 根据模板配置生成图表
# template.charts 包含所有图表规格

from charts import Theme

# 支持的主题：POWERBI, ALIBABA, TENCENT, BYTEDANCE, NEUTRAL
factory = ChartFactory()
factory.set_theme("powerbi")