Page History

...

-loan id stays the same throughout all loan trans

Historic Loan Rows Anonymization Process

Here are the details of the process that will be followed to replance the user_id field on historic loan rows with NULL on Friday, May 9:

	Step	Status
1	Hosting Team backs up folio_circulation schema
2	As specified in the Metadb documentation, the hosting team will stop the server to prevent it from operating with an out-of-date cache.
3	The hosting team will run the 2 anonymization scripts on the loan tables in the Metadb reporting database
4	As specified in the Metadb documentation, the hosting team will start the server to prevent it from operating with an out-of-date cache.
5	The hosting team will inform Sharon when the Steps 2 and 3 are complete
	Sharon and Joanne will verify that the loan anonymization process has been successful

Loan Anonymization Scripts

This script replaces the user_id in historic loan rows on the loan__ table:

UPDATE folio_circulation.loan__ AS ln 

SET jsonb = jsonb_set(ln.jsonb, '{userId}', 'null'::jsonb, false) 

WHERE __current = FALSE

 ;

This script replaces the user_id in historic loan rows on the loan__t__ table:

UPDATE folio_circulation.loan__t__ 

SET user_id = NULL 

WHERE __current = FALSE 

AND user_id IS NOT NULL

 ;

...

Page tree