[ANN] istring 1.0.1 released; announce list created

[Andreas Kostyrka]

On Wed, 6 Mar 2002 12:10:58 +0000 (UTC)
Artur Skura <arturs at iidea.pl> wrote:

>       Ask yourself which query is clearer:
> 
>       (1) db.query("""SELECT    foo, bar
>                       FROM      %s
>                       WHERE     rsrc_id = %s
>                       AND       name = '%s'" % (table, rsrc_id, name))
> 
>       Or:
> 
>       (2) qry = istring("""SELECT   foo, bar
>                            FROM     $table
>                            WHERE    rsrc_id = $rsrc_id
>                            AND      name = $.name""")
>           db.query(qry)
> 
And what about:
db.query("""SELECT   foo, bar
            FROM     %(table)s
            WHERE    rsrc_id = %(rsrc_id)d
            AND      name = '%(name)s'""" % locals())

pure standard Python :)

Andreas