SqlChangeAutomation

3.0.3.2525

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>$_.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>$_.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>