On 10/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I would like to be able to use SQLObject or SQLAlchemy for my tg > project, but since my older database, Sybase 9, is only accessible > through mxODBC, I do not think I have much choice. > have you think of migrating it ? or writting mxOBBC support for SA/SO?
> What do I have to worry about in creating custom model classes so that > eveything else in the tg stack "just works", like widgets, etc. > most of the toolbox wont work and the quickstart templates either, I think tg-admin will be totally broken. > Do I just need to implement an SQLObject like interface for each of my > model classes since they are typically derived from the SQLObject class > anyway? not necessary you could use any other method. like PDO > I would do this just using normal python DB-API calls. I know > it's not as fancy as the ORM tools, but if its all I got, its all I > got. > or write a SO/SA wrapper for mxODBC? I don't know for SA but it's not that complicated for SO check out http://sqlobject.org/module-index.html this should get you the basic module needs. on the other hand in order to do what you need you will need to patch this file, and add that TG layer to work with your underlaying protocol. http://trac.turbogears.org/turbogears/browser/tags/1.0b1/turbogears/database.py > Also, can I leave identity management alone, pull it normally from > postgresql or something like that, and pull other data from legacy > system. > identity is 100% optional > Is shouldn't matter right if I have multiple data sources as that > should all be encapsulated in the model classes? > for SO this is a bit complicated because you will have to handle 2 connection hubs. > Thanks, > Aaron Bostick > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
