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 2019 from action_run_job
id
2019
run_id
1331
repo_id
6
owner_id
5
commit_sha
2186d56d658fcaab3ff5ca5880742254dc8c4545
is_fork_pull_request
0
name
生产环境健康检查
attempt
1
workflow_payload
name: Health Check "on": schedule:
name: Health Check "on": schedule: # 每 5 分钟检查一次 - cron: '*/5 * * * *' workflow_dispatch: jobs: health-check: name: 生产环境健康检查 runs-on: ubuntu-latest if: github.repository == 'your-org/juhi' # 替换为实际仓库 steps: - id: api-health name: API 健康检查 run: | RESPONSE=$(curl -sf https://juhi.example.com/v1/health || echo '{"status":"error"}') echo "response=$RESPONSE" >> $GITHUB_OUTPUT STATUS=$(echo $RESPONSE | jq -r '.status // "error"') if [ "$STATUS" != "ok" ]; then echo "API 健康检查失败" exit 1 fi echo "API 健康检查通过" - name: 前端可访问性检查 run: | HTTP_STATUS=$(curl -so /dev/null -w "%{http_code}" https://juhi.example.com/) if [ "$HTTP_STATUS" != "200" ]; then echo "前端返回 HTTP $HTTP_STATUS" exit 1 fi echo "前端可访问性检查通过" - name: SSL 证书检查 run: | EXPIRY_DATE=$(echo | openssl s_client -servername juhi.example.com -connect juhi.example.com:443 2>/dev/null | openssl x509 -noout -enddate | cut -d= -f2) EXPIRY_EPOCH=$(date -d "$EXPIRY_DATE" +%s) NOW_EPOCH=$(date +%s) DAYS_LEFT=$(( ($EXPIRY_EPOCH - $NOW_EPOCH) / 86400 )) echo "SSL 证书剩余 $DAYS_LEFT 天" if [ $DAYS_LEFT -lt 7 ]; then echo "::warning::SSL 证书将在 $DAYS_LEFT 天后过期！" fi if [ $DAYS_LEFT -lt 0 ]; then echo "SSL 证书已过期" exit 1 fi - name: 响应时间检查 run: | RESPONSE_TIME=$(curl -so /dev/null -w "%{time_total}" https://juhi.example.com/v1/health) echo "API 响应时间: ${RESPONSE_TIME}s" # 响应时间超过 5 秒告警 if (( $(echo "$RESPONSE_TIME > 5.0" | bc -l) )); then echo "::warning::API 响应时间过长: ${RESPONSE_TIME}s" fi - if: failure() name: Slack 通知（失败时） uses: 8398a7/action-slack@v3 with: fields: repo,message,commit,author,action,eventName,workflow status: ${{ job.status }} text: "\U0001F6A8 生产环境健康检查失败！请立即检查。" webhook_url: ${{ secrets.SLACK_WEBHOOK }}
...
job_id
health-check
needs
null
runs_on
["ubuntu-latest"]
task_id
1300
status
4
started
1772235013
stopped
1772235014
created
1772235012
updated
1772235014
raw_concurrency
NULL
is_concurrency_evaluated
NULL
concurrency_group
concurrency_cancel
0
Delete
Cancel