# quick check if we got a sane rs on our hands
my @pcols = $rsrc->primary_columns;
+ unless (@pcols) {
+ $self->throw_exception (
+ sprintf (
+ "You must declare primary key(s) on source '%s' (via set_primary_key) in order to update or delete complex resultsets",
+ $rsrc->source_name || $rsrc->from
+ )
+ );
+ }
my $sel = $rs->_resolved_attrs->{select};
$sel = [ $sel ] unless ref $sel eq 'ARRAY';
elsif (
($attrs->{rows} || $attrs->{offset})
&&
- ($sql_maker->limit_dialect eq 'RowNumberOver' || $sql_maker->limit_dialect eq 'Top' )
+ $sql_maker->limit_dialect eq 'RowNumberOver'
&&
(ref $ident eq 'ARRAY' && @$ident > 1) # indicates a join
&&
scalar $sql_maker->_order_by_chunks ($attrs->{order_by})
) {
- # the two limit dialects above mangle the SQL such that the join gets lost
+ # the RNO limit dialect above mangles the SQL such that the join gets lost
# wrap a subquery here
push @limit, delete @{$attrs}{qw/rows offset/};
data => $schema,
);
- my $ret = $tr->translate
- or $self->throw_exception( 'Unable to produce deployment statements: ' . $tr->error);
+ my @ret;
+ my $wa = wantarray;
+ if ($wa) {
+ @ret = $tr->translate;
+ }
+ else {
+ $ret[0] = $tr->translate;
+ }
+
+ $self->throw_exception( 'Unable to produce deployment statements: ' . $tr->error)
+ unless (@ret && defined $ret[0]);
- return $ret;
+ return $wa ? @ret : $ret[0];
}
sub deploy {