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 48852 from action_run_job
id
48852
run_id
27322
repo_id
116
owner_id
5
commit_sha
4564ab569c8a98021d58891203c247f1e6ba7b61
is_fork_pull_request
0
name
M1 identity transitional workspace (IdP static → E
M1 identity transitional workspace (IdP static → E2 → governance)
...
attempt
0
workflow_payload
name: Platform "on": pull_request:
name: Platform "on": pull_request: push: branches: [main] workflow_dispatch: env: GITEA_ACTIONS: "true" PNPM_VERSION: 9.15.9 jobs: identity: name: M1 identity transitional workspace (IdP static → E2 → governance) runs-on: ubuntu-latest env: # 库名前缀由 identity/package.json name 派生（enterprise_idp*）；Redis 必须 db 0（老框架 C22） DATABASE_URL: postgresql://postgres:postgres@127.0.0.1:5432/enterprise_idp_ci?schema=public REDIS_URL: redis://127.0.0.1:6379/0 if: ${{ github.event_name != 'pull_request' || github.event.pull_request.head.repo.full_name == github.repository }} steps: - name: Candidate tag (real run attempt, computed per job) run: | if ! [[ "${GITHUB_RUN_ATTEMPT:-}" =~ ^[1-9][0-9]*$ ]]; then echo "::error::GITHUB_RUN_ATTEMPT is missing or invalid on this runner; the candidate tag needs the real attempt (no fallback, decision 2026-10-11)" exit 1 fi echo "CANDIDATE_TAG=${GITHUB_SHA}-${GITHUB_RUN_ID}-${GITHUB_RUN_ATTEMPT}" >> "$GITHUB_ENV" - name: Prepare fixed Actions using existing read-only job token run: | python3 <<'PYTHON' import hashlib,os,pathlib,re,subprocess,tempfile,urllib.request sha=os.environ.get('GITHUB_SHA','') if not re.fullmatch('[0-9a-f]{40}',sha):raise RuntimeError('FIXED_SOURCE_REQUIRED') if os.environ.get('GITHUB_SERVER_URL','').rstrip('/')!='https://gitea.g-hi.com' or os.environ.get('GITHUB_REPOSITORY')!='luoanwu/enterprise-platform':raise RuntimeError('UNEXPECTED_ORIGIN') token=os.environ.get('CI_ACTION_READ_TOKEN','') if not token or any(c in token for c in '\r\n'):raise RuntimeError('JOB_TOKEN_REQUIRED') class NoRedirect(urllib.request.HTTPRedirectHandler): def redirect_request(self,*args,**kwargs):return None request=urllib.request.Request('https://gitea.g-hi.com/api/v1/repos/luoanwu/enterprise-platform/raw/ci/prepare-actions.py?ref='+sha,headers={'Authorization':'token '+token}) with urllib.request.build_opener(NoRedirect()).open(request,timeout=20) as response: data=response.read(65537) if len(data)>65536 or hashlib.sha256(data).hexdigest()!='2bcd53f681a4ce771cc5f5a8820eb65a07b197e210a5685d9f2331d505f39728':raise RuntimeError('BOOTSTRAP_2bcd53f681a4ce771cc5f5a8820eb65a07b197e210a5685d9f2331d505f39728_MISMATCH') with tempfile.TemporaryDirectory(prefix='verified-action-bootstrap-') as td: script=pathlib.Path(td,'prepare-actions.py');script.write_bytes(data) subprocess.run(['python3',str(script)],check=True,timeout=510) PYTHON shell: bash env: CI_ACTION_READ_TOKEN: ${{ github.token }} - uses: ./.git/ci-actions/checkout with: fetch-depth: "0" persist-credentials: "false" - name: Enable pnpm run: | corepack enable corepack prepare pnpm@${PNPM_VERSION} --activate - uses: ./.git/ci-actions/setup-node with: cache: pnpm cache-dependency-path: identity/pnpm-lock.yaml node-version: "20" - name: Private registry auth (temporary userconfig; shared runtime identity fixture dependencies) uses: ./.github/actions/private-npm with: token: ${{ secrets.PLATFORM_NPM_TOKEN }} - name: Install locked governance tools run: pnpm --dir governance install --frozen-lockfile --ignore-scripts - name: Install identity workspace (frozen lockfile) run: pnpm --dir identity install --frozen-lockfile - name: Build shared identity fixture dependencies from this checkout run: | pnpm --dir runtime install --frozen-lockfile --filter @juhai/module-identity... --filter @juhai/client-identity --filter api-nestjs pnpm --dir runtime --filter @juhai/module-identity prisma:generate pnpm --dir runtime exec turbo run build --filter=@juhai/module-identity... --filter=@juhai/client-identity... pnpm --dir identity --filter api-nestjs exec node -e "require('node:assert/strict').strictEqual(require('@juhai/module-kit'), require('../../../runtime/modules/kit'))" - name: Provision ordinary owner for the isolated identity test database run: | psql "${DATABASE_URL%%\?*}" -v ON_ERROR_STOP=1 <<'SQL' CREATE ROLE enterprise_idp_ci_rt LOGIN PASSWORD 'ci-test-only' NOSUPERUSER NOCREATEDB NOCREATEROLE NOBYPASSRLS; ALTER DATABASE enterprise_idp_ci OWNER TO enterprise_idp_ci_rt; ALTER SCHEMA public OWNER TO enterprise_idp_ci_rt; SQL echo 'DATABASE_URL=postgresql://enterprise_idp_ci_rt:ci-test-only@127.0.0.1:5432/enterprise_idp_ci?schema=public' >> "$GITHUB_ENV" - name: Generate Prisma clients run: pnpm --dir identity prisma:generate - name: IdP static sub-checks (independent of runtime / UI reports) run: pnpm identity:check:static - name: IdP real DB acceptance (single NestJS host, serialized) run: pnpm identity:check:runtime - name: Install Playwright browser run: pnpm --dir identity --filter web exec playwright install --with-deps chromium - name: IdP UI acceptance (single NestJS host) run: pnpm identity:check:ui - name: IdP final governance aggregation (same checkout, fresh runtime / UI reports) run: pnpm identity:check:governance - if: ${{ always() && env.CANDIDATE_TAG != '' }} name: Upload identity evidence uses: ./.git/ci-actions/upload-artifact with: if-no-files-found: warn name: platform-identity-${{ env.CANDIDATE_TAG }} path: identity/reports/*.latest.json retention-days: "30" timeout-minutes: "50" services: postgres: image: postgres:16 env: POSTGRES_DB: enterprise_idp_ci POSTGRES_PASSWORD: postgres POSTGRES_USER: postgres ports: - 5432:5432 options: --health-cmd "pg_isready -U postgres -d enterprise_idp_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 permissions: contents: read
...
job_id
identity
needs
["static"]
runs_on
["ubuntu-latest"]
task_id
0
status
3
started
0
stopped
1794416852
created
1794414732
updated
1794416852
raw_concurrency
is_concurrency_evaluated
0
concurrency_group
concurrency_cancel
0
Delete
Cancel