-
Notifications
You must be signed in to change notification settings - Fork 3.1k
/
SqliteDatabaseCreatorTest.cs
242 lines (206 loc) · 7.76 KB
/
SqliteDatabaseCreatorTest.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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
// Licensed to the .NET Foundation under one or more agreements.
// The .NET Foundation licenses this file to you under the MIT license.
// ReSharper disable InconsistentNaming
using Microsoft.Data.Sqlite;
namespace Microsoft.EntityFrameworkCore;
#nullable disable
public class SqliteDatabaseCreatorTest
{
[ConditionalTheory]
[InlineData(false, false)]
[InlineData(true, false)]
[InlineData(false, true)]
[InlineData(true, true)]
public async Task Exists_returns_false_when_database_doesnt_exist(bool async, bool useCanConnect)
{
var context = CreateContext("Data Source=doesnt-exist.db");
if (useCanConnect)
{
Assert.False(async ? await context.Database.CanConnectAsync() : context.Database.CanConnect());
}
else
{
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.False(async ? await creator.ExistsAsync() : creator.Exists());
}
}
[ConditionalTheory]
[InlineData(false)]
[InlineData(true)]
public async Task HasTables_returns_false_when_database_is_empty(bool async)
{
using var testStore = await SqliteTestStore.GetOrCreateInitializedAsync("Empty");
var context = CreateContext(testStore.ConnectionString);
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.False(async ? await creator.HasTablesAsync() : creator.HasTables());
}
[ConditionalTheory]
[InlineData(false)]
[InlineData(true)]
public async Task HasTables_returns_true_when_database_is_not_empty(bool async)
{
using var testStore = await SqliteTestStore.GetOrCreateInitializedAsync($"HasATable{(async ? 'A' : 'S')}");
var context = CreateContext(testStore.ConnectionString);
context.Database.ExecuteSqlRaw("CREATE TABLE Dummy (Foo INTEGER)");
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.True(async ? await creator.HasTablesAsync() : creator.HasTables());
}
[ConditionalTheory]
[InlineData(false, false)]
[InlineData(true, false)]
[InlineData(false, true)]
[InlineData(true, true)]
public async Task Exists_returns_true_when_database_exists(bool async, bool useCanConnect)
{
using var testStore = await SqliteTestStore.GetOrCreateInitializedAsync("Empty");
var context = CreateContext(testStore.ConnectionString);
if (useCanConnect)
{
Assert.True(async ? await context.Database.CanConnectAsync() : context.Database.CanConnect());
}
else
{
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.True(async ? await creator.ExistsAsync() : creator.Exists());
}
}
[ConditionalTheory]
[InlineData(false)]
[InlineData(true)]
public async Task Create_sets_journal_mode_to_wal(bool async)
{
using var testStore = SqliteTestStore.GetOrCreate("Create");
using var context = CreateContext(testStore.ConnectionString);
var creator = context.GetService<IRelationalDatabaseCreator>();
if (async)
{
await creator.CreateAsync();
}
else
{
creator.Create();
}
testStore.OpenConnection();
var journalMode = testStore.ExecuteScalar<string>("PRAGMA journal_mode;");
Assert.Equal("wal", journalMode);
}
[ConditionalTheory]
[InlineData(false)]
[InlineData(true)]
public async Task Delete_works_even_when_different_connection_exists_to_same_file(bool async)
{
using (var context = new BathtubContext("DataSource=bathtub.db"))
{
if (async)
{
await context.Database.EnsureDeletedAsync();
await context.Database.EnsureCreatedAsync();
}
else
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
}
using (var context = new BathtubContext("Command Timeout=60;DataSource=bathtub.db"))
{
var creator = context.GetService<IRelationalDatabaseCreator>();
if (async)
{
await context.Database.EnsureDeletedAsync();
Assert.False(await creator.ExistsAsync());
}
else
{
context.Database.EnsureDeleted();
Assert.False(creator.Exists());
}
}
}
private class BathtubContext(string connectionString) : DbContext
{
private readonly string _connectionString = connectionString;
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder.UseSqlite(_connectionString);
}
[ConditionalTheory]
[InlineData(false)]
[InlineData(true)]
public async Task Delete_works_for_in_memory_database(bool async)
{
using var connection = new SqliteConnection("Data Source=:memory:");
connection.Open();
using (var context = new ShowerContext(connection))
{
_ = async
? await context.Database.EnsureCreatedAsync()
: context.Database.EnsureCreated();
context.Add(new Soap());
context.SaveChanges();
}
using (var context = new ShowerContext(connection))
{
Assert.NotNull(context.Soap.FirstOrDefault());
_ = async
? await context.Database.EnsureDeletedAsync()
: context.Database.EnsureDeleted();
}
using (var context = new ShowerContext(connection))
{
_ = async
? await context.Database.EnsureCreatedAsync()
: context.Database.EnsureCreated();
Assert.Null(context.Soap.FirstOrDefault());
context.Add(new Soap());
context.SaveChanges();
}
using (var context = new ShowerContext(connection))
{
Assert.NotNull(context.Soap.FirstOrDefault());
}
// using (var context = new BathtubContext("Command Timeout=60;DataSource=bathtub.db"))
// {
// var creator = context.GetService<IRelationalDatabaseCreator>();
//
// if (async)
// {
// await context.Database.EnsureDeletedAsync();
// Assert.False(await creator.ExistsAsync());
// }
// else
// {
// context.Database.EnsureDeleted();
// Assert.False(creator.Exists());
// }
// }
}
private class Soap
{
public int Id { get; set; }
}
private class ShowerContext(DbConnection connection) : DbContext
{
private readonly DbConnection _connection = connection;
public DbSet<Soap> Soap
=> Set<Soap>();
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder.UseSqlite(_connection);
}
[ConditionalTheory]
[InlineData("Data Source=:memory:")]
[InlineData("Data Source=exists-memory;Mode=Memory;Cache=Shared")]
public void Exists_returns_true_when_memory(string connectionString)
{
var context = CreateContext(connectionString);
var creator = context.GetService<IRelationalDatabaseCreator>();
Assert.True(creator.Exists());
}
private DbContext CreateContext(string connectionString)
=> new(
new DbContextOptionsBuilder()
.UseSqlite(connectionString)
.UseInternalServiceProvider(
SqliteTestStoreFactory.Instance.AddProviderServices(new ServiceCollection())
.BuildServiceProvider(validateScopes: true))
.Options);
}