use base qw/DBIx::Class/;
+__PACKAGE__->load_components(qw/AccessorGroup/);
+
+__PACKAGE__->mk_group_accessors('simple' => 'result_source');
+
=head1 NAME
DBIx::Class::Row - Basic row methods
$obj->insert;
Inserts an object into the database if it isn't already in there. Returns
-the object itself.
+the object itself. Requires the object's result source to be set, or the
+class to have a result_source_instance method.
=cut
sub insert {
my ($self) = @_;
return $self if $self->in_storage;
+ $self->{result_source} ||= $self->result_source_instance
+ if $self->can('result_source_instance');
+ my $source = $self->{result_source};
+ die "No result_source set on this object; can't insert" unless $source;
#use Data::Dumper; warn Dumper($self);
- my %in;
- $in{$_} = $self->get_column($_)
- for grep { defined $self->get_column($_) } $self->columns;
- my %out = %{ $self->storage->insert($self->_table_name, \%in) };
- $self->store_column($_, $out{$_})
- for grep { $self->get_column($_) ne $out{$_} } keys %out;
+ $source->storage->insert($source->from, { $self->get_columns });
$self->in_storage(1);
$self->{_dirty_columns} = {};
return $self;
return $self->{_in_storage};
}
-=head2 create
-
- my $new = My::Class->create($attrs);
-
-A shortcut for My::Class->new($attrs)->insert;
-
-=cut
-
-sub create {
- my ($class, $attrs) = @_;
- $class->throw( "create needs a hashref" ) unless ref $attrs eq 'HASH';
- return $class->new($attrs)->insert;
-}
-
=head2 update
$obj->update;
sub update {
my ($self, $upd) = @_;
$self->throw( "Not in database" ) unless $self->in_storage;
- if (ref $upd eq 'HASH') {
- $self->$_($upd->{$_}) for keys %$upd;
- }
- my %to_update;
- $to_update{$_} = $self->get_column($_) for $self->is_changed;
- return -1 unless keys %to_update;
- my $rows = $self->storage->update($self->_table_name, \%to_update,
- $self->ident_condition);
+ my %to_update = $self->get_dirty_columns;
+ return $self unless keys %to_update;
+ my $rows = $self->result_source->storage->update(
+ $self->result_source->from, \%to_update, $self->ident_condition);
if ($rows == 0) {
$self->throw( "Can't update ${self}: row not found" );
} elsif ($rows > 1) {
my $self = shift;
if (ref $self) {
$self->throw( "Not in database" ) unless $self->in_storage;
- #warn $self->_ident_cond.' '.join(', ', $self->_ident_values);
- $self->storage->delete($self->_table_name, $self->ident_condition);
+ $self->result_source->storage->delete(
+ $self->result_source->from, $self->ident_condition);
$self->in_storage(undef);
- #$self->store_column($_ => undef) for $self->primary_columns;
- # Should probably also arrange to trash PK if auto
- # but if we do, post-delete cascade triggers fail :/
} else {
+ die "Can't do class delete without a ResultSource instance"
+ unless $self->can('result_source_instance');
my $attrs = { };
if (@_ > 1 && ref $_[$#_] eq 'HASH') {
$attrs = { %{ pop(@_) } };
}
my $query = (ref $_[0] eq 'HASH' ? $_[0] : {@_});
- $self->storage->delete($self->_table_name, $query);
+ $self->result_source_instance->resultset->search(@_)->delete;
}
return $self;
}
sub get_column {
my ($self, $column) = @_;
$self->throw( "Can't fetch data as class method" ) unless ref $self;
- $self->throw( "No such column '${column}'" ) unless $self->has_column($column);
return $self->{_column_data}{$column}
if exists $self->{_column_data}{$column};
+ $self->throw( "No such column '${column}'" ) unless $self->has_column($column);
return undef;
}
sub get_columns {
my $self = shift;
- return map { $_ => $self->get_column($_) } $self->columns;
+ return return %{$self->{_column_data}};
+}
+
+=head2 get_dirty_columns
+
+ my %data = $obj->get_dirty_columns;
+
+Identical to get_columns but only returns those that have been changed.
+
+=cut
+
+sub get_dirty_columns {
+ my $self = shift;
+ return map { $_ => $self->{_column_data}{$_} }
+ keys %{$self->{_dirty_columns}};
}
=head2 set_column
my ($column) = @_;
my $old = $self->get_column($column);
my $ret = $self->store_column(@_);
- $self->{_dirty_columns}{$column} = 1 unless defined $old && $old eq $ret;
+ $self->{_dirty_columns}{$column} = 1
+ if (defined $old ^ defined $ret) || (defined $old && $old ne $ret);
return $ret;
}
while (my ($col,$val) = each %$data) {
$self->set_column($col,$val);
}
+ return $self;
}
=head2 copy
=cut
+sub copy {
+ my ($self, $changes) = @_;
+ my $new = bless({ _column_data => { %{$self->{_column_data}}} }, ref $self);
+ $new->set_column($_ => $changes->{$_}) for keys %$changes;
+ return $new->insert;
+}
+
=head2 store_column
$obj->store_column($col => $val);
sub store_column {
my ($self, $column, $value) = @_;
$self->throw( "No such column '${column}'" )
- unless $self->has_column($column);
+ unless exists $self->{_column_data}{$column} || $self->has_column($column);
$self->throw( "set_column called for ${column} without value" )
if @_ < 3;
return $self->{_column_data}{$column} = $value;
=head2 inflate_result
- Class->inflate_result(\%me, \%prefetch?)
+ Class->inflate_result($result_source, \%me, \%prefetch?)
Called by ResultSet to inflate a result from storage
=cut
sub inflate_result {
- my ($class, $me, $prefetch) = @_;
+ my ($class, $source, $me, $prefetch) = @_;
#use Data::Dumper; print Dumper(@_);
- my $new = bless({ _column_data => $me }, ref $class || $class);
- $new->in_storage(1);
+ my $new = bless({ result_source => $source,
+ _column_data => $me,
+ _in_storage => 1
+ },
+ ref $class || $class);
+ my $schema;
PRE: foreach my $pre (keys %{$prefetch||{}}) {
- my $rel_obj = $class->_relationships->{$pre};
- my $pre_class = $class->resolve_class($rel_obj->{class});
- my $fetched = $pre_class->inflate_result(@{$prefetch->{$pre}});
+ my $rel_obj = $class->relationship_info($pre);
+ die "Can't prefetch non-eistant relationship ${pre}" unless $rel_obj;
+ $schema ||= $source->schema;
+ my $pre_class = $schema->class($rel_obj->{class});
+ my $fetched = $pre_class->inflate_result(
+ $schema->source($pre_class), @{$prefetch->{$pre}});
$class->throw("No accessor for prefetched $pre")
unless defined $rel_obj->{attrs}{accessor};
- if ($rel_obj->{attrs}{accessor} eq 'single') {
- PRIMARY: foreach my $pri ($rel_obj->{class}->primary_columns) {
- unless (defined $fetched->get_column($pri)) {
- undef $fetched;
- last PRIMARY;
- }
+ PRIMARY: foreach my $pri ($rel_obj->{class}->primary_columns) {
+ unless (defined $fetched->get_column($pri)) {
+ undef $fetched;
+ last PRIMARY;
}
+ }
+ if ($rel_obj->{attrs}{accessor} eq 'single') {
$new->{_relationship_data}{$pre} = $fetched;
} elsif ($rel_obj->{attrs}{accessor} eq 'filter') {
$new->{_inflated_column}{$pre} = $fetched;
return $new;
}
-sub copy {
- my ($self, $changes) = @_;
- my $new = bless({ _column_data => { %{$self->{_column_data}}} }, ref $self);
- $new->set_column($_ => $changes->{$_}) for keys %$changes;
- return $new->insert;
-}
-
=head2 insert_or_update
$obj->insert_or_update
return keys %{shift->{_dirty_columns} || {}};
}
+=head2 result_source
+
+ Accessor to the ResultSource this object was created from
+
+=cut
+
1;
=head1 AUTHORS