From 4c5df72057fe02257e243de37930a47425a84722 Mon Sep 17 00:00:00 2001 From: Yuqian Yang Date: Wed, 19 Feb 2025 02:05:39 +0800 Subject: chore(docker): remove crupest-api, forgejo and move dropped. --- .../CrupestApi.Commons/Crud/InsertClause.cs | 77 ---------------------- 1 file changed, 77 deletions(-) delete mode 100644 dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs (limited to 'dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs') diff --git a/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs b/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs deleted file mode 100644 index a880e66..0000000 --- a/dropped/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/InsertClause.cs +++ /dev/null @@ -1,77 +0,0 @@ -using System.Text; - -namespace CrupestApi.Commons.Crud; - -public class InsertItem -{ - /// - /// Null means use default value. Use . - /// - public InsertItem(string columnName, object? value) - { - ColumnName = columnName; - Value = value; - } - - public string ColumnName { get; set; } - public object? Value { get; set; } -} - -public interface IInsertClause : IClause -{ - List Items { get; } - string GenerateColumnListSql(string? dbProviderId = null); - (string sql, ParamList parameters) GenerateValueListSql(string? dbProviderId = null); -} - -public class InsertClause : IInsertClause -{ - public List Items { get; } = new List(); - - public InsertClause(params InsertItem[] items) - { - Items.AddRange(items); - } - - public InsertClause Add(params InsertItem[] items) - { - Items.AddRange(items); - return this; - } - - public InsertClause Add(string column, object? value) - { - return Add(new InsertItem(column, value)); - } - - public static InsertClause Create(params InsertItem[] items) - { - return new InsertClause(items); - } - - public List GetRelatedColumns() - { - return Items.Select(i => i.ColumnName).ToList(); - } - - public string GenerateColumnListSql(string? dbProviderId = null) - { - return string.Join(", ", Items.Select(i => i.ColumnName)); - } - - public (string sql, ParamList parameters) GenerateValueListSql(string? dbProviderId = null) - { - var parameters = new ParamList(); - var sb = new StringBuilder(); - for (var i = 0; i < Items.Count; i++) - { - var item = Items[i]; - var parameterName = parameters.AddRandomNameParameter(item.Value, item.ColumnName); - sb.Append($"@{parameterName}"); - if (i != Items.Count - 1) - sb.Append(", "); - } - - return (sb.ToString(), parameters); - } -} -- cgit v1.2.3