soroush.asadi
22 lines
941 B
YAML
22 lines
941 B
YAML
name: Diag
|
|
on:
|
|
push:
|
|
branches: [diag/admin-otp]
|
|
jobs:
|
|
admins:
|
|
name: "Diag · system admins"
|
|
runs-on: self-hosted
|
|
timeout-minutes: 4
|
|
env:
|
|
PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
|
|
steps:
|
|
- name: Dump SystemAdmins
|
|
run: |
|
|
set -eu
|
|
U=$(docker exec meezi-db env | grep '^POSTGRES_USER=' | cut -d= -f2)
|
|
D=$(docker exec meezi-db env | grep '^POSTGRES_DB=' | cut -d= -f2)
|
|
echo "=== SystemAdmins (phone / username / active / deleted / has-password) ==="
|
|
docker exec meezi-db psql -U "$U" -d "$D" -c "SELECT \"Id\", \"Phone\", \"Username\", \"IsActive\", \"DeletedAt\", (\"PasswordHash\" IS NOT NULL) AS has_pw, \"CreatedAt\" FROM \"SystemAdmins\" ORDER BY \"CreatedAt\";" || true
|
|
echo "=== count ==="
|
|
docker exec meezi-db psql -U "$U" -d "$D" -t -c "SELECT count(*) FROM \"SystemAdmins\";" || true
|