PowerShellUniversal.Apps.Cookbook

1.1.1

public/Switch-RecipeFavorite.ps1

function Switch-RecipeFavorite {
    [CmdletBinding()]
    param(
        [Parameter(Mandatory)]
        [int]$RecipeId
    )

    Invoke-RecipeDbQuery -Query @"
UPDATE Recipes
SET IsFavorite = CASE WHEN IsFavorite = 1 THEN 0 ELSE 1 END,
    FavoritedAt = CASE WHEN IsFavorite = 1 THEN NULL ELSE datetime('now') END,
    UpdatedAt = datetime('now')
WHERE RecipeId = $RecipeId;
"@ | Out-Null
}