clear_mappers()
engine.dispose()

let sessions and mapped objects fall out of scope

...and thats pretty much it.

however, you really shouldnt be opening up a brand new "sqlite://" 
connection for every test.  you should be using the same engine for 
the whole program, and just do a metadata.drop_all() each time.

which leads to the next thing, it would be extremely helpful if you 
converted this program to work as a regular SA unit test so i can 
check it in somewhere (i.e. using testbase.AssertMixin or 
testbase.ORMTest as a base class).  definitely stick to the "nested 
loops" style of testing all the cases, it would be madness to make a 
300 meg source file (like that generation script does).  that way the 
tests could embed into all the other services the testbase offers 
(testing across all databases, turning on code coverage, forcing 
different connection pool options, etc).

On Jan 28, 3:55 pm, [EMAIL PROTECTED] wrote:
> > all tests pass with rev 2267 of that branch.  try that rev
> > specifically, since i want to take whats there and do another pass.
> > im trying to get it so that the entire science of "parent table,
> > child table, polymorphic selectables, primary join -> polymorphic
> > joins -> determine direction/lazy clause/eager clause/synchronize
> > FKs" is super-well-nailed down.okay, give me a day.
> i've done the "bruteforce" A-B-C combinations test and now trying to
> classify the results...
>
> one thing that hickups is that i hit some memory leak or something -
> 4000 times setuping and tearing-down SA with sqlite/memory fills the
> available 2Gig RAM. That is 500K per session is leaking. i guess it
> might be sqlite problem, as gc didn't reveal anything...
> i'll try on postgres tomorrow.
>
> Is there any particular way of stopping SQLalchemy, so it
> force-releases all connections, removes all caches etc etc ?
>
> bye
> svil


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to