471,350 Members | 1,767 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

multiple record update in dbase thru sqlalchemy in python shell

I need to update multiple record in my table(in PostgreSQL dbase)..

here is my sample data
user_id user_name display_name email_address
1 user1 BPI bpi.com
2 user2 Union union.com
3 user3 WestBank westbank.com

i want to change the user_name of record 1 (user1--->user10),
change display_name of record2 (BPI --> HSBC) and email_address of record3(bpi.com-->hsbc.com)

how can i do that using sqlalchemy (object mapping) in python shell?
>>>session.query(User).filter_by(.....)

pls help.. thanks
Sep 17 '07 #1
0 1154

Post your reply

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.