Class: Sequel::JDBC::TypeConvertor

Inherits:
Object
  • Object
show all
Defined in:
lib/sequel/adapters/jdbc.rb,
lib/sequel/adapters/jdbc/db2.rb,
lib/sequel/adapters/jdbc/oracle.rb,
lib/sequel/adapters/jdbc/postgresql.rb,
lib/sequel/adapters/jdbc/sqlanywhere.rb

Constant Summary collapse

INSTANCE = 
new
MAP = 
Hash.new(o.method(:Object))
BASIC_MAP = 
MAP.dup
JAVA_BIG_DECIMAL_CONSTRUCTOR = 
java.math.BigDecimal.java_class.constructor(Java::long).method(:new_instance)

Instance Method Summary collapse

Instance Method Details

#DB2Clob(r, i) ⇒ Object 



7
8
9
10
11
12
13
 
# File 'lib/sequel/adapters/jdbc/db2.rb', line 7

def DB2Clob(r, i)
  if v = r.getClob(i)
    v = v.getSubString(1, v.length)
    v = Sequel::SQL::Blob.new(v) if ::Sequel::DB2::use_clob_as_blob
    v
  end
end

#OracleDecimal(r, i) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
 
# File 'lib/sequel/adapters/jdbc/oracle.rb', line 9

def OracleDecimal(r, i)
  if v = r.getBigDecimal(i)
    i = v.long_value
    if v == JAVA_BIG_DECIMAL_CONSTRUCTOR.call(i)
      i
    else
      BigDecimal.new(v.to_string)
    end
  end
end

#RubyBigDecimal(r, i) ⇒ Object 



205
206
207
208
209
 
# File 'lib/sequel/adapters/jdbc.rb', line 205

def RubyBigDecimal(r, i)
  if v = r.getBigDecimal(i)
    BigDecimal.new(v.to_string)
  end
end

#RubyBlob(r, i) ⇒ Object 



210
211
212
213
214
 
# File 'lib/sequel/adapters/jdbc.rb', line 210

def RubyBlob(r, i)
  if v = r.getBytes(i)
    Sequel::SQL::Blob.new(String.from_java_bytes(v))
  end
end

#RubyClob(r, i) ⇒ Object 



215
216
217
218
219
 
# File 'lib/sequel/adapters/jdbc.rb', line 215

def RubyClob(r, i)
  if v = r.getClob(i)
    v.getSubString(1, v.length)
  end
end

#RubyDate(r, i) ⇒ Object 



195
196
197
198
199
 
# File 'lib/sequel/adapters/jdbc.rb', line 195

def RubyDate(r, i)
  if v = r.getDate(i)
    Date.civil(v.getYear + 1900, v.getMonth + 1, v.getDate)
  end
end

#RubyPGArray(r, i) ⇒ Object

Return PostgreSQL array types as ruby Arrays instead of JDBC PostgreSQL driver-specific array type. Only used if the database does not have a conversion proc for the type.



11
12
13
14
15
 
# File 'lib/sequel/adapters/jdbc/postgresql.rb', line 11

def RubyPGArray(r, i)
  if v = r.getArray(i)
    v.array.to_ary
  end
end

#RubyPGHstore(r, i) ⇒ Object

Return PostgreSQL hstore types as ruby Hashes instead of Java HashMaps. Only used if the database does not have a conversion proc for the type.



20
21
22
23
24
 
# File 'lib/sequel/adapters/jdbc/postgresql.rb', line 20

def RubyPGHstore(r, i)
  if v = r.getObject(i)
    v.to_hash
  end
end

#RubyTime(r, i) ⇒ Object 



190
191
192
193
194
 
# File 'lib/sequel/adapters/jdbc.rb', line 190

def RubyTime(r, i)
  if v = r.getTime(i)
    Sequel.string_to_time("#{v.to_string}.#{sprintf('%03i', v.getTime.divmod(1000).last)}")
  end
end

#RubyTimestamp(r, i) ⇒ Object 



200
201
202
203
204
 
# File 'lib/sequel/adapters/jdbc.rb', line 200

def RubyTimestamp(r, i)
  if v = r.getTimestamp(i)
    Sequel.database_to_application_timestamp([v.getYear + 1900, v.getMonth + 1, v.getDate, v.getHours, v.getMinutes, v.getSeconds, v.getNanos])
  end
end

#SqlAnywhereBoolean(r, i) ⇒ Object 



7
8
9
10
11
 
# File 'lib/sequel/adapters/jdbc/sqlanywhere.rb', line 7

def SqlAnywhereBoolean(r, i)
  if v = Short(r, i)
    v != 0
  end
end