From 2c9e38fbb434759593825f3893563dcd0c3806bb Mon Sep 17 00:00:00 2001 From: crupest Date: Sat, 10 Dec 2022 11:35:49 +0800 Subject: Develop secret api. v23 --- .../CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs') diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs index 8f3e5c6..c019e19 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs @@ -44,9 +44,11 @@ public class SqlCompareHelper } else { - wordBuilder = new StringBuilder(sql[current]); + wordBuilder = new StringBuilder(); + wordBuilder.Append(sql[current]); } } + current++; } if (wordBuilder is not null) @@ -54,6 +56,14 @@ public class SqlCompareHelper result.Add(wordBuilder.ToString()); } + if (toLower) + { + for (int i = 0; i < result.Count; i++) + { + result[i] = result[i].ToLower(); + } + } + return result; } @@ -68,6 +78,6 @@ public class SqlCompareHelper var sql = "SELECT * FROM TableName WHERE id = @abcd;"; var words = SqlExtractWords(sql); - Assert.Equal(words, new List { "select", "*", "from", "tablename", "where", "id", "=", "@abcd", ";" }); + Assert.Equal(new List { "select", "*", "from", "tablename", "where", "id", "=", "@abcd", ";" }, words); } } -- cgit v1.2.3