I would guess (without knowing) that the dbi_database_connection object is to the Zope Object Database; not an RDBMS interface. What you would need to do is access the actual database connection object inside the ZODB and invoke it to get a Python connection object, then do whatever magic you need to to invoke its execute() method from Perl, followed by invoking its fetch{one|many|all}method. I dont know how to do that myself. Robin Smidsrød wrote:
If I create a normal Z DBI database connection, is there a way to use this handle to directly get the corresponding DBI $dbh for that connection?
I would like to use the persistence of Zope to get rid of connection-penalty, but I need to use the DBI API to be able to make advanced scripts which calls multiple SQL-statements without the need to make Z SQL Methods for each one...
I've looked over Zope.pm (zoperl), and taken a small look at the relevant ZDBI_DA files, but the solution isn't obvious.
Can I use it something like this?
----------------- cut here ---------------------- package ZopeExt::return_something;
use Zope;
# dbi_database_connection is defined in the Zope object tree # DBH is the field described in the Zope.pm BEGIN sub. # Is this correct? my $dbh=$Zope::DBH{'dbi_database_connection'};
my $sth=$dbh->prepare('select * from table'); $sth->execute;
my @row=$sth->fetchrow;
return @row;
1;
---------------- cut here -----------------------
BTW: I sent this to the zope-perl mailinglist, but it doesn't look like there is much activity on that list.
-- Matt Kromer Zope Corporation http://www.zope.com/