Sha256: 8887bf21c8e9092d7e51bb3320a568381354311aa031b558d2115fd7373bc314
Contents?: true
Size: 1.27 KB
Versions: 5
Compression:
Stored size: 1.27 KB
Contents
# frozen-string-literal: true
Sequel.require 'adapters/shared/mssql'
module Sequel
module JDBC
# Database and Dataset instance methods for MSSQL specific
# support via JDBC.
module MSSQL
# Database instance methods for MSSQL databases accessed via JDBC.
module DatabaseMethods
PRIMARY_KEY_INDEX_RE = /\Apk__/i.freeze
Sequel::Deprecation.deprecate_constant(self, :PRIMARY_KEY_INDEX_RE)
ATAT_IDENTITY = 'SELECT @@IDENTITY'.freeze
Sequel::Deprecation.deprecate_constant(self, :ATAT_IDENTITY)
SCOPE_IDENTITY = 'SELECT SCOPE_IDENTITY()'.freeze
Sequel::Deprecation.deprecate_constant(self, :SCOPE_IDENTITY)
include Sequel::MSSQL::DatabaseMethods
private
# Get the last inserted id using SCOPE_IDENTITY().
def last_insert_id(conn, opts=OPTS)
statement(conn) do |stmt|
sql = opts[:prepared] ? 'SELECT @@IDENTITY' : 'SELECT SCOPE_IDENTITY()'
rs = log_connection_yield(sql, conn){stmt.executeQuery(sql)}
rs.next
rs.getLong(1)
end
end
# Primary key indexes appear to start with pk__ on MSSQL
def primary_key_index_re
/\Apk__/i
end
end
end
end
end
Version data entries
5 entries across 5 versions & 2 rubygems