SqlChangeAutomation.Format.ps1xml
|
<?xml version="1.0" encoding="utf-8"?>
<Configuration> <ViewDefinitions> <View> <Name>Truncated Soc Release Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.ReleaseArtifacts.SocReleaseArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <PropertyName>Target</PropertyName> </ListItem> <ListItem> <PropertyName>Source</PropertyName> </ListItem> <ListItem> <label>UpdateSql</label> <ScriptBlock> if ($_.UpdateSql.Length -gt 83) { $_.UpdateSql.Substring(0, 80) + "..." } else { $_.UpdateSql } </ScriptBlock> </ListItem> <ListItem> <label>ReportHtml</label> <ScriptBlock> if ($_.ReportHtml.Length -gt 83) { $_.ReportHtml.Substring(0, 80) + "..." } else { $_.ReportHtml } </ScriptBlock> </ListItem> <ListItem> <PropertyName>Warnings</PropertyName> </ListItem> <ListItem> <PropertyName>Filter</PropertyName> </ListItem> <ListItem> <PropertyName>Options</PropertyName> </ListItem> <ListItem> <PropertyName>IgnoreAdditional</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>ScriptsFolder View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.Projects.ScriptsFolder</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Scripts folder</label> <ScriptBlock> "'{0}'" -f $_.Description.Path </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Truncated DatabaseSyncResult View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.DatabaseSyncResult</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>UpdateSql</label> <ScriptBlock> if ($_.UpdateSql.Length -gt 83) { $_.UpdateSql.Substring(0, 80) + "..." } else { $_.UpdateSql } </ScriptBlock> </ListItem> <ListItem> <PropertyName>Warnings</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SchemaDocumentation View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Documentation.SchemaDocumentation</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Description</label> <ScriptBlock> "Schema documentation" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Soc Build Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.BuildArtifacts.SocBuildArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>ScriptsFolder</label> <ScriptBlock> $_.ScriptsFolder.Description </ScriptBlock> </ListItem> <ListItem> <PropertyName>Id</PropertyName> </ListItem> <ListItem> <PropertyName>Version</PropertyName> </ListItem> <ListItem> <PropertyName>Description</PropertyName> </ListItem> <ListItem> <label>Documentation</label> <ScriptBlock> if ($_.SchemaDocumentation -ne $null) { "This package contains schema documentation" } else { "None" } </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Formatted Test Results</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.SchemaTesting.TestResults</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>TotalTestsRun</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TotalErrors</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TotalFailures</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TestSuites</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>Formatted Test Case</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.SchemaTesting.TestCase</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> <Width>10</Width> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Result</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Message</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SQL Change Automation Project View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.Projects.ScaProject</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Project</label> <ScriptBlock> $_.SqlProjFileName </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PackageScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Package Script</Label> <ScriptBlock> if ($_.PackageScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.PackageScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.PackageScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.SnapshotPackageBytes -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Snapshot Package</Label> <ScriptBlock> "Snapshot" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SQL Change Automation Build Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.BuildArtifacts.ScaBuildArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Project</label> <ScriptBlock> $_.ScaProject.SqlProjFileName </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PackageScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Package Script</Label> <ScriptBlock> if ($_.PackageScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.PackageScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.PackageScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.SnapshotPackageBytes -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Snapshot Package</Label> <ScriptBlock> "Snapshot" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SQL Change Automation Release Artifact View</Name> <ViewSelectedBy> <TypeName>RedGate.Versioning.Automation.Compare.Domain.ReleaseArtifacts.ScaReleaseArtifact</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <label>Project</label> <ScriptBlock> $_.ScaProject.SqlProjFileName </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PatchScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Patch Script</Label> <ScriptBlock> if ($_.PatchScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.PatchScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.PatchScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.ProvisioningScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Provisioning Script</Label> <ScriptBlock> if ($_.ProvisioningScript.Length -gt 100) { $lineSeparator = [System.Environment]::NewLine (($_.ProvisioningScript -split '\r?\n' | Select-Object -First 5) -Join $lineSeparator) + "$lineSeparator..." } else { $_.ProvisioningScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DiffReport -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Diff Report</Label> <ScriptBlock> if ($_.DiffReport.Length -gt 83) { $_.DiffReport.Substring(0, 80) + "..." } else { $_.DiffReport } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DriftReport -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Drift Report</Label> <ScriptBlock> if ($_.DriftReport.Length -gt 83) { $_.DriftReport.Substring(0, 80) + "..." } else { $_.DriftReport } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DriftScript -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Drift Script</Label> <ScriptBlock> if ($_.DriftScript.Length -gt 83) { $_.DriftScript.Substring(0, 80) + "..." } else { $_.DriftScript } </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.DriftStatus -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Drift Status</Label> <ScriptBlock> $_.DriftStatus </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.SnapshotPackageBytes -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Snapshot Package</Label> <ScriptBlock> "Snapshot" </ScriptBlock> </ListItem> <ListItem> <ItemSelectionCondition> <ScriptBlock>$_.PreReleaseMigrationLogState -ne $null</ScriptBlock> </ItemSelectionCondition> <Label>Pre-State</Label> <ScriptBlock> "Migration Log State" </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> </ViewDefinitions> </Configuration> |