commit 312db429e4605d6d0ce47d1034662fdf0ec053b7
author Ankush Menat <ankush@frappe.io> Sat Feb 19 16:26:17 2022 +0530
committer Ankush Menat <ankushmenat@gmail.com> Mon Feb 21 18:02:40 2022 +0530
tree 0cec0f56459559864f215a458b0257488d1fedbe
parent d130233ffc79d085b61bc1b63956d18c03de7a88

refactor: use qb for patching flag

erpnext/patches/v14_0/update_batch_valuation_flag.py

diff --git a/erpnext/patches/v14_0/update_batch_valuation_flag.py b/erpnext/patches/v14_0/update_batch_valuation_flag.py
index d9f08d8..55c8c48 100644
--- a/erpnext/patches/v14_0/update_batch_valuation_flag.py
+++ b/erpnext/patches/v14_0/update_batch_valuation_flag.py
@@ -6,7 +6,6 @@
 	- Don't use batchwise valuation for existing batches.
 	- Only batches created after this patch shoule use it.
 	"""
-	frappe.db.sql("""
-		UPDATE `tabBatch`
-		SET use_batchwise_valuation=0
-	""")
+
+	batch = frappe.qb.DocType("Batch")
+	frappe.qb.update(batch).set(batch.use_batchwise_valuation, 0).run()