欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
IMDbPY
来自开放百科 - 灰狐
（版本间的差异）
| 第11行： | 第11行： | ||
http://localhost:8000 | http://localhost:8000 | ||
| − | How to put the whole IMDb's database in a SQL database. | + | 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. | 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 | http://imdbpy.sourceforge.net/docs/README.sqldb.txt | ||
2007年4月15日 (日) 14:29的版本
IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about both movies and people.
Install
apt-get install python-imdbpy 获得 imdbpyweb python setup.py install python imdbpyweb http://localhost:8000
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:
分享您的观点
