docs.ssis_PumlPackage - V

type: V ( view ), modify_date: 2021-11-22 19:20:44

RepoObject_guid: BEDCAD7F-F73E-EC11-852D-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssis_pumlpackage

Columns

Table 1. Columns of docs.ssis_PumlPackage - V
PK Column Name Data Type NULL? ID

varchar(50)

NOT NULL

varchar(200)

NOT NULL

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssis_pumlpackage

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssis_pumlpackage

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssis_pumlpackage

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssis_pumlpackage

Column Reference Diagram

entity_1_1_colref-docs.ssis_pumlpackage

Column Details

_

AntoraModule

AntoraModule

varchar(50)

NOT NULL

PackageName

PackageName

varchar(200)

NOT NULL

PumlPackageControlFlows

PumlPackageControlFlows

nvarchar(max)

NOT NULL

sql_modules_definition

docs.ssis_PumlPackage - V script
CREATE View docs.ssis_PumlPackage
As
Select
    pt.AntoraModule
  , pt.PackageName
  , PumlPackageControlFlows =
  --
  Concat (
             '@startuml'
           , Char ( 13 ) + Char ( 10 )
           , '
package "'
             --
             +          pt.PackageName + '" {
'
           --
           , String_Agg ( Cast(N'' As NVarchar(Max)) + pt.PumlPartialTaskComponent, Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                                pt.TaskPath)
           , '
}
'
           -- relations
           , Char ( 13 ) + Char ( 10 )
           , Max ( pf.PumlPartialControlFlows )
           --
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 )
             + Max ( puml_skinparam_component.Parameter_value_result ) + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 ) + Char ( 13 ) + Char ( 10 ) + Max ( puml_footer.Parameter_value_result )
             + Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 ) + '@enduml' + Char ( 13 ) + Char ( 10 )
         )
From
    docs.ssis_PumlPartialTaskComponent                                         As pt
    Left Join
        docs.ssis_PumlPartialControlFlows                                      As pf
            On
            pf.AntoraModule = pt.AntoraModule
            And pf.PackageName = pt.PackageName
    Cross Join config.ftv_get_parameter_value ( 'puml_footer', 'interactive' ) As puml_footer
    Cross Join config.ftv_get_parameter_value ( 'puml_skinparam_component', 'ssis_task' ) As puml_skinparam_component
Group By
    pt.AntoraModule
  , pt.PackageName