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 2>&1
> | 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
