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 49295 from action_run_job
id
49295
run_id
27430
repo_id
82
owner_id
5
commit_sha
485856a88edf1b9b954664ecadd7dc88129c42b7
is_fork_pull_request
0
name
Runtime and UI acceptance
attempt
0
workflow_payload
name: Governance "on": pull_request:
name: Governance "on": pull_request: push: branches: - main jobs: runtime-acceptance: name: Runtime and UI acceptance runs-on: ubuntu-latest env: DATABASE_URL: postgresql://postgres:postgres@127.0.0.1:5432/juhai_ai_work_order_system_ci?schema=public REDIS_URL: redis://127.0.0.1:6379 S3_ENDPOINT: http://127.0.0.1:9000 S3_ACCESS_KEY_ID: juhai-ci S3_SECRET_ACCESS_KEY: juhai-ci-secret-change-me S3_ATTACHMENT_BUCKET: juhai-attachments S3_REGION: us-east-1 S3_FORCE_PATH_STYLE: "true" CLAMAV_HOST: 127.0.0.1 CLAMAV_PORT: "3310" steps: - name: Checkout uses: actions/checkout@v4 - name: Setup Node.js uses: actions/setup-node@v4 with: node-version: "20" - name: Enable pnpm run: | corepack enable corepack prepare pnpm@9.15.9 --activate - name: Prepare scoped package authentication run: node scripts/prepare-ci-npmrc.mjs env: GITEA_NPM_TOKEN: ${{ secrets.GITEA_NPM_TOKEN }} - name: Install dependencies run: pnpm install --frozen-lockfile env: NPM_CONFIG_USERCONFIG: ${{ runner.temp }}/juhai-ticket-npmrc - if: always() name: Remove temporary package authentication run: rm -f -- "${RUNNER_TEMP}/juhai-ticket-npmrc" - name: Generate Prisma clients run: pnpm prisma:generate - name: Start real S3 and antivirus acceptance infrastructure run: | set -euo pipefail docker run -d --name juhai-ci-minio -p 9000:9000 \ -e MINIO_ROOT_USER=juhai-ci \ -e MINIO_ROOT_PASSWORD=juhai-ci-secret-change-me \ quay.io/minio/minio@sha256:064117214caceaa8d8a90ef7caa58f2b2aeb316b5156afe9ee8da5b4d83e12c8 \ server /data docker run -d --name juhai-ci-clamav -p 3310:3310 \ clamav/clamav-debian@sha256:967334b92d1782e4d1314ddf903ae537d26792d21c9a39adecb8ac9757980514 for attempt in $(seq 1 60); do curl --fail --silent http://127.0.0.1:9000/minio/health/live && break if [[ "$attempt" == 60 ]]; then exit 1; fi sleep 2 done docker run --rm --network host \ quay.io/minio/mc@sha256:09f93f534cde415d192bb6084dd0e0ddd1715fb602f8a922ad121fd2bf0f8b44 \ sh -c 'mc alias set local http://127.0.0.1:9000 juhai-ci juhai-ci-secret-change-me && mc mb --ignore-existing local/juhai-attachments' for attempt in $(seq 1 90); do docker exec juhai-ci-clamav clamdscan --ping 1 && break if [[ "$attempt" == 90 ]]; then exit 1; fi sleep 3 done shell: bash - name: Run real DB and Redis acceptance run: pnpm check:runtime - name: Install Playwright browser run: pnpm --filter web exec playwright install --with-deps chromium - name: Run UI acceptance run: pnpm check:ui - name: Reconcile full governance evidence run: pnpm check:governance - name: Create verified logical backup run: bash scripts/backup-postgres.sh env: BACKUP_OUTPUT: ${{ runner.temp }}/juhai-ticket-ci.dump - name: Restore into an isolated database and verify governed facts run: | set -euo pipefail createdb --dbname="postgresql://postgres:postgres@127.0.0.1:5432/postgres" juhai_ai_work_order_system_restore_ci checksum="$(awk '{print $1}' "${RUNNER_TEMP}/juhai-ticket-ci.dump.sha256")" BACKUP_INPUT="${RUNNER_TEMP}/juhai-ticket-ci.dump" \ EXPECTED_SHA256="${checksum}" \ RESTORE_DATABASE_URL="postgresql://postgres:postgres@127.0.0.1:5432/juhai_ai_work_order_system_restore_ci" \ bash scripts/restore-postgres-drill.sh shell: bash services: postgres: image: pgvector/pgvector@sha256:ccc6e83d6e35e931dc7c5def2022729d5a6c370318d099181995567ff1fb4d6b env: POSTGRES_DB: juhai_ai_work_order_system_ci POSTGRES_PASSWORD: postgres POSTGRES_USER: postgres ports: - 5432:5432 options: --health-cmd "pg_isready -U postgres -d juhai_ai_work_order_system_ci" --health-interval 5s --health-timeout 5s --health-retries 20 redis: image: redis:7 ports: - 6379:6379 options: --health-cmd "redis-cli ping" --health-interval 5s --health-timeout 5s --health-retries 20
...
job_id
runtime-acceptance
needs
["static-governance"]
runs_on
["ubuntu-latest"]
task_id
0
status
3
started
0
stopped
1794738965
created
1794737485
updated
1794738965
raw_concurrency
is_concurrency_evaluated
0
concurrency_group
concurrency_cancel
0
Delete
Cancel