From 2d38b90f9b7f3297ada25b78a722b4e18fa8dc60 Mon Sep 17 00:00:00 2001 From: crupest Date: Mon, 19 Dec 2022 12:39:37 +0800 Subject: Develop secret api. v44 --- .../CrupestApi.Commons/Crud/CrudService.cs | 6 ++++++ .../CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs | 21 +++++++++++++++++++++ 2 files changed, 27 insertions(+) (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud') diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs index 27f0c85..d1958e5 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs @@ -62,6 +62,12 @@ public class CrudService : IDisposable where TEntity : class return result.Single(); } + public string Create(TEntity entity) + { + var key = _table.Insert(_dbConnection, entity); + return (string)key; + } + public string Create(JsonElement jsonElement) { var insertClauses = _jsonHelper.ConvertJsonElementToInsertClauses(jsonElement); diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs index 3147e99..a20963c 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/TableInfo.cs @@ -1,4 +1,5 @@ using System.Data; +using System.Diagnostics; using System.Reflection; using System.Text; using Dapper; @@ -438,6 +439,18 @@ CREATE TABLE {tableName}( return queryResult.Select(MapDynamicTo).ToList(); } + public IInsertClause ConvertEntityToInsertClause(object entity) + { + Debug.Assert(EntityType.IsInstanceOfType(entity)); + var result = new InsertClause(); + foreach (var column in PropertyColumns) + { + var value = column.PropertyInfo!.GetValue(entity); + result.Add(column.ColumnName, value); + } + return result; + } + /// /// Insert a entity and call hooks. /// @@ -504,6 +517,14 @@ CREATE TABLE {tableName}( return key ?? throw new Exception("No key???"); } + public object Insert(IDbConnection dbConnection, object entity) + { + Debug.Assert(EntityType.IsInstanceOfType(entity)); + var insert = ConvertEntityToInsertClause(entity); + return Insert(dbConnection, insert); + } + + /// /// Upgrade a entity and call hooks. /// -- cgit v1.2.3