[New-bugs-announce] [issue7572] Strabge issue : cursor.commit() with sqlite

lakshmipathi report at bugs.python.org
Thu Dec 24 11:18:38 CET 2009


New submission from lakshmipathi <lakshmipathi.g at gmail.com>:

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()
-------------------------

----------
messages: 96851
nosy: lakshmipathi
severity: normal
status: open
title: Strabge issue : cursor.commit() with sqlite
type: behavior
versions: Python 2.6

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue7572>
_______________________________________


More information about the New-bugs-announce mailing list