Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #33174

Re: Is there a way to creat a func that returns a cursor that can be used?

Show all headers | View raw

Khalid Al-Ghamdi wrote:

> Is there a way to create a func that returns a cursor that can be used to
> execute sql statements?

You should read an introductory text on Python, this is not specific to 
sqlite3.
 
> I tried this (after importing sqlite3), but it gave me the error below:
> 
>>>> def connect():
>     conn = sqlite3.connect(':memory:')#use sch3.db or sch4.db  .... etc.
>     cur = conn.cursor()
>     cur.execute("create table schedule (teams integer, sn integer, badge
>     integer ,name text, grp integer,\
>     major text, track text, stage text,  tc text, subject text, course
>     text, ws text, date text, \ time text, proctor text, code text, no
>     integer,fl_time text, flag2 text, flag3 text, flag4 text, clash1
>     integer, clash2 integer)") return cur
>>>> connect()

connect() returns a cursor, but you discard the result. Try

     cur = connect()

> <sqlite3.Cursor object at 0x0119EA20>
>>>> cur.execute("select * from schedule")
> Traceback (most recent call last):
>   File "<pyshell#26>", line 1, in <module>
>     cur.execute("select * from schedule")
> NameError: name 'cur' is not defined

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Is there a way to creat a func that returns a cursor that can be used? Khalid Al-Ghamdi <emailkgnow@gmail.com> - 2012-11-12 02:45 -0800
  Re: Is there a way to creat a func that returns a cursor that can be used? Peter Otten <__peter__@web.de> - 2012-11-12 11:57 +0100
  Re: Is there a way to creat a func that returns a cursor that can be used? Chris Angelico <rosuav@gmail.com> - 2012-11-12 22:01 +1100
  Re: Is there a way to creat a func that returns a cursor that can be used? Terry Reedy <tjreedy@udel.edu> - 2012-11-12 15:41 -0500

csiph-web