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
jo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---