fix: Laboratory Module patch (#25431)
diff --git a/erpnext/patches/v13_0/healthcare_lab_module_rename_doctypes.py b/erpnext/patches/v13_0/healthcare_lab_module_rename_doctypes.py
index a78f802..028c619 100644
--- a/erpnext/patches/v13_0/healthcare_lab_module_rename_doctypes.py
+++ b/erpnext/patches/v13_0/healthcare_lab_module_rename_doctypes.py
@@ -38,16 +38,37 @@
""".format(doctype), {'parentfield': parentfield})
# copy renamed child table fields (fields were already renamed in old doctype json, hence sql)
- frappe.db.sql("""UPDATE `tabNormal Test Result` SET lab_test_name = test_name""")
- frappe.db.sql("""UPDATE `tabNormal Test Result` SET lab_test_event = test_event""")
- frappe.db.sql("""UPDATE `tabNormal Test Result` SET lab_test_uom = test_uom""")
- frappe.db.sql("""UPDATE `tabNormal Test Result` SET lab_test_comment = test_comment""")
- frappe.db.sql("""UPDATE `tabNormal Test Template` SET lab_test_event = test_event""")
- frappe.db.sql("""UPDATE `tabNormal Test Template` SET lab_test_uom = test_uom""")
- frappe.db.sql("""UPDATE `tabDescriptive Test Result` SET lab_test_particulars = test_particulars""")
- frappe.db.sql("""UPDATE `tabLab Test Group Template` SET lab_test_template = test_template""")
- frappe.db.sql("""UPDATE `tabLab Test Group Template` SET lab_test_description = test_description""")
- frappe.db.sql("""UPDATE `tabLab Test Group Template` SET lab_test_rate = test_rate""")
+ rename_fields = {
+ 'lab_test_name': 'test_name',
+ 'lab_test_event': 'test_event',
+ 'lab_test_uom': 'test_uom',
+ 'lab_test_comment': 'test_comment'
+ }
+
+ for new, old in rename_fields.items():
+ if frappe.db.has_column('Normal Test Result', old):
+ frappe.db.sql("""UPDATE `tabNormal Test Result` SET %(new)s = %(old)s""", {
+ 'new': new, 'old': old})
+
+ if frappe.db.has_column('Normal Test Template', 'test_event'):
+ frappe.db.sql("""UPDATE `tabNormal Test Template` SET lab_test_event = test_event""")
+
+ if frappe.db.has_column('Normal Test Template', 'test_uom'):
+ frappe.db.sql("""UPDATE `tabNormal Test Template` SET lab_test_uom = test_uom""")
+
+ if frappe.db.has_column('Descriptive Test Result', 'test_particulars'):
+ frappe.db.sql("""UPDATE `tabDescriptive Test Result` SET lab_test_particulars = test_particulars""")
+
+ rename_fields = {
+ 'lab_test_template': 'test_template',
+ 'lab_test_description': 'test_description',
+ 'lab_test_rate': 'test_rate'
+ }
+
+ for new, old in rename_fields.items():
+ if frappe.db.has_column('Lab Test Group Template', old):
+ frappe.db.sql("""UPDATE `tabLab Test Group Template` SET %(new)s = %(old)s""", {
+ 'new': new, 'old': old})
# rename field
frappe.reload_doc('healthcare', 'doctype', 'lab_test')