Public/Remove-Neo4jNodeProperty.ps1

function Remove-Neo4jNodeProperty {
    <#
    .SYNOPSIS
        Remove properties from Neo4j nodes

    .DESCRIPTION
        Remove properties from Neo4j nodes

        Use the 'remove' variable in Cypher parameters like Where and Match

    .EXAMPLE
        Remove-Neo4jNodeProperty -Label Server -Property BadProp, OldProp

        # Remove BadProp and OldProp properties from every node labeled Server

    .EXAMPLE
        Remove-Neo4jNodeProperty -Label Server -Hash @{ osfamily = 'windows' } -Property BadProp, OldProp

        # Remove BadProp and OldProp properties from nodes labeled Server that have osfamily property = windows

    .EXAMPLE
        Remove-Neo4jNodeProperty -Match "MATCH (remove:Server) WHERE remove.operatingsystem =~ '.*windows.*'" -Property BadProp, OldProp

        # Remove BadProp and OldProp properties from nodes labeled Server that have operatingsystem property regex matching .*windows.*

    .PARAMETER Property
        Properties to remove from any matching nodes

        Warning: susceptible to query injection

    .PARAMETER Match
        If specified, remove properties from nodes returned from this MATCH statement.
        You must use variable 'remove'

        Example: MATCH (remove:SomeLabel) WHERE some =~ 'comparison'

    .PARAMETER Label
        Remove properties from nodes with this label

        Warning: susceptible to query injection

    .PARAMETER Hash
        One or more hashtables containing properties and values corresponding to nodes we will delete properties on

        Warning: susceptible to query injection (keys only. values are parameterized)

    .PARAMETER Where
        Filter matching nodes with this. Use 'remove' as the matched item

        Example:
            WHERE remove.something = 'blah'

        Warning: susceptible to query injection

    .PARAMETER As
        Parse the Neo4j response as...
            Parsed: We attempt to parse the output into friendlier PowerShell objects
                     Please open an issue if you see unexpected output with this
            Raw: We don't touch the response ($Response)
            Results: We expand the 'results' property on the response ($Response.results)
            Row: We expand the 'row' property on the responses results ($Response.results.data.row)

        We default to the value specified by Set-PSNeo4jConfiguration (Initially, 'Parsed')

        See ConvertFrom-Neo4jResponse for implementation details

    .PARAMETER MetaProperties
        Merge zero or any combination of these corresponding meta properties in the results: 'id', 'type', 'deleted'

        We default to the value specified by Set-PSNeo4jConfiguration (Initially, 'type')

    .PARAMETER MergePrefix
        If any MetaProperties are specified, we add this prefix to avoid clobbering existing neo4j properties

        We default to the value specified by Set-PSNeo4jConfiguration (Initially, 'Neo4j')

    .PARAMETER BaseUri
        BaseUri to build REST endpoint Uris from

        We default to the value specified by Set-PSNeo4jConfiguration (Initially, 'http://127.0.0.1:7474')

    .PARAMETER Credential
        PSCredential to use for auth

        We default to the value specified by Set-PSNeo4jConfiguration (Initially, not specified)

    .FUNCTIONALITY
        Neo4j
    #>

    [cmdletbinding(DefaultParameterSetName = 'LabelHash')]
    param(
        [parameter( ParameterSetName = 'Match',
                    Position = 1,
                    Mandatory = $True)]
        [string]$Match,

        [parameter(ParameterSetName = 'LabelHash',
                   Position = 1,
                   Mandatory = $True)]
        [string]$Label,

        [parameter( ParameterSetName = 'LabelHash',
                    ValueFromPipeline=$True)]
        [hashtable[]]$Hash,

        [parameter( Mandatory = $True )]
        [string[]]$Property,

        [string]$Where,

        [validateset('Raw', 'Results', 'Row', 'Parsed', 'ParsedColumns')]
        [string]$As = $PSNeo4jConfig.As,
        [validateset('id', 'type', 'deleted')]
        [string]$MetaProperties = $PSNeo4jConfig.MetaProperties,
        [string]$MergePrefix = $PSNeo4jConfig.MergePrefix,

        [string]$BaseUri = $PSNeo4jConfig.BaseUri,

        [System.Management.Automation.PSCredential]
        [System.Management.Automation.Credential()]
        $Credential =  $PSNeo4jConfig.Credential
    )
    begin {
        $Queries = [System.Collections.ArrayList]@()
        $Count = 0
        $Var = 'remove'
        $InvokeParams = @{}
        $SQLParams = @{}
        function Get-RemoveString {
            param([string[]]$Property, $Var) 
            [string[]]$ToDeleteArray = foreach($Prop in $Property) {
                "$Var.$Prop"
            }
            $ToDeleteString = $ToDeleteArray -join ', '
            if($ToDeleteString) {
                "REMOVE $ToDeleteString"
            }
        }
    }
    process {
        if($PSCmdlet.ParameterSetName -like 'LabelHash')
        {
            foreach($PropHash in $Hash)
            {
                $PropString = $null
                if($Hash.keys.count -gt 0) {
                    $Props = foreach($Prop in $PropHash.keys) {
                        "$Prop`: `$$Var$Count$Prop"
                        $SQLParams.Add("$Var$Count$Prop", $PropHash[$Prop])
                    }
                    $PropString = $Props -join ', '
                    $PropString = "{$PropString}"
                }
                $Query = "MATCH ($Var`:$Label $PropString)"
                if($Where){
                    $Query = "$Query`n$Where`n"
                }
                $Count++
                $Remove = Get-RemoveString -Var $Var -Property $Property
                [void]$Queries.Add("$Query $Remove")
            }
            if($Label -and -not $Hash) {
                $Queries.Add("MATCH ($Var`:$Label) $(Get-RemoveString -Var $Var -Property $Property)")
            }
        }
        else {
            $Query = $Match
            if($Where){
                $Query = "$Query`n$Where`n"
            }
            $Queries.Add("$Query $(Get-RemoveString -Var $Var -Property $Property)")
        }
    }
    end {
        if($Queries.count -eq 0) {
            return
        }
        if($SQLParams.Keys.count -gt 0) {
            $InvokeParams.add('Parameters', $SQLParams)
        }
        $InvokeParams.add('Query', $Queries)
        $Params = . Get-ParameterValues -BoundParameters $PSBoundParameters -Invocation $MyInvocation -Properties MetaProperties, MergePrefix, Credential, BaseUri, As
        Write-Verbose "$($Params | Format-List | Out-String)"
        Invoke-Neo4jQuery @Params @InvokeParams
    }
}