this question might be more about the structure of the imdb database in SQL than about IMDbPY, but I'm hoping you can help as I'm not sure where else to turn with it.
I've used IMDbPY to import a subset of the IMDb list files into MySQL, and I have a program that uses these tables to gather information about movies and tv shows. It will perform queries for things like director, cast, genre, etc. For movies it works great to just use the "id" key in the "title" table to get this information from other tables, but for TV series it appears to be a different story. For example if I use the "search_movie.py" program to search for "Futurama" using the SQL access method, I get these results:
movieID : imdbID : title
715550 : 0149460 : "Futurama" (1999)
715549 : None : "Futurama" (1999)
712510 : 0149460 : "Futurama" (1999)
709134 : 0149460 : "Futurama" (1999)
706740 : 0149460 : "Futurama" (1999)
703744 : 0149460 : "Futurama" (1999)
700084 : 0149460 : "Futurama" (1999)
673085 : 0149460 : "Futurama" (1999)
... (irrelevant approximate results left off)
My question is how can I use these results to get overall information about the show. I realize that a lot of information about tv shows is specific to each episode, but on the imdb page for the show itself, there is at least the creator, the 'series cast summary', and the genre, among other things. If I use the 'web' access method with search_movie.py, I only get this relevant result:
movieID : imdbID : title
0149460 : 0149460 : "Futurama" (1999)
and if I then run 'get_movie.py 149460' with the web access method, I get:
Title: "Futurama" (1999)
Genres: Animation, Sci-Fi, Comedy.Writer: Matt Groening, Matt Groening, David X. Cohen.
Runtime: 30.
Country: USA.
Language: English.
Rating: 9.2(2941 votes).
Plot: Phillip Fry is a 25-year-old pizza delivery boy whose life is going nowhere...
So it looks at this point like 'imdb_id' is the field to use in the SQL tables, because all the results I got through sql had the same value for it. But I can't find anything in any other tables that point to that value (149460) and contain the information I'm looking for. movieID seems to be the only field used as a foreign key in other tables. The movieIDs in the first list above each have a seemingly random selection of episodes that point to them, all from different seasons, with their "episode_of_id" field, although bizarrely I have to subtract 1 from the movieID to find those. For example, "SELECT * FROM title WHERE episode_of_id = (712510 - 1);" returns 14 episodes from various seasons, but using 712510 itself produces no results. I can't find anywhere the Creator or any of the other overall information about the series. Could I be missing a list file (I have cast_info, but not complete_cast), or is this something that's on the web site but not part of the downloadable list files? Or am I missing something else...
Thanks for any help you can offer, and sorry for the long-winded question.
-Jay Klein
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
