Create scriptblocks with expanded variables

Question

I know that this question has been asked before here and here. But for one reason or another it doesn't really work for us.

Desired result

2 scriptblocks that are usable with the Pester parameter ParameterFilter whre only the variable $testTable is expanded:

{
    ($Query -like "*SELECT * FROM tableOne* 
        WHERE TicketNr IS NOT NULL AND TicketCloseDate IS NULL*")
}
{
    ($Query -like "*SELECT * FROM tableWto* 
        WHERE TicketNr IS NOT NULL AND TicketCloseDate IS NULL*")
}

The code below does not work because we need to escape everything within the $testQuery. Isn't there a way to only expand the $testTable and not the other pieces?

foreach ($testTable in @('tableOne', 'tableTwo')) {
    $testQuery = "*SELECT * FROM $testTable* 
    WHERE TicketNr IS NOT NULL AND TicketCloseDate IS NULL*"
    
    [ScriptBlock]::create("`$Query `-like $testQuery")
}

DarkLite1 · Accepted Answer · 2020-10-09 13:06:22Z

0

I think I figured it out:

foreach ($testTable in @('tableOne', 'tableTwo')) {   
    [ScriptBlock]::create(@"
    (`$Query -like  "*SELECT * FROM $testTable*
    WHERE TicketNr IS NOT NULL AND TicketCloseDate IS NULL*" )
"@)
}

answered Oct 9, 2020 at 13:06

DarkLite1

14.9k46 gold badges138 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create scriptblocks with expanded variables

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related