Manlio Perillo wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Michael Bayer ha scritto:
>> Manlio Perillo wrote:
>> [...]
>>>>> OK you mean SQL expression during compilation.   This is ticket #1534
>>>>> which is not yet implemented.
>>>
>>> After some tests I got something that works
>>> http://paste.pocoo.org/show/173099/
>>>
>> [...]
>>
>> errr, you can put SQL expressions into insert.values(), but not in the
>> params sent to execute() (that was discontinued after 0.4).
>
>
> I have never used the values method.
> Is this a recent feature?

couple of years old at this point...goes back to 0.4 at least

>
>>  the example
>> you have is actually executing the sql.select() statement beforehand
>> since
>> thats what "scalar()" does.
>>
>> you're looking for
>>
>> query = test.insert().values(text=sql.func.to_tsvector(u'some text'))
>> engine.execute(query)
>>
>
> Thanks.
>
> Manlio
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iEYEARECAAYFAktolCUACgkQscQJ24LbaURINgCglj+N2JKqkWit1/DFCEBff2Kd
> 7fsAn0F8Y5mUCYyqWSxydosxk36RzsGZ
> =VHYH
> -----END PGP SIGNATURE-----
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to