UNIQUE constraint failed: feeds_last_items.url #32

New Issue

Closed

opened 2022-07-09 20:02:40 +00:00 by skobkin · 0 comments

skobkin commented

2022-07-09 20:02:40 +00:00

Collaborator

When updating last feed items in the database, SQL query can fail sometimes because current database schema is relying on url of the FeedItem to be unique, but it's not the oftenly.

We should rely on something like guid and store it instead. We also probably don't need an UNIQUE constraint there at all.

This could be fixed while working on #15.

Traceback (most recent call last):
  File "update.py", line 18, in <module>
    updater.update()
  File "update_manager.py", line 30, in update
    self.database.update_feed_items(feed_id, new_items)
  File "database.py", line 137, in update_feed_items
    self.cur.executemany(
sqlite3.IntegrityError: UNIQUE constraint failed: feeds_last_items.url

Process finished with exit code 1

When updating last feed items in the database, SQL query can fail sometimes because current database schema is relying on `url` of the `FeedItem` to be unique, but it's not the oftenly. We should rely on something like `guid` and store it instead. We also probably don't need an `UNIQUE` constraint there **at all**. This could be fixed while working on #15. ``` Traceback (most recent call last): File "update.py", line 18, in <module> updater.update() File "update_manager.py", line 30, in update self.database.update_feed_items(feed_id, new_items) File "database.py", line 137, in update_feed_items self.cur.executemany( sqlite3.IntegrityError: UNIQUE constraint failed: feeds_last_items.url Process finished with exit code 1 ```