this looks reasonable

gistfile1.txt

import datetime

import mock

op =  mock.Mock()

today = datetime.datetime.utcnow().date()
for i in range(28, 0, -1):
    then = today - datetime.timedelta(days=i)
    till = then + datetime.timedelta(days=1)
    print (
        """
        SELECT
            backfill_weekly_report_partitions(
                '%s', '%s', 'signature_summary_os'
            )
        """ % (
            then.strftime('%Y-%m-%d'),
            till.strftime('%Y-%m-%d')
        )
    )


        SELECT
            backfill_weekly_report_partitions(
                '2015-08-05', '2015-08-06', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-06', '2015-08-07', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-07', '2015-08-08', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-08', '2015-08-09', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-09', '2015-08-10', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-10', '2015-08-11', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-11', '2015-08-12', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-12', '2015-08-13', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-13', '2015-08-14', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-14', '2015-08-15', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-15', '2015-08-16', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-16', '2015-08-17', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-17', '2015-08-18', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-18', '2015-08-19', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-19', '2015-08-20', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-20', '2015-08-21', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-21', '2015-08-22', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-22', '2015-08-23', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-23', '2015-08-24', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-24', '2015-08-25', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-25', '2015-08-26', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-26', '2015-08-27', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-27', '2015-08-28', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-28', '2015-08-29', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-29', '2015-08-30', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-30', '2015-08-31', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-08-31', '2015-09-01', 'signature_summary_os'
            )
        

        SELECT
            backfill_weekly_report_partitions(
                '2015-09-01', '2015-09-02', 'signature_summary_os'
            )