Files
temp/robot/resource_registry_migration.robot

34 lines
1.7 KiB
Plaintext

*** Settings ***
Documentation Smoke tests for resource registry migration (schema creation).
... Validates that ``init_database`` creates the ``resource_types``,
... ``resources``, and ``resource_edges`` tables with expected columns
... and that the operation is idempotent.
Resource ${CURDIR}/common.resource
Suite Setup Setup Test Environment
Suite Teardown Cleanup Test Environment
*** Variables ***
${HELPER_SCRIPT} robot/helper_resource_registry_migration.py
*** Test Cases ***
Schema Creation Produces Resource Registry Tables
[Documentation] Verify init_database creates resource_types, resources, and resource_edges tables
[Tags] database migration smoke
${result}= Run Process ${PYTHON} ${HELPER_SCRIPT} schema-creates-tables cwd=${WORKSPACE}
Should Be Equal As Integers ${result.rc} 0
Should Contain ${result.stdout} schema-creates-tables-ok
Resource Registry Tables Have Expected Columns
[Documentation] Verify core columns exist on each resource registry table after migration
[Tags] database migration smoke
${result}= Run Process ${PYTHON} ${HELPER_SCRIPT} table-columns cwd=${WORKSPACE}
Should Be Equal As Integers ${result.rc} 0
Should Contain ${result.stdout} table-columns-ok
Migration Is Idempotent
[Documentation] Verify that running init_database twice does not raise errors
[Tags] database migration smoke
${result}= Run Process ${PYTHON} ${HELPER_SCRIPT} migration-idempotent cwd=${WORKSPACE}
Should Be Equal As Integers ${result.rc} 0
Should Contain ${result.stdout} migration-idempotent-ok