fix(patch): lab module patch fix (#25447)
* fix(patch): lab module patch fix
* fix: param
Co-authored-by: Rucha Mahabal <ruchamahabal2@gmail.com>
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 028c619..9af0a8d 100644
--- a/erpnext/patches/v13_0/healthcare_lab_module_rename_doctypes.py
+++ b/erpnext/patches/v13_0/healthcare_lab_module_rename_doctypes.py
@@ -47,8 +47,8 @@
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})
+ frappe.db.sql("""UPDATE `tabNormal Test Result` SET {} = {}"""
+ .format(new, old))
if frappe.db.has_column('Normal Test Template', 'test_event'):
frappe.db.sql("""UPDATE `tabNormal Test Template` SET lab_test_event = test_event""")
@@ -67,8 +67,8 @@
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})
+ frappe.db.sql("""UPDATE `tabLab Test Group Template` SET {} = {}"""
+ .format(new, old))
# rename field
frappe.reload_doc('healthcare', 'doctype', 'lab_test')