my $conversion = $config->type =~ m{^(?:date|timestamp)$} ? $config->type
: $config->type =~ m{^(?:customer|vendor|part)$} ? 'integer'
: $config->type eq 'number' ? 'numeric'
- # : $config->type eq 'bool' ? 'boolean'
: '';
($query{config}, $bind_vals{config}) = Rose::DB::Object::QueryBuilder::build_select(
$query{$key} =~ s{\bt\d+(?:\.)?\b}{}g;
# manually inline the values. again, rose doen't know how to handly bind params in subqueries :(
- $query{$key} =~ s{\?}{ $config->dbh->quote($_) }xe for @{ $bind_vals{$key} };
+ $query{$key} =~ s{\?}{ $config->dbh->quote(shift @{ $bind_vals{$key} }) }xeg;
$query{$key} =~ s{\n}{ }g;
}