Saltar a contenido

app.models.history

Modelo de base de datos para registrar la trazabilidad completa de las ejecuciones.

ExecutionHistory

Bases: Base

id = Column(Integer, primary_key=True, index=True) class-attribute instance-attribute

project_id = Column(Integer, ForeignKey('projects.id'), nullable=False, default=1) class-attribute instance-attribute

test_case_id = Column(Integer, ForeignKey('test_cases.id'), nullable=True) class-attribute instance-attribute

suite_id = Column(Integer, ForeignKey('test_suites.id'), nullable=True) class-attribute instance-attribute

connection_profile_id = Column(Integer, ForeignKey('connection_profiles.id'), nullable=True) class-attribute instance-attribute

status = Column(String, index=True, nullable=False) class-attribute instance-attribute

executed_at = Column(DateTime(timezone=True), default=get_utc_now, index=True) class-attribute instance-attribute

duration_ms = Column(Float, nullable=False) class-attribute instance-attribute

statement_type = Column(String, nullable=True) class-attribute instance-attribute

executed_sql = Column(Text, nullable=False) class-attribute instance-attribute

validation_type = Column(String, nullable=True) class-attribute instance-attribute

expected_result = Column(String, nullable=True) class-attribute instance-attribute

actual_result = Column(Text, nullable=True) class-attribute instance-attribute

rowcount = Column(Integer, default=0) class-attribute instance-attribute

rollback_applied = Column(Boolean, default=False) class-attribute instance-attribute

rollback_error = Column(Text, nullable=True) class-attribute instance-attribute

error_message = Column(Text, nullable=True) class-attribute instance-attribute

trigger_source = Column(String, nullable=True, index=True) class-attribute instance-attribute

run_id = Column(String, nullable=True, index=True) class-attribute instance-attribute

executed_by = Column(String(50), nullable=True, index=True) class-attribute instance-attribute

project = relationship('Project', back_populates='execution_histories') class-attribute instance-attribute

test_case = relationship('TestCase', back_populates='execution_histories') class-attribute instance-attribute

test_suite = relationship('TestSuite', back_populates='execution_histories') class-attribute instance-attribute

connection_profile = relationship('ConnectionProfile', back_populates='execution_histories') class-attribute instance-attribute

case_name property

suite_name property

connection_name property

get_utc_now()