line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
package DBIx::Class::InflateColumn::DateTime::Duration; |
2
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|
|
=head1 NAME |
4
|
|
|
|
|
|
|
|
5
|
|
|
|
|
|
|
DBIx::Class::InflateColumn::DateTime::Duration - Auto create |
6
|
|
|
|
|
|
|
DateTime::Duration objects from columns |
7
|
|
|
|
|
|
|
|
8
|
|
|
|
|
|
|
=head1 SYNOPSIS |
9
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
Load this component and then declare one or more columns as duration columns. |
11
|
|
|
|
|
|
|
|
12
|
|
|
|
|
|
|
package Holiday; |
13
|
|
|
|
|
|
|
__PACKAGE__->load_components(qw/InflateColumn::DateTime::Duration Core/); |
14
|
|
|
|
|
|
|
__PACKAGE__->add_columns( |
15
|
|
|
|
|
|
|
length => { |
16
|
|
|
|
|
|
|
datatype => 'varchar', |
17
|
|
|
|
|
|
|
size => 255, |
18
|
|
|
|
|
|
|
is_nullable => 1, |
19
|
|
|
|
|
|
|
is_duration => 1, |
20
|
|
|
|
|
|
|
}, |
21
|
|
|
|
|
|
|
); |
22
|
|
|
|
|
|
|
|
23
|
|
|
|
|
|
|
Then you can treat the specified column as a L<DateTime::Duration> object. |
24
|
|
|
|
|
|
|
|
25
|
|
|
|
|
|
|
print 'days: ', $holiday->length->delta_days, "\n"; |
26
|
|
|
|
|
|
|
print 'hours: ', $holiday->length->delta_hours, "\n"; |
27
|
|
|
|
|
|
|
|
28
|
|
|
|
|
|
|
=head1 DESCRIPTION |
29
|
|
|
|
|
|
|
|
30
|
|
|
|
|
|
|
This module inflates/deflates designated columns into L<DateTime::Duration> objects. |
31
|
|
|
|
|
|
|
|
32
|
|
|
|
|
|
|
=cut |
33
|
|
|
|
|
|
|
|
34
|
1
|
|
|
1
|
|
40163
|
use strict; |
|
1
|
|
|
|
|
3
|
|
|
1
|
|
|
|
|
30
|
|
35
|
1
|
|
|
1
|
|
9
|
use warnings; |
|
1
|
|
|
|
|
2
|
|
|
1
|
|
|
|
|
55
|
|
36
|
|
|
|
|
|
|
|
37
|
|
|
|
|
|
|
our $VERSION = '0.01002'; |
38
|
|
|
|
|
|
|
|
39
|
1
|
|
|
1
|
|
7
|
use base qw(DBIx::Class); |
|
1
|
|
|
|
|
6
|
|
|
1
|
|
|
|
|
83
|
|
40
|
|
|
|
|
|
|
|
41
|
1
|
|
|
1
|
|
9
|
use Try::Tiny; |
|
1
|
|
|
|
|
1
|
|
|
1
|
|
|
|
|
66
|
|
42
|
1
|
|
|
1
|
|
1260
|
use DateTime::Format::Duration::XSD; |
|
1
|
|
|
|
|
12679
|
|
|
1
|
|
|
|
|
231
|
|
43
|
|
|
|
|
|
|
|
44
|
|
|
|
|
|
|
=head1 METHODS |
45
|
|
|
|
|
|
|
|
46
|
|
|
|
|
|
|
=head2 register_column |
47
|
|
|
|
|
|
|
|
48
|
|
|
|
|
|
|
Chains with the "register_column" in L<DBIx::Class::Row> method, and sets up duration |
49
|
|
|
|
|
|
|
columns appropriately. This would not normally be directly called by end users. |
50
|
|
|
|
|
|
|
|
51
|
|
|
|
|
|
|
=cut |
52
|
|
|
|
|
|
|
|
53
|
|
|
|
|
|
|
sub register_column { |
54
|
3
|
|
|
3
|
1
|
107121
|
my ($self, $column, $info, @rest) = @_; |
55
|
3
|
|
|
|
|
14
|
$self->next::method($column, $info, @rest); |
56
|
|
|
|
|
|
|
|
57
|
3
|
100
|
|
|
|
1490
|
return unless defined $info->{is_duration}; |
58
|
|
|
|
|
|
|
|
59
|
|
|
|
|
|
|
$self->inflate_column( |
60
|
|
|
|
|
|
|
$column => { |
61
|
|
|
|
|
|
|
inflate => sub { |
62
|
5
|
|
|
5
|
|
486798
|
my ($value, $obj) = @_; |
63
|
5
|
|
|
|
|
10
|
my $duration; |
64
|
|
|
|
|
|
|
|
65
|
5
|
50
|
|
|
|
13
|
if ($value) { |
66
|
5
|
|
|
|
|
32
|
my $parser = DateTime::Format::Duration::XSD->new; |
67
|
|
|
|
|
|
|
|
68
|
|
|
|
|
|
|
try { |
69
|
5
|
|
|
|
|
214
|
$duration = $parser->parse_duration($value); |
70
|
|
|
|
|
|
|
} |
71
|
|
|
|
|
|
|
catch { |
72
|
0
|
|
|
|
|
0
|
$self->throw_exception('Could not parse duration from ' . $value); |
73
|
|
|
|
|
|
|
} |
74
|
5
|
|
|
|
|
292
|
} |
75
|
|
|
|
|
|
|
|
76
|
5
|
|
|
|
|
987
|
return $duration; |
77
|
|
|
|
|
|
|
}, |
78
|
|
|
|
|
|
|
deflate => sub { |
79
|
1
|
|
|
1
|
|
2684
|
my ($value, $obj) = @_; |
80
|
|
|
|
|
|
|
|
81
|
1
|
50
|
|
|
|
5
|
return unless (ref $value eq 'DateTime::Duration'); |
82
|
|
|
|
|
|
|
|
83
|
1
|
|
|
|
|
5
|
my $parser = DateTime::Format::Duration::XSD->new; |
84
|
|
|
|
|
|
|
|
85
|
1
|
|
|
|
|
61
|
return $parser->format_duration($value); |
86
|
|
|
|
|
|
|
}, |
87
|
|
|
|
|
|
|
} |
88
|
1
|
|
|
|
|
24
|
); |
89
|
|
|
|
|
|
|
} |
90
|
|
|
|
|
|
|
|
91
|
|
|
|
|
|
|
=head1 SEE ALSO |
92
|
|
|
|
|
|
|
|
93
|
|
|
|
|
|
|
L<DateTime::Duration>, |
94
|
|
|
|
|
|
|
L<DBIx::Class::InflateColumn>, |
95
|
|
|
|
|
|
|
L<DBIx::Class>. |
96
|
|
|
|
|
|
|
|
97
|
|
|
|
|
|
|
=head1 AUTHOR |
98
|
|
|
|
|
|
|
|
99
|
|
|
|
|
|
|
Pete Smith, E<lt>pete@cubabit.netE<gt> |
100
|
|
|
|
|
|
|
|
101
|
|
|
|
|
|
|
=head1 COPYRIGHT AND LICENSE |
102
|
|
|
|
|
|
|
|
103
|
|
|
|
|
|
|
Copyright (C) 2010 by Pete Smith |
104
|
|
|
|
|
|
|
|
105
|
|
|
|
|
|
|
This library is free software; you can redistribute it and/or modify |
106
|
|
|
|
|
|
|
it under the same terms as Perl itself, either Perl version 5.10.1 or, |
107
|
|
|
|
|
|
|
at your option, any later version of Perl 5 you may have available. |
108
|
|
|
|
|
|
|
|
109
|
|
|
|
|
|
|
=cut |
110
|
|
|
|
|
|
|
|
111
|
|
|
|
|
|
|
1; |
112
|
|
|
|
|
|
|
|