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.