Guest User

Untitled

a guest
Jan 12th, 2018
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.54 KB | None | 0 0
  1. varun-folio@varunfolio-VirtualBox:~/gse-hosting-operations/gse.hosting.operations/db-populate$ ./bin/populate.sql 5kItems.manifest psql.conf diku
  2. =================================================
  3. PGUSER: folio_admin
  4. PGPASSWORD: folio_admin
  5. PGDATABASE: okapi_modules
  6. PGHOST: 10.0.2.2
  7. PGPORT: 5432
  8. TENANT: diku
  9.  
  10. USERS: datasets/5kItems/names.tsv
  11. USER_GROUPS: datasets/common/groups.tsv
  12. LOGINS: datasets/5kItems/logins.tsv
  13. PERMS: datasets/5kItems/perms.tsv
  14. MATERIALS: datasets/common/materials.tsv
  15. LOAN_TYPES: datasets/common/loanTypes.tsv
  16. ITEMS: datasets/5kItems/items.tsv
  17. CIRCULATION: datasets/5kItems/circulate.tsv
  18. REQUESTS: datasets/5kItems/requests.tsv
  19. NOTES: datasets/5kItems/notes.tsv
  20. INSTANCES: datasets/5kItems/instances.tsv
  21. NOTIFICATIONS: datasets/5kItems/notifications.tsv
  22. SHELF_LOCATIONS: datasets/common/locations.tsv
  23. INSTANCE_TYPES: datasets/common/instanceTypes.tsv
  24. IDENTIFIER_TYPES: datasets/common/identifierTypes.tsv
  25. RECORD_HOLDINGS: datasets/5kItems/recordholdings.tsv
  26. ==================================================
  27. DELETE 1229
  28. DELETE 199
  29. DELETE 163
  30. DELETE 13
  31. DELETE 163
  32. DELETE 5
  33. DELETE 49997
  34. DELETE 10
  35. DELETE 4
  36. DELETE 47745
  37. DELETE 47745
  38. DELETE 2
  39. DELETE 0
  40. DELETE 15
  41. DELETE 193
  42. DELETE 586
  43. COMMIT
  44. copy diku_mod_users.groups(id, jsonb) FROM 'datasets/common/groups.tsv' DELIMITER E'\t'
  45. COPY 5
  46. copy diku_mod_users.addresstype(id, jsonb) FROM 'datasets/common/addressTypes.tsv' DELIMITER E'\t'
  47. ERROR: duplicate key value violates unique constraint "addresstype_pkey"
  48. DETAIL: Key (id)=(c3840f08-9c94-4ba3-972f-e5696a085f25) already exists.
  49. CONTEXT: COPY addresstype, line 1: "c3840f08-9c94-4ba3-972f-e5696a085f25 {"addressType" : "Payment", "desc" : "Payment Address"}"
  50. copy diku_mod_users.users(id, jsonb) FROM 'datasets/5kItems/names.tsv' DELIMITER E'\t'
  51. COPY 163
  52. copy diku_mod_login.auth_credentials(jsonb) FROM datasets/5kItems/logins.tsv DELIMITER E'\t'
  53. COPY 13
  54. copy diku_mod_permissions.permissions_users(_id, jsonb) FROM 'datasets/5kItems/perms.tsv' DELIMITER E'\t'
  55. COPY 163
  56. copy diku_mod_inventory_storage.identifier_type(_id, jsonb) FROM 'datasets/common/identifierTypes.tsv' DELIMITER E'\t'
  57. COPY 15
  58. copy diku_mod_inventory_storage.instance_type(_id, jsonb) FROM 'datasets/common/instanceTypes.tsv' DELIMITER E'\t'
  59. datasets/common/instanceTypes.tsv: No such file or directory
  60. copy diku_mod_inventory_storage.material_type(_id, jsonb) FROM 'datasets/common/materials.tsv' DELIMITER E'\t'
  61. COPY 10
  62. copy diku_mod_inventory_storage.loan_type(_id, jsonb) FROM 'datasets/common/loanTypes.tsv' DELIMITER E'\t'
  63. COPY 4
  64. copy diku_mod_inventory_storage.item(_id, jsonb, permanentloantypeid, temporaryloantypeid, materialTypeId) FROM 'datasets/5kItems/items.tsv' DELIMITER E'\t'
  65. COPY 49997
  66. copy diku_mod_inventory_storage.instance(_id, jsonb) FROM 'datasets/5kItems/instances.tsv' DELIMITER E'\t'
  67. COPY 47745
  68. copy diku_mod_inventory_storage.shelflocation(_id, jsonb) FROM 'datasets/common/locations.tsv' DELIMITER E'\t'
  69. COPY 2
  70. copy diku_mod_circulation_storage.loan(_id, jsonb) FROM 'datasets/5kItems/circulate.tsv' DELIMITER E'\t'
  71. COPY 1226
  72. copy diku_mod_circulation_storage.request(_id, jsonb) FROM 'datasets/5kItems/requests.tsv' DELIMITER E'\t'
  73. COPY 196
  74. copy diku_mod_notes.note_data(id, jsonb) FROM 'datasets/5kItems/notes.tsv' DELIMITER E'\t'
  75. COPY 178
  76. copy diku_mod_notify.notify_data(id, jsonb) FROM 'datasets/5kItems/notifications.tsv' DELIMITER E'\t'
  77. COPY 476
  78. copy diku_mod_inventory_storage.holdings_record(_id, jsonb, permanentLocationId) FROM 'datasets/5kItems/recordholdings.tsv' DELIMITER E'\t'
  79. COPY 47745
  80. varun-folio@varunfolio-VirtualBox:~/gse-hosting-operations/gse.hosting.operations/db-populate$
Add Comment
Please, Sign In to add comment