This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author lakshmipathi
Recipients lakshmipathi
Date 2009-12-24.10:18:35
SpamBayes Score 9.400356e-08
Marked as misclassified No
Message-id <1261649918.23.0.144063644038.issue7572@psf.upfronthosting.co.za>
In-reply-to
Content
Hi all,
I'm new user to python and sqlite, let me know if i'm wrong or it's
sqlite issue.When I uncomment the line from below program it works -as
expected. But even when it's commented It works for first time.-As per
doc,without commit -all changes will be lost- am i right?

Issue : Running the program once without commit works for the first time
but not the next time.

Try changing the return value from 'OSS' to 'GNU' and comment/uncomment
the commit line.
----------------------------------
Here is my program:
-------------------------------------
import sqlite3
def loopy():
	return 'OSS'
#get connection object 
conn = sqlite3.connect("/tmp/example")
#get curson obj. and invoke execute
cur = conn.cursor()

conn.create_function("loopy",0,loopy)

cur.execute("insert into stk values (loopy())""")
#commit changes.
#conn.commit()  # ******Uncomment this line and run again*******

# read values
cur.execute("select * from stk")
for row in cur:
	print row
	
cur.close()
-------------------------
History
Date User Action Args
2009-12-24 10:18:38lakshmipathisetrecipients: + lakshmipathi
2009-12-24 10:18:38lakshmipathisetmessageid: <1261649918.23.0.144063644038.issue7572@psf.upfronthosting.co.za>
2009-12-24 10:18:36lakshmipathilinkissue7572 messages
2009-12-24 10:18:35lakshmipathicreate