Hi Davide,
I figured out my friend's problems. The votes and rating information are
stored in the movie_info_idx table, not the movie_info table...
As for the cast info, it looks like maybe it was not imported into the
database. I did not do the importing so I am not sure if anything went
wrong (eg missed file). We'll investigate this more on our own and come
back to the list if it seems like a library bug and not a silly mistake on
our part.
Thanks,
Ben
On Sun, Feb 20, 2011 at 11:08 AM, Davide Alberani davide.alber...@gmail.com
wrote:
On Sun, Feb 20, 2011 at 16:46, Te Kim tk...@ucsc.edu wrote:
My group is using a SQL database to make these calls. Is this a bug or
could there
possibly be something wrong with our database?
What you're trying to do should work.
Are you sure to have downloaded and processed all the
available plain text data files?
Please download each available file (and be sure that they're
not corrupted) and - if possible - keep track of the output of
the imdbpy2sql.py script.
In a Unix environment, use something like:
imdbpy2sql.py -d /path/to/imdb_files/ -u db::/connection_params 21
| tee debug.txt
Notice that you can somewhat speed-up the process creating temporary
CSV files (see the README.sqldb for complete information - essentially
you need to add a '-c /path/to/a/tmp/directory/' argument to the command
line).
In addition, I am unable to find ratings or votes in the database.
The query:
select * from movie_info mi join info_type it on mi.info_type_id
= it.id where it.info = 'runtimes' group by mi.info;
yields results, as well as in the case where it.info = 'genres'.
However, if I change it.info to 'votes', 'cast', or 'rating', I get 0
rows.
Well, 'cast' information are not there: they are in the cast_info table.
Votes and rating should be present.
What could be the reason for the missing information?
Hard to tell: or you don't have some information, or something has
gone wrong importing it.
Unfortunately I'll be unable to do deeper tests on the database
access system for another day or two, so in the meanwhile try to
collect as much information as possible to spot the problem.
HTH,
--
Davide Alberani davide.alber...@gmail.com [PGP KeyID: 0x465BFD47]
http://www.mimante.net/
--
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb___
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help