47 lines
1.5 KiB
YAML
47 lines
1.5 KiB
YAML
name: EVEREST engineering core Postgres integration
|
|
on:
|
|
push:
|
|
branches:
|
|
- 'feature/everest-stage3-oem-engineering-20261021'
|
|
pull_request:
|
|
paths:
|
|
- 'sql/engineering_core/**'
|
|
- 'src/oem_evidence_bridge.py'
|
|
- 'src/engineering_core.py'
|
|
- 'src/verified_designation_dictionary.py'
|
|
permissions:
|
|
contents: read
|
|
jobs:
|
|
test-postgres-migration:
|
|
runs-on: ubuntu-latest
|
|
services:
|
|
postgres:
|
|
image: postgres:16
|
|
env:
|
|
POSTGRES_USER: tester
|
|
POSTGRES_PASSWORD: ci_password
|
|
POSTGRES_DB: everest_bearings_ci
|
|
ports:
|
|
- 5432:5432
|
|
options: >-
|
|
--health-cmd "pg_isready -U tester -d everest_bearings_ci"
|
|
--health-interval 5s
|
|
--health-timeout 5s
|
|
--health-retries 10
|
|
env:
|
|
PGHOST: localhost
|
|
PGPORT: 5432
|
|
PGUSER: tester
|
|
PGPASSWORD: ci_password
|
|
PGDATABASE: everest_bearings_ci
|
|
steps:
|
|
- uses: actions/checkout@v4
|
|
- name: Apply engineering schema to ephemeral PostgreSQL
|
|
run: psql -X -v ON_ERROR_STOP=1 -f sql/engineering_core/001_engineering_core_postgres.sql
|
|
- name: Run rollback-only SQL assertions
|
|
run: psql -X -v ON_ERROR_STOP=1 -f sql/engineering_core/tests/smoke.sql
|
|
- name: Verify Python gate and OEM bridge
|
|
run: |
|
|
python -m pip install pytest
|
|
PYTHONPATH=. python -m pytest -q tests/test_engineering_core.py tests/test_verified_dictionary.py tests/test_oem_evidence_bridge.py tests/test_bearing_dimension_roles.py
|