#!/usr/bin/env fish
set DROP_IN_DBS yus migel ch_oddb
set ROLES_TO_DROP yus migel ch_oddb oddb
export GEN_DROP_OID="SELECT 'ALTER TABLE \"' || n.nspname || '\".\"' || c.relname || '\" SET WITHOUT OIDS;'
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE 1=1
  AND c.relkind = 'r'
  AND c.relhasoids = true
  AND n.nspname <> 'pg_catalog'
order by n.nspname, c.relname;"

for db in $DROP_IN_DBS
  echo Dropping all OID columns in database $db
  echo "$GEN_DROP_OID" >  tst_get_oid
  psql -t -p 5433 $db -f tst_get_oid > drop_oid_in_$db
  psql -t -p 5433 $db -f drop_oid_in_$db
end
for role in $ROLES_TO_DROP
  psql -t -p 5433 postgres -c "drop role $role"
end

echo Next command should only list the current user
psql -t -p 5433  postgres -c "SELECT CURRENT_USER;"
psql -t -p 5433  postgres -c "SELECT rolname FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_|postgres';"
echo Now we stop the old server
devenv processes stop