Hi,
I need help with SQLAlchemy. I am not sure if this is the right forum to ask
the query but since we are using Pylons and SQLAlchemy is part of the same,
I thought asking here:
I am using UPDATE query on SQLAlchemy session as follows:
p = DBSession.query(Paymenttransaction).filter_by(id =
payment.id).update({"status":'success', "transactionid":'transaction_id']},
synchronize_session=False)
p is returning 1 (number of rows matching the query). There is also no
exception thrown. But somehow the columns are not getting updated in the
Database. I am not sure what is going wrong here.
I have used similar query elsewhere in the code where it is working fine.
Would really appreciate if you could give me some pointers.
We are using SQLAlchemy 0.6. Database is MySQL.
Looking forward to your response and support.
Thanks,
Pinakee Biswas
Director & CTO
cid:E95B8D36-1F36-4B11-B91A-CF8977B83894
7E- Mail: <mailto:[email protected]> [email protected] I 8Web:
<http://www.vvidiacom.com/> http://www.vvidiacom.com
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
<<image001.jpg>>
<<image002.png>>
