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