diff options
| author | dev | 2026-06-24 04:53:05 +0200 |
|---|---|---|
| committer | dev | 2026-06-24 04:53:05 +0200 |
| commit | d41b60d08fdd5a6589cdb4e33ac1931fa16aef4c (patch) | |
| tree | 406a40ac279a6bf9d2b8ddbe0e85d410788783c8 | |
| parent | 1d20ca594c4246a3fcd63c52911b6d56c0aa503e (diff) | |
| download | hnimdbbot-d41b60d08fdd5a6589cdb4e33ac1931fa16aef4c.tar.gz | |
fix: use INSERT IGNORE for imdb_genre to handle re-runs
The previous run left partial data after a mid-transaction rollback.
INSERT IGNORE makes the junction table insert idempotent.
| -rw-r--r-- | src/imdbdata.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/imdbdata.go b/src/imdbdata.go index cea914e..8313188 100644 --- a/src/imdbdata.go +++ b/src/imdbdata.go @@ -274,7 +274,7 @@ func (a *App) applyImdbUpdates(ratings map[string]ratingEntry, basics map[string defer genreUpsert.Close() genreLink, err := tx.Prepare(` - INSERT INTO imdb_genre (imdb_id, genre_id) + INSERT IGNORE INTO imdb_genre (imdb_id, genre_id) VALUES ((SELECT i.id FROM imdb i WHERE i.imdb_id = ?), ?) `) if err != nil { |