[TxMt] Re: Python: SQL in triple " strings scope

[Jacob Rus]

Alexey Blinov wrote:
> I have something like this:
> cur.execute("""
> 	select svc.post.id_post,
> 		svc.post.id_post_zone,
> 		svc.post.post_name as post_name,
> 		svc.post_zone.zone_name as zone_name,
> 		svc.post.id_post_type,
> 		svc.post_type.post_type_name,
> 		svc.post_type.post_color
> 	from svc.post inner join svc.post_zone on svc.post.id_post_zone =
> svc.post_zone.id_post_zone
> 		inner join svc.post_type on svc.post_type.id_post_type = svc.post.id_post_type
> 			where svc.post.id_post = :id
> 		""",
> 		{'id':post}
> 	)

Off topic: have you tried any of the Python ORMs lying around?  My good 
friend keeps raving about SQLAlchemy. :)