[sqlalchemy] how to rename labels? - jose - com.googlegroups.sqlalchemy

7 messages in com.googlegroups.sqlalchemy[sqlalchemy] how to rename labels?

From	Sent On	Attachments
jose	28 Dec 2006 00:14
Lee McFadden	28 Dec 2006 02:36
jose	28 Dec 2006 03:21
Lee McFadden	28 Dec 2006 06:48
jose	28 Dec 2006 07:20
Lee McFadden	28 Dec 2006 07:51
jo	29 Dec 2006 04:02

Subject:	[sqlalchemy] how to rename labels?
From:	jose (jo...@sferacarta.com)
Date:	12/28/2006 12:14:52 AM
List:	com.googlegroups.sqlalchemy

the following query... session.query(Comune).options(eagerload('provincia')).select(and_(Provincia.c.nome=='MODENA',Provincia.c.codice==Comune.c.cod_provincia),order_by=Provincia.c.nome, limit=10)

generate this cose:

INFO SELECT comune.cod_provincia AS comune_cod_provincia, provincia_b453.codice AS provincia_b453_codice, provincia_b453.nome AS provincia_b453_nome, provincia_b453.data_fine AS provincia_b453_data_fine, provincia_b453.cod_regione AS provincia_b453_cod_regione, provincia_b453.istat AS provincia_b453_istat, provincia_b453.bdn_id AS provincia_b453_bdn_id, provincia_b453.data_inizio AS provincia_b453_data_inizio, provincia_b453.capoluogo AS provincia_b453_capoluogo, comune.codice_erariale AS comune_codice_erariale, comune.data_fine AS comune_data_fine, comune.nome AS comune_nome, comune.cap AS comune_cap, comune.auto_sync_bdn AS comune_auto_sync_bdn, comune.bdn_id AS comune_bdn_id, comune.data_inizio AS comune_data_inizio, comune.id AS comune_id, comune.istat AS comune_istat FROM (SELECT comune.id AS comune_id, provincia.nome AS provincia_nome FROM comune, provincia WHERE provincia.nome = %(provincia_nome)s AND provincia.codice = comune.cod_provincia ORDER BY provincia.nome LIMIT 10) AS tbl_row_count, comune LEFT OUTER JOIN provincia AS provincia_b453 ON provincia_b453.codice = comune.cod_provincia WHERE comune.id = tbl_row_count.comune_id ORDER BY provincia_b453.nome, provincia_b453.codice 2006-12-28 10:44:06,518 sqlalchemy.engine.base.Engine.0x..34 INFO {'provincia_nome': 'MODENA'}

I would like to know how assign label names as in:

comune.cod_provincia AS sigla_provincia instead of: comune.cod_provincia AS comune_cod_provincia