From f9aa02ec1a4c24e80a206857d4f68198bb027bb4 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Mon, 11 Nov 2024 01:12:29 +0800
Subject: HALF WORK: 2024.12.19

Re-organize file structure.
---
 .../CrupestApi.Commons/Secrets/SecretService.cs    | 48 ++++++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Secrets/SecretService.cs

(limited to 'dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Secrets/SecretService.cs')

diff --git a/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Secrets/SecretService.cs b/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Secrets/SecretService.cs
new file mode 100644
index 0000000..c693d8d
--- /dev/null
+++ b/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Secrets/SecretService.cs
@@ -0,0 +1,48 @@
+using System.Data;
+using CrupestApi.Commons.Crud;
+using CrupestApi.Commons.Crud.Migrations;
+
+namespace CrupestApi.Commons.Secrets;
+
+public class SecretService : CrudService<SecretInfo>, ISecretService
+{
+    private readonly ILogger<SecretService> _logger;
+
+    public SecretService(ITableInfoFactory tableInfoFactory, IDbConnectionFactory dbConnectionFactory, IDatabaseMigrator migrator, ILoggerFactory loggerFactory)
+        : base(tableInfoFactory, dbConnectionFactory, migrator, loggerFactory)
+    {
+        _logger = loggerFactory.CreateLogger<SecretService>();
+    }
+
+    protected override void AfterMigrate(IDbConnection connection, TableInfo table)
+    {
+        if (table.SelectCount(connection) == 0)
+        {
+            _logger.LogInformation("No secrets found, insert default secrets.");
+            using var transaction = connection.BeginTransaction();
+            var insertClause = InsertClause.Create()
+                .Add(nameof(SecretInfo.Key), SecretsConstants.SecretManagementKey)
+                .Add(nameof(SecretInfo.Secret), "crupest")
+                .Add(nameof(SecretInfo.Description), "This is the init key. Please revoke it immediately after creating a new one.");
+            _table.Insert(connection, insertClause, out var _);
+            transaction.Commit();
+        }
+    }
+
+    public void CreateTestSecret(string key, string secret)
+    {
+        var connection = _dbConnection;
+        var insertClause = InsertClause.Create()
+               .Add(nameof(SecretInfo.Key), key)
+               .Add(nameof(SecretInfo.Secret), secret)
+               .Add(nameof(SecretInfo.Description), "Test secret.");
+        _table.Insert(connection, insertClause, out var _);
+    }
+
+    public List<string> GetPermissions(string secret)
+    {
+        var list = _table.Select<SecretInfo>(_dbConnection,
+            where: WhereClause.Create().Eq(nameof(SecretInfo.Secret), secret));
+        return list.Select(x => x.Key).ToList();
+    }
+}
-- 
cgit v1.2.3