fix anonymise_db.pl failure to update nhs_number if value already exists in patients table and not yet replaced - didn't consider existing values when generating replacement nhs_numbers; adjusted vertical spacing of HaemOnc SLF for test server
fix anonymise_db.pl failure to update nhs_number if value already exists in patients table and not yet replaced - didn't consider existing values when generating replacement nhs_numbers; adjusted vertical spacing of HaemOnc SLF for test server
new db anonymisation function; screen categories sorted lc (for new PNH/AA entry); fixed syntax error in mpla deployment script
9 years ago
README.txt
* does a mysqldump of hilis4/genomics/uclh/etc database and anonymises the patients + patient_case tables
* excludes some tables with patient info (eg patient_demographics - difficult/unnecessary to anonymise)
* generates a temporary db so required partition space will depend on size of uncompressed source db data dump (HILIS4 around 1GB)
* outreach & hmrn dbs can be directly exported via mysqldump as they have no patient data
patient_id is FK to hilis4.patients.id and request_id is FK to hilis4.requests.id
* expected usage is on a test/staging server with current clone of required db (LTH149890 or 'official' test HMDS server)
* usage: sh dump_and_anonymise_db.sh <cloned_db_to_anonymise> <db username> <db password>
