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