[Zope] Dynamic Reference, mixing ZOPE and SQL

[Ryan T. Bard]

I have a sequence of code that is monstrously inefficient and am
looking for help. I am storing the id tag of an ExtFile object in my
sql database along with other information and am now creating a page
that displays info from the database record by record. For each
record displayed, I also want to pull the file size from the Zope
side of things.

The method which works is something like this:

    <dtml-in my_query>
      <dtml-comment>
        query returns file_id amongst other values
      </dtml-comment>
      <dtml-with files>
        <dtml-in "objectValues(['ExtFile'])">
          <dtml-if "id == file_id">
            <dtml-var size>
          </dtml-if>
        </dtml-in>
      </dtml-with>
    </dtml-in>

With a 1000+ ExtFile objects in the "files" folder, the search is ok
for just one record being displayed; however, if this page is
displaying all 1000+ files based on the SQL records, then for each
SQL record returned it is iterating through the entire contents of
my files folder, and is very slow to resolve.

What I am looking for is a way to say:

    <dtml-in my_query>
      <dtml-comment>
        query returns file_id amongst other values
      </dtml-comment>
      <dtml-var files.file_id.size>  //where file_id is a dynamic ref
                                     // not the id itself
    </dtml-in>

However, I don't know a good method for doing a dynamic reference
here, such as the following which fails:

    <dtml-in my_query>
      <dtml-comment>
        query returns file_id amongst other values
      </dtml-comment>
      <dtml-with files>
        <dtml-in "objectValues(['ExtFile'])._['file_id']">
          <dtml-var size>
        </dtml-in>
      </dtml-with>
    </dtml-in>

I am just extrapolating from things like using "sequence-item" in an
expression changes it over to "_['sequence-item']". Not even sure
the dtml-in would work the way I want, but the idea is there. Maybe
to effectively use something like this to reference an object I
explicitly know:

    <dtml-in my_query>
      <dtml-comment>
        query returns file_id amongst other values
      </dtml-comment>
      <dtml-var "files._['file_id'].size">
    </dtml-in>

The above approach throws unauthorized exceptions, so obviously not
the right way to go about it.

Anyone know the correct syntax for achieving this both inside a
python expression and/or as a direct dtml expression?

Thanks,
-- 
Ryan T. Bard
Webmaster/Software Developer
Department of Medical Education
University of Miami School of Medicine
Office: (305) 243-3273

The information contained in this transmission may contain
privileged and
confidential information, including patient information protected by
federal and
state privacy laws. It is intended only for the use of the person(s)
named above. If
you are not the intended recipient, you are hereby notified that any
review,
dissemination, distribution or duplication of this communication is
strictly
prohibited. If you are not the intended recipient, please contact
the sender by
reply email and destroy all copies of the original message.