def test_no_auth(db_parameters):
"""
SNOW-13588: No auth Rest API test
"""
rest = SnowflakeRestful(
host=db_parameters['host'],
port=db_parameters['port'])
try:
# no auth
# show warehouse
rest.request(
url='/queries',
body={
'sequenceId': 10000,
'sqlText': 'show warehouses',
'parameters': {
'ui_mode': True,
},
},
method='post',
client='rest')
raise Exception("Must fail with auth error")
except errors.Error as e:
assert e.errno == errorcode.ER_CONNECTION_IS_CLOSED
finally:
rest.close()
def test_no_auth(db_parameters):
"""SNOW-13588: No auth Rest API test."""
rest = SnowflakeRestful(host=db_parameters["host"],
port=db_parameters["port"])
try:
# no auth
# show warehouse
rest.request(
url="/queries",
body={
"sequenceId": 10000,
"sqlText": "show warehouses",
"parameters": {
"ui_mode": True,
},
},
method="post",
client="rest",
)
raise Exception("Must fail with auth error")
except errors.Error as e:
assert e.errno == errorcode.ER_CONNECTION_IS_CLOSED
finally:
rest.close()
def close_sessions(rest: SnowflakeRestful, num_session_pools: int) -> None:
"""Helper function to call SnowflakeRestful.close(). Asserts close was called on all SessionPools."""
with mock.patch(
"snowflake.connector.network.SessionPool.close") as close_mock:
rest.close()
assert close_mock.call_count == num_session_pools
