functions/Convert-AdsDotNetToNotDotNet.ps1
|
<#
.SYNOPSIS Converts a dotnet interactive PowerShell notebook to a Not DotNet PowerShell notebook for Azure Data Studio .DESCRIPTION Converts a dotnet interactive PowerShell notebook to a Not DotNet PowerShell notebook for Azure Data Studio .PARAMETER SourceNotebook The path to the Source Notebook .PARAMETER DestinationDirectory The directory to create the Not DotNet Notebook (will be created if it doesnt exist) .PARAMETER DestinationNotebook Optional - The name of the Destination Notebook - will retain the orignal name by default .EXAMPLE Convert-AdsDotNetToNotDotNet -SourceNotebook Number1.ipynb -DestinationDirectory Git:\dbatoolsnotebooks Will convert the dotnet interactive notebook Number1.iynb to not dotnet notebook and save in the Git:\dbatoolsnotebooks directory .EXAMPLE Convert-AdsDotNetToNotDotNet -SourceNotebook Number1.ipynb -DestinationDirectory Git:\dbatoolsnotebooks -DestinationNotebook NotNumber1 Will convert the dotnet interactive notebook Number1.iynb to not dotnet notebook and save in the Git:\dbatoolsnotebooks directory and rename it to NotNumber1 .NOTES Some Month in 2020 - Rob Sewell @SQLDbaWithBeard blog.robsewell.com #> Function Convert-AdsDotNetToNotDotNet { [cmdletbinding(SupportsShouldProcess)] Param( [Parameter(Mandatory)] [string]$SourceNotebook, [Parameter(Mandatory)] [string]$DestinationDirectory, [Parameter()] [string]$DestinationNotebook ) if (Test-Path $SourceNotebook) { $SourceNotebookObject = Get-Item $SourceNotebook if($SourceNotebookObject.Extension -eq '.ipynb'){ $Source = Get-Content $SourceNotebook | ConvertFrom-Json } else { Write-Warning "$SourceNotebook doesnt appear to be a notebook" Return } } else { Write-Warning "There doesn't appear to be anything here $SourceNotebook" Return } if($source.metadata.kernelspec.name -eq '.net-powershell'){ }else{ Write-Warning "This notebook $SourceNotebook does not appear to be a dotnet PowerShell notebook " Return } if (Test-Path $DestinationDirectory) { Write-Verbose "Destination Directory $DestinationDirectory exists " } else { if ($PSCmdlet.ShouldProcess("$DestinationDirectory", "Creating ")) { $null = New-Item $DestinationDirectory -ItemType Directory } } $Source.metadata.kernelspec.name = 'powershell' $Source.metadata.kernelspec.display_name = 'PowerShell' $Source.metadata.language_info.name = 'powershell' $Source.metadata.language_info.mimetype = 'text/x-sh' $Source.metadata.language_info | Add-Member -Name "codemirror_mode" -Value 'shell' -MemberType NoteProperty $Source.metadata.language_info.PSObject.Properties.Remove('version') $Source.metadata.language_info.PSObject.Properties.Remove('pygments_lexer') if($DestinationNotebook){ if($DestinationNotebook.EndsWith('.ipynb')){ }else{ $DestinationNotebook = $DestinationNotebook + '.ipynb' } $Destination = $DestinationDirectory + '\' + $DestinationNotebook } else{ $Destination = $DestinationDirectory + '\' + $SourceNotebookObject.Name } if ($PSCmdlet.ShouldProcess("$Destination", "Creating NotDotNet Notebook")) { $Source | ConvertTo-Json -Depth 5 |Set-Content $Destination } } |