How To Delete Record Or Document From TinyDB

How to delete record or document from TinyDB Example of DB: {'1' : {'id_key' : 'xxx', 'params' : {} } }, {'2' : {'id_key' : 'yyy', 'params' : {} } }, I want to delete '1' if id_ke

Solution 1:

To use the example code for your data, type:

db.update(delete('id_key'), where('id_key') == 'xxx')

Please note: TinyDB is a key-value database. using the code above will remove the key 'xxx'. If you type:

db.all()

you will see that the key 'xxx' is deleted. but realize that the row still exists in the database AND if 'params' had any values in it, the values in 'params' would still exist.

A better alternative might be to use TinyDB's remove command, for example:

db.remove(where('id_key') == 'xxx')