AzureDevOpsHelpers

1.0.24

Public/TestHelpers/Test.DatabaseObjects.Functions.Tests.ps1

                                #Requires -Version 5.0

#Requires -Modules  @{ ModuleName="Pester"; ModuleVersion="3.4.0" }

$ErrorActionPreference = "Stop";

Set-StrictMode -Version 'Latest'

$sut = (Split-Path -Leaf $MyInvocation.MyCommand.Path) -replace '\.Tests\.ps1', '.psm1'

Import-Module "$PSScriptRoot\$sut" -Force

# NOTE: This test depends on the presence of a database so probably won't run in CI

Describe 'ValidateViews returns expected when testing valid views' -Tag 'Integration' {

    # Arrange

    $expected = 1

    # Act

    [int] $actual = ValidateViews `

        -dbInstance 'localhost' `

        -dbName 'TrainingNotifier_UAT_9001' `

        -schema 'AppCore' 

    # Assert

    It 'returns expected' {

        $actual | Should Be $expected

    }

}