yeah, well, i was using implicit for little things and explicit for the bigger ones, but it seems that even small things are error prone :) i was just wondering if there's a "faster" way to do it, even explicit, so i can get a class (whatever it is) to query against an engine i know (so there's the key to make things work). if I have a metadata bind to some engine, is there a quick (and performatic) way to know it?
Em 2014-05-18 16:21, Michael Bayer escreveu: > On May 18, 2014, at 12:10 PM, Richard Gerd Kuesters > <rich...@humantech.com.br> wrote: > >> well, this part is still working, as long as i remember. my biggest problem >> now - and has been for the last couple of years - is to manage this mayhem >> of classes and engines AND sessions, because everyone "wants to go online" >> with their data. i'm writting and rewriting a session manager that can >> simplify my life for a looooong time, i got close to get things done with >> your RoutingSession vertical example, but it doesn't work very well with >> functions, session.query(...).count() or .exists() and so on. i'm writing >> code as hell and still far from an acceptable, performatic session "router" >> (?) for a class that can come from anywhere, for one or more specific >> engines, without grind string ids everywhere. >> >> well, i think my problem have a lot of weaknesses to discuss ... but, one at >> a time. >> >> for now, any tips on enterprise multi-everything session routing? :) > > you're trying to route to different sessions based on the intricacies of > what's inside a SELECT statement? See I just would never do that, it's very > complicated and error prone. I'd have an explicit node name sent in right at > the top. Explicit is better than implicit. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.