Centralize all user-side rsrc calls to go through result_source()
[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / InflateColumn.pm
CommitLineData
0e5c2582 1package DBIx::Class::InflateColumn;
2
3use strict;
4use warnings;
aa562407 5
3705e3b2 6use base 'DBIx::Class::Row';
b5ce6748 7use SQL::Abstract 'is_literal_value';
3705e3b2 8use namespace::clean;
0e5c2582 9
75d07914 10=head1 NAME
bcae85db 11
e81a6241 12DBIx::Class::InflateColumn - Automatically create references from column data
bcae85db 13
14=head1 SYNOPSIS
15
1b23a127 16 # In your table classes
17 __PACKAGE__->inflate_column('column_name', {
18 inflate => sub {
19 my ($raw_value_from_db, $result_object) = @_;
20 ...
21 },
22 deflate => sub {
23 my ($inflated_value_from_user, $result_object) = @_;
24 ...
25 },
26 });
bcae85db 27
28=head1 DESCRIPTION
29
e81a6241 30This component translates column data into references, i.e. "inflating"
31the column data. It also "deflates" references into an appropriate format
bcae85db 32for the database.
33
34It can be used, for example, to automatically convert to and from
ef7a8b67 35L<DateTime> objects for your date and time fields. There's a
48580715 36convenience component to actually do that though, try
ef7a8b67 37L<DBIx::Class::InflateColumn::DateTime>.
bcae85db 38
ef7a8b67 39It will handle all types of references except scalar references. It
40will not handle scalar values, these are ignored and thus passed
41through to L<SQL::Abstract>. This is to allow setting raw values to
42"just work". Scalar references are passed through to the database to
43deal with, to allow such settings as C< \'year + 1'> and C< \'DEFAULT' >
44to work.
45
46If you want to filter plain scalar values and replace them with
9b2c0de6 47something else, see L<DBIx::Class::FilterColumn>.
e81a6241 48
bcae85db 49=head1 METHODS
50
51=head2 inflate_column
52
75d07914 53Instruct L<DBIx::Class> to inflate the given column.
bcae85db 54
55In addition to the column name, you must provide C<inflate> and
56C<deflate> methods. The C<inflate> method is called when you access
57the field, while the C<deflate> method is called when the field needs
58to used by the database.
59
60For example, if you have a table C<events> with a timestamp field
61named C<insert_time>, you could inflate the column in the
62corresponding table class using something like:
63
64 __PACKAGE__->inflate_column('insert_time', {
1b23a127 65 inflate => sub {
66 my ($insert_time_raw_value, $event_result_object) = @_;
67 DateTime->from_epoch( epoch => $insert_time_raw_value );
68 },
69 deflate => sub {
70 my ($insert_time_dt_object, $event_result_object) = @_;
71 $insert_time_dt_object->epoch;
72 },
bcae85db 73 });
74
06fc5fc9 75The coderefs you set for inflate and deflate are called with two parameters,
1b23a127 76the first is the value of the column to be inflated/deflated, the second is
77the result object itself.
06fc5fc9 78
bcae85db 79In this example, calls to an event's C<insert_time> accessor return a
1b23a127 80L<DateTime> object. This L<DateTime> object is later "deflated" back
81to the integer epoch representation when used in the database layer.
82For a much more thorough handling of the above example, please see
83L<DBIx::Class::DateTime::Epoch>
bcae85db 84
85=cut
86
0e5c2582 87sub inflate_column {
88 my ($self, $col, $attrs) = @_;
c227b295 89
b83736a7 90 my $colinfo = $self->result_source->columns_info([$col])->{$col};
52416317 91
85aee309 92 $self->throw_exception("InflateColumn can not be used on a column with a declared FilterColumn filter")
93 if defined $colinfo->{_filter_info} and $self->isa('DBIx::Class::FilterColumn');
c227b295 94
bc0c9800 95 $self->throw_exception("inflate_column needs attr hashref")
96 unless ref $attrs eq 'HASH';
e570488a 97
52416317 98 $colinfo->{_inflate_info} = $attrs;
99 my $acc = $colinfo->{accessor};
b82c8a28 100 $self->mk_group_accessors('inflated_column' => [ (defined $acc ? $acc : $col), $col]);
0e5c2582 101 return 1;
102}
103
4a07648a 104sub _inflated_column {
0e5c2582 105 my ($self, $col, $value) = @_;
b342451e 106
107 return $value if (
108 ! defined $value # NULL is NULL is NULL
109 or
110 is_literal_value($value) #that would be a not-yet-reloaded literal update
111 );
3705e3b2 112
b83736a7 113 my $info = $self->result_source->columns_info([$col])->{$col};
3705e3b2 114
103647d5 115 return $value unless exists $info->{_inflate_info};
3705e3b2 116
5ae153d7 117 return (
118 $info->{_inflate_info}{inflate}
119 ||
120 $self->throw_exception("No inflator found for '$col'")
121 )->($value, $self);
0e5c2582 122}
123
89279e9d 124sub _deflated_column {
125 my ($self, $col, $value) = @_;
3705e3b2 126
127 ## Deflate any refs except for literals, pass through plain values
128 return $value if (
129 ! length ref $value
130 or
131 is_literal_value($value)
132 );
133
b83736a7 134 my $info = $self->result_source->columns_info([$col])->{$col};
3705e3b2 135
89279e9d 136 return $value unless exists $info->{_inflate_info};
3705e3b2 137
5ae153d7 138 return (
139 $info->{_inflate_info}{deflate}
140 ||
141 $self->throw_exception("No deflator found for '$col'")
142 )->($value, $self);
0e5c2582 143}
144
7eb4ecc8 145=head2 get_inflated_column
146
147 my $val = $obj->get_inflated_column($col);
148
149Fetch a column value in its inflated state. This is directly
150analogous to L<DBIx::Class::Row/get_column> in that it only fetches a
48580715 151column already retrieved from the database, and then inflates it.
7eb4ecc8 152Throws an exception if the column requested is not an inflated column.
153
154=cut
155
0e5c2582 156sub get_inflated_column {
157 my ($self, $col) = @_;
5ae153d7 158
bc0c9800 159 $self->throw_exception("$col is not an inflated column")
b83736a7 160 unless exists $self->result_source->columns_info->{$col}{_inflate_info};
5ae153d7 161
162 # we take care of keeping things in sync
0e5c2582 163 return $self->{_inflated_column}{$col}
164 if exists $self->{_inflated_column}{$col};
f92b166e 165
166 my $val = $self->get_column($col);
3705e3b2 167
f92b166e 168 return $self->{_inflated_column}{$col} = $self->_inflated_column($col, $val);
0e5c2582 169}
170
7eb4ecc8 171=head2 set_inflated_column
172
173 my $copy = $obj->set_inflated_column($col => $val);
174
175Sets a column value from an inflated value. This is directly
176analogous to L<DBIx::Class::Row/set_column>.
177
178=cut
179
0e5c2582 180sub set_inflated_column {
5ae153d7 181 my ($self, $col, $value) = @_;
182
b342451e 183 # pass through deflated stuff
184 if (! length ref $value or is_literal_value($value)) {
185 $self->set_column($col, $value);
9b2c0de6 186 delete $self->{_inflated_column}{$col};
9f471067 187 }
b342451e 188 # need to call set_column with the deflate cycle so that
189 # relationship caches are nuked if any
190 # also does the compare-for-dirtyness and change tracking dance
191 else {
192 $self->set_column($col, $self->_deflated_column($col, $value));
193 $self->{_inflated_column}{$col} = $value;
194 }
195
5ae153d7 196 return $value;
0e5c2582 197}
198
7eb4ecc8 199=head2 store_inflated_column
200
201 my $copy = $obj->store_inflated_column($col => $val);
202
203Sets a column value from an inflated value without marking the column
47c56124 204as dirty. This is directly analogous to L<DBIx::Class::Row/store_column>.
7eb4ecc8 205
206=cut
207
0e5c2582 208sub store_inflated_column {
5ae153d7 209 my ($self, $col, $value) = @_;
3705e3b2 210
b342451e 211 if (! length ref $value or is_literal_value($value)) {
3705e3b2 212 delete $self->{_inflated_column}{$col};
5ae153d7 213 $self->store_column($col => $value);
9f471067 214 }
3705e3b2 215 else {
216 delete $self->{_column_data}{$col};
5ae153d7 217 $self->{_inflated_column}{$col} = $value;
3705e3b2 218 }
219
5ae153d7 220 return $value;
180c7679 221}
4a07648a 222
bcae85db 223=head1 SEE ALSO
224
225=over 4
226
227=item L<DBIx::Class::Core> - This component is loaded as part of the
d88ecca6 228 C<core> L<DBIx::Class> components; generally there is no need to
bcae85db 229 load it directly
230
231=back
232
a2bd3796 233=head1 FURTHER QUESTIONS?
bcae85db 234
a2bd3796 235Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>.
bcae85db 236
a2bd3796 237=head1 COPYRIGHT AND LICENSE
bcae85db 238
a2bd3796 239This module is free software L<copyright|DBIx::Class/COPYRIGHT AND LICENSE>
240by the L<DBIx::Class (DBIC) authors|DBIx::Class/AUTHORS>. You can
241redistribute it and/or modify it under the same terms as the
242L<DBIx::Class library|DBIx::Class/COPYRIGHT AND LICENSE>.
bcae85db 243
244=cut
245
0e5c2582 2461;