SQL movie database description made by IMDBpy
Recently, I have been using the IMDBpy API to clear the IMDB dataset. This API has imdbpy2sql.py which can convert the IMDB movie dataset to SQL database. But I cannot find a description of this dataset. So I cannot understand the schema of this SQL database. There are too many tables in this database. Is there a way to find out?
I am strictly following this website for creating my database http://blog.secaserver.com/2013/08/importing-imdb-sample-data-set-mysql/ .
Thank you so much!
source to share
I doubt there are too many tables. There are many properties / relationships available.
I generated once while building pyIRDG . You can also take a look at this code for documentation of the available data. Here is the output of the comments: http://pastebin.com/zGnZ02w4
I also used MySQL Workbench to generate schema from DB.
There is also an article in the German blog c .
not that I know, and of course our DB is not in any SF. :-) Anyway, you can easily look at the schema in the imdb / parser / sql / dbschema.py module or use some tool directly on the database. Source .
source to share