I am currently working on a personal addon for Anki that aims to change the due date of specific cards to match a database. However, I have encountered an issue where not all the due dates are being changed, and the pattern seems somewhat random. I have noticed that when I delete and re-add the cards and modify the due date, some cards get updated with the new due date while others retain their previous due date. To provide more context, I have attached an example of my database and the results I am getting.
This is the result I’m trying to match:
This is what I’m getting:
In my addon, I am iterating through the cards in the Anki deck and retrieving the ID of each card. I then select the corresponding card from my SQLite database, retrieve the due date, and update the due date of that specific card using the function
I would greatly appreciate any advice or insight into why this issue might be occurring and how I can resolve it. Thank you in advance for your help.