From 7eb0ad568ee9f200cd8b6185b9515deacfd89ff6 Mon Sep 17 00:00:00 2001 From: James Vasile Date: Fri, 2 Nov 2012 14:44:06 -0400 Subject: cleanup extra cursor creation --- withsqlite.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/withsqlite.py b/withsqlite.py index 63e8494..19370a0 100644 --- a/withsqlite.py +++ b/withsqlite.py @@ -117,14 +117,14 @@ True if not os.path.exists(self.fname): self.make_db() self.conn = sqlite3.connect(self.fname) - c = self.conn.cursor() - c.execute('''create table if not exists store (key text unique, val text)''') - self.conn.commit() self.crsr = self.conn.cursor() + self.crsr.execute('''create table if not exists store (key text unique, val text)''') + self.conn.commit() return self def __exit__(self, type, value, traceback): self.conn.commit() self.crsr.close() + def make_db(self): conn = sqlite3.connect(self.fname) c = conn.cursor() -- cgit v1.2.3