Lines Matching refs:cur
162 cur = self.con.cursor()
163 cur.execute("select reftest()")
166 cur = self.con.cursor()
167 cur.execute("select returntext()")
168 val = cur.fetchone()[0]
173 cur = self.con.cursor()
174 cur.execute("select returnunicode()")
175 val = cur.fetchone()[0]
180 cur = self.con.cursor()
181 cur.execute("select returnint()")
182 val = cur.fetchone()[0]
187 cur = self.con.cursor()
188 cur.execute("select returnfloat()")
189 val = cur.fetchone()[0]
195 cur = self.con.cursor()
196 cur.execute("select returnnull()")
197 val = cur.fetchone()[0]
202 cur = self.con.cursor()
203 cur.execute("select returnblob()")
204 val = cur.fetchone()[0]
209 cur = self.con.cursor()
210 cur.execute("select returnlonglong()")
211 val = cur.fetchone()[0]
215 cur = self.con.cursor()
217 cur.execute("select raiseexception()")
218 cur.fetchone()
224 cur = self.con.cursor()
225 cur.execute("select isstring(?)", ("foo",))
226 val = cur.fetchone()[0]
230 cur = self.con.cursor()
231 cur.execute("select isint(?)", (42,))
232 val = cur.fetchone()[0]
236 cur = self.con.cursor()
237 cur.execute("select isfloat(?)", (3.14,))
238 val = cur.fetchone()[0]
242 cur = self.con.cursor()
243 cur.execute("select isnone(?)", (None,))
244 val = cur.fetchone()[0]
248 cur = self.con.cursor()
249 cur.execute("select isblob(?)", (buffer("blob"),))
250 val = cur.fetchone()[0]
254 cur = self.con.cursor()
255 cur.execute("select islonglong(?)", (1<<42,))
256 val = cur.fetchone()[0]
262 cur = self.con.cursor()
263 cur.execute("""
272 cur.execute("insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)",
284 #self.cur.close()
296 cur = self.con.cursor()
298 cur.execute("select nostep(t) from test")
304 cur = self.con.cursor()
306 cur.execute("select nofinalize(t) from test")
307 val = cur.fetchone()[0]
313 cur = self.con.cursor()
315 cur.execute("select excInit(t) from test")
316 val = cur.fetchone()[0]
322 cur = self.con.cursor()
324 cur.execute("select excStep(t) from test")
325 val = cur.fetchone()[0]
331 cur = self.con.cursor()
333 cur.execute("select excFinalize(t) from test")
334 val = cur.fetchone()[0]
340 cur = self.con.cursor()
341 cur.execute("select checkType('str', ?)", ("foo",))
342 val = cur.fetchone()[0]
346 cur = self.con.cursor()
347 cur.execute("select checkType('int', ?)", (42,))
348 val = cur.fetchone()[0]
352 cur = self.con.cursor()
353 cur.execute("select checkType('float', ?)", (3.14,))
354 val = cur.fetchone()[0]
358 cur = self.con.cursor()
359 cur.execute("select checkType('None', ?)", (None,))
360 val = cur.fetchone()[0]
364 cur = self.con.cursor()
365 cur.execute("select checkType('blob', ?)", (buffer("blob"),))
366 val = cur.fetchone()[0]
370 cur = self.con.cursor()
371 cur.execute("delete from test")
372 cur.executemany("insert into test(i) values (?)", [(10,), (20,), (30,)])
373 cur.execute("select mysum(i) from test")
374 val = cur.fetchone()[0]
