tonydebat/threemetres

Television show tracking and recommendation engine

threemetres

Television show tracking and recommendation engine

Requirements

• Python 2.7
• Django 1.10.5
• MySql 5.7

Data

Television show data comes from tvdb.

Data can be retrieved and updated via their api.

To avoid placing a heavy load on the TVDB server it's also possible to download an initial dump of the database from this directory.

Installation of bulk TVDB Data

Start the MySql command line console and create the database.

CREATE DATABASE tvdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Create a user who has access to the new tvdb database.

GRANT ALL ON `tvdb`.* TO 'tvdbuser'@'localhost' IDENTIFIED BY 'secretpassword';

Load the bulk TVDB data into the newly created database.

mysql --password --user tvdbuser tvdb < tvdb.sql