aboutsummaryrefslogtreecommitdiff
path: root/docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs
diff options
context:
space:
mode:
Diffstat (limited to 'docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs')
-rw-r--r--docker/crupest-api/CrupestApi/CrupestApi.Commons.Tests/Crud/SqlCompareHelper.cs14
1 files changed, 12 insertions, 2 deletions
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<string> { "select", "*", "from", "tablename", "where", "id", "=", "@abcd", ";" });
+ Assert.Equal(new List<string> { "select", "*", "from", "tablename", "where", "id", "=", "@abcd", ";" }, words);
}
}