On Jun 20, 2010, at 5:33 PM, Aref wrote:
> I tried that and still cannot seem to change the field.
is "password" an actual column in the database table ? create a SQLSoup using
an engine obtained via create_engine(), and specify echo=True on that engine to
see what SQL is actually emitted.
>
> On Jun 20, 3:25 pm, Michael Bayer <[email protected]> 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
