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