Frappe Database Operations

Quick Reference

Action	Method	Permissions
Get document	`frappe.get_doc(doctype, name)`	Yes
Cached document	`frappe.get_cached_doc(doctype, name)`	No
New document	`frappe.new_doc(doctype)`	—
Insert	`doc.insert()`	Yes
Save	`doc.save()`	Yes
Delete document	`frappe.delete_doc(doctype, name)`	Yes
List (with perms)	`frappe.db.get_list(doctype, ...)`	Yes
List (no perms)	`frappe.get_all(doctype, ...)`	No
Single field	`frappe.db.get_value(doctype, name, field)`	No
Single DocType	`frappe.db.get_single_value(doctype, field)`	No
Cached value	`frappe.db.get_value(..., cache=True)`	No
Direct update	`frappe.db.set_value(doctype, name, field, val)`	No
Direct update	`doc.db_set(field, value)`	No

Related skills