i'm porting an app to Pylons/SQLalchemy and am a bit lost with some of the concepts.
in my app, i have 5 unique db connections/handles that have specific user permissions for tables in postgres : read , write , config , log , session for the sake of simplicity, lets just say that every table/class will be associated to the db. obviously, I'll have a separate engine item for each db connection param my question is this: i. do i make 5 separate Session objects with orm.scoped_session , or just 1 ? ii. do i make 5 separate MetaData objects for use with sqlalchemy.Table() and orm.mapper() , or just 1? I'm trying to grasp exactly how the Session and MetaData work. some examples/docs/tutorials suggest i use a sep connection for each db, others suggest multiple. i'm trying to figure out the most- correct way to handle this. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
