aboutsummaryrefslogtreecommitdiff
path: root/BackEnd/Timeline/Services/DatabaseManagement/DatabaseCustomMigrator.cs
blob: 20e2c07450d7e4c637d759a679db0c6cfa8eaf9a (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
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 class DatabaseCustomMigrator : IDatabaseCustomMigrator
    {
        private readonly IEnumerable<IDatabaseCustomMigration> _migrations;
        private readonly DatabaseContext _database;

        private readonly 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(Resource.DatabaseCustomMigratorFoundMigration, name, isApplied);

                if (!isApplied)
                {
                    _logger.LogWarning(Resource.DatabaseCustomMigratorBeginMigration, 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(Resource.DatabaseCustomMigratorFinishMigration, name);
                }
            }
        }
    }
}