def test_except_fields(self): category = CategoryFactory() TextFieldFactory(category=category) NumericFieldFactory(category=category) DateTimeFieldFactory(category=category) DateFieldFactory(category=category) TimeFieldFactory(category=category) LookupFieldFactory(category=category) MultipleLookupFieldFactory(category=category) all_fields = category.fields.all().select_subclasses() type_names = [ 'Text', 'Numeric', 'Date and Time', 'Date', 'Time', 'Select box', 'Multiple select' ] for type_name in type_names: remaining_fields = filter_fields.except_fields( all_fields, type_name) self.assertEqual(len(remaining_fields), len(type_names) - 1) for field in remaining_fields: self.assertNotEqual(field.type_name, type_name) date_fields = filter_fields.except_fields( fields=all_fields, type_names=', '.join(type_names)) self.assertEqual(len(date_fields), 0)
def test_only_fields(self): category = CategoryFactory() TextFieldFactory(category=category) NumericFieldFactory(category=category) DateTimeFieldFactory(category=category) DateFieldFactory(category=category) TimeFieldFactory(category=category) LookupFieldFactory(category=category) MultipleLookupFieldFactory(category=category) all_fields = category.fields.all() type_names = [ 'Text', 'Numeric', 'Date and Time', 'Date', 'Time', 'Select box', 'Multiple select' ] for type_name in type_names: date_fields = filter_fields.only_fields(all_fields, type_name) self.assertEqual(len(date_fields), 1) for field in date_fields: self.assertEqual(field.type_name, type_name) date_fields = filter_fields.only_fields(all_fields, (', ').join(type_names)) self.assertEqual(len(date_fields), len(type_names)) for field in date_fields: self.assertTrue(field.type_name in type_names)
def test_get_data_min_max_date_filter(self): user = UserF.create() project = ProjectF.create() category_1 = CategoryFactory(**{'project': project}) DateFieldFactory(**{ 'key': 'date', 'category': category_1 }) category_2 = CategoryFactory(**{'project': project}) DateFieldFactory(**{ 'key': 'bla', 'category': category_2 }) UserGroupF.create( add_users=[user], **{ 'project': project, 'filters': { category_1.id: {'date': { 'minval': '2014-01-01', 'maxval': '2014-06-09'} } } } ) for x in range(0, 5): ObservationFactory.create(**{ 'project': project, 'category': category_1, 'properties': {'date': '2014-04-09'} }) ObservationFactory.create(**{ 'project': project, 'category': category_1, 'properties': {'date': '2013-04-09'} }) ObservationFactory.create(**{ 'project': project, 'category': category_2, 'properties': {'bla': '2014-04-09'} }) self.assertEqual(project.get_all_contributions(user).count(), 5)
def test_get_data_max_date_filter(self): user = UserF.create() project = ProjectF.create(add_admins=[user]) category_1 = CategoryFactory(**{'project': project}) DateFieldFactory(**{ 'key': 'date', 'category': category_1 }) category_2 = CategoryFactory(**{'project': project}) DateFieldFactory(**{ 'key': 'bla', 'category': category_2 }) for x in range(0, 5): ObservationFactory.create(**{ 'project': project, 'category': category_1, 'properties': {'date': '2014-04-09'} }) ObservationFactory.create(**{ 'project': project, 'category': category_1, 'properties': {'date': '2013-04-09'} }) ObservationFactory.create(**{ 'project': project, 'category': category_2, 'properties': {'bla': '2014-04-09'} }) view = GroupingFactory(**{'project': project}) RuleFactory(**{ 'grouping': view, 'category': category_1, 'constraints': {'date': { 'maxval': '2014-01-01'} } }) self.assertEqual(view.data(user).count(), 5)