Evans Pres repr needs to be updated to work with MetaDB

[jeremythuff]

evans-pres-repr/nodes/connect.json

• The name field needs to be refactored.
• The description field needs to be refactored
• The designation field needs to be refactored
• These field needs to be refactored: url, username and password

evans-pres-repr/nodes/disconnect.json

• name
• The description field needs to be refactored
• The designation field needs to be refactored

evans-pres-repr/nodes/query.json

• The designation field needs to be refactored
• query: folio_reporting.item_ext

[rmathew1011]

query prior to refactor:

SELECT *
 FROM folio_reporting.item_ext ie 
WHERE ie.temporary_location_name = 'Evans pres repr'  
AND
ie.item_id = '4f5c4f98-f374-3fba-96dc-18342927aa82'; 

results:

4f5c4f98-f374-3fba-96dc-18342927aa82	it00003951994		A14850730988												DS779.27 .S873 2021		95467209-6d7b-468b-94df-0f5d7ad2747d	Library of Congress classification			fe050219-8aa1-460d-b40e-930271137175	unmediated -- volume	1		5d907602-badb-403f-86fa-35af4c86dc30	normal					6ff3d07a-b274-4b39-ba5b-da3ef7630c31	Evans pres repr	6ff3d07a-b274-4b39-ba5b-da3ef7630c31	Evans pres repr		2025-06-06T16:03:59.733Z	Available	ee071ee1-d088-3ede-bb73-21d06967027d	false	2022-01-07 08:03:33.950	883f3880-0792-3c13-ae99-120cbc362560	2025-06-06T17:22:15.550Z

query post refactor:

SELECT * 
FROM folio_derived.item_ext ie 
WHERE ie.temporary_location_name = 'Evans pres repr'  
AND ie.item_id = '4f5c4f98-f374-3fba-96dc-18342927aa82';

results:

4f5c4f98-f374-3fba-96dc-18342927aa82	it00003951994		A14850730988												DS779.27 .S873 2021		95467209-6d7b-468b-94df-0f5d7ad2747d	Library of Congress classification			fe050219-8aa1-460d-b40e-930271137175	unmediated -- volume	1		5d907602-badb-403f-86fa-35af4c86dc30	normal					6ff3d07a-b274-4b39-ba5b-da3ef7630c31	Evans pres repr	6ff3d07a-b274-4b39-ba5b-da3ef7630c31	Evans pres repr		2025-06-06T16:03:59.733Z	Available	ee071ee1-d088-3ede-bb73-21d06967027d	false	2022-01-07 08:03:33.950	883f3880-0792-3c13-ae99-120cbc362560	2025-06-06T17:22:15.550Z

Camunda Logs:

INFO 1 --- [mod-camunda] [nio-8081-exec-5] o.f.rest.camunda.delegate.SetupDelegate  : Setup [] started
INFO 1 --- [mod-camunda] [nio-8081-exec-5] o.f.rest.camunda.delegate.SetupDelegate  : loading initial context
INFO 1 --- [mod-camunda] [nio-8081-exec-5] o.f.rest.camunda.delegate.SetupDelegate  : loading scripts
INFO 1 --- [mod-camunda] [nio-8081-exec-5] o.f.rest.camunda.delegate.SetupDelegate  : Setup finished in 0.482581 milliseconds
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.d.DatabaseConnectionDelegate     : Connect MetaDB [] started
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.d.DatabaseConnectionDelegate     : Connect MetaDB finished in 0.014773 milliseconds
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.delegate.DatabaseQueryDelegate   : Query items with location as Evans Pres Repr [] started
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.delegate.DatabaseQueryDelegate   : Writing results to file as CSV including headers
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.delegate.DatabaseQueryDelegate   : Query items with location as Evans Pres Repr finished in 843.776344 milliseconds
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.rest.camunda.delegate.EmailDelegate  : Send Evans Pres Repr Email [] started
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.rest.camunda.delegate.EmailDelegate  : Send Evans Pres Repr Email finished in 186.134321 milliseconds
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.d.DatabaseDisconnectDelegate     : Disconnect MetaDB [] started
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.r.c.d.DatabaseDisconnectDelegate     : Disconnect MetaDB finished in 0.007583 milliseconds
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.rest.camunda.delegate.FileDelegate   : Delete Evans Pres Repr CSV [DELETE] started
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.rest.camunda.delegate.FileDelegate   : /mnt/workflows/tamu/evans-pres-repr/evans-pres-repr-1753736727295.csv has been deleted
INFO 1 --- [mod-camunda] [aTaskExecutor-3] o.f.rest.camunda.delegate.FileDelegate   : Delete Evans Pres Repr CSV finished in 74.40882 milliseconds

Email: