use parent qw(SL::DBUpgrade2::Base);
-sub convert_column {
- my ($self, $table, $column) = @_;
-
- my $sth = $self->dbh->prepare(qq|UPDATE $table SET $column = ? WHERE id = ?|) || $self->dberror;
-
- foreach my $row (selectall_hashref_query($::form, $self->dbh, qq|SELECT id, $column FROM $table WHERE $column IS NOT NULL|)) {
- next if !$row->{$column} || (($row->{$column} =~ m{^<[a-z]+>}) && ($row->{$column} =~ m{</[a-z]+>$}));
-
- my $new_content = "" . $::request->presenter->escape($row->{$column});
- $new_content =~ s{\r}{}g;
- $new_content =~ s{\n\n+}{</p><p>}g;
- $new_content =~ s{\n}{<br />}g;
- $new_content = "<p>${new_content}</p>" if $new_content;
-
- $sth->execute($new_content, $row->{id}) if $new_content ne $row->{$column};
- }
-
- $sth->finish;
-}
-
sub run {
my ($self) = @_;
map({ ($_ => 'longdescription') } qw(translation orderitems invoice delivery_order_items)),
);
- $self->convert_column($_, $tables{$_}) for sort { $a <=> $b } keys %tables;
+ $self->convert_column_to_html($_, $tables{$_}) for keys %tables;
return 1;
}