Method: Sequel::Database.connect

Defined in:
lib/sequel/database.rb

.connect(conn_string, opts = {}, &block) ⇒ Object

Connects to a database. See Sequel.connect.



121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
 
# File 'lib/sequel/database.rb', line 121

def self.connect(conn_string, opts = {}, &block)
  if conn_string.is_a?(String)
    if conn_string =~ /\Ajdbc:/
      c = adapter_class(:jdbc)
      opts = {:uri=>conn_string}.merge(opts)
    elsif conn_string =~ /\Ado:/
      c = adapter_class(:do)
      opts = {:uri=>conn_string}.merge(opts)
    else
      uri = URI.parse(conn_string)
      scheme = uri.scheme
      scheme = :dbi if scheme =~ /\Adbi-/
      c = adapter_class(scheme)
      uri_options = {}
      uri.query.split('&').collect{|s| s.split('=')}.each{|k,v| uri_options[k.to_sym] = v} unless uri.query.to_s.strip.empty?
      opts = c.send(:uri_to_options, uri).merge(uri_options).merge(opts)
    end
  else
    opts = conn_string.merge(opts)
    c = adapter_class(opts[:adapter] || opts['adapter'])
  end
  # process opts a bit
  opts = opts.inject({}) do |m, kv| k, v = *kv
    k = :user if k.to_s == 'username'
    m[k.to_sym] = v
    m
  end
  if block
    begin
      yield(db = c.new(opts))
    ensure
      db.disconnect if db
      ::Sequel::DATABASES.delete(db)
    end
    nil
  else
    c.new(opts)
  end
end