docs.RepoObject_Plantuml_Entity - V
type: V ( view ), modify_date: 2021-11-28 10:58:40
RepoObject_guid: BCD49D8D-4595-EB11-84F4-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObject_Plantuml_Entity__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_Plantuml_Entity__2
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObject_Plantuml_Entity__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
RepoObject_fullname2
RepoObject_fullname2 |
|
|
(concat([RepoObject_schema_name],'.',[RepoObject_name]))
RepoObject_PumlOnlyPkOrIndex
RepoObject_PumlOnlyPkOrIndex |
|
|
RepoObject_PumlOnlyPkOrIndexOrMeasure
RepoObject_PumlOnlyPkOrIndexOrMeasure |
|
|
RepoObject_PumlOnlyPkOrNotHidden
RepoObject_PumlOnlyPkOrNotHidden |
|
|
sql_modules_definition
docs.RepoObject_Plantuml_Entity - V script
/*
PlantUML definition per RepoObject
to be used in composed PlantUML diagrams
you need to persist:
EXEC [docs].[usp_PERSIST_RepoObject_Plantuml_Entity_T]
it is possible to create interactive SVG diagrams.
But they need to be inline, and big diagrams will not match and it will not be possible to open them in a separate window
Code should be like
entity "[[{site-url}/{page-component-name}/{page-component-version}/{page-module}/config.Parameter.html config.Parameter]]" as config.Parameter << U >> {
But maybe this could be hard coded instead of using inline and parameters? At least to use the "current" version?
page-component-name and page-module could also be hard coded,
but what about the {site-url}?
entity "[[{site-url}/{page-component-name}/current/{page-module}/config.Parameter.html config.Parameter]]" as config.Parameter << U >> {
*/
CREATE View docs.RepoObject_Plantuml_Entity
As
Select
ro.RepoObject_guid
, ro.cultures_name
, RepoObject_Puml =
--
Concat (
ro.PumlEntityTopDefault
, ' {'
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlAllEntityColumns
--, collist.PlantumlPkEntityColumns
--, Iif(ro.tables_isHidden = 1, ' ..', ' --')
--, Char ( 13 ) + Char ( 10 )
--, collist.PlantumlNonPkEntityColumns
--, Iif(ro.tables_isHidden = 1, ' ..', ' --')
--, Char ( 13 ) + Char ( 10 )
--, collist.PlantumlNonPkHiddenEntityColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, mlist.PlantumlMeasures
, '}'
, Char ( 13 ) + Char ( 10 )
)
, RepoObject_PumlOnlyPK =
--
Concat (
ro.PumlEntityTopDefault
, ' {'
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlPkEntityColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, '}'
, Char ( 13 ) + Char ( 10 )
)
, RepoObject_PumlOnlyPkOrNotHidden =
--
Concat (
ro.PumlEntityTopDefault
, ' {'
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlPkEntityColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlNonPkEntityColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, '}'
, Char ( 13 ) + Char ( 10 )
)
, RepoObject_PumlOnlyPkOrIndex =
--
Concat (
ro.PumlEntityTopDefault
, ' {'
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlPkEntityColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlNonPkIndexColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, '}'
, Char ( 13 ) + Char ( 10 )
)
, RepoObject_PumlOnlyPkOrIndexOrMeasure =
--
Concat (
ro.PumlEntityTopWorkaround
, ' {'
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlPkEntityColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, collist.PlantumlNonPkIndexColumns
, Iif(ro.tables_isHidden = 1, ' ..', ' --')
, Char ( 13 ) + Char ( 10 )
, mlist.PlantumlMeasures
, '}'
, Char ( 13 ) + Char ( 10 )
)
, RepoObject_PumlOnlyIndex =
--
Concat (
ro.PumlEntityTopDefault
, ' {'
, Char ( 13 ) + Char ( 10 )
, indexlist.PumlIndexList
, Char ( 13 ) + Char ( 10 )
, '}'
, Char ( 13 ) + Char ( 10 )
)
, ro.RepoObject_fullname2
, ro.RepoObject_schema_name
From
docs.RepoObject_OutputFilter_T As ro
Left Join
docs.RepoObject_ColumnList_T As collist
On
collist.RepoObject_guid = ro.RepoObject_guid
And
(
(
collist.is_external = 0
And collist.cultures_name = ro.cultures_name
)
Or
--external objects are without culture
(
collist.is_external = 1
And collist.cultures_name = ''
)
)
Left Join
docs.RepoObject_IndexList_T As indexlist
On
indexlist.RepoObject_guid = ro.RepoObject_guid
And indexlist.cultures_name = ro.cultures_name
Left Join
docs.RepoObject_MeasureList As mlist
On
mlist.RepoObject_guid = ro.RepoObject_guid
And mlist.cultures_name = ro.cultures_name