script/rest/search_twitter.py
changeset 289 a5eff8f2b81d
parent 255 500cd0405c7a
child 411 0471e6eb8a1b
--- a/script/rest/search_twitter.py	Tue Sep 20 16:55:16 2011 +0200
+++ b/script/rest/search_twitter.py	Thu Sep 22 12:37:53 2011 +0200
@@ -42,10 +42,10 @@
         conn_str = 'sqlite:///' + conn_str
 
     
-    engine, metadata = models.setup_database(conn_str, echo=((options.verbose-options.quiet)>0), create_all=True)
-    Session = sessionmaker(bind=engine)
-    session = Session()
+    engine, metadata, Session = models.setup_database(conn_str, echo=((options.verbose-options.quiet)>0), create_all=True)
+    session = None
     try:
+        session = Session()
         #conn.row_factory = sqlite3.Row
         #curs = conn.cursor()
         #curs.execute("create table if not exists tweet_tweet (json);")
@@ -67,6 +67,7 @@
             page += 1
             #session.commit()
     finally:
-        session.close()
+        if session:
+            session.close()