[Python-Dev] PEP 30XZ: Simplified Parsing (original) (raw)

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