--- /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()
+
+