Re: SqlAlchemy thru Five

On Sun, Apr 02, 2006 at 09:26:40PM -0300, David Pratt wrote:
> Hi. I have seen very little in the way of SqlAlchemy through Z3 or Five. 
> Has anyone been working/experimenting with this that can provide some 
> feedback, experiences or whether there is anything ZPL that is in the 
> hopper that may be available in the future. It would be quite excellent 
> to get away from zsql and work with this excellent ORM. Many thanks.

Hoi David,

So I see you've moved away from SQLOS and SQLObject to SQLAlcehemy, mind
giving us some feedback or experiences?

Looking at the SQLAlchemy docs I guess you can use large pieces of SQLOS
for this integration. At a minimum you would want to integrate the
SQLAlchemy transaction and connection management.

It might integrate easier with Zope2 as the object from the ORM is not a
meta-class (as is the case with SQLObject). Though I have difficulty
seeing how you would organise a Two Phase Commit with the interface that
is shown in the docs.

However, I don't think this is really a Five subject and perhaps is
better discussed somewhere else. 

-- 
Brian Sutherland

Metropolis - "it's the first movie with a robot. And she's a woman.
              And she's EVIL!!"