Sébastien LELONG ha scritto:
>> Seems that SA compiles in a wrong way my query...
>>
>
> Can't what's wrong is happening... subvet appers to be a sub-select, so
> probably SA made some optimizations. You should print the whole query (print
> sql) and not the sub-query (as in your code: print subvet) to check if your
> query is actually compiled the wrong way.
>
> Seb
>
sql=select([unita_aziendale.c.id],
and_(unita_aziendale.c.id.in_(
select([azienda_veterinario.c.id_unita_aziendale],
and_(azienda_veterinario.c.id_veterinario==3,
azienda_veterinario.c.id_unita_aziendale==unita_aziendale.c.id,
azienda_veterinario.c.data_inizio<>None,
azienda_veterinario.c.data_fine==None
),
from_obj=[ azienda_veterinario, unita_aziendale],
),
)),
)
print sql
SELECT unita_aziendale.id
FROM unita_aziendale
WHERE unita_aziendale.id IN (SELECT
azienda_veterinario.id_unita_aziendale AS id_unita_aziendale
FROM azienda_veterinario
WHERE azienda_veterinario.id_veterinario =
%(azienda_veterinario_id_veterinario)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)
------
As you can see the from_obj of subselect is wrong, the FROM should be:
FROM azienda_veterinario, unita_aziendale
j
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
