diff options
| author | dev | 2026-06-24 04:40:22 +0200 |
|---|---|---|
| committer | dev | 2026-06-24 04:40:22 +0200 |
| commit | 1d20ca594c4246a3fcd63c52911b6d56c0aa503e (patch) | |
| tree | 0720522d745a455e344b4b4721651af06bc7497c /imdbdata/source.txt | |
| parent | 6d5231a204790dae325a0557d908c2c6d15bb516 (diff) | |
| download | hnimdbbot-1d20ca594c4246a3fcd63c52911b6d56c0aa503e.tar.gz | |
feat: adapt genre code for n:m relation via imdb_genre
- genre table: (id, name) with unique name constraint
- imdb_genre table: (id, imdb_id, genre_id) junction table
- Upsert genres via INSERT ... ON DUPLICATE KEY UPDATE
- Link via imdb_genre using LAST_INSERT_ID
- Check missing genres via LEFT JOIN imdb_genre
Diffstat (limited to 'imdbdata/source.txt')
0 files changed, 0 insertions, 0 deletions