# export from Bugfest env.
\copy fs00001000_mod_login.auth_credentials(_id, jsonb) to ~/hji/export/logins2.tsv (delimiter E'\t');
\copy fs00001000_mod_permissions.permissions_users(_id, jsonb) to ~/hji/export/perms2.tsv (delimiter E'\t');
\copy fs00001000_mod_users.users(id, jsonb) to ~/hji/export/names2.tsv (delimiter E'\t');
\copy fs00001000_mod_inventory_storage.service_point_user to ~/hji/export/servicePointsUsers2.tsv (delimiter E'\t');
# change Bugfest admin to admin2
sed -i s/"admin"/"admin2"/g names.tsv
# change address types
sed -i s/6731169b-90e3-4dfe-8403-948c4432c3fc/59bfdaf5-dcbc-4193-9340-885234872eb6/g names2.tsv
sed -i s/2400fbeb-b369-45f3-8de0-362ce5d114a4/ae749f82-a4ef-47ca-b29c-0a5ad7bbff03/g names2.tsv
# change patron groups
sed -i s/211a3d2f-1976-4cd6-bee4-9b093f87f515/97d25c0c-3c18-4683-8b4a-979f5b6db2bf/g names2.tsv
sed -i s/c38708e6-e75a-4e01-bbd7-9ed0ff5bd0b9/a7f4cac3-884a-47be-aef6-ec886a17b164/g names2.tsv
sed -i s/2a469406-c7c9-4283-b752-175c21404648/a7f4cac3-884a-47be-aef6-ec886a17b164/g names2.tsv
sed -i s/4a34b923-2f07-41e9-97db-0224ceb5410c/b0c005d5-599f-4839-b3f7-63000915cfc3/g names2.tsv
sed -i s/ac4646cb-9a26-4f63-8acc-d07b6a6755e8/6e50e769-3e07-45f5-a7e2-d83f13d7402b/g names2.tsv
sed -i s/94adb2e8-f002-4e1a-ab51-d9225129f330/5464cbd9-2c7d-4286-8e89-20c75980884b/g names2.tsv
sed -i s/642f497b-4aea-4b53-b0f8-cb9a91393b5b/5464cbd9-2c7d-4286-8e89-20c75980884b/g names2.tsv
# change service end points
sed -i s/b06364e4-b98c-48f2-a8fc-141685a9140d/3a40852d-49fd-4df2-a1f9-6e2641a6e91f/g servicePointsUsers2.tsv
sed -i s/67021699-24a0-48d9-aa66-212f1ccbeb0f/3a40852d-49fd-4df2-a1f9-6e2641a6e91f/g servicePointsUsers2.tsv
sed -i s/c546871b-4860-49c7-ab73-6282d361f601/3a40852d-49fd-4df2-a1f9-6e2641a6e91f/g servicePointsUsers2.tsv
sed -i s/3c6c995e-23a0-469e-9775-121ad92d7092/3a40852d-49fd-4df2-a1f9-6e2641a6e91f/g servicePointsUsers2.tsv
sed -i s/425c1280-476e-4ce7-921f-3bc945d6a962/3a40852d-49fd-4df2-a1f9-6e2641a6e91f/g servicePointsUsers2.tsv
sed -i s/d18c7b5a-d20f-4e9d-8776-a12ad91a4c26/c4c90014-c8c9-4ade-8f24-b5e313319f4b/g servicePointsUsers2.tsv
sed -i s/582a28b8-0956-4608-8130-8022d8964756/c4c90014-c8c9-4ade-8f24-b5e313319f4b/g servicePointsUsers2.tsv
sed -i s/3a40852d-49fd-4df2-a1f9-6e2641a6e91f/c4c90014-c8c9-4ade-8f24-b5e313319f4b/g servicePointsUsers2.tsv
sed -i s/c4c90014-c8c9-4ade-8f24-b5e313319f4b/c4c90014-c8c9-4ade-8f24-b5e313319f4b/g servicePointsUsers2.tsv
sed -i s/b487749c-e10f-4c89-a1ff-f431fbce14ea/c4c90014-c8c9-4ade-8f24-b5e313319f4b/g servicePointsUsers2.tsv
# append new files to old
cat logins2.tsv >> logins.tsv
cat names2.tsv >> names.tsv
cat perms2.tsv >> perms.tsv
cat servicePointsUsers2.tsv >> servicePointsUsers.tsv