Sha256: 58adb70480407e815edaa9d0a0c54aadae24f36fa857104ac67349c5c7dc5c81
Contents?: true
Size: 1.02 KB
Versions: 6
Compression:
Stored size: 1.02 KB
Contents
Sequel.require 'adapters/shared/mssql'
module Sequel
module ODBC
# Database and Dataset instance methods for MSSQL specific
# support via ODBC.
module MSSQL
module DatabaseMethods
include Sequel::MSSQL::DatabaseMethods
LAST_INSERT_ID_SQL='SELECT SCOPE_IDENTITY()'.freeze
# Return the last inserted identity value.
def execute_insert(sql, opts={})
synchronize(opts[:server]) do |conn|
begin
log_yield(sql){conn.do(sql)}
begin
s = log_yield(LAST_INSERT_ID_SQL){conn.run(LAST_INSERT_ID_SQL)}
if (rows = s.fetch_all) and (row = rows.first)
Integer(row.first)
end
ensure
s.drop if s
end
rescue ::ODBC::Error => e
raise_error(e)
end
end
end
end
class Dataset < ODBC::Dataset
include Sequel::MSSQL::DatasetMethods
end
end
end
end
Version data entries
6 entries across 6 versions & 1 rubygems