luster/is-pepsi-okay — pull request #1 by luster (2014-11-21 04:46:58+00:00)
Title: Populate Database

The code in `./database/populate.py` populates the MySQL database `IsPepsiOkay` using the director/movie key (first column in UCI repository main.html) and title from the second, along with genre from the eighth (ninth?). The rest of the relevant columns were added with the `wikipedia` python module. Code was finicky with unicode strings as well as resolving which wikipedia page was the right page. Of ~11,000 films in the file, only 4,600 were initially added. I don't advise running the `populate.py` as is until some major refactoring is done.

For this project's purposes, this puts us in a good place. Some genre data is messy (duplicates, nonsensical names), and some People data are repeated (e.g. Charles Chaplin, Charlie Chaplin, etc.), but this is something we can improve with user interaction.

We can foreseeably also allow the user to search their own movies and provide links to wikipedia pages, for example.

![screen shot 2014-11-20 at 11 45 33 pm](https://cloud.githubusercontent.com/assets/1887425/5137823/643a2d5a-710f-11e4-8554-1497815ae1bd.png)

![screen shot 2014-11-20 at 11 46 35 pm](https://cloud.githubusercontent.com/assets/1887425/5137830/81da3e2c-710f-11e4-9caa-ae74a8002796.png)