public static void Equals_GivenEqualComplexExpressionsWrappedInParens_ReturnsTrue() { const string input = "([test_column_1] > len(left([test], 50)))"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(input, input); Assert.That(equals, Is.True); }
public static void Equals_GivenEqualSqlStringArgumentsWrappedInParens_ReturnsTrue() { const string input = "('test')"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(input, input); Assert.That(equals, Is.True); }
public static void Equals_GivenEqualNumberArguments_ReturnsTrue() { const string input = "123"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(input, input); Assert.That(equals, Is.True); }
public static void Equals_GivenDifferentSqlStringsWithOneWrappedInParens_ReturnsTrue() { const string inputX = "('test')"; const string inputY = "'alternative'"; var comparer = new OracleExpressionComparer(); 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 OracleExpressionComparer(); 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 OracleExpressionComparer(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 OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.False); }
public static void Equals_GivenEqualComplexExpressionsOneWithWhitespaceRemoved_ReturnsTrue() { const string inputX = "([test_column_1] > len(left([test], (50))))"; const string inputY = "[test_column_1]>len(left([test],50))"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.True); }
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 OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.False); }
public static void Equals_GivenEqualNumbersWithOneWrappedTwiceInParens_ReturnsTrue() { const string inputX = "((123))"; const string inputY = "123"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.True); }
public static void Equals_GivenDifferentNumbersWithOneWrappedInParens_ReturnsTrue() { const string inputX = "(123)"; const string inputY = "456"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.False); }
public static void Equals_GivenDifferentNumberArguments_ReturnsFalse() { const string inputX = "123"; const string inputY = "456"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.False); }
public static void Equals_GivenEqualDatesWithOneWrappedInParens_ReturnsTrue() { const string inputX = "(getdate())"; const string inputY = "getdate()"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.True); }
public static void Equals_GivenDifferentDateArgumentsWrappedInParens_ReturnsFalse() { const string inputX = "(getdate())"; const string inputY = "(getutcdate())"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(inputX, inputY); Assert.That(equals, Is.False); }
public async Task Columns_WhenGivenTableWithColumnWithDefaultValue_ColumnReturnsCorrectDefaultValue() { const string tableName = "TABLE_TEST_TABLE_33"; var table = await GetTableAsync(tableName).ConfigureAwait(false); var column = table.Columns.Single(); const string defaultValue = "1"; var comparer = new OracleExpressionComparer(); var equals = comparer.Equals(defaultValue, column.DefaultValue.UnwrapSome()); Assert.That(equals, Is.True); }