IMDbPY

2007年4月15日 (日) 14:34的版本

IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about both movies and people.

• http://imdbpy.sourceforge.net
• http://www.imdb.com/help/show_article?conditions

Install

apt-get install python-imdbpy
get  imdbpyweb
python setup.py install
python imdbpyweb
http://localhost:8000

The Plain Text Data Files

• ftp.fu-berlin.de (Germany) ftp://ftp.fu-berlin.de/pub/misc/movies/database/
• ftp.funet.fi (Finland) ftp://ftp.funet.fi/pub/mirrors/ftp.imdb.com/pub/
• ftp.sunet.se (Sweden) ftp://ftp.sunet.se/pub/tv+movies/imdb/

How to put the whole IMDb's database in a SQL database. as of 12 Nov 2006, with about 890.000 titles and over 2.000.000 names

the database will require between 1.5GB and 3GB of disc space.

# mysqladmin -p create imdb // mysql
# createdb -W imdb // postgresql

# imdbpy2sql.py -d /dir/with/plainTextDataFiles/ -u 'URI'

URI

scheme://[user[:password]@]host[:port]/database[?parameters]

Where 'scheme' is one in "sqlite", "mysql", "postgres", "firebird","interbase", "maxdb", "sapdb", "mssql", "sybase".

mysql://user:password@host/database
postgres://user:password@host/database
mysql://host/database?debug=1
postgres:///full/path/to/socket/database
postgres://host:5432/database
sqlite:///full/path/to/database
sqlite:/C|/full/path/to/database
sqlite:/:memory:

http://imdbpy.sourceforge.net/docs/README.sqldb.txt