app.models.test_case¶
Modelo de base de datos para Casos de Prueba SQL.
TestCase
¶
Bases: Base
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
¶