def test_create_table_from_query_wrong_query(mocker):
# When
with pytest.raises(ValueError) as e:
create_table_from_query('WRONG SQL QUERY', '__new_table_name__')
# Then
assert str(e.value) == 'Wrong query. You should provide a valid SQL query.'
def test_create_table_from_query_wrong_credentials(mocker):
# When
with pytest.raises(ValueError) as e:
create_table_from_query('SELECT * FROM table', '__new_table_name__',
1234)
# Then
assert str(e.value) == 'Credentials attribute is required. Please pass a `Credentials` ' + \
'instance or use the `set_default_credentials` function.'
def test_create_table_from_query_wrong_new_table_name(mocker):
# When
with pytest.raises(ValueError) as e:
create_table_from_query('SELECT * FROM table', 1234)
# Then
assert str(
e.value
) == 'Wrong new table name. You should provide a valid table name.'
def test_create_table_from_query_wrong_if_exists(mocker):
# When
with pytest.raises(ValueError) as e:
create_table_from_query('SELECT * FROM table',
'__new_table_name__',
if_exists='keep_calm')
# Then
assert str(
e.value
) == 'Wrong option for the `if_exists` param. You should provide: fail, replace, append.'