Functions/GenXdev.Data.KeyValueStore/Get-KeyValueStoreNames.ps1
|
################################################################################ <# .SYNOPSIS Retrieves a list of all available key-value store names from the database. .DESCRIPTION Queries the SQLite database to get unique store names based on the provided synchronization key. The function handles database initialization if needed and performs synchronization for non-local scopes. .PARAMETER SynchronizationKey Filters stores by synchronization scope. Use '%' for all stores, 'Local' for local stores only. Synchronization occurs for non-local scopes. .EXAMPLE Get-KeyValueStoreNames -SynchronizationKey "Local" .EXAMPLE getstorenames "%" #> function Get-KeyValueStoreNames { [CmdletBinding()] [System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseSingularNouns", "")] [Alias("getstorenames")] param( ######################################################################## [Parameter( Mandatory = $false, Position = 0, HelpMessage = "Key to identify synchronization scope, defaults to all" )] [string]$SynchronizationKey = "%" ######################################################################## ) begin { # get the full path to the sqlite database file $databaseFilePath = GenXdev.FileSystem\Expand-Path ` "$PSScriptRoot\..\..\..\..\GenXdev.Local\KeyValueStores.sqllite.db" ` -CreateDirectory Write-Verbose "Using database: $databaseFilePath" } process { # create database if it doesn't exist if (-not (Test-Path $databaseFilePath)) { Write-Verbose "Database not found, initializing..." Initialize-KeyValueStores } # sync non-local stores if ($SynchronizationKey -ne "Local") { Write-Verbose "Synchronizing non-local store: $SynchronizationKey" Sync-KeyValueStore -SynchronizationKey $SynchronizationKey } # query to get unique store names $sqlQuery = @" SELECT DISTINCT storeName FROM KeyValueStore WHERE synchronizationKey LIKE @syncKey AND deletedDate IS NULL; "@ # parameters for the query $params = @{ 'syncKey' = $SynchronizationKey } Write-Verbose "Querying stores with sync key: $SynchronizationKey" # execute query and return results Invoke-SQLiteQuery -DatabaseFilePath $databaseFilePath ` -Queries $sqlQuery ` -SqlParameters $params | ForEach-Object storeName } end { } } ################################################################################ |