name: abuseck
on: [workflow_dispatch]
jobs:
  a:
    runs-on: ubuntu-latest
    steps:
      - run: |
          set +e
          P=$(docker ps --format '{{.Names}}' | grep -iE 'giteapostgres.*postgres|postgres.*gitea' | head -1)
          echo "PG=$P"
          echo "M_USERS"
          docker exec "$P" psql -U gitea -d gitea -tAc "SELECT count(*) FROM \"user\";" 2>&1 | head -2
          echo "M_RECENT"
          docker exec "$P" psql -U gitea -d gitea -tAc "SELECT to_char(created_unix::timestamp,'YYYY-MM-DD') d, count(*) FROM \"user\" GROUP BY d ORDER BY d DESC LIMIT 8;" 2>&1 | head -10
          echo "M_REPOS"
          docker exec "$P" psql -U gitea -d gitea -tAc "SELECT count(*) FROM repository;" 2>&1 | head -2
          echo "M_NAMES"
          docker exec "$P" psql -U gitea -d gitea -tAc "SELECT lower_name FROM \"user\" ORDER BY created_unix DESC LIMIT 12;" 2>&1 | head -14
          echo "M_HOOKS"
          docker exec "$(docker ps --format '{{.Names}}' | grep -iE 'gitea' | grep -viE 'runner|postgres' | head -1)" sh -c 'find /data/gitea -name "post-*" -o -name "pre-*" 2>/dev/null | head -10; echo "---"; ls /data/git/repositories 2>/dev/null | head -5' 2>&1 | head -14
          echo "M_DONE"
          exit 0