[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-Dev
mailing list