def test_filter_string_greater_case_insensitive_data(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Greater, 'donec', case_sensitive=False) ])(self.table) correct_data = [SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and row[0].lower() > 'donec'] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_list_case_insensitive_data(self): filtered_data = filter.Values(conditions=[ filter.FilterStringList(-1, ["donec"], case_sensitive=False) ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] in ["Donec"] ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_less_equal_case_insensitive_value(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.LessEqual, 'In', case_sensitive=False) ])(self.table) correct_data = [SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and row[0].lower() <= 'in'] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_outside(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Outside, "am", "di") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and not "am" < row[0] < "di" ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_ends_with(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.EndsWith, "s") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and row[0].endswith("s") ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_between(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Between, "a", "c") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and "a" <= row[0] <= "c" ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_contains(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Contains, "et") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and "et" in row[0] ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_less_equal(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.LessEqual, "A") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and row[0] <= "A" ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_greater(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Greater, "volutpat") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and row[0] > "volutpat" ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_not_equal(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.NotEqual, "in") ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] != "in" ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_is_defined(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.IsDefined) ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_outside_case_insensitive(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Outside, 'd', 'k', case_sensitive=False) ])(self.table) correct_data = [SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and not 'd' < row[0].lower() < 'k'] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_between_case_insensitive_data(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.Between, 'i', 'O', case_sensitive=False) ])(self.table) correct_data = [SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and 'i' <= row[0].lower() <= 'o'] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_ends_with_case_insensitive(self): filtered_data = filter.Values(conditions=[ filter.FilterString(-1, filter.FilterString.EndsWith, 'S', case_sensitive=False) ])(self.table) correct_data = [SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] is not None and row[0].lower().endswith('s')] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)
def test_filter_string_equal_case_insensitive_value(self): filtered_data = filter.Values(conditions=[ filter.FilterString( -1, filter.FilterString.Equal, "In", case_sensitive=False) ])(self.table) correct_data = [ SqlRowInstance(filtered_data.domain, row) for row in self.data if row[0] == "in" ] self.assertEqual(len(filtered_data), len(correct_data)) self.assertSequenceEqual(filtered_data, correct_data)