121 lines
4.2 KiB
Plaintext
121 lines
4.2 KiB
Plaintext
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Tests\bin\Debug\net8.0\Strata.SqlTools.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Markdown.Tests\bin\Debug\net8.0\Strata.SqlTools.Markdown.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Rules.Tests\bin\Debug\net8.0\Strata.SqlTools.Rules.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.PostgreSql.Tests\bin\Debug\net8.0\Strata.SqlTools.PostgreSql.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.EFCore.Tests\bin\Debug\net8.0\Strata.SqlTools.EFCore.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Snowflake.Tests\bin\Debug\net8.0\Strata.SqlTools.Snowflake.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.SqlServer.Tests\bin\Debug\net8.0\Strata.SqlTools.SqlServer.Tests.dll (.NETCoreApp,Version=v8.0)
|
|
VSTest version 17.14.1 (x64)
|
|
|
|
VSTest version 17.14.1 (x64)
|
|
|
|
VSTest version 17.14.1 (x64)
|
|
VSTest version 17.14.1 (x64)
|
|
|
|
VSTest version 17.14.1 (x64)
|
|
VSTest version 17.14.1 (x64)
|
|
|
|
|
|
|
|
VSTest version 17.14.1 (x64)
|
|
|
|
Starting test execution, please wait...
|
|
Starting test execution, please wait...
|
|
A total of 1 test files matched the specified pattern.
|
|
Starting test execution, please wait...
|
|
Starting test execution, please wait...
|
|
Starting test execution, please wait...
|
|
Starting test execution, please wait...
|
|
Starting test execution, please wait...
|
|
A total of 1 test files matched the specified pattern.
|
|
A total of 1 test files matched the specified pattern.
|
|
A total of 1 test files matched the specified pattern.
|
|
A total of 1 test files matched the specified pattern.
|
|
A total of 1 test files matched the specified pattern.
|
|
A total of 1 test files matched the specified pattern.
|
|
|
|
Passed! - Failed: 0, Passed: 90, Skipped: 0, Total: 90, Duration: 95 ms - Strata.SqlTools.Tests.dll (net8.0)
|
|
Regenerated Snowflake SQL:
|
|
SELECT
|
|
-- Primary key -- Customer name field /* Email address for notifications */
|
|
ID,
|
|
|
|
NAME,
|
|
|
|
|
|
|
|
EMAIL,
|
|
|
|
STATUS
|
|
FROM
|
|
-- Main user table
|
|
USERS
|
|
WHERE
|
|
/* Filter for active users only */
|
|
STATUS = 'Active'
|
|
ORDER BY
|
|
-- Sort alphabetically
|
|
NAME
|
|
|
|
|
|
Regenerated SQL:
|
|
|
|
|
|
SELECT
|
|
-- Primary key -- Customer name field /* Email address for notifications */
|
|
ID,
|
|
|
|
Name,
|
|
|
|
|
|
|
|
Email,
|
|
|
|
Status
|
|
FROM
|
|
-- Main user table
|
|
Users
|
|
WHERE
|
|
/* Filter for active users only */
|
|
Status = 'Active'
|
|
ORDER BY
|
|
-- Sort alphabetically
|
|
Name
|
|
|
|
|
|
|
|
|
|
Skipped AllQueriesDirectory_Exists [4 ms]
|
|
Skipped GenerateMarkdownForAllQueries_CreatesMarkdownFiles [4 ms]
|
|
Skipped GenerateMarkdownForAllQueries_IncludesQuerySource [4 ms]
|
|
Skipped OutputDirectory_IsCreated [4 ms]
|
|
|
|
|
|
Passed! - Failed: 0, Passed: 90, Skipped: 4, Total: 94, Duration: 154 ms - Strata.SqlTools.Markdown.Tests.dll (net8.0)
|
|
Passed! - Failed: 0, Passed: 78, Skipped: 0, Total: 78, Duration: 110 ms - Strata.SqlTools.PostgreSql.Tests.dll (net8.0)
|
|
((1 + 2) <= 50)
|
|
|
|
input => input.DepartmentCode.StartsWith("01", OrdinalIgnoreCase)
|
|
|
|
input => input.DepartmentCode.StartsWith("012C", OrdinalIgnoreCase)
|
|
|
|
input => input.DepartmentCode.StartsWith("012c", OrdinalIgnoreCase)
|
|
|
|
input => input.DepartmentCode.StartsWith("oasd", OrdinalIgnoreCase)
|
|
|
|
101 == 103 || 120 > 119 || input.TotalCharges > 200.0 && input.DepartmentName == "foobar"
|
|
|
|
items => items.Any(s => (s.Length >= 4))
|
|
input.DepartmentId == 3 && input.PatientId == 5 && input.Details.Any(p => p.CPTCode == "123")
|
|
|
|
input.Details.Any(p => p.CPTCode == "123" && p.UBRevCode == "0999")
|
|
|
|
|
|
|
|
Passed! - Failed: 0, Passed: 161, Skipped: 0, Total: 161, Duration: 176 msPassed! - Failed: 0, Passed: 217, Skipped: 0, Total: 217, Duration: 152 ms - Strata.SqlTools.Snowflake.Tests.dll (net8.0)
|
|
- Strata.SqlTools.SqlServer.Tests.dll (net8.0)
|
|
|
|
Passed! - Failed: 0, Passed: 69, Skipped: 0, Total: 69, Duration: 287 ms - Strata.SqlTools.Rules.Tests.dll (net8.0)
|
|
|
|
Passed! - Failed: 0, Passed: 15, Skipped: 0, Total: 15, Duration: 675 ms - Strata.SqlTools.EFCore.Tests.dll (net8.0)
|