Module: ArJdbc::PostgreSQL::Column::Cast
- Defined in:
- lib/arjdbc/postgresql/column.rb
Overview
Note:
Based on active_record/connection_adapters/postgresql/cast.rb (4.0).
Instance Method Summary collapse
- #array_to_string(value, column, adapter) ⇒ Object
- #cidr_to_string(object) ⇒ Object
- #hstore_to_string(object, array_member = false) ⇒ Object
- #json_to_string(object) ⇒ Object
- #point_to_string(point) ⇒ Object
- #range_to_string(object) ⇒ Object
- #string_to_array(string, column_or_oid) ⇒ Object
- #string_to_bit(value) ⇒ Object
- #string_to_cidr(string) ⇒ Object
- #string_to_hstore(string) ⇒ Object
- #string_to_json(string) ⇒ Object
- #string_to_money(string) ⇒ Object
- #string_to_point(string) ⇒ Object
- #string_to_time(string) ⇒ Object
Instance Method Details
#array_to_string(value, column, adapter) ⇒ Object
444 445 446 447 448 449 450 451 452 453 454 455 456 457 |
# File 'lib/arjdbc/postgresql/column.rb', line 444 def array_to_string(value, column, adapter) casted_values = value.map do |val| if String === val if val == "NULL" "\"#{val}\"" else quote_and_escape(adapter.type_cast(val, column, true)) end else adapter.type_cast(val, column, true) end end "{#{casted_values.join(',')}}" end |
#cidr_to_string(object) ⇒ Object
487 488 489 490 491 492 493 |
# File 'lib/arjdbc/postgresql/column.rb', line 487 def cidr_to_string(object) if IPAddr === object "#{object.to_s}/#{object.instance_variable_get(:@mask_addr).to_s(2).count('1')}" else object end end |
#hstore_to_string(object, array_member = false) ⇒ Object
412 413 414 415 416 417 418 419 420 |
# File 'lib/arjdbc/postgresql/column.rb', line 412 def hstore_to_string(object, array_member = false) if Hash === object string = object.map { |k, v| "#{escape_hstore(k)}=>#{escape_hstore(v)}" }.join(',') string = escape_hstore(string) if array_member string else object end end |
#json_to_string(object) ⇒ Object
436 437 438 439 440 441 442 |
# File 'lib/arjdbc/postgresql/column.rb', line 436 def json_to_string(object) if Hash === object || Array === object ActiveSupport::JSON.encode(object) else object end end |
#point_to_string(point) ⇒ Object
372 373 374 |
# File 'lib/arjdbc/postgresql/column.rb', line 372 def point_to_string(point) "(#{point[0]},#{point[1]})" end |
#range_to_string(object) ⇒ Object
459 460 461 462 463 |
# File 'lib/arjdbc/postgresql/column.rb', line 459 def range_to_string(object) from = object.begin.respond_to?(:infinite?) && object.begin.infinite? ? '' : object.begin to = object.end.respond_to?(:infinite?) && object.end.infinite? ? '' : object.end "[#{from},#{to}#{object.exclude_end? ? ')' : ']'}" end |
#string_to_array(string, column_or_oid) ⇒ Object
Note:
Only used for default values - we get a "parsed" array from JDBC.
496 497 498 499 |
# File 'lib/arjdbc/postgresql/column.rb', line 496 def string_to_array(string, column_or_oid) return string unless String === string parse_pg_array(string).map { |val| type_cast_array(column_or_oid, val) } end |
#string_to_bit(value) ⇒ Object
396 397 398 399 400 401 |
# File 'lib/arjdbc/postgresql/column.rb', line 396 def string_to_bit(value) case value when /^[01]*$/ then value # Bit-string notation when /^[0-9A-F]*$/i then value.hex.to_s(2) # Hexadecimal notation end end |
#string_to_cidr(string) ⇒ Object
473 474 475 476 477 478 479 480 481 482 483 484 485 |
# File 'lib/arjdbc/postgresql/column.rb', line 473 def string_to_cidr(string) if string.nil? nil elsif String === string begin IPAddr.new(string) rescue ArgumentError nil end else string end end |
#string_to_hstore(string) ⇒ Object
422 423 424 425 426 427 428 429 430 431 432 433 434 |
# File 'lib/arjdbc/postgresql/column.rb', line 422 def string_to_hstore(string) if string.nil? nil elsif String === string Hash[string.scan(HstorePair).map { |k, v| v = v.upcase == 'NULL' ? nil : v.gsub(/\A"(.*)"\Z/m,'\1').gsub(/\\(.)/, '\1') k = k.gsub(/\A"(.*)"\Z/m,'\1').gsub(/\\(.)/, '\1') [k, v] }] else string end end |
#string_to_json(string) ⇒ Object
465 466 467 468 469 470 471 |
# File 'lib/arjdbc/postgresql/column.rb', line 465 def string_to_json(string) if String === string ActiveSupport::JSON.decode(string) else string end end |
#string_to_money(string) ⇒ Object
351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 |
# File 'lib/arjdbc/postgresql/column.rb', line 351 def string_to_money(string) return string unless String === string # Because money output is formatted according to the locale, there # are two cases to consider (note the decimal separators) : # (1) $12,345,678.12 # (2) $12.345.678,12 # Negative values are represented as follows: # (3) -$2.55 # (4) ($2.55) string = string.sub(/^\((.+)\)$/, '-\1') # (4) case string when /^-?\D+[\d,]+\.\d{2}$/ # (1) string.gsub!(/[^-\d.]/, '') when /^-?\D+[\d.]+,\d{2}$/ # (2) string.gsub!(/[^-\d,]/, '') string.sub!(/,/, '.') end value_to_decimal string end |
#string_to_point(string) ⇒ Object
376 377 378 379 380 381 |
# File 'lib/arjdbc/postgresql/column.rb', line 376 def string_to_point(string) if string[0] == '(' && string[-1] == ')' string = string[1...-1] end string.split(',').map { |v| Float(v) } end |
#string_to_time(string) ⇒ Object
383 384 385 386 387 388 389 390 391 392 393 394 |
# File 'lib/arjdbc/postgresql/column.rb', line 383 def string_to_time(string) return string unless String === string case string when 'infinity' then 1.0 / 0.0 when '-infinity' then -1.0 / 0.0 when / BC$/ super("-#{string.sub(/ BC$/, "")}") else super end end |