[sqlalchemy] Understanding sqlalchemy memory usage and releasing unused memory

I wanted to get idea about how much memory my sqlalchemy objects are taking. I used pympler library and used its class tracking function. I am using declarative base for defining the model and hence tables. I am pretty new to web development and python in general. So some questions may not be

[sqlalchemy] @validates clean-up

I am having some trouble cleaning up after my @validates method throws an exception. The validation is of a relationship attribute and the foreign record should be removed. Are there some general tips? Otherwise I will post a code example. -- You received this message because you are subscribed

Re: [sqlalchemy] Disabling auto-conversion to Decimal in Oracle connections

On Feb 5, 2012, at 11:10 PM, Anthony Foglia wrote: If I do shut off the outputtypehandler on the connection, will that cause any other problems as I start adding Table objects with the appropriate Columns? Will the connection outputtypehandler be reset when it goes back into the pool? Or

[sqlalchemy] Re: Having trouble getting a subquery to return entities

Michael: I created a full reproducing test (http://pastebin.com/vutfUgpk) and the test ... WORKS! So, there's obviously something else creeping in here somewhere. It was useful for me to create the test. Thanks for the suggestion. I will close the loop when I find the cause of my original

[sqlalchemy] Question about mutable primary keys and foreign keys

I am trying to efficiently update all things that foreign key to a particular record so that they instead foreign key to a different record. I provided an example that illustrates the problem I am trying to solve. Please see my question at the bottom of the code. Thanks for your help, Michael

Re: [sqlalchemy] Question about mutable primary keys and foreign keys

On Feb 6, 2012, at 12:39 PM, Michael Naber wrote: I am trying to efficiently update all things that foreign key to a particular record so that they instead foreign key to a different record. I provided an example that illustrates the problem I am trying to solve. Please see my question at

[sqlalchemy] Re: session.query().get() is unsupported during flush for getting an object that was just added?

On Feb 1, 3:17 pm, Kent jkentbo...@gmail.com wrote: If the value is based on what's already been INSERTed for previous rows, I'd emit a SQL statement to get at the value.If it's based on some kind of natural consideration that isn't dependent on the outcome of an INSERT statement,

Re: [sqlalchemy] Re: session.query().get() is unsupported during flush for getting an object that was just added?

On Feb 6, 2012, at 4:05 PM, Kent wrote: On Feb 1, 3:17 pm, Kent jkentbo...@gmail.com wrote: If the value is based on what's already been INSERTed for previous rows, I'd emit a SQL statement to get at the value.If it's based on some kind of natural consideration that isn't dependent on