[Zope-DB] Re: Typical size of result sets

Chris Withers chris at simplistix.co.uk
Wed Jan 19 04:30:43 EST 2005


Wolfram Kraus wrote:
>  From the Python Database API Specification v2.0 
> (http://python.org/peps/pep-0249.html):
> 
> paramstyle
> 
> String constant stating the type of parameter marker
> formatting expected by the interface. Possible values are
> [2]:
> 
>    'qmark'         Question mark style,
>                    e.g. '...WHERE name=?'
>    'numeric'       Numeric, positional style,
>                    e.g. '...WHERE name=:1'
>    'named'         Named style,
>                    e.g. '...WHERE name=:name'
>    'format'        ANSI C printf format codes,
>                    e.g. '...WHERE name=%s'
>    'pyformat'      Python extended format codes,
>                    e.g. '...WHERE name=%(name)s'
> [2] Module implementors should prefer 'numeric', 'named' or
>         'pyformat' over the other formats because these offer more
>         clarity and flexibility.

Wow, I've never seen this before in my life :-)

How does it relate to ZSQL methods?

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk


More information about the Zope-DB mailing list