diff options
| author | dev | 2026-06-25 20:07:08 +0200 |
|---|---|---|
| committer | dev | 2026-06-25 20:07:08 +0200 |
| commit | fa742660190a7d3b7b6f068565ce543d413edbab (patch) | |
| tree | 3515262a4bd47aac3e998ecf134451257b0181a0 /schema | |
| parent | d41b60d08fdd5a6589cdb4e33ac1931fa16aef4c (diff) | |
| download | hnimdbbot-fa742660190a7d3b7b6f068565ce543d413edbab.tar.gz | |
feat: fetch Wikipedia article titles via Wikidata SPARQL
- Query Wikidata SPARQL in batches of 30 for entries missing wiki_article
- Store wiki_article title in imdb table
- Respect rate limits with configurable delay and retry on 5xx/429
- Skip entries that have no Wikipedia article
- Removed unique constraint on wiki_article (multiple entries can share one)
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/schema.sql | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/schema/schema.sql b/schema/schema.sql index 9b1e5ab..f957079 100644 --- a/schema/schema.sql +++ b/schema/schema.sql @@ -34,7 +34,6 @@ CREATE TABLE `imdb` ( `num_votes` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `imdb_id` (`imdb_id`), - UNIQUE KEY `wiki_article` (`wiki_article`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; |
