sql/Pg-upgrade2/requirement_spec_edit_html.pl

   1 # @tag: requirement_spec_edit_html
   2 # @description: Pflichtenhefte: diverse Text-Felder in HTML umwandeln
   3 # @depends: requirement_spec_items_update_trigger_fix2 requirement_spec_items_update_trigger_fix requirement_specs_orders requirement_specs_section_templates requirement_specs
   4 package SL::DBUpgrade2::requirement_spec_edit_html;
   5
   6 use strict;
   7 use utf8;
   8
   9 use SL::DBUtils;
  10
  11 use parent qw(SL::DBUpgrade2::Base);
  12
  13 sub run {
  14   my ($self) = @_;
  15
  16   my %tables = (
  17     requirement_spec_predefined_texts => 'text',
  18     requirement_spec_text_blocks      => 'text',
  19     requirement_spec_items            => 'description',
  20     parts                             => 'notes',
  21     map({ ($_ => 'longdescription') } qw(translation orderitems invoice delivery_order_items)),
  22   );
  23
  24   $self->convert_column_to_html($_, $tables{$_}) for keys %tables;
  25
  26   return 1;
  27 }
  28
  29 1;