From 1aec1eb3f0822e17793d43e040efdf127ea8e561 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Fri, 12 Feb 2021 22:10:56 +0800
Subject: feat: Add databse custom migration service.

---
 .../Services/Migration/CustomMigrationManager.cs   | 55 ++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 BackEnd/Timeline/Services/Migration/CustomMigrationManager.cs

(limited to 'BackEnd/Timeline/Services/Migration/CustomMigrationManager.cs')

diff --git a/BackEnd/Timeline/Services/Migration/CustomMigrationManager.cs b/BackEnd/Timeline/Services/Migration/CustomMigrationManager.cs
new file mode 100644
index 00000000..ba86e10b
--- /dev/null
+++ b/BackEnd/Timeline/Services/Migration/CustomMigrationManager.cs
@@ -0,0 +1,55 @@
+using System.Collections.Generic;
+using System.Threading.Tasks;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.Extensions.Logging;
+using Timeline.Entities;
+
+namespace Timeline.Services.Migration
+{
+    public interface ICustomMigrationManager
+    {
+        Task Migrate();
+    }
+
+    public class CustomMigrationManager : ICustomMigrationManager
+    {
+        private IEnumerable<ICustomMigration> _migrations;
+        private DatabaseContext _database;
+
+        private ILogger<CustomMigrationManager> _logger;
+
+        public CustomMigrationManager(IEnumerable<ICustomMigration> migrations, DatabaseContext database, ILogger<CustomMigrationManager> logger)
+        {
+            _migrations = migrations;
+            _database = database;
+            _logger = logger;
+        }
+
+        public async Task Migrate()
+        {
+            foreach (var migration in _migrations)
+            {
+                var name = migration.GetName();
+                var did = await _database.Migrations.AnyAsync(m => m.Name == name);
+
+                _logger.LogInformation("Found custom migration '{0}'. Did: {1}.", name, did);
+
+                if (!did)
+                {
+                    _logger.LogInformation("Begin custom migration '{0}'.", name);
+
+                    await using var transaction = await _database.Database.BeginTransactionAsync();
+
+                    await migration.Execute(_database);
+
+                    _database.Migrations.Add(new MigrationEntity { Name = name });
+                    await _database.SaveChangesAsync();
+
+                    await transaction.CommitAsync();
+
+                    _logger.LogInformation("End custom migration '{0}'.", name);
+                }
+            }
+        }
+    }
+}
-- 
cgit v1.2.3