refactor: Refactor a lot.

1 files changed, 37 insertions, 0 deletions

diff --git a/BackEnd/Timeline/Services/DatabaseManagement/DatabaseBackupService.cs b/BackEnd/Timeline/Services/DatabaseManagement/DatabaseBackupService.cs
new file mode 100644
index 00000000..c00b5f95
--- /dev/null
+++ b/BackEnd/Timeline/Services/DatabaseManagement/DatabaseBackupService.cs
@@ -0,0 +1,37 @@
+using Microsoft.EntityFrameworkCore;

+using System.Globalization;

+using System.IO;

+using System.Threading;

+using System.Threading.Tasks;

+using Timeline.Entities;

+

+namespace Timeline.Services.DatabaseManagement

+{

+    public interface IDatabaseBackupService

+    {

+        Task BackupAsync(CancellationToken cancellationToken = default);

+    }

+

+    public class DatabaseBackupService : IDatabaseBackupService

+    {

+        private readonly DatabaseContext _database;

+        private readonly IPathProvider _pathProvider;

+        private readonly IClock _clock;

+

+        public DatabaseBackupService(DatabaseContext database, IPathProvider pathProvider, IClock clock)

+        {

+            _database = database;

+            _pathProvider = pathProvider;

+            _clock = clock;

+        }

+

+        public async Task BackupAsync(CancellationToken cancellationToken = default)

+        {

+            var backupDirPath = _pathProvider.GetDatabaseBackupDirectory();

+            Directory.CreateDirectory(backupDirPath);

+            var fileName = _clock.GetCurrentTime().ToString("yyyy-MM-ddTHH-mm-ss", CultureInfo.InvariantCulture);

+            var path = Path.Combine(backupDirPath, fileName);

+            await _database.Database.ExecuteSqlInterpolatedAsync($"VACUUM INTO {path}", cancellationToken);

+        }

+    }

+}