[Zope] Database Adaptors and security and query()

[Cary O'Brien]

Couple of things came up trying to use the current PostgreSQL da
and zope 2.2b3.  I am working on a ZClass that lets you define
and create tables in a database, so I needed to execute some
generated sql [1].  

1) I couldn't access the query() method of the connection unless
   I added our friend

   __allow_access_to_unprotected_subobjects__=1
 
  to the DB class defined in ZPyGreSQLDA/db.py

   Is this ok?

2) Re calling query().  The query method only returns a tuple used
   to create a Results object (which dtml-in would like).  So I
   added a method to return a real live Results object 

   def query_result(self,query_string, max_rows=9999999):
        return Results(self.query(query_string, max_rows))

   Which does what I want.  Is this ok?  Is this a good idea?

3) I went down several wrong paths until I realized that it seems
   as if dtml-methods can't return anything but strings.  Is this
   right?


4) Grumble.  I had a lot of trouble with the interaction between
   Results returning data as tuples, and dtml-in handling tuples
   of 2 differently than everything else.  Create a table with
   3 columns, everything works.  Create a table with two columns,
   things dont work.  Is there access to list() anywhere?

-- cary


[1] I know, I can hear you saying "Use ZSQLMethods" but 1) You can't subclass
    them, and b) You can't put one inside a ZClass without a dummy
    connection.