app.models.schemas¶
ValidationTypeEnum
¶
EnvironmentTypeEnum
¶
ProjectCreate
¶
ProjectUpdate
¶
ProjectResponse
¶
Bases: ProjectCreate
ConnectionProfileCreate
¶
Bases: BaseModel
project_id
instance-attribute
¶
name = Field(..., min_length=1, max_length=100)
class-attribute
instance-attribute
¶
engine = Field('ORACLE', min_length=1, max_length=20)
class-attribute
instance-attribute
¶
host = Field(..., min_length=1, max_length=255)
class-attribute
instance-attribute
¶
port = Field(1521, ge=1, le=65535)
class-attribute
instance-attribute
¶
service_name = Field(..., min_length=1, max_length=100)
class-attribute
instance-attribute
¶
username = Field(..., min_length=1, max_length=100)
class-attribute
instance-attribute
¶
environment_type = EnvironmentTypeEnum.TEST
class-attribute
instance-attribute
¶
validate_non_empty(v)
classmethod
¶
validate_host(v)
classmethod
¶
validate_service(v)
classmethod
¶
validate_engine(v)
classmethod
¶
ConnectionProfileUpdate
¶
Bases: BaseModel
name = Field(None, min_length=1, max_length=100)
class-attribute
instance-attribute
¶
host = Field(None, min_length=1, max_length=255)
class-attribute
instance-attribute
¶
port = Field(None, ge=1, le=65535)
class-attribute
instance-attribute
¶
service_name = Field(None, min_length=1, max_length=100)
class-attribute
instance-attribute
¶
username = Field(None, min_length=1, max_length=100)
class-attribute
instance-attribute
¶
environment_type = None
class-attribute
instance-attribute
¶
validate_non_empty(v)
classmethod
¶
validate_host(v)
classmethod
¶
validate_service(v)
classmethod
¶
ConnectionProfileResponse
¶
Bases: BaseModel
id
instance-attribute
¶
project_id
instance-attribute
¶
name
instance-attribute
¶
engine
instance-attribute
¶
host
instance-attribute
¶
port
instance-attribute
¶
service_name
instance-attribute
¶
username
instance-attribute
¶
environment_type
instance-attribute
¶
created_at
instance-attribute
¶
updated_at
instance-attribute
¶
model_config = ConfigDict(from_attributes=True)
class-attribute
instance-attribute
¶
TestConnectionRequest
¶
Bases: BaseModel
password = Field(..., min_length=1)
class-attribute
instance-attribute
¶
TestCaseCreate
¶
Bases: BaseModel
project_id = 1
class-attribute
instance-attribute
¶
name = Field(..., min_length=1, max_length=150)
class-attribute
instance-attribute
¶
description = Field(None, max_length=500)
class-attribute
instance-attribute
¶
sql_query = Field(..., min_length=1)
class-attribute
instance-attribute
¶
validation_type = None
class-attribute
instance-attribute
¶
expected_result = Field(..., min_length=1)
class-attribute
instance-attribute
¶
validacion_automatica(data)
classmethod
¶
validate_text(v)
classmethod
¶
validate_expected(v, info)
classmethod
¶
TestCaseUpdate
¶
Bases: BaseModel
name = Field(None, min_length=1, max_length=150)
class-attribute
instance-attribute
¶
description = Field(None, max_length=500)
class-attribute
instance-attribute
¶
sql_query = Field(None, min_length=1)
class-attribute
instance-attribute
¶
validation_type = None
class-attribute
instance-attribute
¶
expected_result = Field(None, min_length=1)
class-attribute
instance-attribute
¶
validacion_automatica(data)
classmethod
¶
validate_text(v)
classmethod
¶
TestCaseResponse
¶
Bases: TestCaseCreate
TestSuiteCreate
¶
TestSuiteUpdate
¶
TestSuiteResponse
¶
Bases: TestSuiteCreate
DBCredentials
¶
Bases: BaseModel
Credenciales de ejecución. Solo se admite un perfil de conexión GUARDADO: no hay campos
dsn/user/host y cualquier campo desconocido se rechaza (422). environment_type se
acepta por compatibilidad pero se ignora: el ambiente siempre sale del perfil.
ExecutionRequest
¶
Bases: DBCredentials
sql_query
instance-attribute
¶
TestCaseExecutionRequest
¶
Bases: DBCredentials
SuiteExecutionRequest
¶
Bases: DBCredentials
ExecutionResponse
¶
Bases: BaseModel
success
instance-attribute
¶
statement_type = 'UNKNOWN'
class-attribute
instance-attribute
¶
rows = []
class-attribute
instance-attribute
¶
rowcount = 0
class-attribute
instance-attribute
¶
data = []
class-attribute
instance-attribute
¶
message
instance-attribute
¶
error_message = None
class-attribute
instance-attribute
¶
rollback_applied = False
class-attribute
instance-attribute
¶
rollback_error = None
class-attribute
instance-attribute
¶
QuickExecutionRequest
¶
Bases: BaseModel
Prueba rápida: SOLO admite un perfil de conexión guardado. No existe
ningún campo dsn/user/host: el servidor nunca se conecta a un
destino elegido libremente por el navegador.
model_config = ConfigDict(extra='forbid')
class-attribute
instance-attribute
¶
connection_profile_id
instance-attribute
¶
password = Field(..., min_length=1)
class-attribute
instance-attribute
¶
sql_query = Field(..., min_length=1)
class-attribute
instance-attribute
¶
validation_type = None
class-attribute
instance-attribute
¶
expected_result = Field(..., min_length=1)
class-attribute
instance-attribute
¶
motivo_validacion_automatica
property
¶
Explicación de por qué se eligió el tipo de validación (None si la persona lo eligió a mano).
aceptar_auto(data)
classmethod
¶
validate_text(v)
classmethod
¶
validate_expected_for_type()
¶
QuickExecutionResponse
¶
Bases: BaseModel
history_id
instance-attribute
¶
status
instance-attribute
¶
environment_type
instance-attribute
¶
connection_name
instance-attribute
¶
sql_query
instance-attribute
¶
validation_type
instance-attribute
¶
expected_result
instance-attribute
¶
expected_text
instance-attribute
¶
obtained_text
instance-attribute
¶
reason
instance-attribute
¶
validation_auto = False
class-attribute
instance-attribute
¶
validation_reason = None
class-attribute
instance-attribute
¶
columns = []
class-attribute
instance-attribute
¶
obtained_value = None
class-attribute
instance-attribute
¶
rows = []
class-attribute
instance-attribute
¶
rows_shown = 0
class-attribute
instance-attribute
¶
rows_truncated = False
class-attribute
instance-attribute
¶
rows_hidden = False
class-attribute
instance-attribute
¶
rowcount = 0
class-attribute
instance-attribute
¶
duration_ms = 0.0
class-attribute
instance-attribute
¶
error_message = None
class-attribute
instance-attribute
¶
HistoryResponse
¶
Bases: BaseModel
id
instance-attribute
¶
project_id
instance-attribute
¶
test_case_id = None
class-attribute
instance-attribute
¶
suite_id = None
class-attribute
instance-attribute
¶
connection_profile_id = None
class-attribute
instance-attribute
¶
status
instance-attribute
¶
executed_at
instance-attribute
¶
duration_ms
instance-attribute
¶
statement_type = None
class-attribute
instance-attribute
¶
executed_sql
instance-attribute
¶
validation_type = None
class-attribute
instance-attribute
¶
expected_result = None
class-attribute
instance-attribute
¶
actual_result = None
class-attribute
instance-attribute
¶
rowcount = 0
class-attribute
instance-attribute
¶
rollback_applied = False
class-attribute
instance-attribute
¶
rollback_error = None
class-attribute
instance-attribute
¶
error_message = None
class-attribute
instance-attribute
¶
trigger_source = None
class-attribute
instance-attribute
¶
run_id = None
class-attribute
instance-attribute
¶
executed_by = None
class-attribute
instance-attribute
¶
case_name = None
class-attribute
instance-attribute
¶
suite_name = None
class-attribute
instance-attribute
¶
connection_name = None
class-attribute
instance-attribute
¶
model_config = ConfigDict(from_attributes=True)
class-attribute
instance-attribute
¶
SuiteCaseResult
¶
Bases: BaseModel
Resultado legible de un caso dentro de la ejecución de una suite.
history_id
instance-attribute
¶
test_case_id
instance-attribute
¶
case_name
instance-attribute
¶
status
instance-attribute
¶
validation_type = None
class-attribute
instance-attribute
¶
expected_result = None
class-attribute
instance-attribute
¶
expected_text
instance-attribute
¶
obtained_text
instance-attribute
¶
reason
instance-attribute
¶
duration_ms = 0.0
class-attribute
instance-attribute
¶
error_message = None
class-attribute
instance-attribute
¶
previous_status = None
class-attribute
instance-attribute
¶
previous_executed_at = None
class-attribute
instance-attribute
¶
change = None
class-attribute
instance-attribute
¶
change_text = None
class-attribute
instance-attribute
¶
SuiteExecutionSummary
¶
Bases: BaseModel
suite_id
instance-attribute
¶
suite_name
instance-attribute
¶
total_tests
instance-attribute
¶
passed
instance-attribute
¶
failed
instance-attribute
¶
errors
instance-attribute
¶
total_duration_ms
instance-attribute
¶
run_id = None
class-attribute
instance-attribute
¶
details = []
class-attribute
instance-attribute
¶
case_results = []
class-attribute
instance-attribute
¶
new_failures = 0
class-attribute
instance-attribute
¶
fixed = 0
class-attribute
instance-attribute
¶
normalize_expected_result(value, validation_type)
¶
Valida y normaliza el resultado esperado según el tipo de validación.