sqlite-web 0.7.2
gitea.db
action_run_job
Create
Query
access
access_token
action
action_artifact
action_run
action_run_index
action_run_job
action_runner
action_runner_token
action_schedule
action_schedule_spec
action_task
action_task_output
action_task_step
action_tasks_version
action_variable
app_state
attachment
auth_token
badge
branch
collaboration
comment
commit_status
commit_status_index
commit_status_summary
commit_sync_log
commit_sync_status
dbfs_data
dbfs_meta
deploy_key
email_address
email_hash
external_login_user
follow
gpg_key
gpg_key_import
hook_task
issue
issue_assignees
issue_content_history
issue_dependency
issue_index
issue_label
issue_pin
issue_user
issue_watch
label
language_stat
lfs_lock
lfs_meta_object
login_source
milestone
mirror
notice
notification
oauth2_application
oauth2_authorization_code
oauth2_grant
org_user
package
package_blob
package_blob_upload
package_cleanup_rule
package_file
package_property
package_version
project
project_board
project_issue
protected_branch
protected_tag
public_key
pull_auto_merge
pull_request
push_mirror
reaction
release
renamed_branch
repo_archiver
repo_hidden_file
repo_indexer_status
repo_license
repo_redirect
repo_topic
repo_transfer
repo_unit
repository
review
review_state
secret
session
sqlite_sequence
star
stopwatch
system_setting
task
team
team_invite
team_repo
team_unit
team_user
topic
tracked_time
two_factor
upload
user
user_badge
user_blocking
user_open_id
user_redirect
user_setting
version
watch
webauthn_credential
webhook
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Delete row 29690 from action_run_job
id
29690
run_id
22510
repo_id
6
owner_id
5
commit_sha
534799e0b1707368df37aff7b3df545a6ca1064a
is_fork_pull_request
0
name
migration-safety
attempt
1
workflow_payload
name: Database Migration Safety Check "on"
name: Database Migration Safety Check "on": push: paths: - 'backend/prisma/migrations/**' - 'backend/prisma/schema.prisma' - 'backend/prisma/schema/**' pull_request: paths: - 'backend/prisma/migrations/**' - 'backend/prisma/schema.prisma' - 'backend/prisma/schema/**' env: NODE_OPTIONS: --max-old-space-size=8192 jobs: migration-safety: name: migration-safety runs-on: ubuntu-latest steps: - name: Checkout code uses: actions/checkout@v4 - name: Install pnpm uses: pnpm/action-setup@v4 - name: Setup Node.js uses: actions/setup-node@v4 with: cache: pnpm node-version: "20" - name: Install dependencies run: pnpm install --frozen-lockfile working-directory: ./backend - name: Verify Prisma schema mirror run: pnpm run audit:prisma-schema-source working-directory: ./backend - name: Create PostgreSQL extensions on deploy DB run: | # 主部署库 psql -h localhost -U juhi -d juhi_revops_test -c "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" psql -h localhost -U juhi -d juhi_revops_test -c "CREATE EXTENSION IF NOT EXISTS pgcrypto;" psql -h localhost -U juhi -d juhi_revops_test -c "CREATE EXTENSION IF NOT EXISTS pg_trgm;" psql -h localhost -U juhi -d juhi_revops_test -c "CREATE EXTENSION IF NOT EXISTS vector;" env: PGPASSWORD: test_password - name: Create shadow DB for prisma migrate diff run: | # prisma migrate diff 在 ephemeral shadow DB 上 replay 历史 migrations， # 然后与 prisma/schema 文件夹真源对比生成 drift SQL。必须是独立空库，不能用 deploy DB psql -h localhost -U juhi -d postgres -c "CREATE DATABASE juhi_shadow_test;" psql -h localhost -U juhi -d juhi_shadow_test -c "CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";" psql -h localhost -U juhi -d juhi_shadow_test -c "CREATE EXTENSION IF NOT EXISTS pgcrypto;" psql -h localhost -U juhi -d juhi_shadow_test -c "CREATE EXTENSION IF NOT EXISTS pg_trgm;" psql -h localhost -U juhi -d juhi_shadow_test -c "CREATE EXTENSION IF NOT EXISTS vector;" env: PGPASSWORD: test_password - name: Run migration safety checks run: | # Run the comprehensive migration safety check ./scripts/ci-migration-check.sh env: DATABASE_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test DIRECT_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test - name: Validate Prisma schema run: | npx prisma validate working-directory: ./backend env: DATABASE_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test DIRECT_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test - name: Generate Prisma Client run: | npx prisma generate working-directory: ./backend env: DATABASE_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test DIRECT_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test - name: Migration deploy gate (HARD) run: | ./scripts/ci-migration-deploy-gate.sh env: DATABASE_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test DIRECT_URL: postgresql://juhi:test_password@localhost:5432/juhi_revops_test SHADOW_DATABASE_URL: postgresql://juhi:test_password@localhost:5432/juhi_shadow_test - if: always() name: Upload migration drift artifacts uses: actions/upload-artifact@v4 with: if-no-files-found: warn name: migration-drift-reports path: | reports/migration-drift-diff.latest.sql reports/migration-drift-summary.latest.json retention-days: "14" services: postgres: image: pgvector/pgvector:pg16 env: POSTGRES_DB: juhi_revops_test POSTGRES_PASSWORD: test_password POSTGRES_USER: juhi ports: - 5432:5432 options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
...
job_id
migration-safety
needs
null
runs_on
["ubuntu-latest"]
task_id
25873
status
2
started
1778639248
stopped
1778639279
created
1778624987
updated
1778639279
raw_concurrency
is_concurrency_evaluated
0
concurrency_group
concurrency_cancel
0
Delete
Cancel