Page History

...

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.
6	Sharon and Joanne will verify that the loan anonymization process has been successful and that normal data synchronization is continuing through test scripts that capture data stamps in loan_id rows.

Loan Anonymization Scripts

...

UPDATE folio_circulation.loan__ AS ln 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