Lines Matching refs:cur
164 cur = self.con.cursor()
165 cur.execute("select reftest()")
168 cur = self.con.cursor()
169 cur.execute("select returntext()")
170 val = cur.fetchone()[0]
175 cur = self.con.cursor()
176 cur.execute("select returnunicode()")
177 val = cur.fetchone()[0]
182 cur = self.con.cursor()
183 cur.execute("select returnint()")
184 val = cur.fetchone()[0]
189 cur = self.con.cursor()
190 cur.execute("select returnfloat()")
191 val = cur.fetchone()[0]
197 cur = self.con.cursor()
198 cur.execute("select returnnull()")
199 val = cur.fetchone()[0]
204 cur = self.con.cursor()
205 cur.execute("select returnblob()")
206 val = cur.fetchone()[0]
212 cur = self.con.cursor()
213 cur.execute("select returnlonglong()")
214 val = cur.fetchone()[0]
218 cur = self.con.cursor()
220 cur.execute("select raiseexception()")
221 cur.fetchone()
227 cur = self.con.cursor()
228 cur.execute("select isstring(?)", ("foo",))
229 val = cur.fetchone()[0]
233 cur = self.con.cursor()
234 cur.execute("select isint(?)", (42,))
235 val = cur.fetchone()[0]
239 cur = self.con.cursor()
240 cur.execute("select isfloat(?)", (3.14,))
241 val = cur.fetchone()[0]
245 cur = self.con.cursor()
246 cur.execute("select isnone(?)", (None,))
247 val = cur.fetchone()[0]
251 cur = self.con.cursor()
253 cur.execute("select isblob(?)", (buffer("blob"),))
254 val = cur.fetchone()[0]
258 cur = self.con.cursor()
259 cur.execute("select islonglong(?)", (1<<42,))
260 val = cur.fetchone()[0]
266 cur = self.con.cursor()
267 cur.execute("""
277 cur.execute("insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)",
289 #self.cur.close()
301 cur = self.con.cursor()
303 cur.execute("select nostep(t) from test")
309 cur = self.con.cursor()
311 cur.execute("select nofinalize(t) from test")
312 val = cur.fetchone()[0]
318 cur = self.con.cursor()
320 cur.execute("select excInit(t) from test")
321 val = cur.fetchone()[0]
327 cur = self.con.cursor()
329 cur.execute("select excStep(t) from test")
330 val = cur.fetchone()[0]
336 cur = self.con.cursor()
338 cur.execute("select excFinalize(t) from test")
339 val = cur.fetchone()[0]
345 cur = self.con.cursor()
346 cur.execute("select checkType('str', ?)", ("foo",))
347 val = cur.fetchone()[0]
351 cur = self.con.cursor()
352 cur.execute("select checkType('int', ?)", (42,))
353 val = cur.fetchone()[0]
357 cur = self.con.cursor()
358 cur.execute("select checkType('float', ?)", (3.14,))
359 val = cur.fetchone()[0]
363 cur = self.con.cursor()
364 cur.execute("select checkType('None', ?)", (None,))
365 val = cur.fetchone()[0]
369 cur = self.con.cursor()
371 cur.execute("select checkType('blob', ?)", (buffer("blob"),))
372 val = cur.fetchone()[0]
376 cur = self.con.cursor()
377 cur.execute("delete from test")
378 cur.executemany("insert into test(i) values (?)", [(10,), (20,), (30,)])
379 cur.execute("select mysum(i) from test")
380 val = cur.fetchone()[0]
