def test_is_dst():
"""SNOW-6020: Failed to convert to local time during DST is being changed."""
# DST to non-DST
convClass = DefaultConverterClass()
conv = convClass()
conv.set_parameter('TIMEZONE', 'America/Los_Angeles')
col_meta = {
'name': 'CREATED_ON',
'type': 6,
'length': None,
'precision': None,
'scale': 3,
'nullable': True,
}
m = conv.to_python_method('TIMESTAMP_LTZ', col_meta)
ret = m('1414890189.000')
assert str(ret) == '2014-11-01 18:03:09-07:00', \
'Timestamp during from DST to non-DST'
# non-DST to DST
col_meta = {
'name': 'CREATED_ON',
'type': 6,
'length': None,
'precision': None,
'scale': 3,
'nullable': True,
}
m = conv.to_python_method('TIMESTAMP_LTZ', col_meta)
ret = m('1425780189.000')
assert str(ret) == '2015-03-07 18:03:09-08:00', \
'Timestamp during from non-DST to DST'
def test_is_dst():
"""SNOW-6020: Failed to convert to local time during DST is being changed."""
# DST to non-DST
convClass = DefaultConverterClass()
conv = convClass()
conv.set_parameter("TIMEZONE", "America/Los_Angeles")
col_meta = {
"name": "CREATED_ON",
"type": 6,
"length": None,
"precision": None,
"scale": 3,
"nullable": True,
}
m = conv.to_python_method("TIMESTAMP_LTZ", col_meta)
ret = m("1414890189.000")
assert (str(ret) == "2014-11-01 18:03:09-07:00"
), "Timestamp during from DST to non-DST"
# non-DST to DST
col_meta = {
"name": "CREATED_ON",
"type": 6,
"length": None,
"precision": None,
"scale": 3,
"nullable": True,
}
m = conv.to_python_method("TIMESTAMP_LTZ", col_meta)
ret = m("1425780189.000")
assert (str(ret) == "2015-03-07 18:03:09-08:00"
), "Timestamp during from non-DST to DST"
def db(**kwargs):
if not kwargs.get(u'timezone'):
kwargs[u'timezone'] = u'UTC'
if not kwargs.get(u'converter_class'):
kwargs[u'converter_class'] = DefaultConverterClass()
cnx = create_connection(**kwargs)
try:
yield cnx
finally:
cnx.close()
def db(**kwargs) -> Generator['SnowflakeConnection', None, None]:
if not kwargs.get('timezone'):
kwargs['timezone'] = 'UTC'
if not kwargs.get('converter_class'):
kwargs['converter_class'] = DefaultConverterClass()
cnx = create_connection(**kwargs)
try:
yield cnx
finally:
cnx.close()
def negative_db(**kwargs):
if not kwargs.get(u'timezone'):
kwargs[u'timezone'] = u'UTC'
if not kwargs.get(u'converter_class'):
kwargs[u'converter_class'] = DefaultConverterClass()
cnx = create_connection(**kwargs)
if not IS_PUBLIC_CI:
cnx.cursor().execute("alter session set SUPPRESS_INCIDENT_DUMPS=true")
try:
yield cnx
finally:
cnx.close()
def negative_db(**kwargs) -> Generator['SnowflakeConnection', None, None]:
if not kwargs.get('timezone'):
kwargs['timezone'] = 'UTC'
if not kwargs.get('converter_class'):
kwargs['converter_class'] = DefaultConverterClass()
cnx = create_connection(**kwargs)
if not is_public_testaccount():
cnx.cursor().execute("alter session set SUPPRESS_INCIDENT_DUMPS=true")
try:
yield cnx
finally:
cnx.close()
def db(
connection_name: str = "default",
**kwargs,
) -> Generator[SnowflakeConnection, None, None]:
if not kwargs.get("timezone"):
kwargs["timezone"] = "UTC"
if not kwargs.get("converter_class"):
kwargs["converter_class"] = DefaultConverterClass()
cnx = create_connection(connection_name, **kwargs)
try:
yield cnx
finally:
cnx.close()
def negative_db(
connection_name: str = "default",
**kwargs,
) -> Generator[SnowflakeConnection, None, None]:
if not kwargs.get("timezone"):
kwargs["timezone"] = "UTC"
if not kwargs.get("converter_class"):
kwargs["converter_class"] = DefaultConverterClass()
cnx = create_connection(connection_name, **kwargs)
if not is_public_testaccount():
cnx.cursor().execute("alter session set SUPPRESS_INCIDENT_DUMPS=true")
try:
yield cnx
finally:
cnx.close()
