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
   # 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