On Mar 19, 12:43 pm, raharley <[email protected]> wrote: > Maurits van Rees-3 wrote: > > > Op 17-03-11 11:53, raharley schreef: > >> This is the problem I am going to have. I am integrating a ZMI based > >> application with lots of sql methods/python scripts with a Plone install. > >> What's the best practice here? > > > Best would probably be to replace those zsql mothods with sqlalchemy. > > There's 9000 ZSQL methods in the application .... I want to have a life for > the next two years :) > Also how does sql alchemy handle joining 6 tables in a normalised database. > Not as easily as straight SQL I would bet.
If your tables are defined correctly, just as easily, ime. I'm not really sure why you should replace zsql methods though. Just export them and drop them in your skins template directory. I have a (file- system based) product using SQLAlchemyDA, zsql methods, and straight SQLalchemy. On the same site I have ore.contentmirror, also using sqlalchemy. What I really want is a way to define the connection strings in only one place. _______________________________________________ Product-Developers mailing list [email protected] https://lists.plone.org/mailman/listinfo/product-developers
