functions/Invoke-Data.ps1
|
function Invoke-Data { [CmdletBinding()] [OutputType([PSObject])] param ( [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)] [psobject]$RawData, [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)] [string]$OutDir ) begin { # Get function definition files. $functions = @( Get-ChildItem -Path "$PSScriptRoot\data" -Filter *.ps1 -ErrorAction SilentlyContinue ) # Dot source the files foreach ($import in @($functions)) { try { . $import.fullname } catch { Write-Error -Message "Failed to import function $($import.fullname): $_" } } } process { #$OutDirFilePath = "$($OutDir)\metadata_new.json" $SplitDirectory = "$($OutDir)\Datamart" $Msg = "$(" " * 4)Creating new $(($RawData.DatamartNM).ToLower()) object..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; $Data = New-HCEmptyDatamartObject #region DATAMART $Data.ContentId = $RawData.ContentId.ToString() $Data.DatamartNM = $RawData.DatamartNM $Data.DatamartNoSpacesNM = (Get-CleanFileName -Name $RawData.DatamartNM -RemoveSpace) $Data.DataMartTypeDSC = $RawData.DataMartTypeDSC $Data.DescriptionTXT = $RawData.DescriptionTXT $Data.DestinationDatabaseName = $RawData.DestinationDatabaseName $Data.DestinationObjectPrefix = $RawData.DestinationObjectPrefix $Data.DestinationSchemaName = $RawData.DestinationSchemaName $Data.SamTypeCode = $RawData.SamTypeCode $Data.Status = $RawData.Status $Data.VersionText = $RawData.VersionText $Data.SAMDVersionText<#extension#> = $RawData.SAMDVersionText $Data._hcposh<#extension#> = $RawData._hcposh #endregion #region ENTITIES foreach ($Entity in $RawData.Tables.GetEnumerator()) { $HCEntity = New-HCEmptyEntityObject #region GENERAL PROPS $HCEntity.ContentId = $Entity.ContentId.ToString() $HCEntity.DescriptionTXT = $Entity.DescriptionTXT $HCEntity.DatabaseNM = $Entity.DatabaseNM $HCEntity.SchemaNM = $Entity.SchemaNM $HCEntity.TableNM = $Entity.TableNM $HCEntity.TableTypeNM = $Entity.TableTypeNM $HCEntity.ViewName = $Entity.ViewName $HCEntity.LoadType = $Entity.LoadType $HCEntity.LastModifiedTimestamp = $Entity.LastModifiedTimestamp $HCEntity.IsPersisted = $Entity.IsPersisted $HCEntity.IsPublic = $Entity.IsPublic $IsUniversal = $Entity.AttributeValues | Where-Object AttributeName -eq 'IsUniversal' if ($IsUniversal) { $HCEntity | Add-Member -Type NoteProperty -Name IsUniversal -Value $([System.Convert]::ToBoolean($IsUniversal.TextValue)) } #endregion #region PROTECTION PROPS $IsProtected = $Entity.AttributeValues | Where-Object AttributeName -eq 'IsProtected' if ($IsProtected) { #New attributes introduced with CAP 4.0 $HCEntity | Add-Member -Type NoteProperty -Name IsProtected -Value $([System.Convert]::ToBoolean($IsProtected.TextValue)) } #endregion #region FULLYQUALIFIEDNAME PROPS $HCFullyQualifiedName = New-HCEmptyFullyQualifiedNameObject $HCFullyQualifiedName.Table = "$($Entity.DatabaseNM).$($Entity.SchemaNM).$($Entity.TableNM)" $HCFullyQualifiedName.View = "$($Entity.DatabaseNM).$($Entity.SchemaNM).$($Entity.ViewName)" $HCEntity.FullyQualifiedNames = $HCFullyQualifiedName #endregion #region COLUMN PROPS foreach ($Column in $Entity.Columns.GetEnumerator()) { $HCColumn = New-HCEmptyColumnObject $HCColumn.ContentId = $Column.ContentId.ToString() $HCColumn.ColumnNM = $Column.ColumnNM $HCColumn.DataSensitivityCD = $Column.DataSensitivityCD $HCColumn.DataTypeDSC = $Column.DataTypeDSC $HCColumn.DescriptionTXT = $Column.DescriptionTXT $HCColumn.IsIncrementalColumnValue = $Column.IsIncrementalColumnValue $HCColumn.IsSystemColumnValue = $Column.IsSystemColumnValue $HCColumn.IsNullableValue = $Column.IsNullableValue $HCColumn.IsPrimaryKeyValue = $Column.IsPrimaryKeyValue $HCColumn.Ordinal = $Column.Ordinal $HCColumn.Status = $Column.Status $HCEntity.Columns += $HCColumn } #endregion #region INDEX PROPS foreach ($Index in $Entity.Indexes.GetEnumerator()) { $HCIndex = New-HCEmptyIndexObject $HCIndex.IndexName = $Index.IndexName $HCIndex.IndexTypeCode = $Index.IndexTypeCode $HCIndex.IsActive = $Index.IsActive foreach ($IndexColumn in $Index.IndexColumns.GetEnumerator()) { $HCIndexColumn = New-HCEmptyIndexColumnObject $HCIndexColumn.Ordinal = $IndexColumn.Ordinal $HCIndexColumn.ColumnNM = $IndexColumn.Column.ColumnNM $HCIndexColumn.IsCovering = $IndexColumn.IsCovering $HCIndexColumn.IsDescending = $IndexColumn.IsDescending $HCIndex.IndexColumns += $HCIndexColumn } $HCEntity.Indexes += $HCIndex } #endregion #region BINDING PROPS foreach ($Binding in $Entity.FedByBindings.GetEnumerator()) { $HCBinding = New-HCEmptyBindingObject $HCBinding.ContentId = $Binding.ContentId.ToString() $HCBinding.BindingName = $Binding.BindingName $HCBinding.BindingNameNoSpaces = (Get-CleanFileName -Name $Binding.BindingName -RemoveSpace) $HCBinding.BindingStatus = $Binding.BindingStatus $HCBinding.BindingDescription = $Binding.BindingDescription $HCBinding.ClassificationCode = $Binding.ClassificationCode $HCBinding.GrainName = $Binding.GrainName $HCBinding.BindingType = $Binding.GetType().ToString().split('.')[-1] switch ($HCBinding.BindingType) { 'SqlBinding' { $HCBinding.Script = $Binding.UserDefinedSQL } 'RBinding' { $HCBinding.Script = $Binding.Script } } #New attributes introduced with CAP 4.0 $IsProtected = $Binding.AttributeValues | Where-Object AttributeName -eq 'IsProtected' if ($IsProtected) { $HCBinding | Add-Member -Type NoteProperty -Name IsProtected -Value $([System.Convert]::ToBoolean($IsProtected.TextValue)) } $LoadType = if ($Binding.LoadType) { $Binding.LoadType } else { $HCEntity.LoadType } if ($LoadType) { $HCBinding | Add-Member -Type NoteProperty -Name LoadType -Value $LoadType if ($Binding.IncrementalConfigurations) { $HCBinding | Add-Member -Type NoteProperty -Name IncrementalConfigurations -Value @() foreach ($IncrementalConfiguration in $Binding.IncrementalConfigurations.GetEnumerator()) { $HCIncrementalConfiguration = New-HCEmptyIncrementalConfigurationObject $HCIncrementalConfiguration.IncrementalColumnName = $IncrementalConfiguration.IncrementalColumnName $HCIncrementalConfiguration.OverlapNumber = $IncrementalConfiguration.OverlapNumber $HCIncrementalConfiguration.OverlapType = $IncrementalConfiguration.OverlapType $HCIncrementalConfiguration.SourceDatabaseName = $IncrementalConfiguration.SourceDatabaseName $HCIncrementalConfiguration.SourceSchemaName = $IncrementalConfiguration.SourceSchemaName $HCIncrementalConfiguration.SourceTableAlias = $IncrementalConfiguration.SourceTableAlias $HCIncrementalConfiguration.SourceTableName = $IncrementalConfiguration.SourceTableName $HCBinding.IncrementalConfigurations += $HCIncrementalConfiguration } } } $HCEntity.Bindings += $HCBinding } #endregion #region EXTENSION PROPS $ExtensionContentIds = New-HCEmptyExtensionContentIdsObject if ($Entity.ParentEntityRelationships.Count -or $Entity.ChildEntityRelationships.Count) { $HCEntity | Add-Member -Type NoteProperty -Name IsExtended -Value $true -Force $HCEntity | Add-Member -Type NoteProperty -Name ExtensionContentIds -Value $ExtensionContentIds -Force } if ($Entity.ParentEntityRelationships.Count) { $HCEntity.ExtensionContentIds.CoreEntity = $Entity.ContentId.ToString() foreach ($Relationship in $Entity.ParentEntityRelationships.GetEnumerator()) { $HCEntity.ExtensionContentIds."$($Relationship.ChildRoleName)" = $Relationship.ChildEntity.ContentId.ToString() } } if ($Entity.ChildEntityRelationships.Count) { $HCEntity.ExtensionContentIds."$($Entity.ChildEntityRelationships.ChildRoleName)" = $Entity.ChildEntityRelationships.ChildEntity.ContentId.ToString() foreach ($Relationship in $Entity.ChildEntityRelationships.ParentEntity.ParentEntityRelationships.GetEnumerator()) { $HCEntity.ExtensionContentIds."$($Relationship.ChildRoleName)" = $Relationship.ChildEntity.ContentId.ToString() $HCEntity.ExtensionContentIds."$($Relationship.ParentRoleName)" = $Relationship.ParentEntity.ContentId.ToString() } } #endregion #region CUSTOM GROUP PROPS $HCEntity.EntityGroupNM = $HCEntity.Bindings[0].GrainName #Set the EntityGroupNM to the first Grain name for now // not a perfect solution if ($HCEntity.Bindings) { $HCEntity.ClassificationCode = $HCEntity.Bindings[0].ClassificationCode #Set the ClassificationCode to the first ClassificationCode for now // not a perfect solution } if ($Entity.AllowsDataEntry -eq $true) { $HCEntity.ClassificationCode = 'DataEntry' } #endregion $Data.Entities += $HCEntity } #endregion #region Update extension entity classification foreach ($Extension in $Data.Entities | Where-Object { ($_.ExtensionContentIds.PsObject.Properties.Value | Measure-Object).Count -eq 3 }) { foreach ($property in $Extension.ExtensionContentIds.PsObject.Properties) { $Entity = $Data.Entities[$Data.Entities.ContentId.IndexOf($property.Value)]; $Entity | Add-Member -Type NoteProperty -Name ExtensionTypeNM -Value $property.Name -Force; $Entity.ExtensionContentIds = $Extension.ExtensionContentIds; if ($property.Name -eq "OverridingExtensionView") { $Entity.ClassificationCode = "OverridingExtensionView"; } elseif ($property.Name -ne "CoreEntity" -and $Entity.ClassificationCode -notmatch "-") { $Entity.ClassificationCode = "$($Entity.ClassificationCode)-Extension" } foreach ($Binding in $Entity.Bindings) { $Binding.ClassificationCode = $Entity.ClassificationCode; } } } #endregion $Data.MaxLastModifiedTimestamp<#extension#> = ($Data.Entities.LastModifiedTimestamp | Measure-Object -Maximum).Maximum $Msg = "$(" " * 8)$(($Data.Entities | Measure-Object).Count) - Entities"; Write-Host $Msg -ForegroundColor White; Write-Verbose $Msg; Write-Log $Msg; $Msg = "$(" " * 8)$(($Data.Entities.Bindings | Measure-Object).Count) - Bindings"; Write-Host $Msg -ForegroundColor White; Write-Verbose $Msg; Write-Log $Msg; #region ADD DATA ENTRY DATA if ($RawData.DataEntryData) { foreach ($HCEntity in $Data.Entities | Where-Object { $_.ClassificationCode -eq 'DataEntry' }) { $DataEntryDataIndex = $RawData.DataEntryData.FullyQualifiedNM.IndexOf($HCEntity.FullyQualifiedNames.View) if ($DataEntryDataIndex -ne -1) { #New property added to store a maximum of 300 records for that Data entry entity #@{ FullyQualifiedNM = $Csv.BaseName; Data = Import-Csv -Path $Csv.FullName; Msg = $null } $DataEntryRecordCNT = ($RawData.DataEntryData[$DataEntryDataIndex].Data | Measure-Object).Count if ($DataEntryRecordCNT -gt 300) { $Msg = "Displaying only 300 out of $($DataEntryRecordCNT) records" } else { $Msg = "Displaying $($DataEntryRecordCNT) records" } $DataEntryData = New-Object PSObject $DataEntryData | Add-Member -Type NoteProperty -Name FullyQualifiedNM -Value $RawData.DataEntryData[$DataEntryDataIndex].FullyQualifiedNM $DataEntryData | Add-Member -Type NoteProperty -Name Data -Value ($RawData.DataEntryData[$DataEntryDataIndex].Data | Select-Object -First 300) $DataEntryData | Add-Member -Type NoteProperty -Name Data_All -Value ($RawData.DataEntryData[$DataEntryDataIndex].Data) $DataEntryData | Add-Member -Type NoteProperty -Name Msg -Value $Msg $HCEntity | Add-Member -Type NoteProperty -Name DataEntryData -Value $DataEntryData } } } #endregion #region PARSE BINDINGS $Msg = "$(" " * 4)Parsing tables and columns from sql..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; foreach ($HCEntity in $Data.Entities) { foreach ($HCBinding in $HCEntity.Bindings | Where-Object BindingType -eq 'SqlBinding') { $SourcedByEntities = $(Invoke-SqlParser -Query $HCBinding.Script -Log $False -SelectStar $False -Brackets $False) foreach ($SourcedByEntity in $SourcedByEntities | Where-Object { $_.DatabaseNM -and $_.SchemaNM -and $_.TableNM }) { $HCSourcedByEntity = New-HCEmptySourcedByEntityObject #$HCSourcedByEntity.ServerNM = $SourcedByEntity.ServerNM $HCSourcedByEntity.DatabaseNM = $SourcedByEntity.DatabaseNM $HCSourcedByEntity.SchemaNM = $SourcedByEntity.SchemaNM $HCSourcedByEntity.TableNM = $SourcedByEntity.TableNM $HCSourcedByEntity.FullyQualifiedNM = $SourcedByEntity.FullyQualifiedNM $HCSourcedByEntity.AliasNM = $SourcedByEntity.AliasNM $HCSourcedByEntity.BindingCount = 1 #if table originated from a system table if ($HCSourcedByEntity.SchemaNM -eq 'CatalystAdmin') { $HCSourcedByEntity.TableOrigin = 'System' } #or if table originated from a local table elseif (($Data.Entities.FullyQualifiedNames.Table -contains $HCSourcedByEntity.FullyQualifiedNM) -or ` ($Data.Entities.FullyQualifiedNames.View -contains $HCSourcedByEntity.FullyQualifiedNM)) { $HCSourcedByEntity.TableOrigin = 'Local' $HCSourcedByEntity.SourceContentId = ($Data.Entities | Where-Object { (($_.FullyQualifiedNames.Table -eq $HCSourcedByEntity.FullyQualifiedNM) -or ($_.FullyQualifiedNames.View -eq $HCSourcedByEntity.FullyQualifiedNM)) -and $_.ClassificationCode -ne 'OverridingExtensionView' }).ContentId #if it's a universal entity then it originates outside of this datamart if ($Data.Entities[$Data.Entities.ContentId.IndexOf($HCSourcedByEntity.SourceContentId)].IsUniversal) { $HCSourcedByEntity.TableOrigin = 'External' } } #else table must have originated externally else { $HCSourcedByEntity.TableOrigin = 'External' } foreach ($SourcedByColumn in $SourcedByEntity.Columns) { $HCSourcedByColumn = New-HCEmptySourcedByColumnObject $HCSourcedByColumn.ColumnNM = $SourcedByColumn.ColumnNM $HCSourcedByColumn.FullyQualifiedNM = $SourcedByColumn.FullyQualifiedNM $HCSourcedByColumn.AliasNM = $SourcedByColumn.AliasNM $HCSourcedByColumn.BindingCount = 1 $HCSourcedByEntity.SourcedByColumns += $HCSourcedByColumn } #check for missing alias ie PossibleColumns if ($SourcedByEntity.PossibleColumns) { $HCSourcedByEntity | Add-Member -Type NoteProperty -Name SourcedByPossibleColumns -Value @() foreach ($SourcedByPossibleColumn in $SourcedByEntity.PossibleColumns) { $HCSourcedByPossibleColumn = New-HCEmptySourcedByPossibleColumnObject $HCSourcedByPossibleColumn.ColumnNM = $SourcedByPossibleColumn.ColumnNM $HCSourcedByPossibleColumn.FullyQualifiedNM = "$($HCSourcedByEntity.FullyQualifiedNM).$($HCSourcedByPossibleColumn.ColumnNM)" $HCSourcedByEntity.SourcedByPossibleColumns += $HCSourcedByPossibleColumn } } $HCBinding.SourcedByEntities += $HCSourcedByEntity } } #region LEVEL-UP SOURCES (BINDING TO ENTITY) $HCEntityGroups = $HCEntity.Bindings.SourcedByEntities | Group-Object -Property FullyQualifiedNM foreach ($HCEntityGroup in $HCEntityGroups) { $HCSourcedByEntity = New-HCEmptySourcedByEntityObject #$HCSourcedByEntity.ServerNM = $HCEntityGroup.Group[0].ServerNM $HCSourcedByEntity.DatabaseNM = $HCEntityGroup.Group[0].DatabaseNM $HCSourcedByEntity.SchemaNM = $HCEntityGroup.Group[0].SchemaNM $HCSourcedByEntity.TableNM = $HCEntityGroup.Group[0].TableNM $HCSourcedByEntity.FullyQualifiedNM = $HCEntityGroup.Group[0].FullyQualifiedNM $HCSourcedByEntity.TableOrigin = $HCEntityGroup.Group[0].TableOrigin $HCSourcedByEntity.SourceContentId = $HCEntityGroup.Group[0].SourceContentId $HCSourcedByEntity.BindingCount = ($HCEntityGroup.Group.BindingCount | Measure-Object -Sum).Sum $HCSourcedByEntity.PSObject.Properties.Remove('AliasNM') $ColumnGroups = $HCEntityGroup.Group.SourcedByColumns | Group-Object ColumnNM foreach ($ColumnGroup in $ColumnGroups) { $HCSourcedByColumn = New-HCEmptySourcedByColumnObject $HCSourcedByColumn.ColumnNM = $ColumnGroup.Group[0].ColumnNM $HCSourcedByColumn.FullyQualifiedNM = $ColumnGroup.Group[0].FullyQualifiedNM $HCSourcedByColumn.BindingCount = ($ColumnGroup.Group.BindingCount | Measure-Object -Sum).Sum $HCSourcedByColumn.PSObject.Properties.Remove('AliasNM') $HCSourcedByEntity.SourcedByColumns += $HCSourcedByColumn } $HCEntity.SourcedByEntities += $HCSourcedByEntity } #endregion } #endregion #region UPDATE EXTENSION ENTITIES function Get-Entity ($ContentId) { return $Data.Entities[$Data.Entities.ContentId.IndexOf($ContentId)] } foreach ($HCEntity in $Data.Entities | Where-Object { $_.ExtensionTypeNM -eq 'CoreEntity' }) { $ExtensionEntityId = $HCEntity.ExtensionContentIds.ExtensionEntity; $ExtensionEntity = Get-Entity($ExtensionEntityId); $OverridingExtensionViewId = $HCEntity.ExtensionContentIds.OverridingExtensionView; $OverridingExtensionView = Get-Entity($OverridingExtensionViewId); #Add the SourcedByEntities from the OverridingExtensionView to the CoreEntity $HCEntity.SourcedByEntities += $OverridingExtensionView.SourcedByEntities | Where-Object { $_.SourceContentId -ne $HCEntity.ContentId }; #Add the Columns from the ExtensionEntity to the CoreEntity $ColumnsExt = $ExtensionEntity.Columns | Where-Object { $_.IsSystemColumnValue -eq $false -and $_.IsPrimaryKeyValue -eq $false }; $MaxOrdinal = ($HCEntity.Columns.Ordinal | Measure-Object -Maximum).Maximum + 1; foreach ($ColumnExt in $ColumnsExt | Sort-Object Ordinal) { $ColumnExt | Add-Member -Type NoteProperty -Name IsExtended -Value $True; $ColumnExt.Ordinal = $MaxOrdinal; $MaxOrdinal++; } $HCEntity.Columns += $ColumnsExt; #Add the OverridingExtensionView as a property of the CoreEntity $HCEntity | Add-Member -Type NoteProperty -Name OverridingExtensionView -Value $OverridingExtensionView; #Remove the OverridingExtensionView as a true entity $Data.Entities = $Data.Entities | Where-Object { $_.ContentId -ne $OverridingExtensionViewId }; #if the CoreEntity is not a public entity, then turn off the extension and overridingextension as being public #if (!($HCEntity.IsPublic)) #{ # $ExtensionEntity.IsPublic = $false; # $OverridingExtensionView.IsPublic = $false; #} } #endregion #region UPDATE OVERRIDING VIEW ENTITIES (SEPARATE FROM EXTENSIONS) $OverrideList = $Data.Entities | Group-Object -Property { $_.FullyQualifiedNames.View } | Where-Object Count -gt 1 $OverrideObjects = @(); foreach ($Override in $OverrideList) { $OverrideObject = New-Object PSObject $OverrideObject | Add-Member -Type NoteProperty -Name OverriddenContentId -Value $Null $OverrideObject | Add-Member -Type NoteProperty -Name OverridingContentId -Value $Null foreach ($Entity in $Override.Group) { if ($Entity.IsPersisted) { $OverrideObject.OverriddenContentId = $Entity.ContentId } else { $OverrideObject.OverridingContentId = $Entity.ContentId } } $OverrideObjects += $OverrideObject; } foreach ($OverrideObject in $OverrideObjects) { $OverriddenEntity = $Data.Entities[$Data.Entities.ContentId.IndexOf($OverrideObject.OverriddenContentId)]; $OverriddenEntity | Add-Member -Type NoteProperty -Name IsOverridden -Value $True $OverriddenEntity.ViewName = $OverriddenEntity.ViewName + 'BASE' $OverriddenEntity.FullyQualifiedNames.View = $OverriddenEntity.FullyQualifiedNames.View + 'BASE' $OverridingEntity = $Data.Entities[$Data.Entities.ContentId.IndexOf($OverrideObject.OverridingContentId)]; $OverridingEntity | Add-Member -Type NoteProperty -Name DoesOverride -Value $True } #endregion #region LEVEL-UP SOURCES (ENTITY TO DATAMART) $DataGroups = $Data.Entities.SourcedByEntities | Group-Object -Property FullyQualifiedNM foreach ($DataGroup in $DataGroups) { $HCSourcedByEntity = New-HCEmptySourcedByEntityObject #$HCSourcedByEntity.ServerNM = $DataGroup.Group[0].ServerNM $HCSourcedByEntity.DatabaseNM = $DataGroup.Group[0].DatabaseNM $HCSourcedByEntity.SchemaNM = $DataGroup.Group[0].SchemaNM $HCSourcedByEntity.TableNM = $DataGroup.Group[0].TableNM $HCSourcedByEntity.FullyQualifiedNM = $DataGroup.Group[0].FullyQualifiedNM $HCSourcedByEntity.TableOrigin = $DataGroup.Group[0].TableOrigin $HCSourcedByEntity.SourceContentId = $DataGroup.Group[0].SourceContentId $HCSourcedByEntity.BindingCount = ($DataGroup.Group.BindingCount | Measure-Object -Sum).Sum $HCSourcedByEntity.PSObject.Properties.Remove('AliasNM') $ColumnGroups = $DataGroup.Group.SourcedByColumns | Group-Object ColumnNM foreach ($ColumnGroup in $ColumnGroups) { $HCSourcedByColumn = New-HCEmptySourcedByColumnObject $HCSourcedByColumn.ColumnNM = $ColumnGroup.Group[0].ColumnNM $HCSourcedByColumn.FullyQualifiedNM = $ColumnGroup.Group[0].FullyQualifiedNM $HCSourcedByColumn.BindingCount = ($ColumnGroup.Group.BindingCount | Measure-Object -Sum).Sum $HCSourcedByColumn.PSObject.Properties.Remove('AliasNM') $HCSourcedByEntity.SourcedByColumns += $HCSourcedByColumn } $Data.SourcedByEntities += $HCSourcedByEntity } #endregion #region ADD GIT REPO PROPERTIES # try { # $Msg = "$(" " * 4)Adding git properties..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; # function checkGit { # [CmdletBinding()] # param () # begin { # if (!(Test-Path $((Get-Location).Path + '\.git'))) { throw; } # } # process { # git --version # $GitUrl = (git config --local remote.origin.url).Replace(".git", "") # $Data | Add-Member -Type NoteProperty -Name Team -Value $(($GitUrl -split "/")[3]) # $Data | Add-Member -Type NoteProperty -Name Repository -Value $(($GitUrl -split "/")[4]) # $Data | Add-Member -Type NoteProperty -Name Branch -Value $(git rev-parse --abbrev-ref HEAD) # } # } # checkGit -ErrorAction Stop # } # catch { # $Msg = "$(" " * 8)Git not installed or not inside a git directory -- unable to add git properties"; Write-Host $Msg -ForegroundColor Yellow; Write-Verbose $Msg; Write-Log $Msg 'warning'; # } #endregion #region SPLIT OBJECT INTO SMALLER FILES if (!$NoSplit) { $Msg = "$(" " * 4)Splitting data object into smaller files..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; Split-ObjectToFiles -Data $Data -splitDirectory $SplitDirectory } #endregion $Msg = "Success!`r`n"; Write-Host $Msg -ForegroundColor Green; Write-Verbose $Msg; Write-Log $Msg; $Output = New-Object PSObject $Output | Add-Member -Type NoteProperty -Name Data -Value $Data $Output | Add-Member -Type NoteProperty -Name Outdir -Value $OutDir return $Output } } # SIG # Begin signature block # MIIaxgYJKoZIhvcNAQcCoIIatzCCGrMCAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCBMHHMCYrlAPce/ # 5g52Mw4xNyZ3RGnBpRlQmgWfJW1esKCCCqMwggUwMIIEGKADAgECAhAECRgbX9W7 # ZnVTQ7VvlVAIMA0GCSqGSIb3DQEBCwUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK # EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV # BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0xMzEwMjIxMjAwMDBa # Fw0yODEwMjIxMjAwMDBaMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy # dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lD # ZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwggEiMA0GCSqGSIb3 # DQEBAQUAA4IBDwAwggEKAoIBAQD407Mcfw4Rr2d3B9MLMUkZz9D7RZmxOttE9X/l # qJ3bMtdx6nadBS63j/qSQ8Cl+YnUNxnXtqrwnIal2CWsDnkoOn7p0WfTxvspJ8fT # eyOU5JEjlpB3gvmhhCNmElQzUHSxKCa7JGnCwlLyFGeKiUXULaGj6YgsIJWuHEqH # CN8M9eJNYBi+qsSyrnAxZjNxPqxwoqvOf+l8y5Kh5TsxHM/q8grkV7tKtel05iv+ # bMt+dDk2DZDv5LVOpKnqagqrhPOsZ061xPeM0SAlI+sIZD5SlsHyDxL0xY4PwaLo # LFH3c7y9hbFig3NBggfkOItqcyDQD2RzPJ6fpjOp/RnfJZPRAgMBAAGjggHNMIIB # yTASBgNVHRMBAf8ECDAGAQH/AgEAMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAK # BggrBgEFBQcDAzB5BggrBgEFBQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9v # Y3NwLmRpZ2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGln # aWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNydDCBgQYDVR0fBHow # eDA6oDigNoY0aHR0cDovL2NybDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJl # ZElEUm9vdENBLmNybDA6oDigNoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0Rp # Z2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDBPBgNVHSAESDBGMDgGCmCGSAGG/WwA # AgQwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAK # BghghkgBhv1sAzAdBgNVHQ4EFgQUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHwYDVR0j # BBgwFoAUReuir/SSy4IxLVGLp6chnfNtyA8wDQYJKoZIhvcNAQELBQADggEBAD7s # DVoks/Mi0RXILHwlKXaoHV0cLToaxO8wYdd+C2D9wz0PxK+L/e8q3yBVN7Dh9tGS # dQ9RtG6ljlriXiSBThCk7j9xjmMOE0ut119EefM2FAaK95xGTlz/kLEbBw6RFfu6 # r7VRwo0kriTGxycqoSkoGjpxKAI8LpGjwCUR4pwUR6F6aGivm6dcIFzZcbEMj7uo # +MUSaJ/PQMtARKUT8OZkDCUIQjKyNookAv4vcn4c10lFluhZHen6dGRrsutmQ9qz # sIzV6Q3d9gEgzpkxYz0IGhizgZtPxpMQBvwHgfqL2vmCSfdibqFT+hKUGIUukpHq # aGxEMrJmoecYpJpkUe8wggVrMIIEU6ADAgECAhAMMCpTLsjxo9FR9hag8ePUMA0G # CSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ # bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0 # IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcNMjAwMzMxMDAwMDAw # WhcNMjMwNTEwMTIwMDAwWjCBpzELMAkGA1UEBhMCVVMxDTALBgNVBAgTBFV0YWgx # FzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVIZWFsdGggQ2F0YWx5 # c3QsIEluYy4xHjAcBgNVBAMTFUhlYWx0aCBDYXRhbHlzdCwgSW5jLjEwMC4GCSqG # SIb3DQEJARYhYWRtaW5uaXN0cmF0b3JAaGVhbHRoY2F0YWx5c3QuY29tMIIBIjAN # BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA2fY0HWdxDJezDOsbHp7f9u/lrrD5 # nuZ1mENMgvixlrtC/KXgBRXlcWH7ajIOKljKnWCSAZwlZy4nFGbMagKmMzohXUXg # xo94u5nCdiBa/kgPazNGpL0AyGgX2VARMbcpm8Gdy+/uH3Kc7L91lcoGZVVBnVIt # 1oj5iXURqmhL83TrMyYqyj3XOH0So8Y10FVLPSukocMzMqBIRgvn/7EP0iWtOjXx # +o1wB5Ql+z9G3NCqF6CKE/Pn355XYbbmjF7BPzKoOjocHO6VU2uEflJWq1ZFb0QY # /tAosyyLYi9kFfO1damtJfRbbsVqavwg2UeQkzhg9CpB6eSsmBXPlFHudQIDAQAB # o4IBxTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0O # BBYEFFjfHOOIre2C4m9NCk8TFJlDwMxUMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUE # DDAKBggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdp # Y2VydC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2Ny # bDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUw # QzA3BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNl # cnQuY29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcw # AYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8v # Y2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNp # Z25pbmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAsBxn # 9yJAQi+9cJPZpJvOEV6iHaOBGv8898wNJCc4eB5g8WPziEY70GZVeqEdx3z0wS8U # QQIr19Hkju2NFZjDtzB9z1jAc/9EgqFGoCZbPijv1EYAa2oOVAp1BPbLjqBSdXqu # 2mzqo14CJ30oNom9ep9F6LGZ5zEoPsMrJejSbJGr4EacrksX8C8qeFklc7FzwiGk # GX7IQxidrrhOm2fOvGGAAxnvNYAR0FqJK0LiWWPSt5R/j63H/6HQtqD2sLevI3+O # bRP74TPchDobFmWlSogX9oB63E7fsbDAqecY0cRPQ6tVWK53Ke2sB514nahFjZDa # mxsa3/acZWL659ly3jGCD3kwgg91AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD # VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv # BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC # EAwwKlMuyPGj0VH2FqDx49QwDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEM # MQIwADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w # DAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg6BqsOwi7OzT+pKbZSF++uS8C # Xu5azTXMZN0Q00LYHx8wDQYJKoZIhvcNAQEBBQAEggEAAW1Ln0LQ6GSt5M4khqYE # vo69k2nNOo4u+acnagKcSTBPz0Fxv0o6nis6cU682euel5WtOM4wj+Zm5wZpYife # Yn8XL5164Y44oAcoVQKi13w1nxmhdHBSO68H9N0jg5AQq+uWCDRCZwLG/yf1Tlmp # T+cfVxZD52lKU/221HPMITVcjR3mUd6hh61Qz33oh2G/UWhWqAXCv6fGj/Eaow/F # pbaq395dKXh3pubzKMVEftScNT72CCZzRMfWP4zfIHe4oGbDf1pPasOrPky9HEQQ # QhKtvQQCosAqEQ6ucZgiE9Xt7CvVSjjyXIG7mS9w3dHj15EAJXd6o0xx8FB5RT5E # g6GCDUUwgg1BBgorBgEEAYI3AwMBMYINMTCCDS0GCSqGSIb3DQEHAqCCDR4wgg0a # AgEDMQ8wDQYJYIZIAWUDBAIBBQAweAYLKoZIhvcNAQkQAQSgaQRnMGUCAQEGCWCG # SAGG/WwHATAxMA0GCWCGSAFlAwQCAQUABCChOUNPoIC9GO0xXWetsIPTzMeu9ta7 # UO8+dbiTZ1oJBgIRAMb13qWnCo1YduujhNmt08EYDzIwMjEwMzI1MjAxOTAwWqCC # CjcwggT+MIID5qADAgECAhANQkrgvjqI/2BAIc4UAPDdMA0GCSqGSIb3DQEBCwUA # MHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsT # EHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJl # ZCBJRCBUaW1lc3RhbXBpbmcgQ0EwHhcNMjEwMTAxMDAwMDAwWhcNMzEwMTA2MDAw # MDAwWjBIMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xIDAe # BgNVBAMTF0RpZ2lDZXJ0IFRpbWVzdGFtcCAyMDIxMIIBIjANBgkqhkiG9w0BAQEF # AAOCAQ8AMIIBCgKCAQEAwuZhhGfFivUNCKRFymNrUdc6EUK9CnV1TZS0DFC1JhD+ # HchvkWsMlucaXEjvROW/m2HNFZFiWrj/ZwucY/02aoH6KfjdK3CF3gIY83htvH35 # x20JPb5qdofpir34hF0edsnkxnZ2OlPR0dNaNo/Go+EvGzq3YdZz7E5tM4p8XUUt # S7FQ5kE6N1aG3JMjjfdQJehk5t3Tjy9XtYcg6w6OLNUj2vRNeEbjA4MxKUpcDDGK # SoyIxfcwWvkUrxVfbENJCf0mI1P2jWPoGqtbsR0wwptpgrTb/FZUvB+hh6u+elsK # IC9LCcmVp42y+tZji06lchzun3oBc/gZ1v4NSYS9AQIDAQABo4IBuDCCAbQwDgYD # VR0PAQH/BAQDAgeAMAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUH # AwgwQQYDVR0gBDowODA2BglghkgBhv1sBwEwKTAnBggrBgEFBQcCARYbaHR0cDov # L3d3dy5kaWdpY2VydC5jb20vQ1BTMB8GA1UdIwQYMBaAFPS24SAd/imu0uRhpbKi # JbLIFzVuMB0GA1UdDgQWBBQ2RIaOpLqwZr68KC0dRDbd42p6vDBxBgNVHR8EajBo # MDKgMKAuhixodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVkLXRz # LmNybDAyoDCgLoYsaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl # ZC10cy5jcmwwgYUGCCsGAQUFBwEBBHkwdzAkBggrBgEFBQcwAYYYaHR0cDovL29j # c3AuZGlnaWNlcnQuY29tME8GCCsGAQUFBzAChkNodHRwOi8vY2FjZXJ0cy5kaWdp # Y2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEVGltZXN0YW1waW5nQ0EuY3J0 # MA0GCSqGSIb3DQEBCwUAA4IBAQBIHNy16ZojvOca5yAOjmdG/UJyUXQKI0ejq5LS # JcRwWb4UoOUngaVNFBUZB3nw0QTDhtk7vf5EAmZN7WmkD/a4cM9i6PVRSnh5Nnon # t/PnUp+Tp+1DnnvntN1BIon7h6JGA0789P63ZHdjXyNSaYOC+hpT7ZDMjaEXcw30 # 82U5cEvznNZ6e9oMvD0y0BvL9WH8dQgAdryBDvjA4VzPxBFy5xtkSdgimnUVQvUt # MjiB2vRgorq0Uvtc4GEkJU+y38kpqHNDUdq9Y9YfW5v3LhtPEx33Sg1xfpe39D+E # 68Hjo0mh+s6nv1bPull2YYlffqe0jmd4+TaY4cso2luHpoovMIIFMTCCBBmgAwIB # AgIQCqEl1tYyG35B5AXaNpfCFTANBgkqhkiG9w0BAQsFADBlMQswCQYDVQQGEwJV # UzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQu # Y29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVkIElEIFJvb3QgQ0EwHhcNMTYw # MTA3MTIwMDAwWhcNMzEwMTA3MTIwMDAwWjByMQswCQYDVQQGEwJVUzEVMBMGA1UE # ChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMTEwLwYD # VQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQgVGltZXN0YW1waW5nIENBMIIB # IjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvdAy7kvNj3/dqbqCmcU5VChX # tiNKxA4HRTNREH3Q+X1NaH7ntqD0jbOI5Je/YyGQmL8TvFfTw+F+CNZqFAA49y4e # O+7MpvYyWf5fZT/gm+vjRkcGGlV+Cyd+wKL1oODeIj8O/36V+/OjuiI+GKwR5PCZ # A207hXwJ0+5dyJoLVOOoCXFr4M8iEA91z3FyTgqt30A6XLdR4aF5FMZNJCMwXbzs # PGBqrC8HzP3w6kfZiFBe/WZuVmEnKYmEUeaC50ZQ/ZQqLKfkdT66mA+Ef58xFNat # 1fJky3seBdCEGXIX8RcG7z3N1k3vBkL9olMqT4UdxB08r8/arBD13ays6Vb/kwID # AQABo4IBzjCCAcowHQYDVR0OBBYEFPS24SAd/imu0uRhpbKiJbLIFzVuMB8GA1Ud # IwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMBIGA1UdEwEB/wQIMAYBAf8CAQAw # DgYDVR0PAQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMIMHkGCCsGAQUFBwEB # BG0wazAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsG # AQUFBzAChjdodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1 # cmVkSURSb290Q0EuY3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8vY3JsNC5k # aWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqgOKA2hjRo # dHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0Eu # Y3JsMFAGA1UdIARJMEcwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIBFhxodHRw # czovL3d3dy5kaWdpY2VydC5jb20vQ1BTMAsGCWCGSAGG/WwHATANBgkqhkiG9w0B # AQsFAAOCAQEAcZUS6VGHVmnN793afKpjerN4zwY3QITvS4S/ys8DAv3Fp8MOIEIs # r3fzKx8MIVoqtwU0HWqumfgnoma/Capg33akOpMP+LLR2HwZYuhegiUexLoceywh # 4tZbLBQ1QwRostt1AuByx5jWPGTlH0gQGF+JOGFNYkYkh2OMkVIsrymJ5Xgf1gsU # pYDXEkdws3XVk4WTfraSZ/tTYYmo9WuWwPRYaQ18yAGxuSh1t5ljhSKMYcp5lH5Z # /IwP42+1ASa2bKXuh1Eh5Fhgm7oMLSttosR+u8QlK0cCCHxJrhO24XxCQijGGFbP # QTS2Zl22dHv1VjMiLyI2skuiSpXY9aaOUjGCAk0wggJJAgEBMIGGMHIxCzAJBgNV # BAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdp # Y2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBUaW1l # c3RhbXBpbmcgQ0ECEA1CSuC+Ooj/YEAhzhQA8N0wDQYJYIZIAWUDBAIBBQCggZgw # GgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMBwGCSqGSIb3DQEJBTEPFw0yMTAz # MjUyMDE5MDBaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFOHXgqjhkb7va8oWkbWq # tJSmJJvzMC8GCSqGSIb3DQEJBDEiBCBhCjiYhfDhDiTogQuzBic7x4ZEYBbHCoWh # QMdfbtVPszANBgkqhkiG9w0BAQEFAASCAQBYgor1pietboppxw9YnSrYjY7l5fjq # PgepbHKpJpvI+WdfIX4nmq9BkF1J2/f69JRAuXoYcmmXfTBgvIsrKrSd8GOmzXZO # QA4hcGAVkZcw+WuvLSYCLT0LVyHPjogx7RC6tmXrJOXUZI45WIc8aYvb4eSo3eel # r2ozrGAh4ylfnlaf/HblbO6T4DY54Rgv0PWoarignNToFRb0cKuISsApyASBFbwn # t4WKAtKzeq6THaaH9XIzWTI0cq4oQj42OPRVVFFVNh0/qsSWPJcI1TIc/ylpjffZ # PquIM2QpQhHThWrnizEbpmEQNkE7ivGTnZOwrkBmYedj8GIfMZFacbUP # SIG # End signature block |