Hi Laurent, Thanks for your response.
I think I have tried with commit also but I will try again. But do we need to commit after every query? I do not think I am doing commit after other queries but still they are working. I will check logging. Thanks, Pinakee Biswas Director & CTO DGSM Mobile (Voice & Data): +91-982-016-7979 GTel: +91-22-26733737 I IFax:+91-22-26732828 FE- Mail: [email protected] I IWeb: http://www.vvidiacom.com Please don't print this e-mail unless you really need to, this will preserve trees on planet earth. ----------------------------Disclaimer------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The information contained in this message (including any attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and permanently delete this message and any attachments from your system. Please note that e-mails are susceptible to change and malwares. VVIDIA COMMUNICATIONS PVT LTD. (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its receipt or damage to your system. -------------------------------------------------------------------------------------------------------------------------Disclaimer---------------------------------------------------------------------------------------------------------- -----Original Message----- From: Laurent DAVERIO [mailto:[email protected]] Sent: 13 April 2013 16:11 To: [email protected] Cc: Biswas, Pinakee Subject: Re: Help with SQLAlchemy 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: No, it's probably not the right forum, as SQLAlchemy is a dependency, not a part of Pylons (no more than Python, or Linux, are) :-) > 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. Have you tried adding an explicit DBSession.commit()? Pyramid doesn't require it - or, rather, doesn't allow for it, since it already uses an transaction manager - but if I remember correctly, Pylons has no automatic transaction manager. > Would really appreciate if you could give me some pointers. You could also activate SQL query logging (from the development.ini file), so that you can make sure that the query is effectively passed to MySQL. Best of luck, Laurent. -- 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.
