my $where_clause = @clauses ? 'WHERE ' . join(' AND ', @clauses) : "";
- my ($orderby, $orderby_values) = $self->build_orderby_clause(keys => {date => 'comments.date'}, params => $params);
+ my ($orderby, $orderby_values) = $self->build_order_by_clause(keys => {date => 'comments.date'}, params => $params);
if (@$orderby_values) {
push @values, @$orderby_values;
}
}
-=head2 build_where_clause(unique_keys => $unique_keys, keys => $keys, params => \%params)
+=head2 build_where_clause(unique_keys => $unique_keys, timestamps => $timestamps, keys => $keys, params => \%params)
build SQL's WHERE clause.
: { clause => $clause, values => \@values };
}
-=head2 build_orderby_clause(keys => $keys, params => \@params)
+=head2 build_order_by_clause(keys => $keys, params => \@params)
build SQL's ORDER BY clause.
=cut
-sub build_orderby_clause {
+sub build_order_by_clause {
my $self = shift;
my $args = {@_};
$order = "ASC" if lc($order_by->{$k}) eq 'asc';
my $target = "";
- if ($use_alias && $args->{columns}->{$k}) {
- $target = $args->{columns}->{$k};
+ if ($use_alias && $args->{keys}->{$k}) {
+ $target = $args->{keys}->{$k};
}
else {
$target = $k;
next if !any {$_ eq $col} @$columns;
my $target = "";
- if ($use_alias && $args->{columns}->{$k}) {
- $target = $args->{columns}->{$k};
+ if ($use_alias && $args->{keys}->{$k}) {
+ $target = $args->{keys}->{$k};
}
else {
$target = $k;
my @all_keys;
push @all_keys, @$uniques, @$keys;
- ($orderby, $values) = $self->build_orderby_clause(keys => \@all_keys, params => $params);
+ ($orderby, $values) = $self->build_order_by_clause(keys => \@all_keys, params => $params);
push @arguments, @$values if @$values;
($limit, $values) = $self->build_limit_clause(params => $params);
my ($self, $params) = @_;
my @values;
- my ($orderby, $orderby_values) = $self->build_orderby_clause(keys => {timestamp => 'submissions.time'}, params => $params);
+ my ($orderby, $orderby_values) = $self->build_order_by_clause(keys => {timestamp => 'submissions.time'}, params => $params);
if (@$orderby_values) {
push @values, @$orderby_values;
}