File size: 2,572 Bytes
afa4de7 2d521fd afa4de7 2d521fd afa4de7 2d521fd afa4de7 2d521fd afa4de7 2d521fd afa4de7 2d521fd afa4de7 | 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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 | from sqlalchemy import Column, Integer, String, DateTime, Boolean, Text, JSON, Float, ForeignKey, UniqueConstraint
from sqlalchemy.orm import relationship
import datetime
from .base import Base
class IntentDB(Base):
__tablename__ = "intents"
id = Column(Integer, primary_key=True, index=True)
deterministic_id = Column(
String(64),
unique=True,
index=True,
nullable=False)
intent_type = Column(String(64), nullable=False)
payload = Column(JSON, nullable=False)
oss_payload = Column(JSON, nullable=True)
environment = Column(String(32), nullable=True)
created_at = Column(
DateTime,
default=datetime.datetime.utcnow,
nullable=False)
evaluated_at = Column(DateTime, nullable=True)
risk_score = Column(String(32), nullable=True)
outcomes = relationship(
"OutcomeDB",
back_populates="intent",
cascade="all, delete-orphan")
class OutcomeDB(Base):
__tablename__ = "intent_outcomes"
id = Column(Integer, primary_key=True, index=True)
intent_id = Column(
Integer,
ForeignKey(
"intents.id",
ondelete="CASCADE"),
nullable=False)
success = Column(Boolean, nullable=False)
recorded_by = Column(String(128), nullable=True)
notes = Column(Text, nullable=True)
recorded_at = Column(
DateTime,
default=datetime.datetime.utcnow,
nullable=False)
idempotency_key = Column(String(128), unique=True, nullable=True)
intent = relationship("IntentDB", back_populates="outcomes")
__table_args__ = (
UniqueConstraint("intent_id", name="uq_outcome_intentid"),
)
# ---------------------------------------------------------------------------
# NEW: Persistence for the conjugate Bayesian state
# ---------------------------------------------------------------------------
class BetaStateDB(Base):
"""
Stores the per‑category posterior parameters (α, β) of the BetaStore
so that online learning survives API restarts.
Only one row per ActionCategory is expected; the 'category' column is
unique. Updates are performed via merge / upsert.
"""
__tablename__ = "beta_state"
id = Column(Integer, primary_key=True, index=True)
category = Column(String(32), unique=True, nullable=False, index=True)
alpha = Column(Float, nullable=False)
beta = Column(Float, nullable=False)
updated_at = Column(
DateTime,
default=datetime.datetime.utcnow,
onupdate=datetime.datetime.utcnow)
|