forked from dotnet/efcore
-
Notifications
You must be signed in to change notification settings - Fork 1
/
SqlQuerySqliteTest.cs
115 lines (93 loc) · 3.74 KB
/
SqlQuerySqliteTest.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
using Microsoft.Data.Sqlite;
namespace Microsoft.EntityFrameworkCore.Query;
#nullable disable
public class SqlQuerySqliteTest : SqlQueryTestBase<NorthwindQuerySqliteFixture<NoopModelCustomizer>>
{
public SqlQuerySqliteTest(NorthwindQuerySqliteFixture<NoopModelCustomizer> fixture, ITestOutputHelper testOutputHelper)
: base(fixture)
{
Fixture.TestSqlLoggerFactory.SetTestOutputHelper(testOutputHelper);
}
public override async Task SqlQueryRaw_queryable_composed(bool async)
{
await base.SqlQueryRaw_queryable_composed(async);
AssertSql(
"""
SELECT "m"."Address", "m"."City", "m"."CompanyName", "m"."ContactName", "m"."ContactTitle", "m"."Country", "m"."CustomerID", "m"."Fax", "m"."Phone", "m"."Region", "m"."PostalCode"
FROM (
SELECT * FROM "Customers"
) AS "m"
WHERE instr("m"."ContactName", 'z') > 0
""");
}
public override async Task<string> SqlQueryRaw_queryable_with_parameters_and_closure(bool async)
{
var queryString = await base.SqlQueryRaw_queryable_with_parameters_and_closure(async);
Assert.Equal(
@".param set p0 'London'
.param set @__contactTitle_1 'Sales Representative'
SELECT ""m"".""Address"", ""m"".""City"", ""m"".""CompanyName"", ""m"".""ContactName"", ""m"".""ContactTitle"", ""m"".""Country"", ""m"".""CustomerID"", ""m"".""Fax"", ""m"".""Phone"", ""m"".""Region"", ""m"".""PostalCode""
FROM (
SELECT * FROM ""Customers"" WHERE ""City"" = @p0
) AS ""m""
WHERE ""m"".""ContactTitle"" = @__contactTitle_1", queryString, ignoreLineEndingDifferences: true);
return queryString;
}
public override Task Bad_data_error_handling_invalid_cast_key(bool async)
// Not supported on SQLite
=> Task.CompletedTask;
public override Task Bad_data_error_handling_invalid_cast(bool async)
// Not supported on SQLite
=> Task.CompletedTask;
public override Task Bad_data_error_handling_invalid_cast_projection(bool async)
// Not supported on SQLite
=> Task.CompletedTask;
public override Task Bad_data_error_handling_invalid_cast_no_tracking(bool async)
// Not supported on SQLite
=> Task.CompletedTask;
public override async Task SqlQueryRaw_composed_with_common_table_expression(bool async)
{
await base.SqlQueryRaw_composed_with_common_table_expression(async);
AssertSql(
"""
SELECT "m"."Address", "m"."City", "m"."CompanyName", "m"."ContactName", "m"."ContactTitle", "m"."Country", "m"."CustomerID", "m"."Fax", "m"."Phone", "m"."Region", "m"."PostalCode"
FROM (
WITH "Customers2" AS (
SELECT * FROM "Customers"
)
SELECT * FROM "Customers2"
) AS "m"
WHERE instr("m"."ContactName", 'z') > 0
""");
}
public override async Task SqlQueryRaw_then_String_Length(bool async)
{
await base.SqlQueryRaw_then_String_Length(async);
AssertSql(
"""
SELECT "s"."Value"
FROM (
SELECT 'x' AS "Value" FROM "Customers"
) AS "s"
WHERE length("s"."Value") = 0
""");
}
public override async Task SqlQueryRaw_then_String_ToUpper_String_Length(bool async)
{
await base.SqlQueryRaw_then_String_ToUpper_String_Length(async);
AssertSql(
"""
SELECT "s"."Value"
FROM (
SELECT 'x' AS "Value" FROM "Customers"
) AS "s"
WHERE length(upper("s"."Value")) = 0
""");
}
protected override DbParameter CreateDbParameter(string name, object value)
=> new SqliteParameter { ParameterName = name, Value = value };
private void AssertSql(params string[] expected)
=> Fixture.TestSqlLoggerFactory.AssertBaseline(expected);
}