aboutsummaryrefslogtreecommitdiff
path: root/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs
diff options
context:
space:
mode:
authorcrupest <crupest@outlook.com>2022-12-08 14:52:58 +0800
committercrupest <crupest@outlook.com>2022-12-20 20:32:52 +0800
commit62c92f97358e2a98271aaf11fdd5626e21cf4689 (patch)
tree2ac7a1f7f8492876a3b245959ef68f92f8dec0ae /docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs
parent78396f289ab50ce414bd8f65af8854ffb52fff48 (diff)
downloadcrupest-62c92f97358e2a98271aaf11fdd5626e21cf4689.tar.gz
crupest-62c92f97358e2a98271aaf11fdd5626e21cf4689.tar.bz2
crupest-62c92f97358e2a98271aaf11fdd5626e21cf4689.zip
Develop secret api. v18
Diffstat (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs')
-rw-r--r--docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs15
1 files changed, 11 insertions, 4 deletions
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs
index 7cb5edf..b9cafee 100644
--- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs
@@ -15,8 +15,13 @@ public class UpdateItem
public object? Value { get; set; }
}
-// TODO: Continue...
-public class UpdateClause
+public interface IUpdateClause : IClause
+{
+ List<UpdateItem> Items { get; }
+ (string sql, DynamicParameters parameters) GenerateSql();
+}
+
+public class UpdateClause : IUpdateClause
{
public List<UpdateItem> Items { get; } = new List<UpdateItem>();
@@ -51,8 +56,10 @@ public class UpdateClause
return Items.Select(i => i.ColumnName).ToList();
}
- public string GenerateSql(DynamicParameters parameters)
+ public (string sql, DynamicParameters parameters) GenerateSql()
{
+ var parameters = new DynamicParameters();
+
StringBuilder result = new StringBuilder();
foreach (var item in Items)
@@ -66,6 +73,6 @@ public class UpdateClause
result.Append($"{item.ColumnName} = @{parameterName}");
}
- return result.ToString();
+ return (result.ToString(), parameters);
}
}