Message96851
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()
------------------------- |
|
Date |
User |
Action |
Args |
2009-12-24 10:18:38 | lakshmipathi | set | recipients:
+ lakshmipathi |
2009-12-24 10:18:38 | lakshmipathi | set | messageid: <1261649918.23.0.144063644038.issue7572@psf.upfronthosting.co.za> |
2009-12-24 10:18:36 | lakshmipathi | link | issue7572 messages |
2009-12-24 10:18:35 | lakshmipathi | create | |
|