public static void Equals_GivenEqualNumberArguments_ReturnsTrue()
{
const string input = "123";
var comparer = new SqliteExpressionComparer();
var equals = comparer.Equals(input, input);
Assert.That(equals, Is.True);
}
public static void Equals_GivenEqualComplexExpressions_ReturnsTrue()
{
const string input = "[test_column_1] > len(left([test], 50))";
var comparer = new SqliteExpressionComparer();
var equals = comparer.Equals(input, input);
Assert.That(equals, Is.True);
}
public static void Equals_GivenDifferentNumberArguments_ReturnsFalse()
{
const string inputX = "123";
const string inputY = "456";
var comparer = new SqliteExpressionComparer();
var equals = comparer.Equals(inputX, inputY);
Assert.That(equals, Is.False);
}
public static void Equals_GivenDifferentSqlStringArguments_ReturnsFalse()
{
const string inputX = "'test'";
const string inputY = "'alternative'";
var comparer = new SqliteExpressionComparer();
var equals = comparer.Equals(inputX, inputY);
Assert.That(equals, Is.False);
}
public static void Equals_GivenIgnoreCaseTextComparerAndEqualComplexExpressionsButDifferentStringCase_ReturnsTrue()
{
const string inputX = "([test_column_1] > len(left('test', (50))))";
const string inputY = "([test_column_1] > len(left('TEST', (50))))";
var comparer = new SqliteExpressionComparer(sqlStringComparer: StringComparer.OrdinalIgnoreCase);
var equals = comparer.Equals(inputX, inputY);
Assert.That(equals, Is.True);
}
public static void Equals_GivenDefaultTextComparerAndEqualComplexExpressionsButDifferentStringCase_ReturnsFalse()
{
const string inputX = "([test_column_1] > len(left('test', (50))))";
const string inputY = "([test_column_1] > len(left('TEST', (50))))";
var comparer = new SqliteExpressionComparer();
var equals = comparer.Equals(inputX, inputY);
Assert.That(equals, Is.False);
}
public static void Equals_GivenDifferentComplexExpressions_ReturnsFalse()
{
const string inputX = "[test_column_1] > len(left([test], 50))";
const string inputY = "[test_column_2] < len(left([test], 50))";
var comparer = new SqliteExpressionComparer();
var equals = comparer.Equals(inputX, inputY);
Assert.That(equals, Is.False);
}
public async Task Checks_WhenGivenTableWithCheck_ReturnsContraintWithDefinition()
{
const string expectedDefinition = "([test_column]>(1))";
var table = await GetTableAsync("table_test_table_14").ConfigureAwait(false);
var check = table.Checks.Single();
var comparer = new SqliteExpressionComparer();
var checksEqual = comparer.Equals(expectedDefinition, check.Definition);
Assert.That(checksEqual, Is.True);
}
public async Task Triggers_GivenTableWithTrigger_ReturnsCorrectDefinition()
{
var table = await GetTableAsync("trigger_test_table_1").ConfigureAwait(false);
var trigger = table.Triggers.First(t => t.Name == "trigger_test_table_1_trigger_1");
const string expectedDefinition = @"create trigger trigger_test_table_1_trigger_1
before insert
on trigger_test_table_1
begin
select 1;
end";
var comparer = new SqliteExpressionComparer(StringComparer.OrdinalIgnoreCase);
Assert.That(comparer.Equals(expectedDefinition, trigger.Definition), Is.True);
}