Moved inflation to inflate_result in Row.pm
[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / Row.pm
CommitLineData
7624b19f 1package DBIx::Class::Row;
2
3use strict;
4use warnings;
5
1edd1722 6use base qw/DBIx::Class/;
7
7624b19f 8=head1 NAME
9
10DBIx::Class::Row - Basic row methods
11
12=head1 SYNOPSIS
13
14=head1 DESCRIPTION
15
16This class is responsible for defining and doing basic operations on rows
17derived from L<DBIx::Class::Table> objects.
18
19=head1 METHODS
20
8091aa91 21=head2 new
7624b19f 22
23 my $obj = My::Class->new($attrs);
24
25Creates a new row object from column => value mappings passed as a hash ref
26
27=cut
28
29sub new {
30 my ($class, $attrs) = @_;
31 $class = ref $class if ref $class;
32 my $new = bless({ _column_data => { } }, $class);
33 if ($attrs) {
34 $new->throw("attrs must be a hashref" ) unless ref($attrs) eq 'HASH';
35 while (my ($k, $v) = each %{$attrs}) {
103647d5 36 die "No such column $k on $class" unless $class->has_column($k);
484c9dda 37 $new->store_column($k => $v);
7624b19f 38 }
39 }
40 return $new;
41}
42
8091aa91 43=head2 insert
7624b19f 44
45 $obj->insert;
46
47Inserts an object into the database if it isn't already in there. Returns
48the object itself.
49
50=cut
51
52sub insert {
53 my ($self) = @_;
54 return $self if $self->in_storage;
55 #use Data::Dumper; warn Dumper($self);
56 my %in;
57 $in{$_} = $self->get_column($_)
58 for grep { defined $self->get_column($_) } $self->columns;
59 my %out = %{ $self->storage->insert($self->_table_name, \%in) };
60 $self->store_column($_, $out{$_})
61 for grep { $self->get_column($_) ne $out{$_} } keys %out;
62 $self->in_storage(1);
63 $self->{_dirty_columns} = {};
64 return $self;
65}
66
8091aa91 67=head2 in_storage
7624b19f 68
69 $obj->in_storage; # Get value
70 $obj->in_storage(1); # Set value
71
72Indicated whether the object exists as a row in the database or not
73
74=cut
75
76sub in_storage {
77 my ($self, $val) = @_;
78 $self->{_in_storage} = $val if @_ > 1;
79 return $self->{_in_storage};
80}
81
8091aa91 82=head2 create
7624b19f 83
84 my $new = My::Class->create($attrs);
85
86A shortcut for My::Class->new($attrs)->insert;
87
88=cut
89
90sub create {
91 my ($class, $attrs) = @_;
92 $class->throw( "create needs a hashref" ) unless ref $attrs eq 'HASH';
93 return $class->new($attrs)->insert;
94}
95
8091aa91 96=head2 update
7624b19f 97
98 $obj->update;
99
100Must be run on an object that is already in the database; issues an SQL
101UPDATE query to commit any changes to the object to the db if required.
102
103=cut
104
105sub update {
106 my ($self, $upd) = @_;
107 $self->throw( "Not in database" ) unless $self->in_storage;
99be059e 108 if (ref $upd eq 'HASH') {
109 $self->$_($upd->{$_}) for keys %$upd;
110 }
111 my %to_update;
7624b19f 112 $to_update{$_} = $self->get_column($_) for $self->is_changed;
113 return -1 unless keys %to_update;
114 my $rows = $self->storage->update($self->_table_name, \%to_update,
115 $self->ident_condition);
116 if ($rows == 0) {
117 $self->throw( "Can't update ${self}: row not found" );
118 } elsif ($rows > 1) {
119 $self->throw("Can't update ${self}: updated more than one row");
120 }
121 $self->{_dirty_columns} = {};
122 return $self;
123}
124
8091aa91 125=head2 delete
7624b19f 126
127 $obj->delete
128
129Deletes the object from the database. The object is still perfectly usable
130accessor-wise etc. but ->in_storage will now return 0 and the object must
131be re ->insert'ed before it can be ->update'ed
132
133=cut
134
135sub delete {
136 my $self = shift;
137 if (ref $self) {
138 $self->throw( "Not in database" ) unless $self->in_storage;
139 #warn $self->_ident_cond.' '.join(', ', $self->_ident_values);
140 $self->storage->delete($self->_table_name, $self->ident_condition);
141 $self->in_storage(undef);
142 #$self->store_column($_ => undef) for $self->primary_columns;
143 # Should probably also arrange to trash PK if auto
144 # but if we do, post-delete cascade triggers fail :/
145 } else {
146 my $attrs = { };
147 if (@_ > 1 && ref $_[$#_] eq 'HASH') {
148 $attrs = { %{ pop(@_) } };
149 }
150 my $query = (ref $_[0] eq 'HASH' ? $_[0] : {@_});
151 $self->storage->delete($self->_table_name, $query);
152 }
153 return $self;
154}
155
8091aa91 156=head2 get_column
7624b19f 157
158 my $val = $obj->get_column($col);
159
8091aa91 160Gets a column value from a row object. Currently, does not do
161any queries; the column must have already been fetched from
162the database and stored in the object.
7624b19f 163
164=cut
165
166sub get_column {
167 my ($self, $column) = @_;
168 $self->throw( "Can't fetch data as class method" ) unless ref $self;
103647d5 169 $self->throw( "No such column '${column}'" ) unless $self->has_column($column);
7624b19f 170 return $self->{_column_data}{$column}
171 if exists $self->{_column_data}{$column};
172 return undef;
173}
174
8091aa91 175=head2 get_columns
076a6864 176
177 my %data = $obj->get_columns;
178
8091aa91 179Does C<get_column>, for all column values at once.
076a6864 180
181=cut
182
183sub get_columns {
184 my $self = shift;
185 return map { $_ => $self->get_column($_) } $self->columns;
186}
187
8091aa91 188=head2 set_column
7624b19f 189
190 $obj->set_column($col => $val);
191
8091aa91 192Sets a column value. If the new value is different from the old one,
193the column is marked as dirty for when you next call $obj->update.
7624b19f 194
195=cut
196
197sub set_column {
198 my $self = shift;
199 my ($column) = @_;
200 my $old = $self->get_column($column);
201 my $ret = $self->store_column(@_);
202 $self->{_dirty_columns}{$column} = 1 unless defined $old && $old eq $ret;
203 return $ret;
204}
205
8091aa91 206=head2 set_columns
076a6864 207
dc818523 208 my $copy = $orig->set_columns({ $col => $val, ... });
076a6864 209
8091aa91 210Sets more than one column value at once.
076a6864 211
212=cut
213
214sub set_columns {
215 my ($self,$data) = @_;
216 while (my ($col,$val) = each %$data) {
217 $self->set_column($col,$val);
218 }
219}
220
8091aa91 221=head2 copy
076a6864 222
223 my $copy = $orig->copy({ change => $to, ... });
224
8091aa91 225Inserts a new row with the specified changes.
076a6864 226
227=cut
228
8091aa91 229=head2 store_column
7624b19f 230
231 $obj->store_column($col => $val);
232
8091aa91 233Sets a column value without marking it as dirty.
7624b19f 234
235=cut
236
237sub store_column {
238 my ($self, $column, $value) = @_;
239 $self->throw( "No such column '${column}'" )
103647d5 240 unless $self->has_column($column);
7624b19f 241 $self->throw( "set_column called for ${column} without value" )
242 if @_ < 3;
243 return $self->{_column_data}{$column} = $value;
244}
245
b52e9bf8 246=head2 inflate_result
247
248 Class->inflate_result(\%me, \%prefetch?)
249
250Called by ResultSet to inflate a result from storage
251
252=cut
253
254sub inflate_result {
255 my ($class, $me, $prefetch) = @_;
256 #use Data::Dumper; print Dumper(@_);
257 my $new = bless({ _column_data => $me }, ref $class || $class);
7624b19f 258 $new->in_storage(1);
b52e9bf8 259 PRE: foreach my $pre (keys %{$prefetch||{}}) {
260 my $rel_obj = $class->_relationships->{$pre};
261 my $pre_class = $class->resolve_class($rel_obj->{class});
262 my $fetched = $pre_class->inflate_result($prefetch->{$pre});
263 $class->throw("No accessor for prefetched $pre")
264 unless defined $rel_obj->{attrs}{accessor};
265 if ($rel_obj->{attrs}{accessor} eq 'single') {
266 PRIMARY: foreach my $pri ($rel_obj->{class}->primary_columns) {
267 unless (defined $fetched->get_column($pri)) {
268 undef $fetched;
269 last PRIMARY;
270 }
271 }
272 $new->{_relationship_data}{$pre} = $fetched;
273 } elsif ($rel_obj->{attrs}{accessor} eq 'filter') {
274 $new->{_inflated_column}{$pre} = $fetched;
275 } else {
276 $class->throw("Don't know how to store prefetched $pre");
277 }
278 }
7624b19f 279 return $new;
280}
281
7624b19f 282sub copy {
283 my ($self, $changes) = @_;
284 my $new = bless({ _column_data => { %{$self->{_column_data}}} }, ref $self);
285 $new->set_column($_ => $changes->{$_}) for keys %$changes;
286 return $new->insert;
287}
288
8091aa91 289=head2 insert_or_update
7624b19f 290
291 $obj->insert_or_update
292
8091aa91 293Updates the object if it's already in the db, else inserts it.
7624b19f 294
295=cut
296
297sub insert_or_update {
298 my $self = shift;
299 return ($self->in_storage ? $self->update : $self->insert);
300}
301
8091aa91 302=head2 is_changed
7624b19f 303
304 my @changed_col_names = $obj->is_changed
305
306=cut
307
308sub is_changed {
309 return keys %{shift->{_dirty_columns} || {}};
310}
311
3121;
313
7624b19f 314=head1 AUTHORS
315
daec44b8 316Matt S. Trout <mst@shadowcatsystems.co.uk>
7624b19f 317
318=head1 LICENSE
319
320You may distribute this code under the same terms as Perl itself.
321
322=cut
323