Update clause doesn't return anything

ERPNext
1

I’m trying to update 10 rows in DB but when using frappe.db.sql(" UPDATE …")
it returns nothing.
I want to know how many rows updated

code:
update_promo_code_query = “”"
UPDATE tabPromoCodes promo
SET promo.number_of_uses = promo.number_of_uses + 1
WHERE promo.code = %(promo_code_id)s AND promo.number_of_uses < promo.maximum_usage
“”"
doc = frappe.db.sql(update_promo_code_query, {‘promo_code_id’: promo_code_id})
frappe.sql.commit()

2
3

how to use it in Frappe?

4

Just call the function with frappe.db.sql

5

Thanks Bro, It worked