Timeline.Tests/Mock/Data/TestDatabase.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

using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using System;
using Timeline.Entities;

namespace Timeline.Tests.Mock.Data
{
    public class TestDatabase : IDisposable
    {
        private readonly SqliteConnection _databaseConnection;
        private readonly DatabaseContext _databaseContext;

        public TestDatabase()
        {
            _databaseConnection = new SqliteConnection("Data Source=:memory:;");
            _databaseConnection.Open();

            var options = new DbContextOptionsBuilder<DatabaseContext>()
                .UseSqlite(_databaseConnection)
                .ConfigureWarnings(builder =>
                {
                    builder.Throw(RelationalEventId.QueryClientEvaluationWarning);
                })
                .Options;

            _databaseContext = new DatabaseContext(options);

            // init with mock data
            _databaseContext.Database.EnsureCreated();
            _databaseContext.Users.AddRange(MockUsers.Users);
            _databaseContext.SaveChanges();
        }

        public void Dispose()
        {
            _databaseContext.Dispose();

            _databaseConnection.Close();
            _databaseConnection.Dispose();
        }

        public SqliteConnection DatabaseConnection => _databaseConnection;
        public DatabaseContext DatabaseContext => _databaseContext;
    }
}