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')