Lines Matching refs:cur
178 cur = self.con.cursor()
179 cur.execute("select reftest()")
182 cur = self.con.cursor()
183 cur.execute("select returntext()")
184 val = cur.fetchone()[0]
189 cur = self.con.cursor()
190 cur.execute("select returnunicode()")
191 val = cur.fetchone()[0]
196 cur = self.con.cursor()
197 cur.execute("select returnint()")
198 val = cur.fetchone()[0]
203 cur = self.con.cursor()
204 cur.execute("select returnfloat()")
205 val = cur.fetchone()[0]
211 cur = self.con.cursor()
212 cur.execute("select returnnull()")
213 val = cur.fetchone()[0]
218 cur = self.con.cursor()
219 cur.execute("select returnblob()")
220 val = cur.fetchone()[0]
225 cur = self.con.cursor()
226 cur.execute("select returnlonglong()")
227 val = cur.fetchone()[0]
231 cur = self.con.cursor()
233 cur.execute("select raiseexception()")
234 cur.fetchone()
238 cur = self.con.cursor()
239 cur.execute("select isstring(?)", ("foo",))
240 val = cur.fetchone()[0]
244 cur = self.con.cursor()
245 cur.execute("select isint(?)", (42,))
246 val = cur.fetchone()[0]
250 cur = self.con.cursor()
251 cur.execute("select isfloat(?)", (3.14,))
252 val = cur.fetchone()[0]
256 cur = self.con.cursor()
257 cur.execute("select isnone(?)", (None,))
258 val = cur.fetchone()[0]
262 cur = self.con.cursor()
263 cur.execute("select isblob(?)", (memoryview(b"blob"),))
264 val = cur.fetchone()[0]
268 cur = self.con.cursor()
269 cur.execute("select islonglong(?)", (1<<42,))
270 val = cur.fetchone()[0]
274 cur = self.con.cursor()
275 cur.execute("select spam(?, ?)", (1, 2))
276 val = cur.fetchone()[0]
323 cur = self.con.cursor()
324 cur.execute("""
333 cur.execute("insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)",
355 cur = self.con.cursor()
357 cur.execute("select nostep(t) from test")
361 cur = self.con.cursor()
363 cur.execute("select nofinalize(t) from test")
364 val = cur.fetchone()[0]
368 cur = self.con.cursor()
370 cur.execute("select excInit(t) from test")
371 val = cur.fetchone()[0]
375 cur = self.con.cursor()
377 cur.execute("select excStep(t) from test")
378 val = cur.fetchone()[0]
382 cur = self.con.cursor()
384 cur.execute("select excFinalize(t) from test")
385 val = cur.fetchone()[0]
389 cur = self.con.cursor()
390 cur.execute("select checkType('str', ?)", ("foo",))
391 val = cur.fetchone()[0]
395 cur = self.con.cursor()
396 cur.execute("select checkType('int', ?)", (42,))
397 val = cur.fetchone()[0]
401 cur = self.con.cursor()
402 cur.execute("select checkTypes('int', ?, ?)", (42, 24))
403 val = cur.fetchone()[0]
407 cur = self.con.cursor()
408 cur.execute("select checkType('float', ?)", (3.14,))
409 val = cur.fetchone()[0]
413 cur = self.con.cursor()
414 cur.execute("select checkType('None', ?)", (None,))
415 val = cur.fetchone()[0]
419 cur = self.con.cursor()
420 cur.execute("select checkType('blob', ?)", (memoryview(b"blob"),))
421 val = cur.fetchone()[0]
425 cur = self.con.cursor()
426 cur.execute("delete from test")
427 cur.executemany("insert into test(i) values (?)", [(10,), (20,), (30,)])
428 cur.execute("select mysum(i) from test")
429 val = cur.fetchone()[0]