>>> from sqlalchemy import *
>>> aa = [1,2,3,4]
>>> print func.in_(*[literal_column(str(x)) for x in aa])
in(1, 2, 3, 4)
this is what you asked for ?
Glauco wrote:
> Michael Bayer ha scritto:
>> Glauco wrote:
>>
>>> I don't know if is better to use the psycopg adapter.
>>>
>>> Can i use the funct.* function only as adapter?
>>>
>>> example:
>>>
>>> In [1]: aa = [1,2,3,4,]
>>>
>>> In [2]: print sa.func.in_( *aa )
>>> in(:in, :in_1, :in_2, :in_3)
>>>
>>> how to obtain this?
>>> in ( 1,2,3,4 )
>>>
>>
>> perhaps you're looking for sa.func.in_(*[literal_column(x) for x in
>> aa]) ?
>>
> not exactly.
>
> In [13]: print sa.func.in_( *[sa.func.literal_column(x) for x in
> [1,2,3]] ).compile()
> in(literal_column(:literal_column), literal_column(:literal_column_1),
> literal_column(:literal_column_2))
>
>
>
> What i mean is similar to psycopg adapter:
>
> class SQL_IN(object):
> """Adapt a tuple to an SQL quotable object."""
>
> def __init__(self, seq):
> self._seq = seq
>
> def getquoted(self):
> # this is the important line: note how every object in the
> # list is adapted and then how getquoted() is called on it
>
> qobjs = [str(psycoadapt(o).getquoted()) for o in self._seq]
>
> return '(' + ', '.join(qobjs) + ')'
>
> __str__ = getquoted
>
>
>
>> I'm not sure what this accomplishes for you overall, however.
>>
>>
>>
> I know this is not a good practise of SA, but this is a small isolated
> case. Here i don't have access to my mappers, so i create manually the
> SQL and after all i use the engine to execute.
> so i find useful to use adapter.
>
>
> Thank you
> Glauco
>
> --
> +------------------------------------------------------------+
> Glauco Uri
> glauco(at)sferacarta.com
>
> Sfera Carta Software® info(at)sferacarta.com
> Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054
> +------------------------------------------------------------+
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
