aboutsummaryrefslogtreecommitdiff
path: root/BackEnd/Timeline/Services/DatabaseManagement/DatabaseCustomMigrator.cs
blob: 2180ad407aa5beeb4e0b8d47ca3ba46a35b84d60 (plain)
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
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using System.Collections.Generic;
using System.Threading;
using System.Threading.Tasks;
using Timeline.Entities;

namespace Timeline.Services.DatabaseManagement
{
    public interface IDatabaseCustomMigrator
    {
        Task MigrateAsync(CancellationToken cancellationToken = default);
    }

    public class DatabaseCustomMigrator : IDatabaseCustomMigrator
    {
        private IEnumerable<IDatabaseCustomMigration> _migrations;
        private DatabaseContext _database;

        private ILogger<DatabaseCustomMigrator> _logger;

        public DatabaseCustomMigrator(IEnumerable<IDatabaseCustomMigration> migrations, DatabaseContext database, ILogger<DatabaseCustomMigrator> logger)
        {
            _migrations = migrations;
            _database = database;
            _logger = logger;
        }

        public async Task MigrateAsync(CancellationToken cancellationToken = default)
        {
            foreach (var migration in _migrations)
            {
                var name = migration.GetName();
                var isApplied = await _database.Migrations.AnyAsync(m => m.Name == name, cancellationToken);

                _logger.LogInformation("Found custom migration '{0}'. Applied: {1}.", name, isApplied);

                if (!isApplied)
                {
                    _logger.LogWarning("Begin custom migration '{0}'.", name);

                    await using var transaction = await _database.Database.BeginTransactionAsync(cancellationToken);

                    await migration.ExecuteAsync(_database, cancellationToken);

                    _database.Migrations.Add(new MigrationEntity { Name = name });
                    await _database.SaveChangesAsync(cancellationToken);

                    await transaction.CommitAsync(cancellationToken);

                    _logger.LogWarning("End custom migration '{0}'.", name);
                }
            }
        }
    }
}