CI/CD and Infrastructure Documentation
This document describes the continuous integration, security scanning, and development infrastructure used by the Local Deep Research project.
Overview
The project uses many GitHub Actions workflows and 20+ pre-commit hooks to ensure code quality, security, and reliability.
┌─────────────────────────────────────────────────────────────────┐
│ Developer Workflow │
├─────────────────────────────────────────────────────────────────┤
│ Local Development │ Pull Request │ Main/Dev │
│ ───────────────── │ ──────────── │ ──────── │
│ • Pre-commit hooks │ • All tests │ • Deploy │
│ • Unit tests │ • Security scans │ • Publish │
│ • Linting │ • Code review │ • Release │
└─────────────────────────────────────────────────────────────────┘
Pre-Commit Hooks
Pre-commit hooks run locally before each commit. Install with:
pre-commit install
pre-commit install-hooks
Standard Hooks
| Hook |
Purpose |
check-yaml |
Validate YAML syntax |
end-of-file-fixer |
Ensure files end with newline |
trailing-whitespace |
Remove trailing whitespace |
check-added-large-files |
Block files >1MB |
check-case-conflict |
Prevent case-sensitivity issues |
forbid-new-submodules |
Prevent git submodules |
Security Hooks
| Hook |
Purpose |
gitleaks |
Detect secrets, API keys, passwords in code |
check-sensitive-logging |
Prevent logging of passwords, tokens, keys |
check-safe-requests |
Enforce SSRF-safe HTTP functions (safe_get, safe_post) |
check-url-security |
Validate URL handling in JavaScript (XSS prevention) |
file-whitelist-check |
Only allow approved file types |
check-image-pinning |
Require SHA256 digests for Docker images |
Code Quality Hooks
| Hook |
Purpose |
ruff |
Python linter (with auto-fix) |
ruff-format |
Python formatter (Black-compatible) |
eslint |
JavaScript linter |
shellcheck |
Shell script linter |
actionlint |
GitHub Actions workflow validator |
custom-code-checks |
Loguru usage, UTC datetime, raw SQL detection |
Project-Specific Hooks
| Hook |
Purpose |
check-env-vars |
Environment variables must use SettingsManager |
check-deprecated-db-connection |
Enforce per-user database connections |
check-ldr-db-usage |
Prevent shared ldr.db usage |
check-research-id-type |
research_id must be string/UUID, not int |
check-datetime-timezone |
SQLAlchemy DateTime must have timezone=True |
check-session-context-manager |
Require context managers for DB sessions |
check-pathlib-usage |
Use pathlib.Path instead of os.path |
check-no-external-resources |
No external CDN/resource references |
check-css-class-prefix |
CSS classes must have ldr- prefix |
GitHub Actions Workflows
Test Workflows
| Workflow |
Trigger |
Purpose |
docker-tests.yml |
PR, push |
Consolidated Docker tests: pytest + coverage, UI tests (51 Puppeteer tests), LLM tests, infrastructure tests (single Docker build shared across all jobs). Includes tests previously in critical-ui-tests, extended-ui-tests, metrics-analytics-tests, library-ui-tests, mobile-ui-tests, and news-tests workflows. |
api-tests.yml |
PR, push |
API endpoint testing |
e2e-research-test.yml |
PR, push |
End-to-end research flow |
followup-research-tests.yml |
PR, push |
Follow-up research tests |
fuzz.yml |
Schedule |
Fuzzing tests |
Security Scanning
| Workflow |
Trigger |
Purpose |
codeql.yml |
PR, push, schedule |
GitHub CodeQL analysis |
semgrep.yml |
PR, push |
Semgrep static analysis |
osv-scanner.yml |
PR, push, schedule |
OSV vulnerability scanning (Python + npm) |
gitleaks.yml |
PR, push |
Secret detection |
security-tests.yml |
PR, push |
Security-focused test suite |
devskim.yml |
PR, push |
Microsoft DevSkim analysis |
checkov.yml |
PR, push |
Infrastructure-as-code scanning |
container-security.yml |
PR, push |
Container vulnerability scanning |
hadolint.yml |
PR, push |
Dockerfile linting |
owasp-zap-scan.yml |
Schedule |
OWASP ZAP dynamic scanning |
retirejs.yml |
PR, push |
JavaScript vulnerability scanning |
zizmor-security.yml |
PR, push |
Additional security checks |
ossar.yml |
PR, push |
OSSAR security analysis |
ossf-scorecard.yml |
Schedule |
OpenSSF Scorecard |
security-headers-validation.yml |
PR, push |
HTTP security headers |
security-file-write-check.yml |
PR, push |
File write security |
npm-audit.yml |
PR, push |
npm audit for JS dependencies |
Dependency Management
| Workflow |
Trigger |
Purpose |
dependency-review.yml |
PR |
Review dependency changes |
update-dependencies.yml |
Schedule |
Auto-update Python deps |
update-npm-dependencies.yml |
Schedule |
Auto-update npm deps |
update-precommit-hooks.yml |
Schedule |
Update pre-commit hooks |
validate-image-pinning.yml |
PR, push |
Verify Docker image pins |
UI/Accessibility
| Workflow |
Trigger |
Purpose |
responsive-ui-tests-enhanced.yml |
PR, push |
Responsive design tests |
Build & Deploy
| Workflow |
Trigger |
Purpose |
docker-publish.yml |
Release, push |
Build and publish Docker images |
docker-multiarch-test.yml |
PR, push |
Multi-architecture build test |
publish.yml |
Release |
Publish to PyPI |
release.yml |
Manual |
Create releases |
Code Quality
| Workflow |
Trigger |
Purpose |
pre-commit.yml |
PR, push |
Run pre-commit hooks in CI |
mypy-type-check.yml |
PR, push |
Python type checking |
ai-code-reviewer.yml |
PR |
AI-assisted code review |
claude-code-review.yml |
PR |
Claude-based code review |
Repository Management
| Workflow |
Trigger |
Purpose |
sync-main-to-dev.yml |
Push to main |
Sync main branch to dev |
label-fixed-in-dev.yml |
Push to dev |
Auto-label fixed issues |
danger-zone-alert.yml |
PR |
Alert on sensitive file changes |
check-env-vars.yml |
PR, push |
Environment variable validation |
file-whitelist-check.yml |
PR, push |
File type validation |
version_check.yml |
PR, push |
Version consistency check |
Dependabot Configuration
Dependabot automatically creates PRs for dependency updates:
| Ecosystem |
Directories |
Schedule |
| Python (pip) |
/ |
Weekly (Monday 04:00) |
| npm |
/, /tests/* |
Weekly/Daily |
| GitHub Actions |
/ |
Weekly |
| Docker |
/ |
Daily |
Coverage Reporting
Coverage reports are generated by the docker-tests.yml workflow (pytest-tests job):
- HTML Report: Deployed to GitHub Pages at
https://learningcircuit.github.io/local-deep-research/coverage/
- PR Comments: Each PR receives a comment with coverage percentage
- Badge: Coverage badge updated via GitHub Gist
Configuration in pyproject.toml:
[tool.coverage.run]
source = ["src"]
omit = ["*/tests/*", "*/migrations/*"]
[tool.coverage.report]
exclude_lines = ["pragma: no cover", "if TYPE_CHECKING:"]
Security Architecture
Supply Chain Security
- Dependency Pinning: All GitHub Actions use SHA256 digests
- Docker Image Pinning: All base images use SHA256 digests
- Lock Files:
pdm.lock and package-lock.json committed
- Vulnerability Scanning: OSV-Scanner, npm audit, RetireJS
Runtime Security
- SSRF Protection:
safe_get(), safe_post(), SafeSession wrappers
- XSS Prevention: DOMPurify for HTML sanitization
- SQL Injection: SQLAlchemy ORM (no raw SQL)
- Secret Management: Environment variables via
SettingsManager
Container Security
- Non-root User: Containers run as
ldruser:1000
- Minimal Base Image: Python slim images
- Health Checks: Docker health check endpoints
- Read-only Where Possible: Minimal write permissions
Running Tests Locally
Quick Test (Unit Tests Only)
pdm run pytest tests/test_settings_manager.py tests/test_utils.py -v
Full Test Suite
pdm run pytest tests/ --ignore=tests/ui_tests --ignore=tests/fuzz -v
With Coverage
pdm run pytest tests/ --cov=src --cov-report=html -v
open coverage/htmlcov/index.html
UI Tests (Requires Server)
# Terminal 1: Start server
pdm run ldr-web
# Terminal 2: Run UI tests
cd tests/ui_tests && npm test
Docker Testing
Build and run tests in Docker:
# Build test image
docker build --target ldr-test -t ldr-test .
# Run tests
docker run --rm -v "$PWD":/app -w /app ldr-test \
pytest tests/ --ignore=tests/ui_tests -v
Environment Variables for CI
| Variable |
Purpose |
CI=true |
Indicates CI environment |
LDR_USE_FALLBACK_LLM=true |
Use mock LLM for tests |
LDR_TESTING_WITH_MOCKS=true |
Enable test mocks |
DISABLE_RATE_LIMITING=true |
Disable rate limits in tests |
Adding New Workflows
When adding a new workflow:
- Use pinned action versions with SHA256 digests
- Add
permissions: {} at top level (minimal permissions)
- Add job-level permissions as needed
- Include
step-security/harden-runner step
- Add workflow to this documentation
Example template:
name: New Workflow
on:
pull_request:
branches: [main]
permissions: {}
jobs:
example:
runs-on: ubuntu-latest
permissions:
contents: read
steps:
- name: Harden the runner
uses: step-security/harden-runner@... # pinned
with:
egress-policy: audit
- uses: actions/checkout@... # pinned
with:
persist-credentials: false
1---2name: 1532-ci-cd-infrastructure-f66f7d8b3description: CI/CD and Infrastructure Documentation4---5# CI/CD and Infrastructure Documentation67This document describes the continuous integration, security scanning, and development infrastructure used by the Local Deep Research project.89## Overview1011The project uses many GitHub Actions workflows and 20+ pre-commit hooks to ensure code quality, security, and reliability.1213```14┌─────────────────────────────────────────────────────────────────┐15│ Developer Workflow │16├─────────────────────────────────────────────────────────────────┤17│ Local Development │ Pull Request │ Main/Dev │18│ ───────────────── │ ──────────── │ ──────── │19│ • Pre-commit hooks │ • All tests │ • Deploy │20│ • Unit tests │ • Security scans │ • Publish │21│ • Linting │ • Code review │ • Release │22└─────────────────────────────────────────────────────────────────┘23```2425## Pre-Commit Hooks2627Pre-commit hooks run locally before each commit. Install with:2829```bash30pre-commit install31pre-commit install-hooks32```3334### Standard Hooks3536| Hook | Purpose |37|------|---------|38| `check-yaml` | Validate YAML syntax |39| `end-of-file-fixer` | Ensure files end with newline |40| `trailing-whitespace` | Remove trailing whitespace |41| `check-added-large-files` | Block files >1MB |42| `check-case-conflict` | Prevent case-sensitivity issues |43| `forbid-new-submodules` | Prevent git submodules |4445### Security Hooks4647| Hook | Purpose |48|------|---------|49| `gitleaks` | Detect secrets, API keys, passwords in code |50| `check-sensitive-logging` | Prevent logging of passwords, tokens, keys |51| `check-safe-requests` | Enforce SSRF-safe HTTP functions (`safe_get`, `safe_post`) |52| `check-url-security` | Validate URL handling in JavaScript (XSS prevention) |53| `file-whitelist-check` | Only allow approved file types |54| `check-image-pinning` | Require SHA256 digests for Docker images |5556### Code Quality Hooks5758| Hook | Purpose |59|------|---------|60| `ruff` | Python linter (with auto-fix) |61| `ruff-format` | Python formatter (Black-compatible) |62| `eslint` | JavaScript linter |63| `shellcheck` | Shell script linter |64| `actionlint` | GitHub Actions workflow validator |65| `custom-code-checks` | Loguru usage, UTC datetime, raw SQL detection |6667### Project-Specific Hooks6869| Hook | Purpose |70|------|---------|71| `check-env-vars` | Environment variables must use `SettingsManager` |72| `check-deprecated-db-connection` | Enforce per-user database connections |73| `check-ldr-db-usage` | Prevent shared `ldr.db` usage |74| `check-research-id-type` | `research_id` must be string/UUID, not int |75| `check-datetime-timezone` | SQLAlchemy DateTime must have `timezone=True` |76| `check-session-context-manager` | Require context managers for DB sessions |77| `check-pathlib-usage` | Use `pathlib.Path` instead of `os.path` |78| `check-no-external-resources` | No external CDN/resource references |79| `check-css-class-prefix` | CSS classes must have `ldr-` prefix |8081---8283## GitHub Actions Workflows8485### Test Workflows8687| Workflow | Trigger | Purpose |88|----------|---------|---------|89| `docker-tests.yml` | PR, push | Consolidated Docker tests: pytest + coverage, UI tests (51 Puppeteer tests), LLM tests, infrastructure tests (single Docker build shared across all jobs). Includes tests previously in critical-ui-tests, extended-ui-tests, metrics-analytics-tests, library-ui-tests, mobile-ui-tests, and news-tests workflows. |90| `api-tests.yml` | PR, push | API endpoint testing |91| `e2e-research-test.yml` | PR, push | End-to-end research flow |92| `followup-research-tests.yml` | PR, push | Follow-up research tests |93| `fuzz.yml` | Schedule | Fuzzing tests |9495### Security Scanning9697| Workflow | Trigger | Purpose |98|----------|---------|---------|99| `codeql.yml` | PR, push, schedule | GitHub CodeQL analysis |100| `semgrep.yml` | PR, push | Semgrep static analysis |101| `osv-scanner.yml` | PR, push, schedule | OSV vulnerability scanning (Python + npm) |102| `gitleaks.yml` | PR, push | Secret detection |103| `security-tests.yml` | PR, push | Security-focused test suite |104| `devskim.yml` | PR, push | Microsoft DevSkim analysis |105| `checkov.yml` | PR, push | Infrastructure-as-code scanning |106| `container-security.yml` | PR, push | Container vulnerability scanning |107| `hadolint.yml` | PR, push | Dockerfile linting |108| `owasp-zap-scan.yml` | Schedule | OWASP ZAP dynamic scanning |109| `retirejs.yml` | PR, push | JavaScript vulnerability scanning |110| `zizmor-security.yml` | PR, push | Additional security checks |111| `ossar.yml` | PR, push | OSSAR security analysis |112| `ossf-scorecard.yml` | Schedule | OpenSSF Scorecard |113| `security-headers-validation.yml` | PR, push | HTTP security headers |114| `security-file-write-check.yml` | PR, push | File write security |115| `npm-audit.yml` | PR, push | npm audit for JS dependencies |116117### Dependency Management118119| Workflow | Trigger | Purpose |120|----------|---------|---------|121| `dependency-review.yml` | PR | Review dependency changes |122| `update-dependencies.yml` | Schedule | Auto-update Python deps |123| `update-npm-dependencies.yml` | Schedule | Auto-update npm deps |124| `update-precommit-hooks.yml` | Schedule | Update pre-commit hooks |125| `validate-image-pinning.yml` | PR, push | Verify Docker image pins |126127### UI/Accessibility128129| Workflow | Trigger | Purpose |130|----------|---------|---------|131| `responsive-ui-tests-enhanced.yml` | PR, push | Responsive design tests |132133### Build & Deploy134135| Workflow | Trigger | Purpose |136|----------|---------|---------|137| `docker-publish.yml` | Release, push | Build and publish Docker images |138| `docker-multiarch-test.yml` | PR, push | Multi-architecture build test |139| `publish.yml` | Release | Publish to PyPI |140| `release.yml` | Manual | Create releases |141142### Code Quality143144| Workflow | Trigger | Purpose |145|----------|---------|---------|146| `pre-commit.yml` | PR, push | Run pre-commit hooks in CI |147| `mypy-type-check.yml` | PR, push | Python type checking |148| `ai-code-reviewer.yml` | PR | AI-assisted code review |149| `claude-code-review.yml` | PR | Claude-based code review |150151### Repository Management152153| Workflow | Trigger | Purpose |154|----------|---------|---------|155| `sync-main-to-dev.yml` | Push to main | Sync main branch to dev |156| `label-fixed-in-dev.yml` | Push to dev | Auto-label fixed issues |157| `danger-zone-alert.yml` | PR | Alert on sensitive file changes |158| `check-env-vars.yml` | PR, push | Environment variable validation |159| `file-whitelist-check.yml` | PR, push | File type validation |160| `version_check.yml` | PR, push | Version consistency check |161162---163164## Dependabot Configuration165166Dependabot automatically creates PRs for dependency updates:167168| Ecosystem | Directories | Schedule |169|-----------|-------------|----------|170| Python (pip) | `/` | Weekly (Monday 04:00) |171| npm | `/`, `/tests/*` | Weekly/Daily |172| GitHub Actions | `/` | Weekly |173| Docker | `/` | Daily |174175---176177## Coverage Reporting178179Coverage reports are generated by the `docker-tests.yml` workflow (pytest-tests job):180181- **HTML Report**: Deployed to GitHub Pages at `https://learningcircuit.github.io/local-deep-research/coverage/`182- **PR Comments**: Each PR receives a comment with coverage percentage183- **Badge**: Coverage badge updated via GitHub Gist184185Configuration in `pyproject.toml`:186```toml187[tool.coverage.run]188source = ["src"]189omit = ["*/tests/*", "*/migrations/*"]190191[tool.coverage.report]192exclude_lines = ["pragma: no cover", "if TYPE_CHECKING:"]193```194195---196197## Security Architecture198199### Supply Chain Security2002011. **Dependency Pinning**: All GitHub Actions use SHA256 digests2022. **Docker Image Pinning**: All base images use SHA256 digests2033. **Lock Files**: `pdm.lock` and `package-lock.json` committed2044. **Vulnerability Scanning**: OSV-Scanner, npm audit, RetireJS205206### Runtime Security2072081. **SSRF Protection**: `safe_get()`, `safe_post()`, `SafeSession` wrappers2092. **XSS Prevention**: DOMPurify for HTML sanitization2103. **SQL Injection**: SQLAlchemy ORM (no raw SQL)2114. **Secret Management**: Environment variables via `SettingsManager`212213### Container Security2142151. **Non-root User**: Containers run as `ldruser:1000`2162. **Minimal Base Image**: Python slim images2173. **Health Checks**: Docker health check endpoints2184. **Read-only Where Possible**: Minimal write permissions219220---221222## Running Tests Locally223224### Quick Test (Unit Tests Only)225```bash226pdm run pytest tests/test_settings_manager.py tests/test_utils.py -v227```228229### Full Test Suite230```bash231pdm run pytest tests/ --ignore=tests/ui_tests --ignore=tests/fuzz -v232```233234### With Coverage235```bash236pdm run pytest tests/ --cov=src --cov-report=html -v237open coverage/htmlcov/index.html238```239240### UI Tests (Requires Server)241```bash242# Terminal 1: Start server243pdm run ldr-web244245# Terminal 2: Run UI tests246cd tests/ui_tests && npm test247```248249---250251## Docker Testing252253Build and run tests in Docker:254255```bash256# Build test image257docker build --target ldr-test -t ldr-test .258259# Run tests260docker run --rm -v "$PWD":/app -w /app ldr-test \261 pytest tests/ --ignore=tests/ui_tests -v262```263264---265266## Environment Variables for CI267268| Variable | Purpose |269|----------|---------|270| `CI=true` | Indicates CI environment |271| `LDR_USE_FALLBACK_LLM=true` | Use mock LLM for tests |272| `LDR_TESTING_WITH_MOCKS=true` | Enable test mocks |273| `DISABLE_RATE_LIMITING=true` | Disable rate limits in tests |274275---276277## Adding New Workflows278279When adding a new workflow:2802811. Use pinned action versions with SHA256 digests2822. Add `permissions: {}` at top level (minimal permissions)2833. Add job-level permissions as needed2844. Include `step-security/harden-runner` step2855. Add workflow to this documentation286287Example template:288```yaml289name: New Workflow290291on:292 pull_request:293 branches: [main]294295permissions: {}296297jobs:298 example:299 runs-on: ubuntu-latest300 permissions:301 contents: read302303 steps:304 - name: Harden the runner305 uses: step-security/harden-runner@... # pinned306 with:307 egress-policy: audit308309 - uses: actions/checkout@... # pinned310 with:311 persist-credentials: false312```