X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=inline;f=SL%2FDBUpgrade2%2FBase.pm;h=cd698c5e59b8d9b0c4cbecc3a878233858665bbc;hb=1b112bd36f0b592a999276b6eb8c90b2a5827998;hp=594fb7fba4b07b94fa9b57783e23e172a41cafd2;hpb=a9da5102a870336ee4d347117ca7a33eeaff64ea;p=kivitendo-erp.git diff --git a/SL/DBUpgrade2/Base.pm b/SL/DBUpgrade2/Base.pm index 594fb7fba..cd698c5e5 100644 --- a/SL/DBUpgrade2/Base.pm +++ b/SL/DBUpgrade2/Base.pm @@ -12,6 +12,7 @@ use File::Copy (); use File::Path (); use List::MoreUtils qw(uniq); use SL::DBUtils qw(selectfirst_hashref_query); +use SL::Presenter::EscapedText qw(escape); use version; use Rose::Object::MakeMethods::Generic ( @@ -30,9 +31,10 @@ sub execute_script { die $EVAL_ERROR; } + my $auth = $file_name =~ m{/Pg-upgrade2-auth/} ? 'Auth::' : ''; my $package = delete $params{tag}; $package =~ s/[^a-zA-Z0-9_]+/_/g; - $package = "SL::DBUpgrade2::${package}"; + $package = "SL::DBUpgrade2::${auth}${package}"; $package->new(%params)->run; } @@ -143,6 +145,26 @@ SQL $self->db_query(qq|ALTER TABLE $params{schema}."$params{table}" DROP CONSTRAINT "${_}"|) for map { $_->[0] } @{ $constraints }; } +sub convert_column_to_html { + 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 = "" . escape($row->{$column}); + $new_content =~ s{\r}{}g; + $new_content =~ s{\n\n+}{
}g;
+ $new_content =~ s{\n}{
}g;
+ $new_content = "
${new_content}
" if $new_content; + + $sth->execute($new_content, $row->{id}) if $new_content ne $row->{$column}; + } + + $sth->finish; +} + 1; __END__ @@ -317,6 +339,11 @@ C