I'm in the process of building a database with all the movies available here and their genres, and would like to append the movie IDs that were added weekly. I see two possible ways to achieve this:
Kan ’n rolprent of TV-program nie vind nie? Teken aan om dit te skep.
Wil u hierdie item gradeer of tot ’n lys toevoeg?
Nie ’n lid nie?
Antwoord deur superboy97
op 4 Oktober 2024 om 11:47 VM
The creation of a new movie is a change.
How far it is looking is irrelevant, as it give you only one single Id : the last one that have been created in the database.
Antwoord deur ticao2 🇧🇷 pt-BR
op 4 Oktober 2024 om 12:28 NM
Just an idea.
Maybe a better solution would be to download the list of valid movie IDs.
https://developer.themoviedb.org/docs/daily-id-exports
http://files.tmdb.org/p/exports/movie_ids_10_03_2024.json.gz
It is basically in ascending order.
There are about 5 or 6 movies at the beginning that are out of order.
Every new movie gets an ID in this ascending order.
The ID of a Movie deleted from our Database is an ID that will never be reused.
So, check your Database for the largest ID.
And in the list of valid IDs, all IDs greater than your largest will be the new IDs.
Antwoord deur rocio.ortiz
op 7 Oktober 2024 om 3:35 VM
Thank you, both! @ticao2 your approach makes perfect sense and is probably the way to go for the application I'm thinking, will give it a shot!