Saltar a contenido

app.models.test_case

Modelo de base de datos para Casos de Prueba SQL.

TestCase

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

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

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

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

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

validation_type = Column(String, nullable=False, default='ROW_COUNT') class-attribute instance-attribute

created_at = Column(DateTime, default=datetime.utcnow) class-attribute instance-attribute

updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow) class-attribute instance-attribute

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

execution_histories = relationship('ExecutionHistory', back_populates='test_case', passive_deletes='all') class-attribute instance-attribute