Re: Better access to database search results

Tue, 12 Apr 2005 14:03:50 -0700



Simon Brunning wrote: 
On Apr 12, 2005 4:32 PM, Gabriel Cooper <[EMAIL PROTECTED]> wrote:
  
Usually when I access db search results it's something like this:

cursor.execute("select A1,A2,A3,A4 from B where C")
for (a1,a2,a3,a4) in cursor.fetchall():
    stuff()

But sometimes the point at which I use the data returned is not with the
search, and so having the ability to access the results as a dictionary
is more useful.

Let me know what you think. Could this be done simpler?
<snip>
    

Have you come across dtuple?
(<http://www.lyra.org/greg/python/dtuple.py>). It's really easy to use
- <http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/81252>.
Hm. that's interesting, it's pretty much the same idea, only I do all the processing up front and return a complete variable that's generally indistinguishable from a list of dictionaries. This method (at least in the ASPN example) appears to prefer that you process each record as you come to it (which is undoubtedly more scalable). For my purposes, where as little programming logic as possible is required in the "view" section of code, I'm willing to accept the idea that I won't be using my function on immense amounts of data.

To explain, I develop websites using Snakeskin (http://snakeskin-tools.sf.net/). It separates design and logic by first processing a python object with specific event triggers and then loads the requested template to accompany it. The python object does the logic, the template does the display. e.g.


def page_process(self, ctx):
    c = ctx.request.db.cursor()
    c.execute("select a,b,c ....")
    ctx.locals.some_var = c.fetchall() # anything in ctx.locals is available as a var in the template


then in the template:

<html>
<body>
...
<ss-for expr="some_var" iter="i" expand="record">
    Print out A: <ss-value expr="record.a"/>
    Print out B: <ss-value expr="record['b']"/>
    ...
</ss-for>
...
</body>
</html>





-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to