More internals cleanup, separated out ResultSourceInstance from TableInstance
[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);
88cb6a1d 56 $self->result_source->storage->insert(
b98e75f6 57 $self->result_source->from, { $self->get_columns });
7624b19f 58 $self->in_storage(1);
59 $self->{_dirty_columns} = {};
60 return $self;
61}
62
8091aa91 63=head2 in_storage
7624b19f 64
65 $obj->in_storage; # Get value
66 $obj->in_storage(1); # Set value
67
68Indicated whether the object exists as a row in the database or not
69
70=cut
71
72sub in_storage {
73 my ($self, $val) = @_;
74 $self->{_in_storage} = $val if @_ > 1;
75 return $self->{_in_storage};
76}
77
8091aa91 78=head2 update
7624b19f 79
80 $obj->update;
81
82Must be run on an object that is already in the database; issues an SQL
83UPDATE query to commit any changes to the object to the db if required.
84
85=cut
86
87sub update {
88 my ($self, $upd) = @_;
89 $self->throw( "Not in database" ) unless $self->in_storage;
d7156e50 90 my %to_update = $self->get_dirty_columns;
c01ab172 91 return $self unless keys %to_update;
88cb6a1d 92 my $rows = $self->result_source->storage->update(
93 $self->result_source->from, \%to_update, $self->ident_condition);
7624b19f 94 if ($rows == 0) {
95 $self->throw( "Can't update ${self}: row not found" );
96 } elsif ($rows > 1) {
97 $self->throw("Can't update ${self}: updated more than one row");
98 }
99 $self->{_dirty_columns} = {};
100 return $self;
101}
102
8091aa91 103=head2 delete
7624b19f 104
105 $obj->delete
106
107Deletes the object from the database. The object is still perfectly usable
108accessor-wise etc. but ->in_storage will now return 0 and the object must
109be re ->insert'ed before it can be ->update'ed
110
111=cut
112
113sub delete {
114 my $self = shift;
115 if (ref $self) {
116 $self->throw( "Not in database" ) unless $self->in_storage;
88cb6a1d 117 $self->result_source->storage->delete(
118 $self->result_source->from, $self->ident_condition);
7624b19f 119 $self->in_storage(undef);
7624b19f 120 } else {
121 my $attrs = { };
122 if (@_ > 1 && ref $_[$#_] eq 'HASH') {
123 $attrs = { %{ pop(@_) } };
124 }
125 my $query = (ref $_[0] eq 'HASH' ? $_[0] : {@_});
c01ab172 126 $self->result_source->resultset->search(@_)->delete;
7624b19f 127 }
128 return $self;
129}
130
8091aa91 131=head2 get_column
7624b19f 132
133 my $val = $obj->get_column($col);
134
8091aa91 135Gets a column value from a row object. Currently, does not do
136any queries; the column must have already been fetched from
137the database and stored in the object.
7624b19f 138
139=cut
140
141sub get_column {
142 my ($self, $column) = @_;
143 $self->throw( "Can't fetch data as class method" ) unless ref $self;
7624b19f 144 return $self->{_column_data}{$column}
145 if exists $self->{_column_data}{$column};
d7156e50 146 $self->throw( "No such column '${column}'" ) unless $self->has_column($column);
7624b19f 147 return undef;
148}
149
8091aa91 150=head2 get_columns
076a6864 151
152 my %data = $obj->get_columns;
153
8091aa91 154Does C<get_column>, for all column values at once.
076a6864 155
156=cut
157
158sub get_columns {
159 my $self = shift;
d7156e50 160 return return %{$self->{_column_data}};
161}
162
163=head2 get_dirty_columns
164
165 my %data = $obj->get_dirty_columns;
166
167Identical to get_columns but only returns those that have been changed.
168
169=cut
170
171sub get_dirty_columns {
172 my $self = shift;
173 return map { $_ => $self->{_column_data}{$_} }
174 keys %{$self->{_dirty_columns}};
076a6864 175}
176
8091aa91 177=head2 set_column
7624b19f 178
179 $obj->set_column($col => $val);
180
8091aa91 181Sets a column value. If the new value is different from the old one,
182the column is marked as dirty for when you next call $obj->update.
7624b19f 183
184=cut
185
186sub set_column {
187 my $self = shift;
188 my ($column) = @_;
189 my $old = $self->get_column($column);
190 my $ret = $self->store_column(@_);
87772e46 191 $self->{_dirty_columns}{$column} = 1
192 if (defined $old ^ defined $ret) || (defined $old && $old ne $ret);
7624b19f 193 return $ret;
194}
195
8091aa91 196=head2 set_columns
076a6864 197
dc818523 198 my $copy = $orig->set_columns({ $col => $val, ... });
076a6864 199
8091aa91 200Sets more than one column value at once.
076a6864 201
202=cut
203
204sub set_columns {
205 my ($self,$data) = @_;
206 while (my ($col,$val) = each %$data) {
207 $self->set_column($col,$val);
208 }
c01ab172 209 return $self;
076a6864 210}
211
8091aa91 212=head2 copy
076a6864 213
214 my $copy = $orig->copy({ change => $to, ... });
215
8091aa91 216Inserts a new row with the specified changes.
076a6864 217
218=cut
219
c01ab172 220sub copy {
221 my ($self, $changes) = @_;
222 my $new = bless({ _column_data => { %{$self->{_column_data}}} }, ref $self);
223 $new->set_column($_ => $changes->{$_}) for keys %$changes;
224 return $new->insert;
225}
226
8091aa91 227=head2 store_column
7624b19f 228
229 $obj->store_column($col => $val);
230
8091aa91 231Sets a column value without marking it as dirty.
7624b19f 232
233=cut
234
235sub store_column {
236 my ($self, $column, $value) = @_;
237 $self->throw( "No such column '${column}'" )
d7156e50 238 unless exists $self->{_column_data}{$column} || $self->has_column($column);
7624b19f 239 $self->throw( "set_column called for ${column} without value" )
240 if @_ < 3;
241 return $self->{_column_data}{$column} = $value;
242}
243
b52e9bf8 244=head2 inflate_result
245
c01ab172 246 Class->inflate_result($result_source, \%me, \%prefetch?)
b52e9bf8 247
248Called by ResultSet to inflate a result from storage
249
250=cut
251
252sub inflate_result {
c01ab172 253 my ($class, $source, $me, $prefetch) = @_;
b52e9bf8 254 #use Data::Dumper; print Dumper(@_);
c01ab172 255 my $new = bless({ result_source => $source,
256 _column_data => $me,
257 _in_storage => 1
258 },
259 ref $class || $class);
7fb16f1a 260 my $schema;
b52e9bf8 261 PRE: foreach my $pre (keys %{$prefetch||{}}) {
4685e006 262 my $rel_obj = $class->relationship_info($pre);
263 die "Can't prefetch non-eistant relationship ${pre}" unless $rel_obj;
c01ab172 264 $schema ||= $source->schema;
7fb16f1a 265 my $pre_class = $schema->class($rel_obj->{class});
c01ab172 266 my $fetched = $pre_class->inflate_result(
267 $schema->source($pre_class), @{$prefetch->{$pre}});
b52e9bf8 268 $class->throw("No accessor for prefetched $pre")
269 unless defined $rel_obj->{attrs}{accessor};
2fb09619 270 PRIMARY: foreach my $pri ($rel_obj->{class}->primary_columns) {
271 unless (defined $fetched->get_column($pri)) {
272 undef $fetched;
273 last PRIMARY;
b52e9bf8 274 }
2fb09619 275 }
276 if ($rel_obj->{attrs}{accessor} eq 'single') {
b52e9bf8 277 $new->{_relationship_data}{$pre} = $fetched;
278 } elsif ($rel_obj->{attrs}{accessor} eq 'filter') {
279 $new->{_inflated_column}{$pre} = $fetched;
280 } else {
281 $class->throw("Don't know how to store prefetched $pre");
282 }
283 }
7624b19f 284 return $new;
285}
286
8091aa91 287=head2 insert_or_update
7624b19f 288
289 $obj->insert_or_update
290
8091aa91 291Updates the object if it's already in the db, else inserts it.
7624b19f 292
293=cut
294
295sub insert_or_update {
296 my $self = shift;
297 return ($self->in_storage ? $self->update : $self->insert);
298}
299
8091aa91 300=head2 is_changed
7624b19f 301
302 my @changed_col_names = $obj->is_changed
303
304=cut
305
306sub is_changed {
307 return keys %{shift->{_dirty_columns} || {}};
308}
309
3101;
311
7624b19f 312=head1 AUTHORS
313
daec44b8 314Matt S. Trout <mst@shadowcatsystems.co.uk>
7624b19f 315
316=head1 LICENSE
317
318You may distribute this code under the same terms as Perl itself.
319
320=cut
321