ImportExcel

6.5.3

__tests__/ConvertFromExcelToSQLInsert.tests.ps1

if (-not (get-command Import-Excel -ErrorAction SilentlyContinue)) {
    Import-Module $PSScriptRoot\..\ImportExcel.psd1
}
$xlFile = "TestDrive:\testSQL.xlsx"

Describe "ConvertFrom-ExcelToSQLInsert" {

    BeforeEach {

        $([PSCustomObject]@{
            Name="John"
            Age=$null
        }) | Export-Excel $xlFile
    }

    AfterAll {
        Remove-Item $xlFile -Recurse -Force -ErrorAction Ignore
    }

    It "Should be empty double single quotes".PadRight(90)  {
        $expected="INSERT INTO Sheet1 ('Name', 'Age') Values('John', '');"

        $actual = ConvertFrom-ExcelToSQLInsert -Path $xlFile Sheet1

        $actual | should be $expected
    }

     It "Should have NULL".PadRight(90)  {
        $expected="INSERT INTO Sheet1 ('Name', 'Age') Values('John', NULL);"

        $actual = ConvertFrom-ExcelToSQLInsert -Path $xlFile Sheet1 -ConvertEmptyStringsToNull

        $actual | should be $expected
    }
}