From d41b60d08fdd5a6589cdb4e33ac1931fa16aef4c Mon Sep 17 00:00:00 2001
From: dev
Date: Wed, 24 Jun 2026 04:53:05 +0200
Subject: 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.
---
 src/imdbdata.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/imdbdata.go')

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 {
-- 
cgit v1.2.3