On Jun 20, 2010, at 5:18 PM, Aref Nammari wrote:
> 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.
you need to commit() the transaction. The current 0.6 docs describe this:
http://www.sqlalchemy.org/docs/reference/ext/sqlsoup.html?highlight=sqlsoup#modifying-objects
.
--
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.
