How to update MongoDB document values ​​using PyMongo?

Question

Python

Good time!
Let's say we added a document to the collection:

db.goalsdoc.insert_one({'chat_id': message.chat.id, 'goals': [{'theme': message.text, 'date': '', 'subgoals': []}]})

We want to update the date key value and add an element to the subgoals list with message.text objects. According to the MongoDB documentation, this is done like this:

db.goalsdoc.update_one({'chat_id': message.chat.id}, {'$set': {'goals.date': message.text}})
db.goalsdoc.update_one({'chat_id': message.chat.id}, {'$push': {'goals.subgoals': message.text}})

But after compilation, the following error occurs:
cannot use the part to traverse the element python
Please tell me what I'm doing wrong? And how to do it right?

Answer 1

db.goalsdoc.update ({'chat_id': message.chat.id}}, { '$set': {"goals.0.date" : message.text} })