I had a similar issue that I resolved by creating a set_data_model
function that when I called in it would set some global variable to
the table objects based on the product passed in to the function. I'm
using multiple schemas in a Postgres database and wanted to try to
limit the number of connections and this was the best way to do that.
The other benefit is that none of my external scripts need to know
anything about the schemas or keeping track of different sessions. The
basic idea is shown below.
Table1 = None
table1_table = None
Table2 = None
table2_table = None
def set_data_model(product):
global Table1
global table1_table
global Table2
global table2_table
if product == 'A':
Table1 = productA.Table1
table1_table = productA.table1_table
Table2 = productA.Table2
table2_table = productA.table2_table
if product == 'B':
...
On Dec 2, 11:28 am, g3 N <tunetog3...@gmail.com> wrote:
> Thanks for the suggestions.
> I'll try them.
>
> Thanks,
> Gayatri
>
> On Thu, Dec 2, 2010 at 8:19 PM, Nagy Viktor <viktor.n...@toolpart.hu> wrote:
> > I would say that if no connection between the databases are required then
> > two sessions are pretty fine.
> > e.g no query like "db1.table1 join db2.table2" exists
>
> > otherwise, it might still work to use one session by importing/definig your
> > table classes twice, and adding all of them to your session with
> > Session.configure(binds={db1.table1: engine1, db2.table1: engine2})
>
> > On Thu, Dec 2, 2010 at 3:29 PM, gayatri <tunetog3...@gmail.com> wrote:
>
> >> Hello All,
>
> >> We have a client-server application. On server side we have two
> >> databases with same set of tables.
>
> >> Based on the client request, server has to get data from the
> >> corresponding database.
>
> >> So, in this scenario, I would like to know which of the following
> >> approaches is better?
>
> >> 1.To have two sessions and have a lookup based on the client request.
>
> >> 2.Have a single session and use sharding.
>
> >> Thanks,
> >> Gayatri
>
> >> --
> >> You received this message because you are subscribed to the Google Groups
> >> "sqlalchemy" group.
> >> To post to this group, send email to sqlalch...@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> sqlalchemy+unsubscr...@googlegroups.com<sqlalchemy%2bunsubscr...@googlegroups.com>
> >> .
> >> For more options, visit this group at
> >>http://groups.google.com/group/sqlalchemy?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "sqlalchemy" group.
> > To post to this group, send email to sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com<sqlalchemy%2bunsubscr...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
