From bed36cfe2e56df769a76cadcec00015e7eeb9a67 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Wed, 21 Dec 2022 19:36:18 +0800
Subject: Develop secret api. v57

---
 .../CrupestApi.Commons.Tests/Crud/CrudServiceTest.cs   | 18 ++++++++++++++++++
 .../CrupestApi/CrupestApi.Commons/Crud/CrudService.cs  |  2 +-
 .../CrupestApi/CrupestApi.Commons/DatabaseHelper.cs    | 13 -------------
 3 files changed, 19 insertions(+), 14 deletions(-)
 delete mode 100644 docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs

(limited to 'docker/crupest-api')

diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/CrudServiceTest.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/CrudServiceTest.cs
index 762e3a8..a515d2f 100644
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/CrudServiceTest.cs
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/CrudServiceTest.cs
@@ -44,6 +44,24 @@ public class CrudServiceTest
 
         var count = _crudService.GetCount();
         Assert.Equal(1, count);
+
+        _crudService.UpdateByKey(key, new TestEntity()
+        {
+            Name = "crupest2.0",
+            Age = 22,
+            Height = 180,
+        });
+
+        entity = _crudService.GetByKey("crupest2.0");
+        Assert.Equal("crupest2.0", entity.Name);
+        Assert.Equal(22, entity.Age);
+        Assert.Equal(180, entity.Height);
+        Assert.NotEmpty(entity.Secret);
+
+        _crudService.DeleteByKey("crupest2.0");
+
+        count = _crudService.GetCount();
+        Assert.Equal(0, count);
     }
 
 
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
index eab8567..dc32387 100644
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs
@@ -108,7 +108,7 @@ public class CrudService<TEntity> : IDisposable where TEntity : class
         return result;
     }
 
-    public void UpdateByKey(object key, TEntity entity, UpdateBehavior behavior)
+    public void UpdateByKey(object key, TEntity entity, UpdateBehavior behavior = UpdateBehavior.None)
     {
         var affectedCount = _table.Update(_dbConnection, WhereClause.Create().Eq(_table.KeyColumn.ColumnName, key),
             ConvertEntityToUpdateClauses(entity, behavior));
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs
deleted file mode 100644
index 9eb6a08..0000000
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/DatabaseHelper.cs
+++ /dev/null
@@ -1,13 +0,0 @@
-namespace CrupestApi.Commons;
-
-
-public static class DatabaseHelper
-{
-    public static string GenerateUpdateColumnString(this IEnumerable<string> updateColumnList, IEnumerable<KeyValuePair<string, string>>? paramNameMap = null)
-    {
-        paramNameMap = paramNameMap ?? Enumerable.Empty<KeyValuePair<string, string>>();
-        var paramNameDictionary = new Dictionary<string, string>(paramNameMap);
-
-        return string.Join(", ", updateColumnList.Select(x => $"{x} = @{paramNameDictionary.GetValueOrDefault(x) ?? x}"));
-    }
-}
\ No newline at end of file
-- 
cgit v1.2.3