On Jun 24, 2011, at 3:22 PM, Chris Withers wrote:
> On 15/06/2011 19:13, Michael Bayer wrote:
>>> session.execute('call myfunc()').scalar()
>>>
>>> ...but is there a way I can generate that?
>>
>> i havent worked with MySQL sps but maybe there's a way to CREATE FUNCTION
>> instead of SP, not sure, otherwise you'd probably want to do this:
>>
>> class Call(ClauseElement):
>> def __init__(self, name):
>> self.name = name
>>
>> @compiles(Call)
>> def _call(expression, compiler, **kw):
>> return "CALL %s" % expression.name
>
> Should this be in SA itself?
shrugs, if its of general use, would be nice if it could do something useful
for SQL server, oracle, etc.
>
> Chris
>
> --
> Simplistix - Content Management, Batch Processing & Python Consulting
> - http://www.simplistix.co.uk
>
> --
> 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
> 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 sqlalchemy@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.
