Hi, According to Mark Ramm's blog, supporting multiple databases is supposed to be easy (see http://compoundthinking.com/blog/index.php/2008/07/31/10-reasons-why-the-new-turbogears-2-alpha-is-worth-a-look/). So where is the documentation that says how to do it??
I "think" I need to put multiple sqlalchemy.url's in my development.ini file. But where oh where do I set up the SA engines at? The model's __init__ claims to support multiple databases too using MetaData, but it doesn't show where to bind the engine unless you're supposed to use the undocumented init_model function somehow. I'm pretty sure the init_model came from Perkins. Maybe he can tell me where to put my call to the function and how to set it up for multiple databases? That would be great! Thanks, Mike On May 28, 12:47 pm, Mike Driscoll <[email protected]> wrote: > Hi, > > I am having a little trouble wrapping my head around how to configure > my model's __init__.py file for multiple databases. I am working on an > application that accesses 3 databases and does reflection on select > tables from all three. > > I assume I need to comment out this line: > > metadata = DeclarativeBase.metadata > > and instead create three metadata instances based on MetaData(), > correct? > > Finally, as I understand it, I can use the "init_model" function to do > the mapping for some of them, but I am not understanding where to > create the engine object to pass to it. Also, once I have my tables > mapped in the function, what do I put in my real model file if > anything? > > Hopefully that stuff makes sense. I am using Python 2.5 and TG2 in a > virtualenv on Windows XP. > > Thanks! > > Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
