def test_just_qzone(): rng = api.build('201706171338', '20171010', qzone='America/Denver') query = 'select ${HPDR_from_time(ts)} FROM my_table' assert ( rng.substitute(query) == "select FROM_UTC_TIMESTAMP(TO_UTC_TIMESTAMP(ts, 'UTC'), 'America/Denver') FROM my_table" )
def test_no_tz(): rng = api.build('201706171338', '20171010') query = 'select ${HPDR_from_time(ts)} FROM my_table' assert ( rng.substitute(query) == "select FROM_UTC_TIMESTAMP(TO_UTC_TIMESTAMP(ts, 'UTC'), 'UTC') FROM my_table" )
def compare(begin, end, slop=None, lslop=None, rslop=None, step=None): one = api.build(begin, end, slop=slop, lslop=lslop, rslop=rslop) many = api.build_with_steps(begin, end, slop=slop, lslop=lslop, rslop=rslop, step=step) durations_match(one, many)
def all(dt1, dt2): rng = api.build(dt1, dt2).partition_range p = rng.build_display(pretty=True) d = rng.build_display(pretty=False) print(d) print(p) durations_match(rng, dt1, dt2) assert parse.parse(parse.tokenize(p)) assert parse.parse(parse.tokenize(d))
def build_range_with_zones(): return api.build('201706171338', '20171010', qzone='Asia/Calcutta', dzone='America/New_York')