Class/Module Index [+]

Quicksearch

JdbcSpec::MsSQL::Column

Attributes

identity[RW]
is_special[RW]

Public Class Methods

string_to_binary(value) click to toggle source

These methods will only allow the adapter to insert binary data with a length of 7K or less because of a SQL Server statement length policy.

# File lib/jdbc_adapter/jdbc_mssql.rb, line 106
def self.string_to_binary(value)
  ''
end

Public Instance Methods

cast_to_datetime(value) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 92
def cast_to_datetime(value)
  if value.is_a?(Time)
    if value.year != 0 and value.month != 0 and value.day != 0
      return value
    else
      return Time.mktime(2000, 1, 1, value.hour, value.min, value.sec) rescue nil
    end
  end
  return cast_to_time(value) if value.is_a?(Date) or value.is_a?(String) rescue nil
  value
end
cast_to_time(value) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 83
def cast_to_time(value)
  return value if value.is_a?(Time)
  time_array = ParseDate.parsedate(value)
  time_array[0] ||= 2000
  time_array[1] ||= 1
  time_array[2] ||= 1
  Time.send(ActiveRecord::Base.default_timezone, *time_array) rescue nil
end
simplified_type(field_type) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 41
def simplified_type(field_type)
  case field_type
    when /int|bigint|smallint|tinyint/                        then :integer
    when /numeric/                                            then (@scale.nil? || @scale == 0) ? :integer : :decimal
    when /float|double|decimal|money|real|smallmoney/         then :decimal
    when /datetime|smalldatetime/                             then :datetime
    when /timestamp/                                          then :timestamp
    when /time/                                               then :time
    when /text|ntext/                                         then :text
    when /binary|image|varbinary/                             then :binary
    when /char|nchar|nvarchar|string|varchar/                 then :string
    when /bit/                                                then :boolean
    when /uniqueidentifier/                                   then :string
  end
end
type_cast(value) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 57
def type_cast(value)
  return nil if value.nil? || value == "(null)" || value == "(NULL)"
  case type
  when :string then unquote_string value
  when :integer then unquote(value).to_i rescue value ? 1 : 0
  when :primary_key then value == true || value == false ? value == true ? 1 : 0 : value.to_i
  when :decimal   then self.class.value_to_decimal(unquote(value))
  when :datetime  then cast_to_datetime(value)
  when :timestamp then cast_to_time(value)
  when :time      then cast_to_time(value)
  when :date      then cast_to_datetime(value)
  when :boolean   then value == true or (value =~ /^t(rue)?$/) == 0 or unquote(value)=="1"
  when :binary    then unquote value
  else value
  end
end
unquote(value) click to toggle source
# File lib/jdbc_adapter/jdbc_mssql.rb, line 79
def unquote(value)
  value.to_s.sub(/\A\([\(\']?/, "").sub(/[\'\)]?\)\Z/, "")
end
unquote_string(value) click to toggle source

JRUBY-2011: Match balanced quotes and parenthesis - 'text',('text') or (text)

# File lib/jdbc_adapter/jdbc_mssql.rb, line 75
def unquote_string(value)
  value.to_s.sub(/^\((.*)\)$/,'\1').sub(/^'(.*)'$/,'\1')
end

[Validate]

Generated with the Darkfish Rdoc Generator 2.