docker exec -it testops-db-1 psql -U testops -d testops -c "
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
AND table_type = 'BASE TABLE'
ORDER BY table_name;
"
# Ожидаемый список:
# alembic_version, attachments, tags, test_case_suites, test_case_steps,
# test_case_tags, test_cases, test_suites, testrun_results
# Колонки testrun_results — проверка полной схемы
docker exec -it testops-db-1 psql -U testops -d testops -c "
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = 'testrun_results'
ORDER BY ordinal_position;
"
# Должны быть: id, run_name, start_date, end_date, stand, status,
# passed_count, failed_count, broken_count, skipped_count, created_at, is_deleted
# Alembic на нужной ревизии
docker exec -it testops-flask-app flask db current
# Ожидаем: 0001_initial_schema (head)