On Oct 18, Jay Klein <[EMAIL PROTECTED]> wrote:
> Hello,
Hi!
> 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.
Yes; for tv series, there are two kind of entries: one (and
hopefully only one ;-) refers to the main information about the
show; this entry is the one with the 'episode_of_id' field set
to NULL. I assume that you need this value of 'id'.
For the same series there are also other entries, one for each
episode, with different 'id' values; every one of these entries
has the 'episode_of_id' field set to the 'id' of the tv series
and 'kind_id' set to 7 (meaning "episode").
> For example if I use the "search_movie.py" program to search for
> "Futurama" using the SQL access method, I get these results:
That's strange.
Are you sure that you have the latest IMDbPY version (from the cvs,
if you can)?
If you've populated the database using an old version of IMDbPY,
try running again the imdbpy2sql.py script.
If it's so, how do you have modified the IMDB_PARAMS dictionary in
the search_movie.py script?
I'm unable to reproduce your behavior; my output is:
$ search_movie.py Futurama
18 results for "Futurama":
movieID : imdbID : title
553147 : None : "Futurama" (1999)
144909 : None : Futurama (2007) (V)
144908 : None : Futurama (2003) (VG)
140035 : None : Fotorama (1960)
144939 : None : Future One (1967)
130838 : None : Federmann (1999) (TV)
127184 : None : Father Mine (1975) (TV)
39687 : None : Il Fattorino (1918)
127212 : None : Fadren (1967) (TV)
[snip other results]
note: the imdbID field is None because I've run the script on a
off-line computer.
As you can see, there are no repetitions of the "Futurama" (1999)
entry, which seems to be a list of episodes.
And the first line match the tv series you're searching (the numbers
can vary amongst installations, and I've a very old data set on my
computer, actually).
> My question is how can I use these results to get overall information
> about the show.
Now, if I search for rows with 'movie_id' set to 553147 in
the 'movie_info', 'cast_info' and other tables I get the generic
information about the show (the ones that are not attached to
specific episodes).
> movieID seems to be the only field used as a foreign key in other
> tables.
Yep; once you've got the 'id' of the show you've searched in the
'title' table, you can use it to select data in other tables,
checking the 'movie_id' column.
> 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.
Hmmm... seems a nasty bug somewhere. I hope it's because you're using
a database created with an old version of imdbpy2sql.py; if it's not
the case, it may be a bit difficult to spot the problem. :-/
Anyway, I'm running the imdbpy2sql.py on my system right now; I'll
check the result.
> 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),
I'm not sure, but if you have actors, actresses, directors, genres,
keywords, language, movies, plot, ratings and writers something
_must_ show up, for the tv series "Futurama".
Obviously none are strictly required (except "movies.list"), but
without you'll lose a lot of information.
> or is this something that's on the web site but not part of the
> downloadable list files?
Not this kind of information: there are complete sets of information
not available on the data files (like "dvd" information), but that's
another story.
Unfortunately actually I don't have broadband access, so I can't
upgrade my data file before 2 or 3 weeks; maybe something has changed
in the file format (even if I doubt it: IMDb seems to be quite
uninterested in modifying the plain text data files)
Thank you for the bug report; please let me know if you can fix it
or if you have other problems!
--
Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/
-------------------------------------------------------------------------
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
