Skip to content

Latest commit

 

History

History
26 lines (20 loc) · 672 Bytes

README.md

File metadata and controls

26 lines (20 loc) · 672 Bytes

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);'