def clear_past_results(self):
        self.log.info('Clearing existiting hits_mv columns.')
        clear_time = time.time()
        execute_sql(
        """UPDATE hits_mv SET hits_posted = 0, hits_consumed = 0
        WHERE
            crawl_id IN (
                SELECT id FROM main_crawl
                WHERE start_time BETWEEN '{0}' AND '{1}'
            ) AND
            hits_posted > 0 OR hits_consumed > 0;
        """.format(self.start.isoformat(), self.end.isoformat()),
        commit=True).close()
        self.log.info('{0}s elapsed.'.format(time.time() - clear_time))

        self.log.info('Clearing existiting main_crawlagregates columns.')
        clear_time = time.time()
        execute_sql(
        """UPDATE main_crawlagregates
        SET
            hits_posted = 0, hits_consumed = 0,
            hitgroups_posted = 0, hitgroups_consumed = 0
        WHERE
            crawl_id IN (
                SELECT id FROM main_crawl
                WHERE start_time BETWEEN '{0}' AND '{1}'
            ) AND (
            hits_posted > 0 OR hits_consumed > 0 OR
            hitgroups_consumed > 0 OR hitgroups_posted > 0);
        """.format(self.start.isoformat(), self.end.isoformat()),
        commit=True).close()
        self.log.info('{0}s elapsed.'.format(time.time() - clear_time))
Checks if an undefined-step snippet is provided for a step
dataset/ETHPy150Open ipeirotis/Mturk-Tracker/app/mturk/arrivals/management/commands/db_arrivals.py/Command.clear_past_results--crossover with--dataset/ETHPy150Open behave/behave/features/steps/behave_undefined_steps.py/step_undefined_step_snippet_should_not_exist_for