/* change field-labels */
UPDATE lab_tests SET field_label = 'Cytocell 11q23'
WHERE lab_section_id = 7 AND test_name = '11q23';
UPDATE lab_tests SET field_label = 'Cytocell 11q24'
WHERE lab_section_id = 7 AND test_name = '11q24';
UPDATE lab_tests SET field_label = 'Cytocell 13q14 DLEU7'
WHERE lab_section_id = 7 AND test_name = '13q14_dleu7';
UPDATE lab_tests SET field_label = 'Cytocell 13q14 Rb'
WHERE lab_section_id = 7 AND test_name = '13q14_rb';
UPDATE lab_tests SET field_label = 'Cytocell 1p32.3 (CDKN2C)'
WHERE lab_section_id = 7 AND test_name = 'cdkn2c';
UPDATE lab_tests SET field_label = 'Cytocell 1q21 (CKS1B)'
WHERE lab_section_id = 7 AND test_name = 'cks1b';
UPDATE lab_tests SET field_label = 'Abbott 5p15 (control)'
WHERE lab_section_id = 7 AND test_name = 'alpha5';
UPDATE lab_tests SET field_label = 'Abbott 5q31'
WHERE lab_section_id = 7 AND test_name = '5q31';
UPDATE lab_tests SET field_label = 'Abbott 7q31'
WHERE lab_section_id = 7 AND test_name = '7q31';
UPDATE lab_tests SET field_label = 'Abbott CEN11'
WHERE lab_section_id = 7 AND test_name = 'alpha11';
UPDATE lab_tests SET field_label = 'Cytocell CEN12'
WHERE lab_section_id = 7 AND test_name = 'alpha12';
UPDATE lab_tests SET field_label = 'Cytocell CEN17'
WHERE lab_section_id = 7 AND test_name = 'alpha17';
UPDATE lab_tests SET field_label = 'Abbott CEN18'
WHERE lab_section_id = 7 AND test_name = 'alpha18';
UPDATE lab_tests SET field_label = 'Abbott CEN7'
WHERE lab_section_id = 7 AND test_name = 'alpha7';
UPDATE lab_tests SET field_label = 'Abbott CEN8'
WHERE lab_section_id = 7 AND test_name = 'alpha8';
UPDATE lab_tests SET field_label = 'DAKO BCL2'
WHERE lab_section_id = 7 AND test_name = 'bcl2';
UPDATE lab_tests SET field_label = 'Abbott BCL2/IGH'
WHERE lab_section_id = 7 AND test_name = 'bcl2_igh';
UPDATE lab_tests SET field_label = 'DAKO BCL6'
WHERE lab_section_id = 7 AND test_name = 'bcl6';
UPDATE lab_tests SET field_label = 'Abbott BCR-ABL'
WHERE lab_section_id = 7 AND test_name = 'bcr_abl';
UPDATE lab_tests SET field_label = 'DAKO CCND1'
WHERE lab_section_id = 7 AND test_name = 'bcl1';
UPDATE lab_tests SET field_label = 'Abbott CCND1/IGH'
WHERE lab_section_id = 7 AND test_name = 'bcl1_igh';
UPDATE lab_tests SET field_label = 'Cytocell CCND2'
WHERE lab_section_id = 7 AND test_name = 'ccnd2';
UPDATE lab_tests SET field_label = 'Cytocell DUSP22/IRF4'
WHERE lab_section_id = 7 AND test_name = 'dusp22_irf4';
UPDATE lab_tests SET field_label = 'Zytolight FGFR3'
WHERE lab_section_id = 7 AND test_name = 'fgfr3';
UPDATE lab_tests SET field_label = 'Cytocell FGFR3/IGH'
WHERE lab_section_id = 7 AND test_name = 'fgfr3_igh';
UPDATE lab_tests SET field_label = 'Cytocell IGH'
WHERE lab_section_id = 7 AND test_name = 'igh';
UPDATE lab_tests SET field_label = 'Cytocell IGH/MAFB'
WHERE lab_section_id = 7 AND test_name = 'igh_mafb';
UPDATE lab_tests SET field_label = 'Cytocell IGK'
WHERE lab_section_id = 7 AND test_name = 'ig_kappa';
UPDATE lab_tests SET field_label = 'Cytocell IGL'
WHERE lab_section_id = 7 AND test_name = 'ig_lambda';
UPDATE lab_tests SET field_label = 'Abbott KMT2A (MLL)'
WHERE lab_section_id = 7 AND test_name = 'mll';
UPDATE lab_tests SET field_label = 'Cytocell MAF/IGH'
WHERE lab_section_id = 7 AND test_name = 'maf_igh';
UPDATE lab_tests SET field_label = 'DAKO MALT1'
WHERE lab_section_id = 7 AND test_name = 'malt1';
UPDATE lab_tests SET field_label = 'DAKO MYC'
WHERE lab_section_id = 7 AND test_name = 'cmyc';
UPDATE lab_tests SET field_label = 'Abbott MYC/IGH'
WHERE lab_section_id = 7 AND test_name = 'cmyc_igh';
UPDATE lab_tests SET field_label = 'Abbott PDGFRA-FIP1L1'
WHERE lab_section_id = 7 AND test_name = 'pdgfra_fip1l1';
UPDATE lab_tests SET field_label = 'Cytocell PML/RARa'
WHERE lab_section_id = 7 AND test_name = 'pml_rar_alpha';
UPDATE lab_tests SET field_label = 'Cytocell TCL1'
WHERE lab_section_id = 7 AND test_name = 'tcl1';
UPDATE lab_tests SET field_label = 'Cytocell TP53'
WHERE lab_section_id = 7 AND test_name = 'p53';
UPDATE lab_tests SET field_label = 'Cytocell TP63 (6p25)'
WHERE lab_section_id = 7 AND test_name = 'tp63_6p25';
UPDATE lab_tests SET field_label = 'Burkitt 11q'
WHERE lab_section_id = 7 AND test_name = '11q';
/* inactivate lab-tests */
UPDATE lab_tests SET is_active = 'no'
WHERE lab_section_id = 7 AND test_name IN (
'13q14', '13q34', '6q21', 'alpha3', 'alpha6', 'bcl3', 'fish', 'atm',
'foxp1', 'pax5', 'cll', 'myeloma_trial', 'plasma_cell_screen'
);
/* new lab-tests */
INSERT INTO lab_tests(test_name,field_label,lab_section_id,test_type,has_results,is_active)
VALUES
('abbott_bcl6','Abbott BCL6',7,'test','yes','yes'),
('abbott_bcl2','Abbott BCL2',7,'test','yes','yes'),
('abbott_fgfr3_igh','Abbott FGFR3/IGH',7,'test','yes','yes'),
('abbott_maf_igh','Abbott MAF/IGH',7,'test','yes','yes'),
('dako_igh','DAKO IGH',7,'test','yes','yes'),
('cytocell_myc','Cytocell MYC',7,'test','yes','yes'),
('cytocell_atm','Cytocell ATM',7,'test','yes','yes'),
('cytocell_cen11','Cytocell CEN11',7,'test','yes','yes'),
('cytocell_bcr_abl','Cytocell BCR-ABL',7,'test','yes','yes'),
('cytocell_kmt2a','Cytocell KMT2A',7,'test','yes','yes'),
('cytocell_ccnd1_igh','Cytocell CCND1/IGH',7,'test','yes','yes'),
('dlbcl_burkitt_fresh','DLBCL v Burkitt (fresh)',7,'panel','no','yes'),
('dlbcl_extended_fresh','DLBCL extended (fresh)',7,'panel','no','yes'),
('dlbcl_screen_fresh','DLBCL screen (fresh)',7,'panel','no','yes'),
('dlbcl_fl_fresh','DLBCL + FL (fresh)',7,'panel','no','yes');
/* lab-test-sample-types & lab_test_data_types */
SELECT @data_type_id := id FROM lab_test_result_data_types
WHERE description = 'fish_text';
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'abbott_bcl6';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'abbott_bcl2';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'abbott_fgfr3_igh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'abbott_maf_igh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'dako_igh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'cytocell_myc';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'cytocell_atm';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'cytocell_cen11';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'cytocell_bcr_abl';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'cytocell_kmt2a';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'cytocell_ccnd1_igh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'dlbcl_burkitt_fresh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'dlbcl_extended_fresh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'dlbcl_screen_fresh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
SELECT @lab_test_id := id FROM lab_tests WHERE test_name = 'dlbcl_fl_fresh';
INSERT INTO lab_test_sample_type(lab_test_id, sample_type_id) VALUES
(@lab_test_id,1),
(@lab_test_id,2),
(@lab_test_id,3);
INSERT INTO lab_test_data_type(lab_test_id, data_type_id, is_active)
VALUES (@lab_test_id,@data_type_id,'yes');
# configure panel-lab-tests manually
