X-Git-Url: http://git.datanom.net/lensdatabase.git/blobdiff_plain/29f0e748a8cd062a091bc4cca710fa91f720c11c..376dc649df68df57869e5f5a02d0cd263254bbde:/db.py diff --git a/db.py b/db.py index b285ff2..0fa2839 100644 --- a/db.py +++ b/db.py @@ -113,7 +113,6 @@ class DB: lensmaker = cur.fetchone() else: lensmaker = (maker, ) - #cur.execute("select sn, description, notes, id from lens where maker = ?", lensmaker) cur.execute(sql, lensmaker) rows = cur. fetchall() return rows @@ -130,7 +129,6 @@ class DB: lensmaker = cur.fetchone() else: lensmaker = (maker, ) - #cur.execute("select sn, description, notes, id from lens where description like ? and maker = ? COLLATE NOCASE", ('%'+pattern+'%', ) + lensmaker) cur.execute(sql, ('%'+pattern+'%', ) + lensmaker) rows = cur. fetchall() return rows