From 81b106a1bfc225abcee1c9b5cfad64489e8cb24b Mon Sep 17 00:00:00 2001 From: crupest Date: Sat, 10 Dec 2022 15:07:12 +0800 Subject: Develop secret api. v23 --- .../CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs | 10 ++++++---- 1 file changed, 6 insertions(+), 4 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 c019e19..72b6218 100644 --- a/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs +++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs @@ -4,6 +4,8 @@ namespace CrupestApi.Commons.Crud.Tests; public class SqlCompareHelper { + private static List SymbolTokens = new List() { '(', ')', ';' }; + public static List SqlExtractWords(string? sql, bool toLower = true) { var result = new List(); @@ -27,14 +29,14 @@ public class SqlCompareHelper wordBuilder = null; } } - else if (sql[current] == ';') + else if (SymbolTokens.Contains(sql[current])) { if (wordBuilder is not null) { result.Add(wordBuilder.ToString()); wordBuilder = null; } - result.Add(";"); + result.Add(sql[current].ToString()); } else { @@ -75,9 +77,9 @@ public class SqlCompareHelper [Fact] public void TestSqlExtractWords() { - var sql = "SELECT * FROM TableName WHERE id = @abcd;"; + var sql = "SELECT * FROM TableName WHERE (id = @abcd);"; var words = SqlExtractWords(sql); - Assert.Equal(new List { "select", "*", "from", "tablename", "where", "id", "=", "@abcd", ";" }, words); + Assert.Equal(new List { "select", "*", "from", "tablename", "where", "(", "id", "=", "@abcd", ")", ";" }, words); } } -- cgit v1.2.3