Ok, now it works, thank you Michael, jo
Michael Bayer ha scritto: > put "correlate=False" in your subquery. > > On Mar 16, 2007, at 12:43 PM, Jose Soares wrote: > > >> Hi, >> Seems that SA compiles in a wrong way my query... >> >> In [9]: sql=select([UnitaAziendale.c.id]) >> >> In [10]: subvet = select([azienda_veterinario.c.id_unita_aziendale], >> ....: and_(azienda_veterinario.c.id_veterinario==3, >> ....: >> azienda_veterinario.c.id_unita_aziendale==UnitaAziendale.c.id, >> ....: azienda_veterinario.c.data_inizio<>None, >> ....: azienda_veterinario.c.data_fine==None >> ....: ) >> ....: ) >> >> In [11]: >> >> In [11]: print subvet >> SELECT azienda_veterinario.id_unita_aziendale >> FROM azienda_veterinario, unita_aziendale >> WHERE azienda_veterinario.id_veterinario = >> %(azienda_veterinario_id_v_5338)s AND >> azienda_veterinario.id_unita_aziendale = unita_aziendale.id AND >> azienda_veterinario.data_inizio IS NOT NULL AND >> azienda_veterinario.data_fine IS NULL >> >> In [12]: sql.append_whereclause(not_(UnitaAziendale.c.id.in_(subvet))) >> >> In [13]: print subvet >> (SELECT azienda_veterinario.id_unita_aziendale AS id_unita_aziendale >> FROM azienda_veterinario >> WHERE azienda_veterinario.id_veterinario = >> %(azienda_veterinario_id_v_5338)s AND >> azienda_veterinario.id_unita_aziendale = unita_aziendale.id AND >> azienda_veterinario.data_inizio IS NOT NULL AND >> azienda_veterinario.data_fine IS NULL) >> >> jo >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
