yes the field password is an actual column. Below is the table
definition:
from sqlalchemy import *
from datetime import datetime
metadata = MetaData('sqlite:///c:\\tutorial.db3')
user_table = Table(\
'tf_user', metadata,
Column('id', Integer, primary_key=True),
Column('user_name', Unicode(16), \
unique= True, nullable=False),
Column('password', Unicode(40), nullable=False),
Column('display_name', Unicode(255), default=''),
Column('created', DateTime, default=datetime.now))
If I put a print statement in the code to print the field (before the
flush and commit) it prints the right value but that does not make it
to the file for some reason. I will try your suggection and see.
Thanks.
On Jun 20, 3:40 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> 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 <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
> > athttp://groups.google.com/group/sqlalchemy?hl=en.- 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.
