def test_that_missing_periods_are_automatically_added(self):

        trackers = DataSyncTracker.objects.all()
        self.assertEqual(0, trackers.count())

        call_command('dhis2_data_download', self.start_period)

        trackers = DataSyncTracker.objects.all()
        results = utils.periods_in_ranges(self.start_period, self.end_period)

        self.assertEqual(len(results), trackers.count())
示例#2
0
    def update_periods(current_period, start_period):
        periods = utils.periods_in_ranges(start_period, current_period)
        tracked_periods = [str(dst.period) for dst in DataSyncTracker.objects.all()]
        diff = [period for period in periods if period not in tracked_periods]

        two_day_ago = timezone.now() - timedelta(days=2)

        for period in diff:
            tracker = DataSyncTracker()
            tracker.period = int(period)
            tracker.last_downloaded = two_day_ago
            tracker.last_parsed = two_day_ago
            tracker.status = DataSyncTrackerStatus.UNKNOWN
            tracker.save()
示例#3
0
    def get_months_from_weeks(self, request):
        start_period = request.GET['from_date']
        end_period = request.GET['to_date']
        group_by_column = request.GET['group']

        actual_group_by_column = get_actual_group_by_column(group_by_column)

        results = []
        if group_by_column == 'period':
            for period in periods_in_ranges(start_period, end_period):
                (year, month) = get_year_and_month_from_period(period)
                for week in month_to_weeks(year, month):
                    weekly_period = "%sW%s" % (year, week)
                    year_month = "%s'%s" % (get_month_from_int(month), str(year)[2:])

                    results.append({actual_group_by_column: weekly_period,
                                    'value_aggregate': year_month})

        return results
示例#4
0
    def get_population(self, request):
        start_period = request.GET['from_date']
        end_period = request.GET['to_date']
        group_by_column = request.GET['group']

        region = self.get_int_with_default(request, 'region', 0)
        district = self.get_int_with_default(request, 'district', 0)

        results = []
        if group_by_column == 'period':
            total_population = District.objects

            if region == 0 and district > 0:
                total_population = total_population.filter(pk=district)
            elif district == 0 and region > 0:
                total_population = total_population.filter(region=region)

            total_population = total_population.aggregate(Sum('population'))

            actual_group_by_column = get_actual_group_by_column(group_by_column)
            for period in periods_in_ranges(start_period, end_period):

                results.append({actual_group_by_column: period,
                                'value_aggregate': total_population['population__sum']})

                (year, month) = get_year_and_month_from_period(period)
                for week in month_to_weeks(year, month):
                    weekly_period = "%sW%s" % (year, week)
                    results.append({actual_group_by_column: weekly_period,
                                    'value_aggregate': total_population['population__sum']})

        elif group_by_column == 'district':
            districts = District.objects.all()
            for district in districts:
                results.append({'district': district.pk, 'value_aggregate': district.population})

        return results
示例#5
0
 def test_generate_periods_in_rage(self):
     ranges = utils.periods_in_ranges("201508", "201602")
     self.assertEqual(['201508', '201509', '201510', '201511', '201512', '201601', '201602'], ranges)