Module: ArJdbc::MSSQL
Defined Under Namespace
Modules: Column, ExplainSupport, LimitHelpers, LockMethods, Utils
Constant Summary
collapse
- ADAPTER_NAME =
'MSSQL'.freeze
ExplainSupport::DISABLED
Constants included
from Utils
Utils::GET_TABLE_NAME_FROM_RE, Utils::GET_TABLE_NAME_INSERT_UPDATE_RE
Class Method Summary
collapse
Instance Method Summary
collapse
-
#adapter_name ⇒ Object
-
#add_column(table_name, column_name, type, options = {}) ⇒ Object
Adds a new column to the named table.
-
#change_column(table_name, column_name, type, options = {}) ⇒ Object
-
#change_column_default(table_name, column_name, default) ⇒ Object
-
#change_column_type(table_name, column_name, type, options = {}) ⇒ Object
-
#change_order_direction(order) ⇒ Object
-
#charset ⇒ Object
-
#clear_cached_table(table_name) ⇒ Object
-
#collation ⇒ Object
-
#columns(table_name, name = nil, default = EMPTY_ARRAY) ⇒ Object
-
#columns_for_distinct(columns, orders) ⇒ Object
-
#configure_connection ⇒ Object
-
#create_database(name, options = {}) ⇒ Object
-
#current_database ⇒ Object
-
#current_user ⇒ Object
-
#database_exists?(name) ⇒ Boolean
-
#default_schema ⇒ Object
(also: #current_schema)
Returns the default schema (to be used for table resolution) used for the #current_user.
-
#default_schema=(default_schema) ⇒ Object
(also: #current_schema=)
Allows for changing of the default schema (to be used during unqualified table name resolution).
-
#distinct(columns, order_by) ⇒ Object
SELECT DISTINCT clause for a given set of columns and a given ORDER BY clause.
-
#drop_database(name) ⇒ Object
-
#exec_proc(proc_name, *variables) ⇒ Object
(also: #execute_procedure)
Support for executing a stored procedure.
-
#exec_query(sql, name = 'SQL', binds = []) ⇒ Object
-
#exec_query_raw(sql, name = 'SQL', binds = [], &block) ⇒ Object
-
#jdbc_column_class ⇒ Object
-
#modify_types(types) ⇒ Object
-
#quote(value, column = nil) ⇒ Object
-
#quote_column_name(name) ⇒ Object
-
#quote_database_name(name) ⇒ Object
-
#quote_default_value(value, column) ⇒ Object
Does not quote function default values for UUID columns.
-
#quote_table_name(name) ⇒ Object
-
#quoted_date(value) ⇒ Object
-
#release_savepoint(name = current_savepoint_name) ⇒ Object
-
#remove_check_constraints(table_name, column_name) ⇒ Object
-
#remove_column(table_name, *column_names) ⇒ Object
-
#remove_columns(table_name, *column_names) ⇒ Object
-
#remove_default_constraint(table_name, column_name) ⇒ Object
-
#remove_index(table_name, options = {}) ⇒ Object
-
#remove_indexes(table_name, column_name) ⇒ Object
-
#rename_column(table_name, column_name, new_column_name) ⇒ Object
-
#rename_table(table_name, new_table_name) ⇒ Object
-
#reset_column_information ⇒ Object
-
#set_identity_insert(table_name, enable = true) ⇒ Object
-
#sqlserver_version ⇒ Object
-
#supports_ddl_transactions? ⇒ Boolean
-
#supports_views? ⇒ Boolean
-
#tables(schema = current_schema) ⇒ Object
-
#truncate(table_name, name = nil) ⇒ Object
-
#type_to_sql(type, limit = nil, precision = nil, scale = nil) ⇒ Object
-
#update_lob_value?(value, column = nil) ⇒ Boolean
-
#use_database(database = nil) ⇒ Object
-
#with_identity_insert_enabled(table_name) ⇒ Object
Turns IDENTITY_INSERT ON for table during execution of the block N.B.
#explain, #set_showplan_option, #supports_explain?, #with_showplan_on
Methods included from Utils
get_table_name, remove_identifier_delimiters, unqualify_db_name, unqualify_table_name, unqualify_table_schema, unquote_column_name, unquote_string, unquote_table_name
Class Method Details
.arel2_visitors(config) ⇒ Object
75
76
77
78
|
# File 'lib/arjdbc/mssql/adapter.rb', line 75
def self.arel2_visitors(config)
visitor = arel_visitor_type(config)
{ 'mssql' => visitor, 'jdbcmssql' => visitor, 'sqlserver' => visitor }
end
|
.arel_visitor_type(config) ⇒ Object
67
68
69
70
71
|
# File 'lib/arjdbc/mssql/adapter.rb', line 67
def self.arel_visitor_type(config)
require 'arel/visitors/sql_server'
( config && config[:sqlserver_version].to_s == '2000' ) ?
::Arel::Visitors::SQLServer2000 : ::Arel::Visitors::SQLServer
end
|
.column_selector ⇒ Object
5
6
7
|
# File 'lib/arjdbc/mssql/column.rb', line 5
def self.column_selector
[ /sqlserver|tds|Microsoft SQL/i, lambda { |config, column| column.extend(Column) } ]
end
|
.jdbc_connection_class ⇒ Object
.update_lob_values=(update) ⇒ Object
46
|
# File 'lib/arjdbc/mssql/adapter.rb', line 46
def self.update_lob_values=(update); @@update_lob_values = update; end
|
.update_lob_values? ⇒ Boolean
Note:
This only applies when prepared statements are not used.
Updating records with LOB values (binary/text columns) in a separate
statement can be disabled using :
ArJdbc::MSSQL.update_lob_values = false
44
|
# File 'lib/arjdbc/mssql/adapter.rb', line 44
def self.update_lob_values?; @@update_lob_values; end
|
Instance Method Details
#adapter_name ⇒ Object
241
242
243
|
# File 'lib/arjdbc/mssql/adapter.rb', line 241
def adapter_name
ADAPTER_NAME
end
|
#add_column(table_name, column_name, type, options = {}) ⇒ Object
Adds a new column to the named table.
361
362
363
364
365
366
367
368
|
# File 'lib/arjdbc/mssql/adapter.rb', line 361
def add_column(table_name, column_name, type, options = {})
clear_cached_table(table_name)
add_column_sql = "ALTER TABLE #{quote_table_name(table_name)} ADD #{quote_column_name(column_name)} #{type_to_sql(type, options[:limit], options[:precision], options[:scale])}"
add_column_options!(add_column_sql, options)
execute(add_column_sql)
end
|
#change_column(table_name, column_name, type, options = {}) ⇒ Object
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
|
# File 'lib/arjdbc/mssql/adapter.rb', line 403
def change_column(table_name, column_name, type, options = {})
column = columns(table_name).find { |c| c.name.to_s == column_name.to_s }
indexes = EMPTY_ARRAY
if options_include_default?(options) || (column && column.type != type.to_sym)
remove_default_constraint(table_name, column_name)
indexes = indexes(table_name).select{ |index| index.columns.include?(column_name.to_s) }
remove_indexes(table_name, column_name)
end
if ! options[:null].nil? && options[:null] == false && ! options[:default].nil?
execute "UPDATE #{quote_table_name(table_name)} SET #{quote_column_name(column_name)}=#{quote_default_value(options[:default], column)} WHERE #{quote_column_name(column_name)} IS NULL"
clear_cached_table(table_name)
end
change_column_type(table_name, column_name, type, options)
change_column_default(table_name, column_name, options[:default]) if options_include_default?(options)
indexes.each do |index| index_columns = index.columns.map { |c| quote_column_name(c) }.join(', ')
execute "CREATE INDEX #{quote_table_name(index.name)} ON #{quote_table_name(table_name)} (#{index_columns})"
end
end
|
#change_column_default(table_name, column_name, default) ⇒ Object
434
435
436
437
438
439
440
441
442
|
# File 'lib/arjdbc/mssql/adapter.rb', line 434
def change_column_default(table_name, column_name, default)
remove_default_constraint(table_name, column_name)
unless default.nil?
column = columns(table_name).find { |c| c.name.to_s == column_name.to_s }
result = execute "ALTER TABLE #{quote_table_name(table_name)} ADD CONSTRAINT DF_#{table_name}_#{column_name} DEFAULT #{quote_default_value(default, column)} FOR #{quote_column_name(column_name)}"
clear_cached_table(table_name)
result
end
end
|
#change_column_type(table_name, column_name, type, options = {}) ⇒ Object
426
427
428
429
430
431
432
|
# File 'lib/arjdbc/mssql/adapter.rb', line 426
def change_column_type(table_name, column_name, type, options = {})
sql = "ALTER TABLE #{quote_table_name(table_name)} ALTER COLUMN #{quote_column_name(column_name)} #{type_to_sql(type, options[:limit], options[:precision], options[:scale])}"
sql << (options[:null] ? " NULL" : " NOT NULL") if options.has_key?(:null)
result = execute(sql)
clear_cached_table(table_name)
result
end
|
#change_order_direction(order) ⇒ Object
245
246
247
248
249
250
251
252
253
254
|
# File 'lib/arjdbc/mssql/adapter.rb', line 245
def change_order_direction(order)
asc, desc = /\bASC\b/i, /\bDESC\b/i
order.split(",").collect do |fragment|
case fragment
when desc then fragment.gsub(desc, "ASC")
when asc then fragment.gsub(asc, "DESC")
else "#{fragment.split(',').join(' DESC,')} DESC"
end
end.join(",")
end
|
#charset ⇒ Object
305
306
307
|
# File 'lib/arjdbc/mssql/adapter.rb', line 305
def charset
select_value "SELECT SERVERPROPERTY('SqlCharSetName')"
end
|
#clear_cached_table(table_name) ⇒ Object
550
551
552
|
# File 'lib/arjdbc/mssql/adapter.rb', line 550
def clear_cached_table(table_name)
( @table_columns ||= {} ).delete(table_name.to_s)
end
|
#collation ⇒ Object
309
310
311
|
# File 'lib/arjdbc/mssql/adapter.rb', line 309
def collation
select_value "SELECT SERVERPROPERTY('Collation')"
end
|
#columns(table_name, name = nil, default = EMPTY_ARRAY) ⇒ Object
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
|
# File 'lib/arjdbc/mssql/adapter.rb', line 529
def columns(table_name, name = nil, default = EMPTY_ARRAY)
return default if table_name.blank?
table_name = unquote_table_name(table_name)
return default if table_name =~ SKIP_COLUMNS_TABLE_NAMES_RE
unless columns = ( @table_columns ||= {} )[table_name]
columns = super(table_name, name)
for column in columns
column.identity = true if column.sql_type =~ IDENTITY_COLUMN_TYPE_RE
column.special = true if column.sql_type =~ SPECIAL_COLUMN_TYPE_RE
end
@table_columns[table_name] = columns
end
columns
end
|
#columns_for_distinct(columns, orders) ⇒ Object
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
|
# File 'lib/arjdbc/mssql/adapter.rb', line 382
def columns_for_distinct(columns, orders)
return columns if orders.blank?
order_columns = [ orders ]; order_columns.flatten! order_columns.map! do |column|
column = column.to_sql unless column.is_a?(String) column.split(',').collect!{ |s| s.split.first }
end.flatten!
order_columns.reject!(&:blank?)
order_columns = order_columns.zip(0...order_columns.size).to_a
order_columns = order_columns.map{ |s, i| "#{s}" }
columns = [ columns ]; columns.flatten!
columns.push( *order_columns ).join(', ')
end
|
80
81
82
|
# File 'lib/arjdbc/mssql/adapter.rb', line 80
def configure_connection
use_database end
|
#create_database(name, options = {}) ⇒ Object
345
346
347
|
# File 'lib/arjdbc/mssql/adapter.rb', line 345
def create_database(name, options = {})
execute "CREATE DATABASE #{quote_database_name(name)}"
end
|
#current_database ⇒ Object
313
314
315
|
# File 'lib/arjdbc/mssql/adapter.rb', line 313
def current_database
select_value 'SELECT DB_NAME()'
end
|
#current_user ⇒ Object
301
302
303
|
# File 'lib/arjdbc/mssql/adapter.rb', line 301
def current_user
@current_user ||= @connection.execute_query_raw("SELECT CURRENT_USER").first['']
end
|
#database_exists?(name) ⇒ Boolean
349
350
351
|
# File 'lib/arjdbc/mssql/adapter.rb', line 349
def database_exists?(name)
select_value "SELECT name FROM sys.databases WHERE name = '#{name}'"
end
|
#default_schema ⇒ Object
Also known as:
current_schema
Returns the default schema (to be used for table resolution) used for the #current_user.
281
282
283
284
285
286
287
|
# File 'lib/arjdbc/mssql/adapter.rb', line 281
def default_schema
return current_user if sqlserver_2000?
@default_schema ||=
@connection.execute_query_raw(
"SELECT default_schema_name FROM sys.database_principals WHERE name = CURRENT_USER"
).first['default_schema_name']
end
|
#default_schema=(default_schema) ⇒ Object
Also known as:
current_schema=
Note:
This is not supported on SQL Server 2000 !
Allows for changing of the default schema (to be used during unqualified
table name resolution).
293
294
295
296
297
|
# File 'lib/arjdbc/mssql/adapter.rb', line 293
def default_schema=(default_schema) raise "changing DEFAULT_SCHEMA only supported on SQLServer 2005+" if sqlserver_2000?
execute("ALTER #{current_user} WITH DEFAULT_SCHEMA=#{default_schema}")
@default_schema = nil if defined?(@default_schema)
end
|
#distinct(columns, order_by) ⇒ Object
SELECT DISTINCT clause for a given set of columns and a given ORDER BY clause.
MSSQL requires the ORDER BY columns in the select list for distinct queries.
378
379
380
|
# File 'lib/arjdbc/mssql/adapter.rb', line 378
def distinct(columns, order_by)
"DISTINCT #{columns_for_distinct(columns, order_by)}"
end
|
#drop_database(name) ⇒ Object
339
340
341
342
343
|
# File 'lib/arjdbc/mssql/adapter.rb', line 339
def drop_database(name)
current_db = current_database
use_database('master') if current_db.to_s == name
execute "DROP DATABASE #{quote_database_name(name)}"
end
|
#exec_proc(proc_name, *variables) ⇒ Object
Also known as:
execute_procedure
Support for executing a stored procedure.
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
|
# File 'lib/arjdbc/mssql/adapter.rb', line 597
def exec_proc(proc_name, *variables)
vars =
if variables.any? && variables.first.is_a?(Hash)
variables.first.map { |k, v| "@#{k} = #{quote(v)}" }
else
variables.map { |v| quote(v) }
end.join(', ')
sql = "EXEC #{proc_name} #{vars}".strip
log(sql, 'Execute Procedure') do
result = @connection.execute_query_raw(sql)
result.map! do |row|
row = row.is_a?(Hash) ? row.with_indifferent_access : row
yield(row) if block_given?
row
end
result
end
end
|
#exec_query(sql, name = 'SQL', binds = []) ⇒ Object
618
619
620
621
622
623
624
625
626
627
628
629
630
631
|
# File 'lib/arjdbc/mssql/adapter.rb', line 618
def exec_query(sql, name = 'SQL', binds = [])
if sql.respond_to?(:to_sql)
sql = to_sql(sql, binds); to_sql = true
end
sql = repair_special_columns(sql)
if prepared_statements?
log(sql, name, binds) { @connection.execute_query(sql, binds) }
else
sql = suble_binds(sql, binds) unless to_sql log(sql, name) { @connection.execute_query(sql) }
end
end
|
#exec_query_raw(sql, name = 'SQL', binds = [], &block) ⇒ Object
634
635
636
637
638
639
640
641
642
643
644
645
|
# File 'lib/arjdbc/mssql/adapter.rb', line 634
def exec_query_raw(sql, name = 'SQL', binds = [], &block)
if sql.respond_to?(:to_sql)
sql = to_sql(sql, binds); to_sql = true
end
sql = repair_special_columns(sql)
if prepared_statements?
log(sql, name, binds) { @connection.execute_query_raw(sql, binds, &block) }
else
sql = suble_binds(sql, binds) unless to_sql log(sql, name) { @connection.execute_query_raw(sql, &block) }
end
end
|
#jdbc_column_class ⇒ Object
#modify_types(types) ⇒ Object
92
93
94
95
96
97
98
99
100
101
102
103
104
|
# File 'lib/arjdbc/mssql/adapter.rb', line 92
def modify_types(types)
types[:string] = { :name => "NVARCHAR", :limit => 255 }
if sqlserver_2000?
types[:text] = { :name => "NTEXT" }
else
types[:text] = { :name => "NVARCHAR(MAX)" }
end
types[:primary_key] = "int NOT NULL IDENTITY(1, 1) PRIMARY KEY"
types[:integer][:limit] = nil
types[:boolean] = { :name => "bit" }
types[:binary] = { :name => "image" }
types
end
|
#quote(value, column = nil) ⇒ Object
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
# File 'lib/arjdbc/mssql/adapter.rb', line 142
def quote(value, column = nil)
return value.quoted_id if value.respond_to?(:quoted_id)
return value if sql_literal?(value)
case value
when String, ActiveSupport::Multibyte::Chars, Integer
value = value.to_s
column_type = column && column.type
if column_type == :binary
if update_lob_value?(value, column)
BLOB_VALUE_MARKER
else
"'#{quote_string(column.class.string_to_binary(value))}'" end
elsif column_type == :integer
value.to_i.to_s
elsif column_type == :float
value.to_f.to_s
elsif ! column.respond_to?(:is_utf8?) || column.is_utf8?
"N'#{quote_string(value)}'" else
super
end
when Date, Time
if column && column.type == :time
"'#{quoted_time(value)}'"
else
"'#{quoted_date(value)}'"
end
when TrueClass then '1'
when FalseClass then '0'
else super
end
end
|
#quote_column_name(name) ⇒ Object
220
221
222
223
224
|
# File 'lib/arjdbc/mssql/adapter.rb', line 220
def quote_column_name(name)
name = name.to_s.split('.')
name.map! { |n| quote_name_part(n) } name.join('.')
end
|
#quote_database_name(name) ⇒ Object
226
227
228
|
# File 'lib/arjdbc/mssql/adapter.rb', line 226
def quote_database_name(name)
quote_name_part(name.to_s)
end
|
#quote_default_value(value, column) ⇒ Object
Does not quote function default values for UUID columns
231
232
233
234
235
236
237
|
# File 'lib/arjdbc/mssql/adapter.rb', line 231
def quote_default_value(value, column)
if column.type == :uuid && value =~ /\(\)/
value
else
quote(value)
end
end
|
#quote_table_name(name) ⇒ Object
216
217
218
|
# File 'lib/arjdbc/mssql/adapter.rb', line 216
def quote_table_name(name)
quote_column_name(name)
end
|
#quoted_date(value) ⇒ Object
179
180
181
182
183
184
185
|
# File 'lib/arjdbc/mssql/adapter.rb', line 179
def quoted_date(value)
if value.respond_to?(:usec)
"#{super}.#{sprintf("%03d", value.usec / 1000)}"
else
super
end
end
|
#release_savepoint(name = current_savepoint_name) ⇒ Object
648
649
650
651
652
653
654
|
# File 'lib/arjdbc/mssql/adapter.rb', line 648
def release_savepoint(name = current_savepoint_name)
if @connection.jtds_driver?
@connection.release_savepoint(name)
else @connection.rollback_savepoint(name)
end
end
|
#remove_check_constraints(table_name, column_name) ⇒ Object
495
496
497
498
499
500
501
502
503
|
# File 'lib/arjdbc/mssql/adapter.rb', line 495
def remove_check_constraints(table_name, column_name)
clear_cached_table(table_name)
constraints = select_values "SELECT constraint_name" <<
" FROM information_schema.constraint_column_usage" <<
" WHERE table_name = '#{table_name}' AND column_name = '#{column_name}'"
constraints.each do |constraint_name|
execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint_name}"
end
end
|
#remove_column(table_name, *column_names) ⇒ Object
465
466
467
|
# File 'lib/arjdbc/mssql/adapter.rb', line 465
def remove_column(table_name, column_name, type = nil, options = {})
remove_columns(table_name, column_name)
end
|
#remove_columns(table_name, *column_names) ⇒ Object
444
445
446
447
448
449
450
451
452
|
# File 'lib/arjdbc/mssql/adapter.rb', line 444
def remove_columns(table_name, *column_names)
raise ArgumentError.new("You must specify at least one column name. Example: remove_column(:people, :first_name)") if column_names.empty?
clear_cached_table(table_name)
column_names = column_names.flatten
return do_remove_column(table_name, column_names.first) if column_names.size == 1
column_names.each { |column_name| do_remove_column(table_name, column_name) }
end
|
#remove_default_constraint(table_name, column_name) ⇒ Object
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
|
# File 'lib/arjdbc/mssql/adapter.rb', line 475
def remove_default_constraint(table_name, column_name)
clear_cached_table(table_name)
if sqlserver_2000?
defaults = select_values "SELECT d.name" <<
" FROM sysobjects d, syscolumns c, sysobjects t" <<
" WHERE c.cdefault = d.id AND c.name = '#{column_name}'" <<
" AND t.name = '#{table_name}' AND c.id = t.id"
else
defaults = select_values "SELECT d.name FROM sys.tables t" <<
" JOIN sys.default_constraints d ON d.parent_object_id = t.object_id" <<
" JOIN sys.columns c ON c.object_id = t.object_id AND c.column_id = d.parent_column_id" <<
" WHERE t.name = '#{table_name}' AND c.name = '#{column_name}'"
end
defaults.each do |def_name|
execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{def_name}"
end
end
|
#remove_index(table_name, options = {}) ⇒ Object
512
513
514
|
# File 'lib/arjdbc/mssql/adapter.rb', line 512
def remove_index(table_name, options = {})
execute "DROP INDEX #{quote_table_name(table_name)}.#{index_name(table_name, options)}"
end
|
#remove_indexes(table_name, column_name) ⇒ Object
505
506
507
508
509
510
|
# File 'lib/arjdbc/mssql/adapter.rb', line 505
def remove_indexes(table_name, column_name)
indexes = self.indexes(table_name)
indexes.select{ |index| index.columns.include?(column_name.to_s) }.each do |index|
remove_index(table_name, { :name => index.name })
end
end
|
#rename_column(table_name, column_name, new_column_name) ⇒ Object
371
372
373
374
|
# File 'lib/arjdbc/mssql/adapter.rb', line 371
def rename_column(table_name, column_name, new_column_name)
clear_cached_table(table_name)
execute "EXEC sp_rename '#{table_name}.#{column_name}', '#{new_column_name}', 'COLUMN'"
end
|
#rename_table(table_name, new_table_name) ⇒ Object
354
355
356
357
|
# File 'lib/arjdbc/mssql/adapter.rb', line 354
def rename_table(table_name, new_table_name)
clear_cached_table(table_name)
execute "EXEC sp_rename '#{table_name}', '#{new_table_name}'"
end
|
554
555
556
|
# File 'lib/arjdbc/mssql/adapter.rb', line 554
def reset_column_information
@table_columns = nil if defined? @table_columns
end
|
#set_identity_insert(table_name, enable = true) ⇒ Object
568
569
570
571
572
573
|
# File 'lib/arjdbc/mssql/adapter.rb', line 568
def set_identity_insert(table_name, enable = true)
execute "SET IDENTITY_INSERT #{table_name} #{enable ? 'ON' : 'OFF'}"
rescue Exception => e
raise ActiveRecord::ActiveRecordError, "IDENTITY_INSERT could not be turned" +
" #{enable ? 'ON' : 'OFF'} for table #{table_name} due : #{e.inspect}"
end
|
#sqlserver_version ⇒ Object
84
85
86
87
88
89
90
|
# File 'lib/arjdbc/mssql/adapter.rb', line 84
def sqlserver_version
@sqlserver_version ||= begin
config_version = config[:sqlserver_version]
config_version ? config_version.to_s :
select_value("SELECT @@version")[/(Microsoft SQL Server\s+|Microsoft SQL Azure.+\n.+)(\d{4})/, 2]
end
end
|
#supports_ddl_transactions? ⇒ Boolean
257
|
# File 'lib/arjdbc/mssql/adapter.rb', line 257
def supports_ddl_transactions?; true end
|
#supports_views? ⇒ Boolean
260
|
# File 'lib/arjdbc/mssql/adapter.rb', line 260
def supports_views?; true end
|
#tables(schema = current_schema) ⇒ Object
262
263
264
|
# File 'lib/arjdbc/mssql/adapter.rb', line 262
def tables(schema = current_schema)
@connection.tables(nil, schema)
end
|
#truncate(table_name, name = nil) ⇒ Object
592
593
594
|
# File 'lib/arjdbc/mssql/adapter.rb', line 592
def truncate(table_name, name = nil)
execute "TRUNCATE TABLE #{quote_table_name(table_name)}", name
end
|
#type_to_sql(type, limit = nil, precision = nil, scale = nil) ⇒ Object
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
# File 'lib/arjdbc/mssql/adapter.rb', line 109
def type_to_sql(type, limit = nil, precision = nil, scale = nil)
type_s = type.to_s
if type_s == 'string' && limit == 1073741823 && ! sqlserver_2000?
'NVARCHAR(MAX)'
elsif NO_LIMIT_TYPES.include?(type_s)
super(type)
elsif type_s == 'integer' || type_s == 'int'
if limit.nil? || limit == 4
'int'
elsif limit == 2
'smallint'
elsif limit == 1
'tinyint'
else
'bigint'
end
elsif type_s == 'uniqueidentifier'
type_s
else
super
end
end
|
#update_lob_value?(value, column = nil) ⇒ Boolean
54
55
56
|
# File 'lib/arjdbc/mssql/adapter.rb', line 54
def update_lob_value?(value, column = nil)
MSSQL.update_lob_values? && ! prepared_statements? end
|
#use_database(database = nil) ⇒ Object
317
318
319
320
|
# File 'lib/arjdbc/mssql/adapter.rb', line 317
def use_database(database = nil)
database ||= config[:database]
execute "USE #{quote_database_name(database)}" unless database.blank?
end
|
#with_identity_insert_enabled(table_name) ⇒ Object
Turns IDENTITY_INSERT ON for table during execution of the block
N.B. This sets the state of IDENTITY_INSERT to OFF after the
block has been executed without regard to its previous state
561
562
563
564
565
566
|
# File 'lib/arjdbc/mssql/adapter.rb', line 561
def with_identity_insert_enabled(table_name)
set_identity_insert(table_name, true)
yield
ensure
set_identity_insert(table_name, false)
end
|