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.
