Could I remove or insert documents while iterating the db?

[hao-lee]

Such as

for item in db:
    if match(item):
        q = Query()
        db.remove(q.name == item["name"])
        new = construct_new(item)
        db.insert(new)

Python doesn't allow list to be manipulated like this. I don't know how tinydb handle this situation. Thanks.

[msiemens]

Hey @hao-lee, this is indeed allowed as TinyDB first reads the storage and then returns an iterator over all documents. The iterator will continue yielding the original set of documents, though. This means that any changes performed while iterating the list will not be represented in subsequent iterations.