#!/bin/sh
export PGPASSWORD=PYnuOIXNbkVOvdTL
P="psql -h 127.0.0.1 -U bgar1_delta_com -d bgar1_delta_com_ingredi"
$P -c "\copy (select u.id, u.username, u.email_address, u.private_display_name, u.public_display_name, u.perm_admin, u.account_disabled, u.last_authenticated_date, u.created_date from users u order by u.id) to '/tmp/.users.csv' csv header"
$P -c "\copy (select g.name as grp, u.username, u.email_address from auth_object_membership m join auth_object g on g.id=m.parent_id join users u on u.auth_object_id=m.child_id where g.type=2 order by g.name, u.username) to '/tmp/.groups.csv' csv header"
$P -c "\copy (select team_id, team_name from support_desk_teams order by 1) to '/tmp/.teams.csv' csv header"
wc -l /tmp/.users.csv /tmp/.groups.csv /tmp/.teams.csv
head -4 /tmp/.users.csv
echo "== groups top"
cut -d, -f1 /tmp/.groups.csv | sort | uniq -c | sort -rn | head -20
