I tried that and still cannot seem to change the field.
On Jun 20, 3:25 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> 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=s....-
> Hide quoted text -
>
> - Show quoted text -
--
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.
