Sha256: dd7e2dbc86228d7c2b8ba91cf9a73c29d070cd81f5c69f44c542786fe35c372b
Contents?: true
Size: 1.7 KB
Versions: 6
Compression:
Stored size: 1.7 KB
Contents
Sequel.require 'adapters/shared/mssql'
module Sequel
module JDBC
class Database
# Alias the generic JDBC version so it can be called directly later
alias jdbc_schema_parse_table schema_parse_table
end
# 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
include Sequel::MSSQL::DatabaseMethods
# Return instance of Sequel::JDBC::MSSQL::Dataset with the given opts.
def dataset(opts=nil)
Sequel::JDBC::MSSQL::Dataset.new(self, opts)
end
private
# Get the last inserted id using SCOPE_IDENTITY().
def last_insert_id(conn, opts={})
stmt = conn.createStatement
begin
sql = opts[:prepared] ? 'SELECT @@IDENTITY' : 'SELECT SCOPE_IDENTITY()'
rs = log_yield(sql){stmt.executeQuery(sql)}
rs.next
rs.getInt(1)
ensure
stmt.close
end
end
# Call the generic JDBC version instead of MSSQL version,
# since the JDBC version handles primary keys.
def schema_parse_table(table, opts={})
jdbc_schema_parse_table(table, opts)
end
# Primary key indexes appear to start with pk__ on MSSQL
def primary_key_index_re
PRIMARY_KEY_INDEX_RE
end
end
# Dataset class for MSSQL datasets accessed via JDBC.
class Dataset < JDBC::Dataset
include Sequel::MSSQL::DatasetMethods
end
end
end
end
Version data entries
6 entries across 6 versions & 2 rubygems