Functions/GenXdev.Data.SQLite/EnsureSQLiteStudioInstalled.ps1
|
<##############################################################################
Part of PowerShell module : GenXdev.Data.SQLite Original cmdlet filename : EnsureSQLiteStudioInstalled.ps1 Original author : René Vaessen / GenXdev Version : 1.300.2025 ################################################################################ Copyright (c) René Vaessen / GenXdev Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ################################################################################> ############################################################################### <# .SYNOPSIS Ensures SQLiteStudio is installed and accessible from the command line. .DESCRIPTION Verifies if SQLiteStudio is installed and available in the system PATH. If not found, it first checks if the PATH environment variable needs updating. If that doesn't resolve the issue, it installs SQLiteStudio using WinGet and configures the PATH environment variable. .EXAMPLE EnsureSQLiteStudioInstalled Checks and ensures SQLiteStudio is installed and accessible. #> function EnsureSQLiteStudioInstalled { [CmdletBinding()] param() begin { ######################################################################## <# .SYNOPSIS Checks if the WinGet PowerShell client module is installed. #> function IsWinGetInstalled { Microsoft.PowerShell.Core\Import-Module 'Microsoft.WinGet.Client' -ErrorAction SilentlyContinue $ModuleObj = Microsoft.PowerShell.Core\Get-Module 'Microsoft.WinGet.Client' -ErrorAction SilentlyContinue return $null -ne $ModuleObj } ######################################################################## <# .SYNOPSIS Installs the WinGet PowerShell client module. #> function InstallWinGet { # Request consent before installing WinGet PowerShell client $consent = GenXdev.FileSystem\Confirm-InstallationConsent ` -ApplicationName 'Microsoft.WinGet.Client' ` -Source 'PowerShell Gallery' ` -Description 'PowerShell module required for package management operations' ` -Publisher 'Microsoft' if (-not $consent) { Microsoft.PowerShell.Utility\Write-Error 'Installation consent denied for Microsoft.WinGet.Client module.' return } Microsoft.PowerShell.Utility\Write-Verbose 'Installing WinGet PowerShell client...' PowerShellGet\Install-Module 'Microsoft.WinGet.Client' -Force -AllowClobber Microsoft.PowerShell.Core\Import-Module 'Microsoft.WinGet.Client' } } process { # check if sqlitestudio executable is available in the system path if (@(Microsoft.PowerShell.Core\Get-Command 'SQLiteStudio.exe' -ErrorAction SilentlyContinue).Length -eq 0) { # determine the default installation directory for sqlitestudio $sqliteStudioPath = (GenXdev.FileSystem\Expand-Path "${env:ProgramFiles}\SQLiteStudio") # get current user path environment variable $currentPath = [Environment]::GetEnvironmentVariable('PATH', 'User') # add sqlitestudio to path if not already present if ($currentPath -notlike "*$sqliteStudioPath*") { Microsoft.PowerShell.Utility\Write-Verbose 'Adding SQLiteStudio directory to user PATH...' [Environment]::SetEnvironmentVariable( 'PATH', "$currentPath;$sqliteStudioPath", 'User') } # ensure current session has updated path only if not already present if ($env:PATH -notlike "*$sqliteStudioPath*") { $env:PATH = "$env:PATH;$sqliteStudioPath" } # verify if path update resolved the missing executable if (@(Microsoft.PowerShell.Core\Get-Command 'SQLiteStudio.exe' -ErrorAction SilentlyContinue).Length -gt 0) { return } Microsoft.PowerShell.Utility\Write-Host 'SQLiteStudio not found. Installing SQLiteStudio...' # Request consent before installing SQLiteStudio $consent = GenXdev.FileSystem\Confirm-InstallationConsent ` -ApplicationName 'SQLiteStudio' ` -Source 'Winget' ` -Description 'Database management tool required for SQLite operations' ` -Publisher 'Pawel Salawa' if (-not $consent) { Microsoft.PowerShell.Utility\Write-Error 'Installation consent denied for SQLiteStudio. SQLite operations may not be available.' return } # ensure winget package manager is available if (-not (IsWinGetInstalled)) { InstallWinGet } # attempt installation using winget Microsoft.PowerShell.Utility\Write-Verbose 'Installing SQLiteStudio using WinGet...' Microsoft.WinGet.Client\Install-WinGetPackage -Id 'PawelSalawa.SQLiteStudio' -Force # verify successful installation if (-not (Microsoft.PowerShell.Core\Get-Command 'SQLiteStudioU.exe' -ErrorAction SilentlyContinue)) { Microsoft.PowerShell.Utility\Write-Error 'SQLiteStudio installation failed.' return } } } end {} } |