Skip to content

fix(db): harden persistence, recovery, and request transactions #723

fix(db): harden persistence, recovery, and request transactions

fix(db): harden persistence, recovery, and request transactions #723

Workflow file for this run

name: Validate PRs and Main
on:
pull_request:
push:
branches:
- main
permissions:
contents: read
jobs:
quality-gate:
name: Validate Default Toolchain
runs-on: ubuntu-latest
steps:
- name: Checkout
uses: actions/checkout@v6
- name: Set up Python
uses: actions/setup-python@v6
with:
python-version: "3.14"
- name: Set up uv
uses: astral-sh/setup-uv@v7
with:
enable-cache: false
- name: Run default validation
run: bash ./scripts/doctor.sh
runtime-matrix:
name: Validate Runtime Matrix (Python ${{ matrix.python-version }})
runs-on: ubuntu-latest
strategy:
fail-fast: false
matrix:
python-version: ["3.11", "3.12", "3.13", "3.14"]
steps:
- name: Checkout
uses: actions/checkout@v6
- name: Set up Python
uses: actions/setup-python@v6
with:
python-version: ${{ matrix.python-version }}
- name: Set up uv
uses: astral-sh/setup-uv@v7
with:
enable-cache: false
- name: Sync locked dependencies
run: uv sync --extra dev --frozen
- name: Run runtime regression tests
run: uv run pytest -m "not integration"
integration-postgres:
name: Validate CLI Integration (PostgreSQL)
runs-on: ubuntu-latest
services:
postgres:
image: postgres:16
env:
POSTGRES_DB: lifeos_test
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres # pragma: allowlist secret
ports:
- 5432:5432
options: >-
--health-cmd "pg_isready -U postgres -d lifeos_test"
--health-interval 10s
--health-timeout 5s
--health-retries 5
steps:
- name: Checkout
uses: actions/checkout@v6
- name: Set up Python
uses: actions/setup-python@v6
with:
python-version: "3.14"
- name: Set up uv
uses: astral-sh/setup-uv@v7
with:
enable-cache: false
- name: Run CLI integration tests
env:
LIFEOS_TEST_DATABASE_URL: postgresql+psycopg://postgres:postgres@127.0.0.1:5432/lifeos_test # pragma: allowlist secret
run: bash ./scripts/integration_tests.sh