Find the dankest memes off twitch
Switch branches/tags
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
db_backup
log
src
.gitignore
README.md
empty_db.sql

README.md

Twitch-Meme-Scraper

Dependencies

Python 2.7 only
sudo apt-get install python-mysqldb

WINDOWS - .exe file
https://pypi.python.org/pypi/MySQL-python/1.2.5

Reference

http://zetcode.com/db/mysqlpython/
http://code.activestate.com/recipes/299411-connect-to-an-irc-server-and-store-messages-into-a/
http://stackoverflow.com/questions/23100704/running-infinite-loops-using-threads-in-python
https://pymotw.com/2/threading/ -- Daemon threading

TODO:

  1. Create/Destroy/Join threads to properly terminate program

USEFUL QUERIES get number of messages per minute 'SELECT Time AS sec, COUNT(*) AS cnt FROM Messages GROUP BY FLOOR(UNIX_TIMESTAMP(Time)/60);'