CI: Create GitHub Actions workflow for pytest and pre-commit

[db-tycoon-stephen]

Summary

Create a CI workflow that runs on every PR to main branch.

Requirements

• Run pytest (all 333+ tests)
• Run pre-commit (Black, YAML validation, secrets scanning)
• Block merge if tests fail

Technical Details

• File: .github/workflows/ci.yml
• Triggers: pull_request to main

Acceptance Criteria

• Workflow runs on PRs
• pytest executes all tests
• pre-commit checks pass
• PR blocked if tests fail

References

• v0.2 Proposal

[db-tycoon-stephen]

Blockers Identified

Before implementing this, we need to resolve:

1. Branch Strategy Decision

• Should features merge directly to main or accumulate in a v0.2 release branch?
• Need to define the release workflow before creating PRs

2. Test Scope for Public CI

• Unit tests with mocks will work fine
• But the public repo has sanitized dummy credentials
• Need to decide: run only mocked tests in public CI?

3. PR #9 Status

Draft PR #9 implements a basic version but is blocked pending these decisions.

---

Action needed: Decide on branch strategy and CI test scope before proceeding.

[db-tycoon-stephen]

✅ Blockers Resolved

Decisions made in #10:

• Branch strategy: Release branch (v0.2)
• CI scope: Unit tests + lint only (no snowddl-plan in public CI)

PR #9 updated to target v0.2 branch. Ready for review.

[db-tycoon-stephen]

Completed in PR #9