[Python-3000] [Python-Dev] PEP 30XZ: Simplified Parsing

Raymond Hettinger python at rcn.com
Thu May 3 03:03:39 CEST 2007


[Skip]
> I use it all the time.  For example, to build up (what I consider to be)
>readable SQL queries:
>
> rows = self.executesql("select cities.city, state, country"
>                        "    from cities, venues, events, addresses"
>                        "    where cities.city like %s"
>                        "      and events.active = 1"
>                        "      and venues.address = addresses.id"
>                        "      and addresses.city = cities.id"
>                        "      and events.venue = venues.id",
>                        (city,))

I find that style hard to maintain.  What is the advantage over multi-line strings?


 rows = self.executesql('''
    select cities.city, state, country
    from cities, venues, events, addresses
    where cities.city like %s
          and events.active = 1
          and venues.address = addresses.id
          and addresses.city = cities.id
          and events.venue = venues.id
    ''', 
    (city,))


Raymond


More information about the Python-3000 mailing list