Namespace

Included Modules

Class/Module Index [+]

Quicksearch

JdbcSpec::MsSQL

Public Class Methods

adapter_matcher(name, *) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 26
def self.adapter_matcher(name, *)
  name =~ /sqlserver|tds/ ? self : false
end
column_selector() click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 30
def self.column_selector
  [/sqlserver|tds/, lambda {|cfg,col| col.extend(::JdbcSpec::MsSQL::Column)}]
end
extended(mod) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 7
def self.extended(mod)
  unless @lob_callback_added
    ActiveRecord::Base.class_eval do
      def after_save_with_mssql_lob
      self.class.columns.select { |c| c.sql_type =~ /image/ }.each do |c|
        value = self[c.name]
        value = value.to_yaml if unserializable_attribute?(c.name, c)
        next if value.nil?  || (value == '')

        connection.write_large_object(c.type == :binary, c.name, self.class.table_name, self.class.primary_key, quote_value(id), value)
      end
      end
    end

    ActiveRecord::Base.after_save :after_save_with_mssql_lob
    @lob_callback_added = true
  end
end
jdbc_connection_class() click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 34
def self.jdbc_connection_class
  ::ActiveRecord::ConnectionAdapters::MssqlJdbcConnection
end

Public Instance Methods

_execute(sql, name = nil) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 246
def _execute(sql, name = nil)
  if sql.lstrip =~ /^insert/
    if query_requires_identity_insert?(sql)
      table_name = get_table_name(sql)
      with_identity_insert_enabled(table_name) do
        id = @connection.execute_insert(sql)
      end
    else
      @connection.execute_insert(sql)
    end
  elsif sql.lstrip =~ /^\(?\s*(select|show)/
    repair_special_columns(sql)
    @connection.execute_query(sql)
  else
    @connection.execute_update(sql)
  end
end
add_column(table_name, column_name, type, options = {}) click to toggle source

Adds a new column to the named table. See TableDefinition#column for details of the options you can use.

# File lib/jdbc_adapter/jdbc_mssql.rb, line 184
def add_column(table_name, column_name, type, options = {})
  add_column_sql = "ALTER TABLE #{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)
  # TODO: Add support to mimic date columns, using constraints to mark them as such in the database
  # add_column_sql << " CONSTRAINT ck__#{table_name}__#{column_name}__date_only CHECK ( CONVERT(CHAR(12), #{quote_column_name(column_name)}, 14)='00:00:00:000' )" if type == :date
  execute(add_column_sql)
end
add_lock!(sql, options) click to toggle source

SELECT .. FOR UPDATE is not supported on Microsoft SQL Server

# File lib/jdbc_adapter/jdbc_mssql.rb, line 265
def add_lock!(sql, options)
  sql
end
after_save_with_mssql_lob() click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 10
def after_save_with_mssql_lob
self.class.columns.select { |c| c.sql_type =~ /image/ }.each do |c|
  value = self[c.name]
  value = value.to_yaml if unserializable_attribute?(c.name, c)
  next if value.nil?  || (value == '')

  connection.write_large_object(c.type == :binary, c.name, self.class.table_name, self.class.primary_key, quote_value(id), value)
end
end
change_order_direction(order) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 153
def change_order_direction(order)
  order.split(",").collect {|fragment|
    case fragment
    when  /\bDESC\b/     then fragment.gsub(/\bDESC\b/, "ASC")
    when  /\bASC\b/      then fragment.gsub(/\bASC\b/, "DESC")
    else                  String.new(fragment).split(',').join(' DESC,') + ' DESC'
    end
  }.join(",")
end
columns(table_name, name = nil) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 236
def columns(table_name, name = nil)
  return [] if table_name =~ /^information_schema\./
  cc = super
  cc.each do |col|
    col.identity = true if col.sql_type =~ /identity/
    col.is_special = true if col.sql_type =~ /text|ntext|image/
  end
  cc
end
create_database(name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 173
def create_database(name)
  execute "CREATE DATABASE #{name}"
  execute "USE #{name}"
end
drop_database(name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 168
def drop_database(name)
  execute "USE master"
  execute "DROP DATABASE #{name}"
end
quote(value, column = nil) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 111
def quote(value, column = nil)
  return value.quoted_id if value.respond_to?(:quoted_id)

  case value
  when String, ActiveSupport::Multibyte::Chars
    value = value.to_s
    if column && column.type == :binary
      "'#{quote_string(JdbcSpec::MsSQL::Column.string_to_binary(value))}'" # ' (for ruby-mode)
    elsif column && [:integer, :float].include?(column.type)
      value = column.type == :integer ? value.to_i : value.to_f
      value.to_s
    else
      "N'#{quote_string(value)}'" # ' (for ruby-mode)
    end
  when TrueClass             then '1'
  when FalseClass            then '0'
  when Time, DateTime        then "'#{value.strftime("%Y%m%d %H:%M:%S")}'"
  when Date                  then "'#{value.strftime("%Y%m%d")}'"
  else                       super
  end
end
quote_column_name(name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 141
def quote_column_name(name)
  "[#{name}]"
end
quote_string(string) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 133
def quote_string(string)
  string.gsub(/\'/, "''")
end
quote_table_name(name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 137
def quote_table_name(name)
  name
end
quoted_false() click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 149
def quoted_false
  quote false
end
quoted_true() click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 145
def quoted_true
  quote true
end
recreate_database(name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 163
def recreate_database(name)
  drop_database(name)
  create_database(name)
end
remove_check_constraints(table_name, column_name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 223
def remove_check_constraints(table_name, column_name)
  # TODO remove all constraints in single method
  constraints = select "SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = '#{table_name}' and COLUMN_NAME = '#{column_name}'"
  constraints.each do |constraint|
    execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint["CONSTRAINT_NAME"]}"
  end
end
remove_column(table_name, column_name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 210
def remove_column(table_name, column_name)
  remove_check_constraints(table_name, column_name)
  remove_default_constraint(table_name, column_name)
  execute "ALTER TABLE #{table_name} DROP COLUMN [#{column_name}]"
end
remove_default_constraint(table_name, column_name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 216
def remove_default_constraint(table_name, column_name)
  defaults = select "select def.name from sysobjects def, syscolumns col, sysobjects tab where col.cdefault = def.id and col.name = '#{column_name}' and tab.name = '#{table_name}' and col.id = tab.id"
  defaults.each {|constraint|
    execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint["name"]}"
  }
end
remove_index(table_name, options = {}) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 231
def remove_index(table_name, options = {})
  execute "DROP INDEX #{table_name}.#{index_name(table_name, options)}"
end
rename_column(table, column, new_column_name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 192
def rename_column(table, column, new_column_name)
  execute "EXEC sp_rename '#{table}.#{column}', '#{new_column_name}'"
end
rename_table(name, new_name) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 178
def rename_table(name, new_name)
  execute "EXEC sp_rename '#{name}', '#{new_name}'"
end

[Validate]

Generated with the Darkfish Rdoc Generator 2.