New submission from lakshmipathi <lakshmipath...@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 <rep...@bugs.python.org>
<http://bugs.python.org/issue7572>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe:
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
