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
commit8995f98b74269dc50584df852920985b93622f68 (patch)
tree2ac7a1f7f8492876a3b245959ef68f92f8dec0ae /docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/UpdateClause.cs
parenta9b726661d018eb8f379851c733f1676f5ac067d (diff)
downloadcrupest-8995f98b74269dc50584df852920985b93622f68.tar.gz
crupest-8995f98b74269dc50584df852920985b93622f68.tar.bz2
crupest-8995f98b74269dc50584df852920985b93622f68.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);
}
}