GitHub - eob/ssql: SELECT brand(tweet), sentiment(tweet) FROM twitter AS tweet;

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 122 Commits
examples		examples
experiments/temperature		experiments/temperature
operator		operator
redis		redis
ssql		ssql
tweepy		tweepy
.gitignore		.gitignore
HOWTO-BULKLOAD-DB		HOWTO-BULKLOAD-DB
README		README
examples.txt		examples.txt
private_settings.tmpl		private_settings.tmpl
query.py		query.py
settings.py		settings.py
streambulkloader.py		streambulkloader.py
streamfilewriter.py		streamfilewriter.py
streamgrabber.py		streamgrabber.py
streamwatcher.py		streamwatcher.py
test.py		test.py

Repository files navigation

SELECT brand(tweet), sentiment(tweet) FROM twitter AS tweet;

LICENSE
-------

REQUIREMENTS
------------
tweepy---Twitter API
pyparsing---For the SSQL parsing
sqlalchemy---For putting results into a relational database
ordereddict---For creating an LRU cache of keys (geoloc cache)
geopy---For
nltk---For sentiment analysis


select text, from twitter where text contains "hi"

SELECT text, created_at, location, tweetLatLng("lat") as latitude, tweetLatLng("lng") as longitude FROM Twitter; 

Twitter_Sample is the fire sample
Twitter is what filters are issued against


Just pull down "location" and do the tweet latlng thing later