class Sequel::DBI::Database

Constants

DBI_ADAPTERS

Public Class Methods

dataset(*args) click to toggle source
# File lib/sequel/adapters/dbi.rb, line 29
def self.dataset(*args)
  ds = super
  ds.extend Sequel::MSSQL::DatasetMethods
  ds
end
new(opts) click to toggle source
# File lib/sequel/adapters/dbi.rb, line 23
def initialize(opts)
  super
  case @opts[:db_type]
  when 'mssql'
    Sequel.ts_require 'adapters/shared/mssql'
    extend Sequel::MSSQL::DatabaseMethods
    def self.dataset(*args)
      ds = super
      ds.extend Sequel::MSSQL::DatasetMethods
      ds
    end
  end
end

Public Instance Methods

connect(server) click to toggle source
# File lib/sequel/adapters/dbi.rb, line 56
def connect(server)
  opts = server_opts(server)
  dbname = opts[:database]
  if dbname !~ %r^DBI:/ then
    dbname = "DBI:#{dbname}"
    [:host, :port].each{|sym| dbname += ";#{sym}=#{opts[sym]}" unless blank_object?(opts[sym])}
  end
  ::DBI.connect(dbname, opts[:user], opts[:password])
end
do(sql, opts={}) click to toggle source
# File lib/sequel/adapters/dbi.rb, line 74
def do(sql, opts={})
  synchronize(opts[:server]){|conn| log_yield(sql){conn.do(sql)}}
end
Also aliased as: execute_dui
execute(sql, opts={}) { |r| ... } click to toggle source
# File lib/sequel/adapters/dbi.rb, line 66
def execute(sql, opts={})
  synchronize(opts[:server]) do |conn|
    r = log_yield(sql){conn.execute(sql)}
    yield(r) if block_given?
    r
  end
end
execute_dui(sql, opts={}) click to toggle source
Alias for: do