background image
65.
cur.close()
66.
except
:
67.
if
warning:
68.
traceback.print_exc()
69.
return
None
70.
return
ret
71.
72.
def
execute(self, sql, warning=1):
73.
self._check_alive()
74.
try
:
75.
cur
= self.conn.cursor()
76.
rows = cur.execute(sql)
77.
self.conn.commit()
78.
cur.close()
79.
return
rows
80.
except
:
81.
if
warning:
82.
traceback.print_exc()
83.
return
-1
84.
85.
def
close(self):
86.
if
self.connected == 0:
87.
return
88.
try
:
89.
self.cur.close()
90.
self.conn.close()
91.
self.connected = 0
92.
except
:
93.
pass
94.
95.
def
__del__(self):
96.
self.close()
97.
98.
def
_lbsql_test_sqlite3():
99.
db = SQLObj(db =
"youmoney.db"
)
100.
lists = db.dquery(
"select * from capital"
)
101.
for
l
in
lists:
102.
for
k, v
in
l.items():
103.
print
"%s: %s"
%(k, v),
104.
break
105.
break
106.
107.
if
__name__ ==
"__main__"
:
108.
_lbsql_test_sqlite3()