module Sequel::Postgres::ExtendedDateSupport::DatasetMethods
Private Instance Methods
literal_date(date)
click to toggle source
Handle BC Date objects.
Calls superclass method
# File lib/sequel/extensions/pg_extended_date_support.rb, line 178 def literal_date(date) if date < DATE_YEAR_1 date <<= ((date.year) * 24 - 12) date.strftime("'%Y-%m-%d BC'") else super end end
literal_datetime(date)
click to toggle source
Handle BC DateTime objects.
Calls superclass method
# File lib/sequel/extensions/pg_extended_date_support.rb, line 188 def literal_datetime(date) if date < DATETIME_YEAR_1 date <<= ((date.year) * 24 - 12) date = db.from_application_timestamp(date) minutes = (date.is_a?(DateTime) ? date.offset * 1440 : date.utc_offset/60).to_i date.strftime("'%Y-%m-%d %H:%M:%S.%N#{format_timestamp_offset(*minutes.divmod(60))} BC'") else super end end
literal_other_append(sql, v)
click to toggle source
Handle Date::Infinity values
Calls superclass method
# File lib/sequel/extensions/pg_extended_date_support.rb, line 200 def literal_other_append(sql, v) if v.is_a?(Date::Infinity) sql << (v > 0 ? "'infinity'" : "'-infinity'") else super end end
literal_time(time)
click to toggle source
Work around JRuby bug #4822 in Time#to_datetime for times before date of calendar reform
Calls superclass method
# File lib/sequel/extensions/pg_extended_date_support.rb, line 224 def literal_time(time) if time < TIME_YEAR_1 dt = DateTime.parse(super) # Work around JRuby bug #5191 dt >>= 12 if JRUBY_VERSION == '9.2.0.0' literal_datetime(dt) else super end end
type_convertor(map, meta, type, i)
click to toggle source
Use non-JDBC parsing as JDBC parsing doesn't work for BC dates/timestamps.
Calls superclass method
# File lib/sequel/extensions/pg_extended_date_support.rb, line 214 def type_convertor(map, meta, type, i) case type when *CONVERT_TYPES db.oid_convertor_proc(meta.getField(i).getOID) else super end end