From 106e7492d8e8d07ccf50f2d13b5685f5838a52d8 Mon Sep 17 00:00:00 2001 From: crupest Date: Wed, 14 Dec 2022 16:23:31 +0800 Subject: Develop secret api. v40 --- .../CrupestApi/CrupestApi.Commons/Crud/CrudService.cs | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs') diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs index 796761e..65085fd 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/CrudService.cs @@ -26,6 +26,8 @@ public class CrudService : IDisposable where TEntity : class } } + public EntityJsonHelper JsonHelper => _jsonHelper; + public virtual void DoInitializeDatabase(IDbConnection connection) { using var transaction = connection.BeginTransaction(); @@ -43,4 +45,17 @@ public class CrudService : IDisposable where TEntity : class var result = _table.Select(_dbConnection, null); return result; } + + public TEntity GetByKey(string key) + { + var result = _table.Select(_dbConnection, null, WhereClause.Create().Eq(_table.KeyColumn.ColumnName, key)); + return result.Single(); + } + + public string Create(JsonElement jsonElement) + { + var insertClauses = _jsonHelper.ConvertJsonElementToInsertClauses(jsonElement); + var key = _table.Insert(_dbConnection, insertClauses); + return (string)key; + } } -- cgit v1.2.3