when you say "get data from 3 databases" it sounds like each of these databases has a different set of tables within them. this is called vertical partitioning. horizontal partitioning is when each of the three databases contain identical schemas, each storing a subset of the data for those tables.
if you're vertically partitioning, the Session will switch among different databases based on the tables you ask for. A brief description of that is here: http://docs.sqlalchemy.org/en/latest/orm/session.html#simple-vertical-partitioning. Later on in that section is a description of horizontal partitioning, which is a more involved technique. On Nov 7, 2012, at 1:46 AM, kampy wrote: > Hi all, > > I have requirement where i need to get data from 3 databases and integrate > all the data. while searching i found there is support in SQLAlchemy by using > horizantal sharding, but i didnt get any correct procedural way to do it. if > anyone had done these kind of requirement please help me out in getting these > things. > > Thanks in Advance > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/BPIp2h2Ryz8J. > 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. -- 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.
