New item isn't show in Item List

Frappe Framework Bug
1

I try to create a new doc/record of Item doctype from backend using python.

doc = frappe.new_doc(‘Item’)
doc.item_code = ‘custom-1’
doc.item_group = ‘All Item Groups’
doc.save()
print(doc.name) #OUTPUT: custom-1

frappe.db.sql(“Select item_name from tabItem where name= ‘custom-1’”)

OUTPUT: (('custom-1),)

But when I go to item list. I didn’t see the new item which i create from the backend.
Why this not working? DId i miss anything?

2

try to use this instead

frappe.db.sql(“”“select item_name from tabItem where name = ‘custom-1’”“”)

3

Solved
After db.save()
I need to frappe.db.commit() for pushing the data into database.