Apps/Create-NAVXFromDB.ps1
|
function Create-NAVXFromDB { [CmdLetBinding()] param( [string] $AppName, [String] $AppPublisher, [String] $AppDescription, [string] $BuildFolder, [string] $OriginalServerInstance, [string] $ModifiedServerInstance, [String] $InitialVersion = '1.0.0.0', [String] $PermissionSetId='', [String] $WebServicePrefix='', [String] $BackupPath, [String] $Dependencies = $null, [String[]] $IncludeFilesInNavApp, [Int[]] $ExportTableDataFromTableIds) # Set Variables $BuildFolder = (join-path $BuildFolder 'Create-NAVXFromDB') $navAppManifestFile = (join-path $BuildFolder "$($AppName).xml") New-Item -ItemType Directory -Force -Path $BuildFolder | Out-Null $packageFolder = Join-Path -Path $BuildFolder -ChildPath 'Packages' $packageFolder = New-Item -ItemType Directory -Force -Path $packageFolder #Restore Manifest from Backup folder if ($BackupPath){ $BackupNAVAppManifestFile = Join-Path $BackupPath "$($AppName).xml" if (Test-Path $BackupNAVAppManifestFile){ $null = Copy-Item -Path $BackupNAVAppManifestFile -Destination $navAppManifestFile -Recurse -Force } } # Update or Create Manifest Write-Host -Foregroundcolor Green 'Setup App-Manifest... ' if (Test-Path -Path $navAppManifestFile){ $MyNewManifest = Get-NAVAppManifest -Path $navAppManifestFile } if ($MyNewManifest -eq $null) { Write-Host -Foregroundcolor Green 'Create APP Package' $MyNewManifest = Create-NAVAppPackage ` -AppName $AppName ` -BuildFolder $BuildFolder ` -Version $InitialVersion ` -Publisher $AppPublisher ` -Description $AppDescription } else { Write-Host -Foregroundcolor Green 'Update APP Package' $newAppVersion = $MyNewManifest.AppVersion.Major.ToString() + '.' + $MyNewManifest.AppVersion.Minor.ToString() + '.' + $MyNewManifest.AppVersion.Build.ToString() + '.' + ($MyNewManifest.AppVersion.Revision + 1).ToString() if ([String]::IsNullOrEmpty($Dependencies)){ $MyNewManifest = Set-NAVAppManifest ` -Manifest $MyNewManifest ` -Version $newAppVersion ` -PrivacyStatement 'http://www.waldo.Be' ` -Eula 'http://www.waldo.Be' ` -Help 'http://www.waldo.Be' ` -Url 'http://www.waldo.Be' if ($Dependencies){ $MyNewManifest = Set-NAVAppManifest ` -Manifest $MyNewManifest ` -Dependencies $Dependencies } } else { $MyNewManifest = Set-NAVAppManifest ` -Manifest $MyNewManifest ` -Version $newAppVersion ` -PrivacyStatement 'http://www.waldo.Be' ` -Eula 'http://www.waldo.Be' ` -Help 'http://www.waldo.Be' ` -Url 'http://www.waldo.Be' if ($Dependencies){ $MyNewManifest = Set-NAVAppManifest ` -Manifest $MyNewManifest ` -Dependencies $Dependencies } } } New-NAVAppManifestFile -Path $navAppManifestFile -Manifest $MyNewManifest -Force # Extract Applications and Create Deltas Write-Host -Foregroundcolor Green "Starting to create deltas between $OriginalServerInstance and $ModifiedServerInstance ..." $navAppFileDirectory = Create-NAVAppFiles ` -OriginalServerInstance $OriginalServerInstance ` -ModifiedServerInstance $ModifiedServerInstance ` -BuildPath $BuildFolder ` -PermissionSetId $PermissionSetId ` -IncludeFilesInNavApp $IncludeFilesInNavApp ` -WebServicePrefix $WebServicePrefix if ($ExportTableDataFromTableIds){ Write-Host -Foregroundcolor Green "Exporting TableData for:" foreach($ExportTableDataFromTableId in $ExportTableDataFromTableIds){ Write-Host -Foregroundcolor Gray "Table $ExportTableDataFromTableId" Export-NAVAppTableData ` -ServerInstance $ModifiedServerInstance ` -TableId $ExportTableDataFromTableId ` -Path $navAppFileDirectory } } # Create NavX Package $navAppPackageFile = $AppName + '_v' + $MyNewManifest.AppVersion.ToString() + '.navx' $navAppPackageFile = Join-Path -Path $packageFolder -ChildPath $navAppPackageFile if (Test-Path -Path $navAppPackageFile) { Remove-item $navAppPackageFile } Write-Host -Foregroundcolor Green "DeltaDir: $navAppFileDirectory" $AppPackage = New-NAVAppPackage -Manifest $MyNewManifest -SourcePath $navAppFileDirectory -Path $navAppPackageFile -PassThru Write-Host -Foregroundcolor Green "NavX Package File: $navAppPackageFile" if ($BackupPath){ $null = Copy-Item -Path $PackageFolder -Destination $BackupPath -Recurse -Force $null = Copy-Item -Path $navAppManifestFile -Destination $BackupPath -Force } [hashtable]$Return = @{} $Return.Manifest = $MyNewManifest $Return.PackageFile = $navAppPackageFile return $Return } |