I have the following code:
db = SqlSoup('sqlite:///c:\\tutorial.db3')
db_dynamic = 'tf_user'
DB = db.entity(db_dynamic)
print DB
ColHeader = DB.c.keys()
conn = db.connection()
#modify a field
DB.password = 'hello'
db.flush()
#get the table data
data = select([db.tf_user],)
listdata=[]
for row in conn.execute(data):
row = ["%s" % el for el in row]
listdata.append(row)
print listdata
which is supposed to modify the value of the password field in a database to
'hello'. However, when I examine the database nothing has changed, the old
value is still there. What am I doing wrong? What is the best way to update
or modify fields? I can't seem to find anything substantial regarding
SQLSoup.
Thanks
Aref
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
