Hi Werner,
Thanks for your response. We have been using 0.6 for quite sometime. Would there be lot of changes while upgrading to 0.8? We would need to plan accordingly. 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 From: [email protected] [mailto:[email protected]] On Behalf Of Werner Sent: 13 April 2013 16:17 To: [email protected] Subject: Re: Help with SQLAlchemy Hi, I don't use Pylons (at least not yet), but use SA. On 13/04/2013 12:12, Biswas, Pinakee wrote: 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. Is there a commit after this? If you activate logging on your DBSession you should be able to see this. 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. This is a very very very old version of SQLAlchemy, any reason why you don't use 0.8? Werner -- 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. -- 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>>
