module Sequel::ADO::MSSQL::DatabaseMethods
Public Instance Methods
execute_dui(sql, opts=OPTS)
click to toggle source
Calls superclass method
# File lib/sequel/adapters/ado/mssql.rb 11 def execute_dui(sql, opts=OPTS) 12 return super unless @opts[:provider] 13 synchronize(opts[:server]) do |conn| 14 begin 15 sql = "SET NOCOUNT ON; #{sql}; SELECT @@ROWCOUNT" 16 rst = log_connection_yield(sql, conn){conn.Execute(sql)} 17 rst.GetRows[0][0] 18 rescue ::WIN32OLERuntimeError => e 19 raise_error(e) 20 end 21 end 22 end
Private Instance Methods
begin_transaction(conn, opts=OPTS)
click to toggle source
The ADO
adapter’s default provider doesn’t support transactions, since it creates a new native connection for each query. So Sequel
only attempts to use transactions if an explicit :provider is given.
Calls superclass method
# File lib/sequel/adapters/ado/mssql.rb 29 def begin_transaction(conn, opts=OPTS) 30 super if @opts[:provider] 31 end
commit_transaction(conn, opts=OPTS)
click to toggle source
Calls superclass method
Sequel::MSSQL::DatabaseMethods#commit_transaction
# File lib/sequel/adapters/ado/mssql.rb 33 def commit_transaction(conn, opts=OPTS) 34 super if @opts[:provider] 35 end
rollback_transaction(conn, opts=OPTS)
click to toggle source
Calls superclass method
# File lib/sequel/adapters/ado/mssql.rb 37 def rollback_transaction(conn, opts=OPTS) 38 super if @opts[:provider] 39 end