On Apr 09, Alex K <spaceout...@gmail.com> wrote:
> I used imdbpy2sql tool to have a local copy of imdb on my server.
> However some tables are missing. For example I don't seem to be
> able to find the "genre" of the movie. Am I missing something or
> is it simply missing?
Hi!
No, it's present [1] - provided that you've downloaded the genres.list.gz
file.
Information about movies are in the movie_info and movie_info_idx
tables; the 'genres' is in movie_info, specifically.
You have to check its ID in the info_type table (e.g.: 3).
After that, you can access information about the movie you need
in movie_info, and see the 'info' values of columns with
info_type_id set to 3 (notice that info_type_id is indexed only
in movie_info_idx, so accessing the whole movie_info table using it
will be very slow).
If you're thinking "what an insane db schema" I agree, but there's
a big amount of different kinds of data, and we have some serious
performance constrains (moreover, I'm not a database guru).
> Also would someone know if IMDB provides its own db schema to
> be downloaded?
As far as I know, no.
There are some schemas on their web site, describing the data they
grant access to when you pay to use it for commercial reasons, but
they are not that helpful for us.
HTH.
+++
[1] some (many) information are missing from the plain text data
files, but IMDbPY uses _every_ info in those files.
--
Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
