+ sudo rm -f /tmp/openmrs_patient.csv
+ mysql -uroot -ppassword openmrs
Warning: Using a password on the command line interface can be insecure.
+ psql -Uclinlims -f deidentify_openelis.sql
TRUNCATE TABLE
UPDATE 20
UPDATE 62
UPDATE 1
UPDATE 1
UPDATE 2
UPDATE 0
UPDATE 2
+ psql -Upostgres -dclinlims -f copy_openmrs_patient_data_to_openelis.sql
SET
psql:copy_openmrs_patient_data_to_openelis.sql:5: NOTICE:  table "temp_openmrs_patient" does not exist, skipping
DROP TABLE
psql:copy_openmrs_patient_data_to_openelis.sql:10: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "temp_openmrs_patient_old_uuid_key" for table "temp_openmrs_patient"
CREATE TABLE
COPY 44
UPDATE 44
UPDATE 44
UPDATE 44
DROP TABLE
+ psql -Uopenerp -f deidentify_openerp.sql
TRUNCATE TABLE
TRUNCATE TABLE
UPDATE 72
UPDATE 3
UPDATE 4
UPDATE 0
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_compose_message"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_mail"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_message_res_partner_rel"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_notification"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_vote"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "message_attachment_rel"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_compose_message_ir_attachments_rel"
psql:deidentify_openerp.sql:24: NOTICE:  truncate cascades to table "mail_compose_message_res_partner_rel"
TRUNCATE TABLE
psql:deidentify_openerp.sql:25: NOTICE:  truncate cascades to table "mail_followers_mail_message_subtype_rel"
TRUNCATE TABLE
UPDATE 7
UPDATE 4
UPDATE 4
+ psql -Upostgres -dopenerp -f copy_openmrs_patient_data_to_openerp.sql
psql:copy_openmrs_patient_data_to_openerp.sql:3: NOTICE:  table "temp_openmrs_patient" does not exist, skipping
DROP TABLE
psql:copy_openmrs_patient_data_to_openerp.sql:7: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "temp_openmrs_patient_old_uuid_key" for table "temp_openmrs_patient"
CREATE TABLE
COPY 44
psql:copy_openmrs_patient_data_to_openerp.sql:14: NOTICE:  table "temp_res_partner_ref" does not exist, skipping
DROP TABLE
SELECT 87
UPDATE 87
UPDATE 44
DROP TABLE
DROP TABLE
+ sudo rm -f /tmp/openmrs_patient.csv