Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- varun-folio@varunfolio-VirtualBox:~/gse-hosting-operations/gse.hosting.operations/db-populate$ ./bin/populate.sql 5kItems.manifest psql.conf diku
- =================================================
- PGUSER: folio_admin
- PGPASSWORD: folio_admin
- PGDATABASE: okapi_modules
- PGHOST: 10.0.2.2
- PGPORT: 5432
- TENANT: diku
- USERS: datasets/5kItems/names.tsv
- USER_GROUPS: datasets/common/groups.tsv
- LOGINS: datasets/5kItems/logins.tsv
- PERMS: datasets/5kItems/perms.tsv
- MATERIALS: datasets/common/materials.tsv
- LOAN_TYPES: datasets/common/loanTypes.tsv
- ITEMS: datasets/5kItems/items.tsv
- CIRCULATION: datasets/5kItems/circulate.tsv
- REQUESTS: datasets/5kItems/requests.tsv
- NOTES: datasets/5kItems/notes.tsv
- INSTANCES: datasets/5kItems/instances.tsv
- NOTIFICATIONS: datasets/5kItems/notifications.tsv
- SHELF_LOCATIONS: datasets/common/locations.tsv
- INSTANCE_TYPES: datasets/common/instanceTypes.tsv
- IDENTIFIER_TYPES: datasets/common/identifierTypes.tsv
- RECORD_HOLDINGS: datasets/5kItems/recordholdings.tsv
- ==================================================
- DELETE 1229
- DELETE 199
- DELETE 163
- DELETE 13
- DELETE 163
- DELETE 5
- DELETE 49997
- DELETE 10
- DELETE 4
- DELETE 47745
- DELETE 47745
- DELETE 2
- DELETE 0
- DELETE 15
- DELETE 193
- DELETE 586
- COMMIT
- copy diku_mod_users.groups(id, jsonb) FROM 'datasets/common/groups.tsv' DELIMITER E'\t'
- COPY 5
- copy diku_mod_users.addresstype(id, jsonb) FROM 'datasets/common/addressTypes.tsv' DELIMITER E'\t'
- ERROR: duplicate key value violates unique constraint "addresstype_pkey"
- DETAIL: Key (id)=(c3840f08-9c94-4ba3-972f-e5696a085f25) already exists.
- CONTEXT: COPY addresstype, line 1: "c3840f08-9c94-4ba3-972f-e5696a085f25 {"addressType" : "Payment", "desc" : "Payment Address"}"
- copy diku_mod_users.users(id, jsonb) FROM 'datasets/5kItems/names.tsv' DELIMITER E'\t'
- COPY 163
- copy diku_mod_login.auth_credentials(jsonb) FROM datasets/5kItems/logins.tsv DELIMITER E'\t'
- COPY 13
- copy diku_mod_permissions.permissions_users(_id, jsonb) FROM 'datasets/5kItems/perms.tsv' DELIMITER E'\t'
- COPY 163
- copy diku_mod_inventory_storage.identifier_type(_id, jsonb) FROM 'datasets/common/identifierTypes.tsv' DELIMITER E'\t'
- COPY 15
- copy diku_mod_inventory_storage.instance_type(_id, jsonb) FROM 'datasets/common/instanceTypes.tsv' DELIMITER E'\t'
- datasets/common/instanceTypes.tsv: No such file or directory
- copy diku_mod_inventory_storage.material_type(_id, jsonb) FROM 'datasets/common/materials.tsv' DELIMITER E'\t'
- COPY 10
- copy diku_mod_inventory_storage.loan_type(_id, jsonb) FROM 'datasets/common/loanTypes.tsv' DELIMITER E'\t'
- COPY 4
- copy diku_mod_inventory_storage.item(_id, jsonb, permanentloantypeid, temporaryloantypeid, materialTypeId) FROM 'datasets/5kItems/items.tsv' DELIMITER E'\t'
- COPY 49997
- copy diku_mod_inventory_storage.instance(_id, jsonb) FROM 'datasets/5kItems/instances.tsv' DELIMITER E'\t'
- COPY 47745
- copy diku_mod_inventory_storage.shelflocation(_id, jsonb) FROM 'datasets/common/locations.tsv' DELIMITER E'\t'
- COPY 2
- copy diku_mod_circulation_storage.loan(_id, jsonb) FROM 'datasets/5kItems/circulate.tsv' DELIMITER E'\t'
- COPY 1226
- copy diku_mod_circulation_storage.request(_id, jsonb) FROM 'datasets/5kItems/requests.tsv' DELIMITER E'\t'
- COPY 196
- copy diku_mod_notes.note_data(id, jsonb) FROM 'datasets/5kItems/notes.tsv' DELIMITER E'\t'
- COPY 178
- copy diku_mod_notify.notify_data(id, jsonb) FROM 'datasets/5kItems/notifications.tsv' DELIMITER E'\t'
- COPY 476
- copy diku_mod_inventory_storage.holdings_record(_id, jsonb, permanentLocationId) FROM 'datasets/5kItems/recordholdings.tsv' DELIMITER E'\t'
- COPY 47745
- varun-folio@varunfolio-VirtualBox:~/gse-hosting-operations/gse.hosting.operations/db-populate$
Add Comment
Please, Sign In to add comment