1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
#!/usr/bin/env ruby
require 'date'
module PG
module TextDecoder
class Date < SimpleDecoder
ISO_DATE = /\A(\d{4})-(\d\d)-(\d\d)\z/
def decode(string, tuple=nil, field=nil)
if string =~ ISO_DATE
::Date.new $1.to_i, $2.to_i, $3.to_i
else
string
end
end
end
class TimestampWithoutTimeZone < SimpleDecoder
ISO_DATETIME_WITHOUT_TIMEZONE = /\A(\d{4})-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)(\.\d+)?\z/
def decode(string, tuple=nil, field=nil)
if string =~ ISO_DATETIME_WITHOUT_TIMEZONE
Time.new $1.to_i, $2.to_i, $3.to_i, $4.to_i, $5.to_i, "#{$6}#{$7}".to_r
else
string
end
end
end
class TimestampWithTimeZone < SimpleDecoder
ISO_DATETIME_WITH_TIMEZONE = /\A(\d{4})-(\d\d)-(\d\d) (\d\d):(\d\d):(\d\d)(\.\d+)?([-\+]\d\d):?(\d\d)?:?(\d\d)?\z/
def decode(string, tuple=nil, field=nil)
if string =~ ISO_DATETIME_WITH_TIMEZONE
Time.new $1.to_i, $2.to_i, $3.to_i, $4.to_i, $5.to_i, "#{$6}#{$7}".to_r, "#{$8}:#{$9 || '00'}:#{$10 || '00'}"
else
string
end
end
end
end
end # module PG
|
