Message96992
ok..let me put this question ,in different manner.
Here is my code (example2)
------------------
import sqlite3
def loopy():
return 'GNU'
#get connection object
conn = sqlite3.connect("/tmp/example2")
#get curson obj. and invoke execute
cur = conn.cursor()
cur.execute('''create table stk (txt text)''')
#insert a single record
conn.create_function("loopy",0,loopy)
t=(loopy(),)
cur.execute("insert into stk values (?)",t)
#I have close it without committing. -So my record length == 0
cur.close()
#But when i open again new cursor cur1
cur1=conn.cursor()
cur1.execute("select * from stk")
row = cur1.fetchall()
# i expect this assert to pass - since there is no record
assert len(row) < 1
-------------------------------------------------------
I used sqlite3 /tmp/example2 and select * from stk returned zero records
as expected.
--------------------------
So commit refers to committing to Database not with in the program. |
|
Date |
User |
Action |
Args |
2009-12-29 10:43:08 | lakshmipathi | set | recipients:
+ lakshmipathi, ghaering |
2009-12-29 10:43:07 | lakshmipathi | set | messageid: <1262083387.98.0.250044043296.issue7572@psf.upfronthosting.co.za> |
2009-12-29 10:43:06 | lakshmipathi | link | issue7572 messages |
2009-12-29 10:43:05 | lakshmipathi | create | |
|