From 2c7e3b1c00dc13ab3647d960a79d1d7b5ba6c362 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Sun, 11 Dec 2022 10:43:56 +0800
Subject: Develop secret api. v26

---
 .../CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs | 62 ++++++++++++++++++++++
 1 file changed, 62 insertions(+)
 create mode 100644 docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs

(limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs')

diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs
new file mode 100644
index 0000000..4b253b7
--- /dev/null
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs
@@ -0,0 +1,62 @@
+using System.Data;
+using System.Diagnostics;
+
+namespace CrupestApi.Commons.Crud;
+
+public record ParamInfo(string Name, object? Value, string? ColumnName = null);
+
+public class ParamList : List<ParamInfo>
+{
+    private static Random random = new Random();
+    private const string chars = "abcdefghijklmnopqrstuvwxyz";
+    public static string GenerateRandomKey(int length)
+    {
+        lock (random)
+        {
+            var result = new string(Enumerable.Repeat(chars, length)
+                .Select(s => s[random.Next(s.Length)]).ToArray());
+            return result;
+        }
+    }
+
+    public string GenerateRandomParameterName()
+    {
+        var parameterName = GenerateRandomKey(10);
+        int retryTimes = 1;
+        while (ContainsKey(parameterName))
+        {
+            retryTimes++;
+            Debug.Assert(retryTimes <= 100);
+            parameterName = GenerateRandomKey(10);
+        }
+        return parameterName;
+    }
+
+
+    public bool ContainsKey(string name)
+    {
+        return this.SingleOrDefault(p => p.Name.Equals(name, StringComparison.OrdinalIgnoreCase)) is not null;
+    }
+
+    public object? this[string key]
+    {
+        get
+        {
+            return this.SingleOrDefault(p => p.Name.Equals(key, StringComparison.OrdinalIgnoreCase)) ?? throw new KeyNotFoundException("Key not found.");
+        }
+    }
+
+    public void Add(string name, object? value, string? columnName = null)
+    {
+        Add(new ParamInfo(name, value, columnName));
+    }
+
+    // Return the random name.
+    public string AddRandomNameParameter(object? value, string? columnName = null)
+    {
+        var parameterName = GenerateRandomParameterName();
+        var param = new ParamInfo(parameterName, value, columnName);
+        Add(param);
+        return parameterName;
+    }
+}
-- 
cgit v1.2.3