feat: SDLC database separation for CI/testing #35

Merged

david merged 12 commits from feat/e2e-test-improvements into main 2026-05-11 06:40:06 +00:00

Conversation 3 Commits 12 Files Changed 16

+792 -196

david commented 2026-05-04 00:11:36 +00:00

Owner

Copy Link

Copy Source

Summary

• Fix isProductionDatabase() to allow CI database (euchre_camp_ci)
• Add database schema reset before CI test runs
• Create global.teardown.ts for cleanup (CI: full reset, dev/prod: selective cleanup)
• Add acceptance-tests job to PR workflow with CI database
• Create sync-prod-to-dev.js script for one-way prod→dev sync
• Add just recipes: sync-dev, test-prod, reset-ci-db
• Store credentials in .credentials (gitignored) with unique CI user

Testing

Verified against CI database:

• Schema reset works
• Migrations apply correctly
• Test users created successfully
• 219 tests pass (slow but working)

Next Steps

• Set CI_DATABASE_URL as Gitea repository variable

## Summary - Fix `isProductionDatabase()` to allow CI database (`euchre_camp_ci`) - Add database schema reset before CI test runs - Create `global.teardown.ts` for cleanup (CI: full reset, dev/prod: selective cleanup) - Add `acceptance-tests` job to PR workflow with CI database - Create `sync-prod-to-dev.js` script for one-way prod→dev sync - Add `just` recipes: `sync-dev`, `test-prod`, `reset-ci-db` - Store credentials in `.credentials` (gitignored) with unique CI user ## Testing Verified against CI database: - Schema reset works - Migrations apply correctly - Test users created successfully - 219 tests pass (slow but working) ## Next Steps - Set `CI_DATABASE_URL` as Gitea repository variable

david added 6 commits 2026-05-04 00:11:36 +00:00

feat: add home page and rankings E2E tests with workflow improvements a9138cfbe4

docs: update .env.example with SDLC environment documentation 66e574d5ec

fix: correct isProductionDatabase() to allow CI database and add schema reset fa13ed86c9

feat: add global teardown config and disable webServer in CI 75cb6ed29d

ci: add acceptance tests job with CI database and sync-dev recipe 30ea4e4e86

fix: add PrismaPg adapter for PostgreSQL and fix GRANT statements f27efebd82

david added 1 commit 2026-05-04 00:35:51 +00:00

fix: correct CI test configuration and Navigation test provider ... 413ebaeaee

- Wrap Navigation tests in RoleSwitcherProvider to fix 6 test failures
- Use remote CI server URL (euchre-ci.notsosm.art) for acceptance tests in CI
- Fix DATABASE_URL reference from vars to secrets in PR workflow

gitea-actions bot commented 2026-05-04 00:37:29 +00:00

Copy Link

Copy Source

🏷️ Version Bump Analysis

Suggested bump type: PATCH
Reason: Defaulting to patch (fixes or other changes)

This PR will bump the version to the next patch version when merged.

## 🏷️ Version Bump Analysis **Suggested bump type:** `PATCH` **Reason:** Defaulting to patch (fixes or other changes) This PR will bump the version to the next patch version when merged.

david added 1 commit 2026-05-04 01:04:03 +00:00

ci: reduce retries to 1 and increase workers to 2 ... b1c4e9a0ce

- Retries reduced from 2 to 1 (retries are helping with flaky remote tests but 2 is overkill)
- Workers increased from 1 to 2 in CI for parallel project execution

gitea-actions bot commented 2026-05-04 01:05:21 +00:00

Copy Link

Copy Source

🏷️ Version Bump Analysis

Suggested bump type: PATCH
Reason: Defaulting to patch (fixes or other changes)

This PR will bump the version to the next patch version when merged.

## 🏷️ Version Bump Analysis **Suggested bump type:** `PATCH` **Reason:** Defaulting to patch (fixes or other changes) This PR will bump the version to the next patch version when merged.

gitea-actions bot commented 2026-05-07 08:49:47 +00:00

Copy Link

Copy Source

🏷️ Version Bump Analysis

Suggested bump type: PATCH
Reason: Defaulting to patch (fixes or other changes)

This PR will bump the version to the next patch version when merged.

## 🏷️ Version Bump Analysis **Suggested bump type:** `PATCH` **Reason:** Defaulting to patch (fixes or other changes) This PR will bump the version to the next patch version when merged.

david added 1 commit 2026-05-07 09:30:37 +00:00

feat: implement full CI/CD pipeline with staged deployments ... ac8562ea51

- PR workflow: build, deploy to CI site, wait for health, run acceptance tests
- Release workflow: deploy to dev using mounted compose path with health check
- Add deploy-prod workflow (workflow_dispatch) for human-gated prod deployment
- Add just recipes: deploy-prod, status (view current image tags across envs)
- Runners now have /apps mount for access to all environment compose files

david added 1 commit 2026-05-07 10:10:53 +00:00

sanitize docker tags e602e83642

david added 1 commit 2026-05-07 10:16:19 +00:00

remove push on ci build 48b524ef84

david added 1 commit 2026-05-07 10:25:54 +00:00

fix: remove unused prisma import causing DATABASE_URL error in CI 820b1d8d84

david merged commit 861e14503b into main 2026-05-11 06:40:06 +00:00

david deleted branch feat/e2e-test-improvements 2026-05-11 06:40:06 +00:00

Sign in to join this conversation.

Reviewers

No Reviewers

Labels

Clear labels

bug

Something isn't working

epic:admin-dashboard

Admin dashboard features

epic:authentication

Authentication and authorization

epic:player-features

Player-facing features

epic:tournament-management

Tournament management features

feature

New functionality

priority:high

High priority issue

ui

User interface changes

visualization

Data visualization

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

sara david

No Assignees

2 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: david/euchre_camp#35