Module: JdbcSpec::HSQLDB::Column

Defined in:
lib/jdbc_adapter/jdbc_hsqldb.rb

Instance Method Summary collapse

Instance Method Details

#cast_to_date_or_time(value) ⇒ Object 



18
19
20
21
22
 
# File 'lib/jdbc_adapter/jdbc_hsqldb.rb', line 18

def cast_to_date_or_time(value)
  return value if value.is_a? Date
  return nil if value.blank?
  guess_date_or_time (value.is_a? Time) ? value : cast_to_time(value)
end

#cast_to_time(value) ⇒ Object 



24
25
26
27
28
29
 
# File 'lib/jdbc_adapter/jdbc_hsqldb.rb', line 24

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

#guess_date_or_time(value) ⇒ Object 



31
32
33
34
 
# File 'lib/jdbc_adapter/jdbc_hsqldb.rb', line 31

def guess_date_or_time(value)
  (value.hour == 0 and value.min == 0 and value.sec == 0) ?
  Date.new(value.year, value.month, value.day) : value
end

#type_cast(value) ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
# File 'lib/jdbc_adapter/jdbc_hsqldb.rb', line 4

def type_cast(value)
  return nil if value.nil? || value =~ /^\s*null\s*$/i
  case type
  when :string    then value
  when :integer   then defined?(value.to_i) ? value.to_i : (value ? 1 : 0)
  when :primary_key then defined?(value.to_i) ? value.to_i : (value ? 1 : 0)
  when :float     then value.to_f
  when :datetime  then cast_to_date_or_time(value)
  when :timestamp then cast_to_time(value)
  when :binary    then value.scan(/[0-9A-Fa-f]{2}/).collect {|v| v.to_i(16)}.pack("C*")
  when :time      then cast_to_time(value)
  else value
  end
end