On Nov 28, 8:56 am, devdiscuss <[EMAIL PROTECTED]> wrote:
> Hi, I've submitted a patch adding basic JDBC stored procedure support
> to the Sequel Database object. The next step would be to add this
> functionality to the Dataset as well. Since this is my first patch
> and I'm still getting familiar with the code (thank you Jeremy for
> your assistance with it all), I figured I'd start small. I've tested
> this successfully using JRuby and the SQLServer JDBC driver.
>
> Usage is:
>
> DB.execute_sproc("{call mysp(?,?)}", :args => ['first param', 'second
> param'])
I'm using your patch as a base for stored procedure support, I should
have a patch ready for testing tomorrow. The API is changing, it will
be:
DB.call_sproc(:mysp, :args=>['first param', 'second param'])
Not that I recommend using the Database object directly, since the
results are adapter dependent. There will be full support for use
from datasets similar to the prepared statement support. The API will
be:
DB[:table].call_sproc(:select, :mysp, 'first param', 'second param')
# or
sp = DB[:table].prepare_sproc(:select, :mysp)
sp.call('first param', 'second param')
sp.call('third param', 'fourth param')
There will be stored procedure support in both the JDBC and MySQL
adapters. Support for other adapters may be added later.
Jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" 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/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
