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, line 10
def execute_dui(sql, opts=OPTS)
  return super unless @opts[:provider]
  synchronize(opts[:server]) do |conn|
    begin
      sql = "SET NOCOUNT ON; #{sql}; SELECT @@ROWCOUNT"
      rst = log_connection_yield(sql, conn){conn.Execute(sql)}
      rst.GetRows[0][0]
    rescue ::WIN32OLERuntimeError => e
      raise_error(e)
    end
  end
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, line 28
def begin_transaction(conn, opts=OPTS)
  super if @opts[:provider]
end
commit_transaction(conn, opts=OPTS) click to toggle source
# File lib/sequel/adapters/ado/mssql.rb, line 32
def commit_transaction(conn, opts=OPTS)
  super if @opts[:provider]
end
rollback_transaction(conn, opts=OPTS) click to toggle source
Calls superclass method
# File lib/sequel/adapters/ado/mssql.rb, line 36
def rollback_transaction(conn, opts=OPTS)
  super if @opts[:provider]
end