diff -r b7f4b0554ef8 -r bb44692e09ee script/rest/search_enmi.py --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/script/rest/search_enmi.py Tue Jan 11 11:17:17 2011 +0100 @@ -0,0 +1,39 @@ +import sqlite3 +import twython + +def get_option(): + + parser = OptionParser() + + parser.add_option("-l", "--log", dest="logfile", + help="log to file", metavar="LOG", default="stderr") + parser.add_option("-v", dest="verbose", action="count", + help="verbose", metavar="VERBOSE", default=0) + parser.add_option("-q", dest="quiet", action="count", + help="quiet", metavar="QUIET", default=0) + parser.add_option("-r", "--request", dest="request", + help="twitter request", metavar="REQUEST", default=0) + #add request token + #add + + return parser.parse_args() + +if __name__ == "__main__": + + twitter = twython.Twython() + conn = sqlite3.connect('enmi2010_twitter_rest.db') + try: + conn.row_factory = sqlite3.Row + curs = conn.cursor() + curs.execute("create table if not exists tweet_tweet (json);") + conn.commit() + + results = twitter.searchTwitter(q="#enmi", rpp="50") + for tweet in results["results"]: + print tweet + curs.execute("insert into tweet_tweet (json) values (:json);", {"json":unicode(tweet)}) + conn.commit() + finally: + conn.close() + +