Skip to content

Latest commit

 

History

History
42 lines (35 loc) · 922 Bytes

README.md

File metadata and controls

42 lines (35 loc) · 922 Bytes
Raw
IMDB2SQL

The project IMDB2SQL intended to create local postgres database with data from open source IMDB datasets (https://datasets.imdbws.com). The second part of the project exposes database via GraphQL

Prerequisites:
  • Python 3.6+
  • docker-compose
Usage:
  • run.py
  -h, --help            show this help message and exit
  --root ROOT, -r ROOT  Directory where data sets will be downloaded
  --download, -d
  --extract, -x
  --parse, -p
  --load, -l
  --dburi DBURI, -db DBURI
                        Database URI
  --resume {name,principal,rating}
                        Start parsing not from first table
  --debug, -dd
  --quiet, -q

Download, extract, parse and copy dataset to postgres database

python3 run.py -r ~/ -d -x -p -l
  • app.py - Flask application which exposes GraphQL endpoint
http://127.0.0.1:5000/graphql
Testing:
./run_tests.sh