API/Bulk Data Access. I've looked at all the dump files, but I can't find how you figure out if a Title is a film or a Tv Show. If I wanted to store additional.
IMDB DB Converter The file tosql.py converts (some of) the raw.list files to a sql database define by the schema below. The schemas folder contains the appropriate sql commands to construct the database for the supported databases (see the DatabaseTypes class in the tosql.py script). The script currently supports conversion to sqlite and postgres sql databases. Usage To use first configure the script by going to the top of the script and modifying the Database and Options classes. Once configured run python tosql.py, the script should notify you as it processes the various files. There is also a script called index.py that will let you add the indices to the database after adding all the data.
This script relies on components of the tosql script so the tosql script must be in the same directory or on the path. Full indexing either in database or through an external data structure will be added soon to allow autocomplete and partial title searches. Dependencies SQLite support is builtin for python 2.5+ so no additional modules are necessary to convert to a SQLite database. Postgres support is offered through by default. Note that you can use any database adapter you like in reality for postgres or otherwise provided it is compliant and provided you create a schema set for it in the schema folder see more details below. MySQL support is provided through Using another DB-API2 client database adapter As stated above you may use any compliant adapter given you edit the script file and provide the schemas in the following way:.
Create a variable for the database type in the DatabaseTypes class. Add a condition to the createtables function to drop and create your database. You may use the function executescript on open cursor/files to execute full SQL files, similar to the builtin capabilities of sqlite's executescript function. Add appropriate drop and create schemas to the schema folder, see the readme in the schema folder for naming conventions. In general these files are dbname.sql, dbname.usedict.sql and dbname.drop.sql. Add appropriate loading code to the start of the main section of the code, use the Database class to read in database parameters such as host, user name/password and database names. Do not put an import statement at the top of the file, use the import function to load the database driver only if necessary and your database type is being used.