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 7037 from action_run_job
id
7037
run_id
6116
repo_id
2
owner_id
2
commit_sha
14b0bd31fd78217bc8d4e3e9675385deef19fcf2
is_fork_pull_request
0
name
deploy
attempt
1
workflow_payload
name: Smart Deploy via Rsync Daemon "on":
name: Smart Deploy via Rsync Daemon "on": [push] jobs: deploy: name: deploy runs-on: ubuntu-latest steps: - name: Checkout code manually run: | # 调试输出 echo "GITEA_HOST: $GITEA_HOST" echo "GITHUB_REPOSITORY: ${{ github.repository }}" echo "GITHUB_SHA: ${{ github.sha }}" if [ -z "$GITEA_HOST" ]; then echo "❌ GITEA_HOST secret is missing!" exit 1 fi # 使用 github 上下文变量 REPO="${{ github.repository }}" SHA="${{ github.sha }}" if [ -z "$REPO" ] || [ -z "$SHA" ]; then echo "❌ Missing GITHUB_REPOSITORY or GITHUB_SHA" exit 1 fi REPO_URL="https://${GITEA_TOKEN}@${GITEA_HOST}/${REPO}.git" echo "Cloning from: ${REPO_URL//${GITEA_TOKEN}/***REDACTED***} (SHA: $SHA)" git init git remote add origin "$REPO_URL" git fetch --depth=2 origin "$SHA" git checkout "$SHA" env: GITEA_HOST: ${{ secrets.GITEAS_HOST }} GITEA_TOKEN: ${{ secrets.GITEAS_TOKEN }} - name: Prepare rsync password file (HARDCODED for test) run: | echo "m9QNiLJ8LIqBozXwmsoKdNXa23xia34R" > /tmp/rsync.pass chmod 600 /tmp/rsync.pass echo "✅ /tmp/rsync.pass created with password 'm9QNiLJ8LIqBozXwmsoKdNXa23xia34R'" - name: Get commit message and decide sync mode run: "COMMIT_MSG=$(git log -1 --pretty=%B | head -n1)\necho \"Commit message: $COMMIT_MSG\"\n\nRSYNC_TARGET=\"rsync://${RSYNC_USER}@${RSYNC_HOST}/${RSYNC_MODULE}/\"\n\nif [[ \"$COMMIT_MSG\" == *\"全量同步\"* ]] || [[ \"$COMMIT_MSG\" == *\"full sync\"* ]]; then\n echo \"\U0001F50D Full sync requested...\"\n /usr/bin/rsync -avz --no-owner --no-group --delete \\\n --exclude='.git' \\\n --exclude='.gitea' \\\n --exclude='node_modules/' \\\n --password-file=/tmp/rsync.pass \\\n ./ \\\n \"$RSYNC_TARGET\"\nelse\n echo \"\U0001F504 Incremental sync...\"\n\n if git rev-parse HEAD~1 >/dev/null 2>&1; then\n git diff --name-only HEAD~1 HEAD > /tmp/changed.txt\n else\n find . -type f -not -path './.git/*' -not -path './.gitea/*' | sed 's|^\\./||' > /tmp/changed.txt\n fi\n\n if [ -s /tmp/changed.txt ]; then\n echo \"Files to sync:\"\n cat /tmp/changed.txt\n\n /usr/bin/rsync -avz --no-owner --no-group --relative \\\n --files-from=/tmp/changed.txt \\\n --password-file=/tmp/rsync.pass \\\n ./ \\\n \"$RSYNC_TARGET\"\n else\n echo \"✅ No files changed.\"\n fi\nfi\n" env: RSYNC_HOST: "172.17.70.241" RSYNC_USER: "ahead_rsync_user" RSYNC_MODULE: "ftp" - if: always() name: Clean up run: rm -f /tmp/rsync.pass
...
job_id
deploy
needs
null
runs_on
["ubuntu-latest"]
task_id
6123
status
1
started
1773663554
stopped
1773663557
created
1773663552
updated
1773663557
raw_concurrency
NULL
is_concurrency_evaluated
NULL
concurrency_group
concurrency_cancel
0
Delete
Cancel