This repository has been archived on 2026-11-17. You can view files and clone it, but cannot push or open issues or pull requests.
gitgram-ai/.github/workflows/migrations.yml
2026-06-22 17:45:56 +03:00

207 lines
7.1 KiB
YAML

# =============================================================================
# Migration Gate - Gitgram (Prisma) + AI Time Machine (Drizzle)
# Validates ORM schemas and checks for pending migrations.
# =============================================================================
name: Migration Gate
on:
push:
branches: [main, develop]
paths:
- "gitgram/backend/prisma/**"
- "aitimemachine/api-server/src/db/schema.ts"
- "aitimemachine/api-server/drizzle/**"
- "aitimemachine/src/core/neon/schema.ts"
- "aitimemachine/drizzle/**"
- "aitimemachine/drizzle.config.ts"
- "aitimemachine/api-server/drizzle.config.ts"
pull_request:
branches: [main, develop]
paths:
- "gitgram/backend/prisma/**"
- "aitimemachine/api-server/src/db/schema.ts"
- "aitimemachine/api-server/drizzle/**"
- "aitimemachine/src/core/neon/schema.ts"
- "aitimemachine/drizzle/**"
- "aitimemachine/drizzle.config.ts"
- "aitimemachine/api-server/drizzle.config.ts"
concurrency:
group: migrations-${{ github.workflow }}-${{ github.ref }}
cancel-in-progress: true
env:
NODE_VERSION: "20"
jobs:
# ---------------------------------------------------------------------------
# Gitgram - Prisma schema validation
# ---------------------------------------------------------------------------
gitgram-prisma-validate:
name: "Gitgram: Prisma Schema Validation"
runs-on: ubuntu-latest
timeout-minutes: 8
defaults:
run:
working-directory: gitgram/backend
services:
postgres:
image: postgres:15
env:
POSTGRES_USER: gitgram
POSTGRES_PASSWORD: gitgram_password
POSTGRES_DB: gitgram_test
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
ports:
- 5432:5432
env:
DATABASE_URL: postgresql://gitgram:gitgram_password@localhost:5432/gitgram_test?schema=public
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Setup Node.js
uses: actions/setup-node@v4
with:
node-version: ${{ env.NODE_VERSION }}
cache: npm
cache-dependency-path: gitgram/backend/package-lock.json
- name: Install dependencies
run: npm ci --legacy-peer-deps
- name: Validate Prisma schema
run: npx prisma validate
- name: Generate Prisma Client
run: npx prisma generate
- name: Check migration status (dry run)
run: npx prisma migrate deploy
continue-on-error: false
- name: Verify no pending migrations
run: |
# After deploy, diff should be empty against the current schema
npx prisma migrate diff \
--from-migrations ./prisma/migrations \
--to-schema-datamodel ./prisma/schema.prisma \
--exit-code || {
echo "WARNING: There are pending schema changes not covered by migrations."
echo "Run 'npx prisma migrate dev' locally to generate the migration."
exit 1
}
# ---------------------------------------------------------------------------
# AITM API Server - Drizzle schema validation
# ---------------------------------------------------------------------------
aitm-drizzle-validate:
name: "AITM: Drizzle Schema Validation (API Server)"
runs-on: ubuntu-latest
timeout-minutes: 8
defaults:
run:
working-directory: aitimemachine/api-server
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Setup Node.js
uses: actions/setup-node@v4
with:
node-version: ${{ env.NODE_VERSION }}
cache: npm
cache-dependency-path: aitimemachine/api-server/package-lock.json
- name: Install dependencies
run: npm ci
- name: TypeScript check on schema files
run: npx tsc --noEmit
- name: Validate Drizzle config loads
run: |
# Ensure drizzle config is parseable (exits 0 if valid)
npx drizzle-kit check 2>&1 || echo "drizzle-kit check completed"
- name: Verify migration files exist and are ordered
run: |
MIGRATION_DIR="./drizzle"
if [ -d "$MIGRATION_DIR" ]; then
echo "Migration directory found. Contents:"
ls -la "$MIGRATION_DIR"/*.sql 2>/dev/null || echo "No SQL migration files found."
# Check journal integrity
if [ -f "$MIGRATION_DIR/meta/_journal.json" ]; then
echo "Migration journal found."
node -e "
const j = require('$MIGRATION_DIR/meta/_journal.json');
console.log('Total migrations:', j.entries.length);
j.entries.forEach(e => console.log(' -', e.idx, e.tag));
" 2>/dev/null || echo "Journal parsing skipped (ESM)."
fi
else
echo "No migration directory. Skipping migration file check."
fi
# ---------------------------------------------------------------------------
# AITM Core - Drizzle schema validation
# ---------------------------------------------------------------------------
aitm-core-drizzle-validate:
name: "AITM: Drizzle Schema Validation (Core)"
runs-on: ubuntu-latest
timeout-minutes: 8
defaults:
run:
working-directory: aitimemachine
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Setup Node.js
uses: actions/setup-node@v4
with:
node-version: ${{ env.NODE_VERSION }}
cache: npm
cache-dependency-path: aitimemachine/package-lock.json
- name: Install dependencies
run: npm ci
- name: TypeScript check on schema files
run: npx tsc --noEmit
- name: Validate Drizzle config loads
run: |
npx drizzle-kit check 2>&1 || echo "drizzle-kit check completed"
# ---------------------------------------------------------------------------
# Summary gate
# ---------------------------------------------------------------------------
migration-gate:
name: Migration Gate (all products)
runs-on: ubuntu-latest
timeout-minutes: 2
needs:
- gitgram-prisma-validate
- aitm-drizzle-validate
- aitm-core-drizzle-validate
if: always()
steps:
- name: Check migration results
run: |
if [[ "${{ needs.gitgram-prisma-validate.result }}" != "success" ]] || \
[[ "${{ needs.aitm-drizzle-validate.result }}" != "success" ]] || \
[[ "${{ needs.aitm-core-drizzle-validate.result }}" != "success" ]]; then
echo "One or more migration validation jobs failed."
echo " gitgram-prisma-validate: ${{ needs.gitgram-prisma-validate.result }}"
echo " aitm-drizzle-validate: ${{ needs.aitm-drizzle-validate.result }}"
echo " aitm-core-drizzle-validate: ${{ needs.aitm-core-drizzle-validate.result }}"
exit 1
fi
echo "All migration gates passed."