...
Edit Bib Record Tag Table Group (ETT)
- ETT_keywords.csv (contains keyword) in this case it is Instance keyword you can generate this file using scripts/selectKeyWords.sql
Code Block | ||
---|---|---|
| ||
SELECT substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4),ARRAY_AGG({tenant}_mod_inventory_storage.instance.id) FROM {tenant}_mod_inventory_storage.instance INNER JOIN {tenant}_mod_inventory.records_instances ON {tenant}_mod_inventory_storage.instance.id = {tenant}_mod_inventory.records_instances.instance_id INNER JOIN {tenant}_mod_source_record_storage.raw_records_lb ON {tenant}_mod_inventory.records_instances.record_id = {tenant}_mod_source_record_storage.raw_records_lb.id group by substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4) having count(1) > 3 and count(1) < 10; |
ETT_search_items.csv: a list of item ids to run the script, this items will be edited (editable).
Item Record Operations (IRO)
...
Code Block | ||
---|---|---|
| ||
SELECT {tenant}_mod_invoice_storage.invoices.jsonb->'vendorInvoiceNo'
FROM {tenant}_mod_invoice_storage.invoices limit 2000; |
View Marc Authority (VAR)
The following data files are needed to support the Jmeter script during its execution.
- VAR_search_marc_keyword.csv: a list of search keywords for marc authority records is dependent on the Environment against which tests will be executed.
(Linares
King
Wright
Lee)
Purchase Orders Operations (POO)
The following data files are needed to support the Jmeter script during its execution.
- POO_vendors.csv: a list of vendors ids that have all needed checkers to create orders. It will be used to execute create, view, edit, and delete orders in the script.
Vendor Record/Organisation Operations (VRO)
The following data files are needed to support the Jmeter script during its execution.
- VRO_organizationNames.scv: a list of organization names that will be used to execute view, edit, and delete operations in the script.
Patron Record Operations (PRO)
The following data files are needed to support the Jmeter script during its execution.
- PRO_users.scv: a list of uuids and names of actual users that will be used to execute the script.
Users Loan Renewal (ULR/RENEW)
ULR_users.csv: a list of user IDs that will be used to execute the script, users should be with previously generated loans.
View MARC Tag Table (VTT)
- VTT_keywords.csv (contains keyword) in this case it is Instance keyword you can generate this file using scripts/selectKeyWords.sql
"aab",5
"aabe",2
"AAC",4
"AACE",2
Code Block | ||
---|---|---|
| ||
SELECT substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4),ARRAY_AGG({tenant}_mod_inventory_storage.instance.id)
FROM {tenant}_mod_inventory_storage.instance
INNER JOIN {tenant}_mod_inventory.records_instances
ON {tenant}_mod_inventory_storage.instance.id = {tenant}_mod_inventory.records_instances.instance_id
INNER JOIN {tenant}_mod_source_record_storage.raw_records_lb
ON {tenant}_mod_inventory.records_instances.record_id = {tenant}_mod_source_record_storage.raw_records_lb.id
group by substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4)
having count(1) > 3 and count(1) < 10; |