summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authordev2026-06-25 20:45:58 +0200
committerdev2026-06-25 20:45:58 +0200
commita5e3f8447022a50080a62285e359d38e0875de21 (patch)
tree61eb209cc3d1ebee06f6207a9d77189a533ddaa2
parent1972c3f0a93c23d861f8b00e4b3570f450d4519a (diff)
downloadhnimdbbot-a5e3f8447022a50080a62285e359d38e0875de21.tar.gz
fix: skip already-classified entries in wikidata query
Add has_no_wiki_article = 0 filter so entries previously marked as having no Wikipedia article are not re-queried on subsequent runs.
-rw-r--r--src/wikidata.go2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/wikidata.go b/src/wikidata.go
index dfaf1bd..20411d2 100644
--- a/src/wikidata.go
+++ b/src/wikidata.go
@@ -42,7 +42,7 @@ type jsonNode struct {
// getMissingWikiArticles returns imdb_ids where wiki_article IS NULL.
func (a *App) getMissingWikiArticles() ([]string, error) {
- rows, err := a.DB.Query(`SELECT imdb_id FROM imdb WHERE wiki_article IS NULL AND imdb_id LIKE 'tt%'`)
+ rows, err := a.DB.Query(`SELECT imdb_id FROM imdb WHERE wiki_article IS NULL AND has_no_wiki_article = 0 AND imdb_id LIKE 'tt%'`)
if err != nil {
return nil, fmt.Errorf("query missing wiki articles: %w", err)
}