Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following data files are needed to support the Jmeter script during its execution.
- itembarcodes.csv: a list of barcodes that have Available status

Code Block
languagesql
select jsonb->>'barcode' from  fs09000000_mod_inventory_storage.item  WHERE jsonb->'status'->>'name' = 'Available' and jsonb->>'barcode' is not null limit 3000;


- user_barcodes.scv: a list of barcodes of actual patron IDs that will be used to check in/out with.

Code Block
languagesql
select jsonb->>'barcode' from fs09000000_mod_users.users where jsonb->'active' = 'true' and jsonb->>'barcode' is not null and jsonb->>'type' = 'patron' limit 3000

Monitoring Pick Slips Requests (MPS)

The following data files are needed to support the Jmeter script during its execution.
- servicepoints.csv: a list of service point ids. It will be used to execute /circulation/pick-slips/<servicepointId> requests.

...

languagesql

...


Data export (DE)

The following data files are needed to support the Jmeter script during its execution.

...

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
languagesql
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)

The following data files are needed to support the Jmeter script during its execution.
- IRO_search_items.csv: a list of instance hrids for Search field that will be used to execute the script.

- IRO_search_items_delete.csv: a list of instance hrid for Search field that will be used to execute delete and edit operations in the script.


Retrieving Instances and Holdings (RIH)

- RIH_instance_ids.csv contains instance ids

View Bib (VB)

- VB_keywords.csv (contains keyword) in this case it is searching Instance by a keyword.

("aab",5
"aabe",2
"AAC",4
"AACE",2)

Code Block
languagesql
SELECT substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4),LEAST((count(1)-2),5)
	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;


View Holdings (VH)

- VH_keywords.csv (contains keyword) in this case it is searching Holdings by a keyword.

(0,5
00,5
00000,5
000000,5)

Code Block
languagesql
SELECT substring((({tenant}_mod_inventory_storage.holding_records.jsonb)->'title')::TEXT from 2 for 4),LEAST((count(1)-2),5)
	FROM {tenant}_mod_inventory_storage.holding_records
	INNER JOIN {tenant}_mod_inventory.records_holdings
	ON {tenant}_mod_inventory_storage.holding_records.id = {tenant}_mod_inventory.records_holdings.holdings_id
	INNER JOIN {tenant}_mod_source_record_storage.raw_records_lb
	ON {tenant}_mod_inventory.records_holdings.record_id = {tenant}_mod_source_record_storage.raw_records_lb.id
	group by substring((({tenant}_mod_inventory_storage.holding_records.jsonb)->'title')::TEXT from 2 for 4)
	having count(1) > 3 and count(1) < 10;



View Instance Holdings Details (VIH)

No data preparation is needed.


Inventory Record Monitoring /View (VIR)

The following data files are needed to support the Jmeter script during its execution.
- VIR_instance_item.csv: a list of instance and item ids to run the script (could be not connected).


Invoices Operations (IO)

The following data files are needed to support the Jmeter script during its execution.
- IO_invoice_codes.csv: a list of keywords for searching invoices (the status of the invoiceі should be open)

Code Block
languagesql
SELECT {tenant}_mod_invoice_storage.invoices.jsonb->'vendorInvoiceNo'
	FROM {tenant}_mod_invoice_storage.invoices limit 2000;


- IO_organization_names.csv: a list of keywords for searching organization(only for create workflow)

Code Block
languagesql
SELECT DISTINCT({tenant}_mod_organizations_storage.organizations.jsonb->'code')
	FROM {tenant}_mod_organizations_storage.organizations limit 2000;


Manage invoices GROUP/Approve invoices (AIE)

The following data files are needed to support the Jmeter script during its execution.
- invoice_codes.csv: a list of keywords for searching invoices (funds used in the invoice should be active and not used in FYR, the status of invoiceі should be open, and invoiceі should be with at least one invoice line)

Code Block
languagesql
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.

Code Block
languagesql
select fs09000000_mod_circulation_storage.loan.jsonb->>'userId' as user, fs09000000_mod_inventory_storage.item.jsonb->>'barcode' as itemBarcode 
from fs09000000_mod_inventory_storage.item join fs09000000_mod_circulation_storage.loan 
ON fs09000000_mod_inventory_storage.item.id = (fs09000000_mod_circulation_storage.loan.jsonb->>'itemId')::uuid
limit 4000

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
languagesql
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;

...