1637366 - Fix timezone issues in test_extract_job

Status: REOPENED

(Tree Management :: Treeherder, defect)

Description

[Armen [:armenzg]]

The error:

E   caused by
E   	ERROR: {
E       "bug_number": 1234567,
E       "created": 1589306273,
E       "modified": 1589306273
E   } does not match expected {
E       "bug_number": 1234567,
E       "created": 1579277905,
E       "modified": 1579277905
E   }

The code failing:

    def test_extract_job(complex_job, extract_job_settings, now):
        source = MySQL(extract_job_settings.source.database)
        extractor = MySqlSnowflakeExtractor(extract_job_settings.source)
        sql = extractor.get_sql(SQL("SELECT " + text(complex_job.id) + " as id"))

        acc = []
        with source.transaction():
            cursor = list(source.query(sql, stream=True, row_tuples=True))
            extractor.construct_docs(cursor, acc.append, False)

        doc = acc[0]
        doc.guid = complex_job.guid
        doc.last_modified = complex_job.last_modified

        assertAlmostEqual(
>           acc, JOB, places=3
        )  # TH MIXES LOCAL TIMEZONE WITH GMT: https://bugzilla.mozilla.org/show_bug.cgi?id=1612

Comment 2

[Kyle Lahnakoski [:ekyle]]

not a duplicate