# File lib/sequel/adapters/odbc.rb, line 12 def connect(server) opts = server_opts(server) conn = if opts.include?(:drvconnect) ::ODBC::Database.new.drvconnect(opts[:drvconnect]) elsif opts.include?(:driver) Deprecation.deprecate("The odbc driver's handling of the :driver option is thought to be broken and will probably be removed in the future. If you are successfully using it, please contact the developers.") drv = ::ODBC::Driver.new drv.name = 'Sequel ODBC Driver130' opts.each do |param, value| if :driver == param and not (value =~ GUARDED_DRV_NAME) value = DRV_NAME_GUARDS % value end drv.attrs[param.to_s.upcase] = value.to_s end ::ODBC::Database.new.drvconnect(drv) else ::ODBC::connect(opts[:database], opts[:user], opts[:password]) end conn.autocommit = true conn end
# File lib/sequel/adapters/odbc.rb, line 34 def disconnect_connection(c) c.disconnect end
# File lib/sequel/adapters/odbc.rb, line 38 def execute(sql, opts=OPTS) synchronize(opts[:server]) do |conn| begin r = log_yield(sql){conn.run(sql)} yield(r) if block_given? rescue ::ODBC::Error, ArgumentError => e raise_error(e) ensure r.drop if r end nil end end
# File lib/sequel/adapters/odbc.rb, line 52 def execute_dui(sql, opts=OPTS) synchronize(opts[:server]) do |conn| begin log_yield(sql){conn.do(sql)} rescue ::ODBC::Error, ArgumentError => e raise_error(e) end end end
# File lib/sequel/adapters/odbc.rb, line 64 def adapter_initialize case @opts[:db_type] when 'mssql' Sequel.require 'adapters/odbc/mssql' extend Sequel::ODBC::MSSQL::DatabaseMethods self.dataset_class = Sequel::ODBC::MSSQL::Dataset set_mssql_unicode_strings when 'progress' Sequel.require 'adapters/shared/progress' extend Sequel::Progress::DatabaseMethods extend_datasets(Sequel::Progress::DatasetMethods) when 'db2' Sequel.require 'adapters/shared/db2' extend ::Sequel::DB2::DatabaseMethods extend_datasets ::Sequel::DB2::DatasetMethods end end
# File lib/sequel/adapters/odbc.rb, line 82 def connection_execute_method :do end
# File lib/sequel/adapters/odbc.rb, line 86 def database_error_classes [::ODBC::Error] end
# File lib/sequel/adapters/odbc.rb, line 90 def disconnect_error?(e, opts) super || (e.is_a?(::ODBC::Error) && DISCONNECT_ERRORS.match(e.message)) end