<commit_before>delete from program_rnr_columns;
insert into program_rnr_columns
(masterColumnId, programId, visible, source, position, label)
values
(1, (select id from programs where code = 'TB'),  true, 'R', 1,  'Product Code'),
(2, (select id from programs where code = 'TB'),  true, 'R', 2,  'Product'),
(3, (select id from programs where code = 'TB'),  true, 'R', 3,  'Unit/Unit of Issue'),
(4, (select id from programs where code = 'TB'),  true, 'U', 4,  'Beginning Balance'),
(5, (select id from programs where code = 'TB'),  true, 'U', 5,  'Total Received Quantity'),
(6, (select id from programs where code = 'TB'),  true, 'U', 6,  'Total Consumed Quantity'),
(7, (select id from programs where code = 'TB'),  true, 'U', 7,  'Total Losses / Adjustments'),
(8, (select id from programs where code = 'TB'),  true, 'C', 8,  'Stock on Hand'),
(9, (select id from programs where code = 'TB'),  true, 'U', 9, 'New Patients'),
(10, (select id from programs where code = 'TB'), true, 'U', 10, 'Total Stockout days'),
(11, (select id from programs where code = 'TB'), true, 'C', 11, 'Adjusted Total Consumption'),
(12, (select id from programs where code = 'TB'), true, 'C', 12, 'Average Monthly Consumption(AMC)'),
(13, (select id from programs where code = 'TB'), true, 'C', 13, 'Maximum Stock Quantity'),
(14, (select id from programs where code = 'TB'), true, 'C', 14, 'Calculated Order Quantity'),
(15, (select id from programs where code = 'TB'), true, 'U', 15, 'Requested quantity'),
(16, (select id from programs where code = 'TB'), true, 'U', 16, 'Requested quantity explanation'),
(17, (select id from programs where code = 'TB'), true, 'U', 17, 'Approved Quantity'),
(18, (select id from programs where code = 'TB'), true, 'C', 18, 'Packs to Ship'),
(19, (select id from programs where code = 'TB'), true, 'R', 19, 'Price per pack'),
(20, (select id from programs where code = 'TB'), true, 'C', 20, 'Total cost'),
(21, (select id from programs where code = 'TB'), true, 'U', 21, 'Remarks'),
(1, (select id from programs where code = 'ESS_MEDS'),  true, 'R', 1,  'Product Code'),
(2, (select id from programs where code = 'ESS_MEDS'),  true, 'R', 2,  'Product'),
(3, (select id from programs where code = 'ESS_MEDS'),  true, 'R', 3,  'Unit/Unit of Issue'),
(4, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 4,  'Beginning Balance'),
(5, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 5,  'Total Received Quantity'),
(6, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 6,  'Total Consumed Quantity'),
(7, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 7,  'Total Losses / Adjustments'),
(8, (select id from programs where code = 'ESS_MEDS'),  true, 'C', 8,  'Stock on Hand'),
(9, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 9, 'New Patients'),
(10, (select id from programs where code = 'ESS_MEDS'), true, 'U', 10, 'Total Stockout days'),
(11, (select id from programs where code = 'ESS_MEDS'), true, 'C', 11, 'Adjusted Total Consumption'),
(12, (select id from programs where code = 'ESS_MEDS'), true, 'C', 12, 'Average Monthly Consumption(AMC)'),
(13, (select id from programs where code = 'ESS_MEDS'), true, 'C', 13, 'Maximum Stock Quantity'),
(14, (select id from programs where code = 'ESS_MEDS'), true, 'C', 14, 'Calculated Order Quantity'),
(15, (select id from programs where code = 'ESS_MEDS'), true, 'U', 15, 'Requested quantity'),
(16, (select id from programs where code = 'ESS_MEDS'), true, 'U', 16, 'Requested quantity explanation'),
(17, (select id from programs where code = 'ESS_MEDS'), true, 'U', 17, 'Approved Quantity'),
(18, (select id from programs where code = 'ESS_MEDS'), true, 'C', 18, 'Packs to Ship'),
(19, (select id from programs where code = 'ESS_MEDS'), true, 'R', 19, 'Price per pack'),
(20, (select id from programs where code = 'ESS_MEDS'), true, 'C', 20, 'Total cost'),
(21, (select id from programs where code = 'ESS_MEDS'), true, 'U', 21, 'Remarks');<commit_msg>+Balvinder|Adding test data to set templateconfigured=true for all configured programs<commit_after>delete from program_rnr_columns;
insert into program_rnr_columns
(masterColumnId, programId, visible, source, position, label)
values
(1, (select id from programs where code = 'TB'),  true, 'R', 1,  'Product Code'),
(2, (select id from programs where code = 'TB'),  true, 'R', 2,  'Product'),
(3, (select id from programs where code = 'TB'),  true, 'R', 3,  'Unit/Unit of Issue'),
(4, (select id from programs where code = 'TB'),  true, 'U', 4,  'Beginning Balance'),
(5, (select id from programs where code = 'TB'),  true, 'U', 5,  'Total Received Quantity'),
(6, (select id from programs where code = 'TB'),  true, 'U', 6,  'Total Consumed Quantity'),
(7, (select id from programs where code = 'TB'),  true, 'U', 7,  'Total Losses / Adjustments'),
(8, (select id from programs where code = 'TB'),  true, 'C', 8,  'Stock on Hand'),
(9, (select id from programs where code = 'TB'),  true, 'U', 9, 'New Patients'),
(10, (select id from programs where code = 'TB'), true, 'U', 10, 'Total Stockout days'),
(11, (select id from programs where code = 'TB'), true, 'C', 11, 'Adjusted Total Consumption'),
(12, (select id from programs where code = 'TB'), true, 'C', 12, 'Average Monthly Consumption(AMC)'),
(13, (select id from programs where code = 'TB'), true, 'C', 13, 'Maximum Stock Quantity'),
(14, (select id from programs where code = 'TB'), true, 'C', 14, 'Calculated Order Quantity'),
(15, (select id from programs where code = 'TB'), true, 'U', 15, 'Requested quantity'),
(16, (select id from programs where code = 'TB'), true, 'U', 16, 'Requested quantity explanation'),
(17, (select id from programs where code = 'TB'), true, 'U', 17, 'Approved Quantity'),
(18, (select id from programs where code = 'TB'), true, 'C', 18, 'Packs to Ship'),
(19, (select id from programs where code = 'TB'), true, 'R', 19, 'Price per pack'),
(20, (select id from programs where code = 'TB'), true, 'C', 20, 'Total cost'),
(21, (select id from programs where code = 'TB'), true, 'U', 21, 'Remarks'),
(1, (select id from programs where code = 'ESS_MEDS'),  true, 'R', 1,  'Product Code'),
(2, (select id from programs where code = 'ESS_MEDS'),  true, 'R', 2,  'Product'),
(3, (select id from programs where code = 'ESS_MEDS'),  true, 'R', 3,  'Unit/Unit of Issue'),
(4, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 4,  'Beginning Balance'),
(5, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 5,  'Total Received Quantity'),
(6, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 6,  'Total Consumed Quantity'),
(7, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 7,  'Total Losses / Adjustments'),
(8, (select id from programs where code = 'ESS_MEDS'),  true, 'C', 8,  'Stock on Hand'),
(9, (select id from programs where code = 'ESS_MEDS'),  true, 'U', 9, 'New Patients'),
(10, (select id from programs where code = 'ESS_MEDS'), true, 'U', 10, 'Total Stockout days'),
(11, (select id from programs where code = 'ESS_MEDS'), true, 'C', 11, 'Adjusted Total Consumption'),
(12, (select id from programs where code = 'ESS_MEDS'), true, 'C', 12, 'Average Monthly Consumption(AMC)'),
(13, (select id from programs where code = 'ESS_MEDS'), true, 'C', 13, 'Maximum Stock Quantity'),
(14, (select id from programs where code = 'ESS_MEDS'), true, 'C', 14, 'Calculated Order Quantity'),
(15, (select id from programs where code = 'ESS_MEDS'), true, 'U', 15, 'Requested quantity'),
(16, (select id from programs where code = 'ESS_MEDS'), true, 'U', 16, 'Requested quantity explanation'),
(17, (select id from programs where code = 'ESS_MEDS'), true, 'U', 17, 'Approved Quantity'),
(18, (select id from programs where code = 'ESS_MEDS'), true, 'C', 18, 'Packs to Ship'),
(19, (select id from programs where code = 'ESS_MEDS'), true, 'R', 19, 'Price per pack'),
(20, (select id from programs where code = 'ESS_MEDS'), true, 'C', 20, 'Total cost'),
(21, (select id from programs where code = 'ESS_MEDS'), true, 'U', 21, 'Remarks');


update programs set templateConfigured = true where id in ((select id from programs where code = 'ESS_MEDS'),
(select id from programs where code = 'TB'));
{'fraction_non_alphanumeric': 0.18064516129032257, 'fraction_numerical': 0.03213633597078515, 'mean_word_length': 5.0367376928728875, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5425523', 'n_tokens_mistral': 2986, 'n_tokens_neox': 2677, 'n_words': 1192}