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 29718 from action_run_job
id
29718
run_id
22516
repo_id
6
owner_id
5
commit_sha
534799e0b1707368df37aff7b3df545a6ca1064a
is_fork_pull_request
0
name
pr-validation
attempt
1
workflow_payload
name: E2E Tests "on": # PR validation
name: E2E Tests "on": # PR validation - 运行关键测试 pull_request: branches: [main, develop] paths: - 'frontend/**' - 'backend/**' - 'e2e/**' - 'package.json' - 'pnpm-lock.yaml' # Push to main - 运行完整测试套件 push: branches: [main] # 每日定时全量测试 (UTC 时间 00:00 = 北京时间 08:00) schedule: - cron: '0 0 * * *' # 手动触发 workflow_dispatch: inputs: test_suite: description: 'Test suite to run' required: true default: 'all' type: choice options: - all - critical - business-flows - visual-regression - performance env: E2E_SKIP_WEB_SERVER: "true" NODE_OPTIONS: --max-old-space-size=8192 NODE_VERSION: "20" PNPM_VERSION: "9" jobs: pr-validation: name: pr-validation runs-on: ubuntu-latest if: github.event_name == 'pull_request' steps: - name: Checkout code uses: actions/checkout@v4 - name: Setup pnpm uses: pnpm/action-setup@v4 - name: Setup Node.js uses: actions/setup-node@v4 with: cache: pnpm node-version: ${{ env.NODE_VERSION }} - name: Install dependencies run: pnpm install --frozen-lockfile - name: Setup test database run: | cd backend npx prisma migrate deploy npx prisma db seed env: DATABASE_URL: postgresql://test_user:test_password@localhost:5432/juhi_test DIRECT_URL: postgresql://test_user:test_password@localhost:5432/juhi_test - name: Build backend run: | cd backend npm run build:fast - name: Build frontend run: | cd frontend npm run build - name: Install Playwright Browsers run: | for attempt in 1 2 3; do pnpm --filter @juhi/e2e exec playwright install --with-deps chromium && exit 0 sleep $((attempt * 20)) done pnpm --filter @juhi/e2e exec playwright install --with-deps chromium - name: Start backend server run: | cd backend npm run start & sleep 10 env: DATABASE_URL: postgresql://test_user:test_password@localhost:5432/juhi_test DIRECT_URL: postgresql://test_user:test_password@localhost:5432/juhi_test REDIS_URL: redis://localhost:6379 NODE_ENV: test - name: Start frontend server run: | cd frontend npm run preview & sleep 5 env: VITE_API_URL: http://localhost:3000 - name: Run critical E2E tests run: | cd e2e npx playwright test \ tests/auth/login.spec.ts \ tests/navigation/full-menu-click.spec.ts \ tests/multi-tenant/data-isolation.spec.ts \ tests/form-interactions/ \ --reporter=html env: E2E_BASE_URL: http://localhost:5173 E2E_TEST_USER: admin@juhi.com E2E_TEST_PASSWORD: Admin@123 - if: always() name: Upload test results uses: actions/upload-artifact@v4 with: name: playwright-report-pr path: e2e/playwright-report/ retention-days: "7" - if: always() && github.event_name == 'pull_request' name: Comment PR with test results uses: actions/github-script@v7 with: script: | const fs = require('fs'); const reportPath = 'e2e/playwright-report/index.html'; const testsPassed = !fs.existsSync('e2e/test-results/'); const comment = testsPassed ? '✅ E2E 测试通过！' : '❌ E2E 测试失败，请查看报告'; github.rest.issues.createComment({ issue_number: context.issue.number, owner: context.repo.owner, repo: context.repo.repo, body: comment }); timeout-minutes: "45" services: postgres: image: pgvector/pgvector:pg16 env: POSTGRES_DB: juhi_test POSTGRES_PASSWORD: test_password POSTGRES_USER: test_user ports: - 5432:5432 options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5 redis: image: redis:7 ports: - 6379:6379 options: --health-cmd "redis-cli ping" --health-interval 10s --health-timeout 5s --health-retries 5 permissions: contents: read pull-requests: write # github-script 评论 E2E 测试结果 checks: write issues: write
...
job_id
pr-validation
needs
null
runs_on
["ubuntu-latest"]
task_id
25894
status
4
started
1778639468
stopped
1778639468
created
1778636051
updated
1778639468
raw_concurrency
is_concurrency_evaluated
0
concurrency_group
concurrency_cancel
0
Delete
Cancel