thanks JJ and Philip for the reply. It might be a moot point for me because I'm having trouble getting sqlalchemy to work properly with Oracle, and I'm not sure its an sqlalchemy issue ro poor database design. I may have to do all the Oracle database stuff in straight forward sql rather then using an orm. :(
Jose Galvez wrote: > Hi all, > I just started using the pylons.database methods for one of my projects > and I've come across what I think is a problem (or rather jut something > I don't know how to deal with) The project requires two different > models connecting to two different database server with two different > users. Specifically I will be connecting to a mysql database and an > oracle database. I didn't design the databases, and at lease on the > oracle side its read only. I was hopping to user sqlalchemy to model > the data, but how do I connect to them both? The docs say that the > default database reference is sqlalchemy.url (I may this worng, but no > matter) Can I just create a second one for oracle say oracle.url and > connect to it explicitly with > make_engine(g.pylons_config.app_conf['oracle.url'] ? I've tried it yet > just thought I would ask first. Also is g available to use in models, > or do I have t import it first (from pylons import g)? Thanks for any > and all help. > > > Jose > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
