Saltar a contenido

app.models.schemas

ValidationTypeEnum

Bases: str, Enum

ROW_COUNT = 'ROW_COUNT' class-attribute instance-attribute

EXISTS = 'EXISTS' class-attribute instance-attribute

SCALAR_VALUE = 'SCALAR_VALUE' class-attribute instance-attribute

EnvironmentTypeEnum

Bases: str, Enum

TEST = 'TEST' class-attribute instance-attribute

STAGING = 'STAGING' class-attribute instance-attribute

PRODUCTION = 'PRODUCTION' class-attribute instance-attribute

ProjectCreate

Bases: BaseModel

name = Field(..., min_length=1, max_length=100) class-attribute instance-attribute

description = Field(None, max_length=500) class-attribute instance-attribute

validate_name(v) classmethod

ProjectUpdate

Bases: BaseModel

name = Field(None, min_length=1, max_length=100) class-attribute instance-attribute

description = Field(None, max_length=500) class-attribute instance-attribute

validate_name(v) classmethod

ProjectResponse

Bases: ProjectCreate

id instance-attribute

created_at instance-attribute

updated_at instance-attribute

model_config = ConfigDict(from_attributes=True) class-attribute instance-attribute

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

id instance-attribute

project_id instance-attribute

model_config = ConfigDict(from_attributes=True) class-attribute instance-attribute

TestSuiteCreate

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

validate_name(v) classmethod

TestSuiteUpdate

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

validate_name(v) classmethod

TestSuiteResponse

Bases: TestSuiteCreate

id instance-attribute

project_id instance-attribute

test_cases = [] class-attribute instance-attribute

model_config = ConfigDict(from_attributes=True) class-attribute instance-attribute

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.

model_config = ConfigDict(extra='forbid') class-attribute instance-attribute

password instance-attribute

connection_profile_id instance-attribute

environment_type = None class-attribute instance-attribute

confirm_staging_dml = False class-attribute instance-attribute

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.