565716 - startTopCrashstartTopCrashesBySignature.py doesn't respect start and end window

Status: RESOLVED WONTFIX

(Socorro :: General, task)

Description

[Austin King [:ozten]]

Repro Notes:
1) ./startTopCrashesBySignature.py --startWindow '2010-03-01 12:00:00' --endWindow '2010-03-01 14:00:00'

Actual: 
2010-05-13 10:02:24,205 DEBUG - Collecting data in range[2010-05-13 06:00:00,2010-05-13 08:00:00) on column date_processed
2010-05-13 10:02:24,206 DEBUG - SELECT
                 r.uptime, r.signature, r.build, r.version, cfg.productdims_id, r.os_name, r.os_version
             FROM product_visibility cfg JOIN productdims p on cfg.productdims_id = p.id
                 JOIN reports r on p.product = r.product AND p.version = r.version
             WHERE
                 NOT cfg.ignore
                 AND '2010-05-13T06:00:00' <= r.date_processed AND r.date_processed < '2010-05-13T08:00:00'
                 AND cfg.start_date <= r.date_processed AND r.date_processed <= cfg.end_date

Expected:
Queries would only be for dates between  '2010-03-01 12:00:00' and  '2010-03-01 14:00:00'

Comment 1

[Lonnen :lonnen]

these jobs are long since deleted