diff options
author | James Vasile <james@jamesvasile.com> | 2012-11-02 14:44:06 -0400 |
---|---|---|
committer | James Vasile <james@jamesvasile.com> | 2012-11-02 14:44:06 -0400 |
commit | 7eb0ad568ee9f200cd8b6185b9515deacfd89ff6 (patch) | |
tree | 622d11706a49d6442389200dfe305b874a6b7f49 | |
parent | 2eed7551b95cebb82515574102952759b8dd81d9 (diff) |
cleanup extra cursor creation
-rw-r--r-- | withsqlite.py | 6 |
1 files 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() |