For a stepwise migration from raw, SQL, it will probably be easier to get
your mind around the SQL-expression side of the library, and then adopt ORM
features as you feel comfortable with them.
On the SQL-expression side of the library, you'll find that your Table()
object has a collection called "c" (for Columns). It's a dict-like
collection that supports retrieving the column by name:
Table.update() takes a dictionary of updates, so the name-based access is
already in there:
tbl.update(tbl.c.dateworked == mydate).execute(dict(columnname =
newvalue))
or using sessions:
S.execute(tbl.update(tbl.c.dateworked == mydate), dict(columnname
= newvalue))
HTH,
Rick
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
