Workflow / main.py
Phupingbut1989's picture
main.py
6e58644 verified
Raw History Blame Contribute Delete
2.93 kB
---
license: mit
---
import os
import sqlite3
import uuid
from datetime import datetime, timezone
from fastapi import FastAPI, Header, HTTPException
from pydantic import BaseModel, Field
app = FastAPI(title="Brilla AI Workflow")
DB = os.getenv("BRILLA_DB", "workflow.db")
API_KEY = os.getenv("BRILLA_API_KEY")
def auth(authorization=None):
if not API_KEY:
raise HTTPException(503, "API key not configured")
if authorization != f"Bearer {API_KEY}":
raise HTTPException(401, "Unauthorized")
def db():
conn = sqlite3.connect(DB)
conn.row_factory = sqlite3.Row
conn.execute("""
CREATE TABLE IF NOT EXISTS workflows (
id TEXT PRIMARY KEY,
name TEXT,
goal TEXT,
status TEXT,
output TEXT,
created_at TEXT
)
""")
return conn
class Workflow(BaseModel):
name: str = Field(min_length=1, max_length=100)
goal: str = Field(min_length=1, max_length=500)
@app.get("/")
def home():
return {"system": "Brilla AI Workflow", "status": "ready"}
@app.get("/health")
def health():
return {"status": "ok"}
@app.post("/workflow/create")
def create(data: Workflow, authorization: str = Header(None)):
auth(authorization)
wid = str(uuid.uuid4())
conn = db()
conn.execute(
"INSERT INTO workflows VALUES (?, ?, ?, ?, ?, ?)",
(wid, data.name, data.goal, "pending", None,
datetime.now(timezone.utc).isoformat())
)
conn.commit()
conn.close()
return {
"workflow_id": wid,
"status": "pending"
}
@app.post("/workflow/execute/{wid}")
def execute(wid: str, authorization: str = Header(None)):
auth(authorization)
conn = db()
row = conn.execute(
"SELECT * FROM workflows WHERE id=?", (wid,)
).fetchone()
if not row:
conn.close()
raise HTTPException(404, "Workflow not found")
# ตัวอย่าง Executor
result = {
"goal": row["goal"],
"message": "Workflow executed"
}
conn.execute(
"UPDATE workflows SET status=?, output=? WHERE id=?",
("completed", str(result), wid)
)
conn.commit()
conn.close()
return {
"workflow_id": wid,
"status": "completed",
"output": result
}
@app.get("/workflow/status/{wid}")
def status(wid: str, authorization: str = Header(None)):
auth(authorization)
conn = db()
row = conn.execute(
"SELECT * FROM workflows WHERE id=?", (wid,)
).fetchone()
conn.close()
if not row:
raise HTTPException(404, "Not found")
return dict(row)
@app.get("/workflow/history")
def history(authorization: str = Header(None)):
auth(authorization)
conn = db()
rows = conn.execute(
"SELECT * FROM workflows ORDER BY created_at DESC"
).fetchall()
conn.close()
return {"items": [dict(r) for r in rows]}