def feature(self, node="clickhouse1"):
"""Check alter user query syntax.
```sql
ALTER USER [IF EXISTS] name [ON CLUSTER cluster_name]
[RENAME TO new_name]
[IDENTIFIED [WITH {PLAINTEXT_PASSWORD|SHA256_PASSWORD|DOUBLE_SHA1_PASSWORD}] BY {'password'|'hash'}]
[[ADD|DROP] HOST {LOCAL | NAME 'name' | REGEXP 'name_regexp' | IP 'address' | LIKE 'pattern'} [,...] | ANY | NONE]
[DEFAULT ROLE role [,...] | ALL | ALL EXCEPT role [,...] ]
[SETTINGS variable [= value] [MIN [=] min_value] [MAX [=] max_value] [READONLY|WRITABLE] | PROFILE 'profile_name'] [,...]
```
"""
node = self.context.cluster.node(node)
@contextmanager
def setup(user):
try:
with Given("I have a user"):
node.query(f"CREATE USER OR REPLACE {user}")
yield
finally:
with Finally("I drop the user"):
node.query(f"DROP USER IF EXISTS {user}")
with Scenario("I alter user, base command",
requirements=[RQ_SRS_006_RBAC_User_Alter("1.0")]):
with setup("user0"):
with When("I alter user"):
node.query("ALTER USER user0")
with Scenario(
"I alter user that does not exist without if exists, throws exception",
requirements=[RQ_SRS_006_RBAC_User_Alter("1.0")]):
with When("I run alter user command, expecting error 192"):
exitcode, message = errors.user_not_found_in_disk(name="user0")
node.query(f"ALTER USER user0", exitcode=exitcode, message=message)
with Scenario("I alter user with if exists",
requirements=[RQ_SRS_006_RBAC_User_Alter_IfExists("1.0")]):
with setup("user0"):
with When(f"I alter user with if exists"):
node.query(f"ALTER USER IF EXISTS user0")
with Scenario("I alter user that does not exist with if exists",
requirements=[RQ_SRS_006_RBAC_User_Alter_IfExists("1.0")]):
user = "******"
with Given("I don't have a user"):
node.query(f"DROP USER IF EXISTS {user}")
with When(f"I alter user {user} with if exists"):
node.query(f"ALTER USER IF EXISTS {user}")
del user
with Scenario("I alter user on a cluster",
requirements=[RQ_SRS_006_RBAC_User_Alter_Cluster("1.0")]):
with Given("I have a user on a cluster"):
node.query(
"CREATE USER OR REPLACE user0 ON CLUSTER sharded_cluster")
with When("I alter user on a cluster"):
node.query("ALTER USER user0 ON CLUSTER sharded_cluster")
with Finally("I drop user from cluster"):
node.query("DROP USER IF EXISTS user0 ON CLUSTER sharded_cluster")
with Scenario("I alter user on a fake cluster, throws exception",
requirements=[RQ_SRS_006_RBAC_User_Alter_Cluster("1.0")]):
with When("I alter user on a fake cluster"):
exitcode, message = errors.cluster_not_found("fake_cluster")
node.query("ALTER USER user0 ON CLUSTER fake_cluster",
exitcode=exitcode,
message=message)
with Scenario("I alter user to rename, target available",
requirements=[RQ_SRS_006_RBAC_User_Alter_Rename("1.0")]):
with setup("user15"):
with When("I alter user name"):
node.query("ALTER USER user15 RENAME TO user15")
with Scenario("I alter user to rename, target unavailable",
requirements=[RQ_SRS_006_RBAC_User_Alter_Rename("1.0")]):
with setup("user15"):
new_user = "******"
try:
with Given(f"Ensure target name {new_user} is NOT available"):
node.query(f"CREATE USER IF NOT EXISTS {new_user}")
with When(f"I try to rename to {new_user}"):
exitcode, message = errors.cannot_rename_user(
name="user15", name_new=new_user)
node.query(f"ALTER USER user15 RENAME TO {new_user}",
exitcode=exitcode,
message=message)
finally:
with Finally(f"I cleanup target name {new_user}"):
node.query(f"DROP USER IF EXISTS {new_user}")
del new_user
with Scenario("I alter user password plaintext password",
requirements=[
RQ_SRS_006_RBAC_User_Alter_Password_PlainText("1.0")
]):
with setup("user1"):
with When("I alter user with plaintext password"):
node.query(
"ALTER USER user1 IDENTIFIED WITH PLAINTEXT_PASSWORD BY 'mypassword'",
step=When)
with Scenario("I alter user password to sha256",
requirements=[
RQ_SRS_006_RBAC_User_Alter_Password_Sha256Password("1.0")
]):
with setup("user2"):
with When("I alter user with sha256_password"):
password = hashlib.sha256(
"mypassword".encode("utf-8")).hexdigest()
node.query(
f"ALTER USER user2 IDENTIFIED WITH SHA256_PASSWORD BY '{password}'",
step=When)
with Scenario(
"I alter user password to double_sha1_password",
requirements=[
RQ_SRS_006_RBAC_User_Alter_Password_DoubleSha1Password("1.0")
]):
with setup("user3"):
with When("I alter user with double_sha1_password"):
def hash(password):
return hashlib.sha1(password.encode("utf-8")).hexdigest()
password = hash(hash("mypassword"))
node.query(
f"ALTER USER user3 IDENTIFIED WITH DOUBLE_SHA1_PASSWORD BY '{password}'",
step=When)
with Scenario("I alter user host local",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_Local("1.0")]):
with setup("user4"):
with When("I alter user with host local"):
node.query("ALTER USER user4 HOST LOCAL")
with Scenario("I alter user host name",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_Name("1.0")]):
with setup("user5"):
with When("I alter user with host name"):
node.query(
"ALTER USER user5 HOST NAME 'localhost', NAME 'clickhouse.com'"
)
with Scenario("I alter user host regexp",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_Regexp("1.0")
]):
with setup("user6"):
with When("I alter user with host regexp"):
node.query(
"ALTER USER user6 HOST REGEXP 'lo..*host', 'lo*host'")
with Scenario("I alter user host ip",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_IP("1.0")]):
with setup("user7"):
with When("I alter user with host ip"):
node.query(
"ALTER USER user7 HOST IP '127.0.0.1', IP '127.0.0.2'")
with Scenario("I alter user host like",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_Like("1.0")]):
with setup("user8"):
with When("I alter user with host like"):
node.query("ALTER USER user8 HOST LIKE '%.clickhouse.com'")
with Scenario("I alter user host any",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_Any("1.0")]):
with setup("user9"):
with When("I alter user with host any"):
node.query("ALTER USER user9 HOST ANY")
with Scenario("I alter user host many hosts",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_Like("1.0")]):
with setup("user11"):
with When("I alter user with multiple hosts"):
node.query("ALTER USER user11 HOST LIKE '%.clickhouse.com', \
IP '127.0.0.2', NAME 'localhost', REGEXP 'lo*host'")
with Scenario("I alter user default role set to none",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_None("1.0")]):
with setup("user12"):
with When("I alter user with default role none"):
node.query("ALTER USER user12 DEFAULT ROLE NONE")
with Scenario(
"I alter user default role set to all",
requirements=[RQ_SRS_006_RBAC_User_Alter_DefaultRole_All("1.0")]):
with setup("user13"):
with When("I alter user with all roles set to default"):
node.query("ALTER USER user13 DEFAULT ROLE ALL")
@contextmanager
def setup_role(role):
try:
with Given(f"I have a role {role}"):
node.query(f"CREATE ROLE OR REPLACE {role}")
yield
finally:
with Finally(f"I drop the role {role}", flags=TE):
node.query(f"DROP ROLE IF EXISTS {role}")
with Scenario("I alter user default role",
requirements=[RQ_SRS_006_RBAC_User_Alter_DefaultRole("1.0")
]):
with setup("user14"), setup_role("role2"):
with Given("I have a user with a role"):
node.query("GRANT role2 TO user14")
with When("I alter user default role"):
node.query("ALTER USER user14 DEFAULT ROLE role2")
with Scenario("I alter user default role, setting default role",
requirements=[RQ_SRS_006_RBAC_User_Alter_DefaultRole("1.0")
]):
with setup("user14a"), setup_role("default"):
with Given("I grant default role to the user"):
node.query("GRANT default TO user14a")
with When("I alter user default role"):
node.query("ALTER USER user14a DEFAULT ROLE default")
with Scenario(
"I alter user default role, role doesn't exist, throws exception",
requirements=[RQ_SRS_006_RBAC_User_Alter_DefaultRole("1.0")]):
with setup("user12"):
role = "role0"
with Given(f"I ensure that role {role} does not exist"):
node.query(f"DROP ROLE IF EXISTS {role}")
with When(f"I alter user with default role {role}"):
exitcode, message = errors.role_not_found_in_disk(role)
node.query(f"ALTER USER user12 DEFAULT ROLE {role}",
exitcode=exitcode,
message=message)
del role
with Scenario(
"I alter user default role, all except role doesn't exist, throws exception",
requirements=[RQ_SRS_006_RBAC_User_Alter_DefaultRole("1.0")]):
with setup("user12"):
role = "role0"
with Given(f"I ensure that role {role} does not exist"):
node.query(f"DROP ROLE IF EXISTS {role}")
with When(f"I alter user with default role {role}"):
exitcode, message = errors.role_not_found_in_disk(role)
node.query(f"ALTER USER user12 DEFAULT ROLE ALL EXCEPT {role}",
exitcode=exitcode,
message=message)
del role
with Scenario("I alter user default role multiple",
requirements=[RQ_SRS_006_RBAC_User_Alter_DefaultRole("1.0")
]):
with setup("user15"), setup_role("second"), setup_role("third"):
with Given("I have a user with multiple roles"):
node.query("GRANT second,third TO user15")
with When("I alter user default role to second, third"):
node.query("ALTER USER user15 DEFAULT ROLE second, third")
with Scenario("I alter user default role set to all except",
requirements=[
RQ_SRS_006_RBAC_User_Alter_DefaultRole_AllExcept("1.0")
]):
with setup("user16"), setup_role("second"):
with Given("I have a user with a role"):
node.query("GRANT second TO user16")
with When("I alter user default role"):
node.query("ALTER USER user16 DEFAULT ROLE ALL EXCEPT second")
with Scenario("I alter user default role multiple all except",
requirements=[
RQ_SRS_006_RBAC_User_Alter_DefaultRole_AllExcept("1.0")
]):
with setup("user17"), setup_role("second"), setup_role("third"):
with Given("I have a user with multiple roles"):
node.query("GRANT second,third TO user17")
with When("I alter user default role to all except second"):
node.query("ALTER USER user17 DEFAULT ROLE ALL EXCEPT second")
with Scenario("I alter user settings profile", requirements=[
RQ_SRS_006_RBAC_User_Alter_Settings("1.0"), \
RQ_SRS_006_RBAC_User_Alter_Settings_Profile("1.0")]):
with setup("user18"):
try:
with Given("I have a profile"):
node.query(f"CREATE SETTINGS PROFILE profile10")
with When(
"I alter user with settings and set profile to profile1"
):
node.query(
"ALTER USER user18 SETTINGS PROFILE profile10, max_memory_usage = 100 MIN 0 MAX 1000 READONLY"
)
finally:
with Finally("I drop the profile"):
node.query(f"DROP SETTINGS PROFILE profile10")
with Scenario(
"I alter user settings profile, fake profile, throws exception",
requirements=[
RQ_SRS_006_RBAC_User_Alter_Settings("1.0"),
RQ_SRS_006_RBAC_User_Alter_Settings_Profile("1.0")
]):
with setup("user18a"):
profile = "profile0"
with Given(f"I ensure that profile {profile} does not exist"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
with When(
f"I alter user with Settings and set profile to fake profile {profile}"
):
exitcode, message = errors.settings_profile_not_found_in_disk(
profile)
node.query("ALTER USER user18a SETTINGS PROFILE profile0",
exitcode=exitcode,
message=message)
del profile
with Scenario(
"I alter user settings with a fake setting, throws exception",
requirements=[RQ_SRS_006_RBAC_User_Alter_Settings("1.0")]):
with setup("user18b"):
with When(
"I alter settings profile using settings and nonexistent value"
):
exitcode, message = errors.unknown_setting("fake_setting")
node.query(
"ALTER USER user18b SETTINGS fake_setting = 100000001",
exitcode=exitcode,
message=message)
with Scenario("I alter user settings without profile (no equals)",
requirements=[
RQ_SRS_006_RBAC_User_Alter_Settings("1.0"),
RQ_SRS_006_RBAC_User_Alter_Settings_Min("1.0"),
RQ_SRS_006_RBAC_User_Alter_Settings_Max("1.0")
]):
with setup("user19"):
with When(
"I alter user with settings without profile using no equals"
):
node.query(
"ALTER USER user19 SETTINGS max_memory_usage=10000000 MIN 100000 MAX 1000000000 READONLY"
)
#equals sign (=) syntax verify
with Scenario("I alter user settings without profile (yes equals)",
requirements=[
RQ_SRS_006_RBAC_User_Alter_Settings("1.0"),
RQ_SRS_006_RBAC_User_Alter_Settings_Min("1.0"),
RQ_SRS_006_RBAC_User_Alter_Settings_Max("1.0")
]):
with setup("user20"):
with When(
"I alter user with settings without profile using equals"):
node.query(
"ALTER USER user20 SETTINGS max_memory_usage=10000000 MIN=100000 MAX=1000000000 READONLY"
)
#Add requirement to host: add/drop
with Scenario(
"I alter user to add host",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_AddDrop("1.0")]):
with setup("user21"):
with When("I alter user by adding local host"):
node.query("ALTER USER user21 ADD HOST LOCAL")
with And("I alter user by adding no host"):
node.query("ALTER USER user21 ADD HOST NONE")
with And("I alter user by adding host like"):
node.query("ALTER USER user21 ADD HOST LIKE 'local%'")
with And("I alter user by adding host ip"):
node.query("ALTER USER user21 ADD HOST IP '127.0.0.1'")
with And("I alter user by adding host name"):
node.query("ALTER USER user21 ADD HOST NAME 'localhost'")
with Scenario(
"I alter user to remove host",
requirements=[RQ_SRS_006_RBAC_User_Alter_Host_AddDrop("1.0")]):
with setup("user22"):
with When("I alter user by removing local host"):
node.query("ALTER USER user22 DROP HOST LOCAL")
with And("I alter user by removing no host"):
node.query("ALTER USER user22 DROP HOST NONE")
with And("I alter user by removing like host"):
node.query("ALTER USER user22 DROP HOST LIKE 'local%'")
with And("I alter user by removing host ip"):
node.query("ALTER USER user22 DROP HOST IP '127.0.0.1'")
with And("I alter user by removing host name"):
node.query("ALTER USER user22 DROP HOST NAME 'localhost'")
def feature(self, node="clickhouse1"):
"""Check alter settings profile query syntax.
```sql
ALTER SETTINGS PROFILE [IF EXISTS] name
[ON CLUSTER cluster_name]
[RENAME TO new_name]
[SETTINGS variable [= value] [MIN [=] min_value] [MAX [=] max_value] [READONLY|WRITABLE] | INHERIT 'profile_name'] [,...]
[TO {user_or_role [,...] | NONE | ALL | ALL EXCEPT user_or_role [,...]]}
```
"""
node = self.context.cluster.node(node)
def cleanup_profile(profile):
with Given(f"I ensure that profile {profile} does not exist"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
try:
with Given("I have a profile and some users and roles"):
node.query(f"CREATE SETTINGS PROFILE profile0")
node.query(f"CREATE USER user0")
node.query(f"CREATE ROLE role0")
with Scenario("I alter settings profile with no options", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter("1.0")]):
with When("I alter settings profile"):
node.query("ALTER SETTINGS PROFILE profile0")
with Scenario("I alter settings profile short form", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter("1.0")]):
with When("I short form alter settings profile"):
node.query("ALTER PROFILE profile0")
with Scenario("I alter settings profile that does not exist, throws exception", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter("1.0")]):
profile = "profile1"
cleanup_profile(profile)
with When(f"I alter settings profile {profile} that doesn't exist"):
exitcode, message = errors.settings_profile_not_found_in_disk(name=profile)
node.query(f"ALTER SETTINGS PROFILE {profile}", exitcode=exitcode, message=message)
del profile
with Scenario("I alter settings profile if exists", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter_IfExists("1.0")]):
with When("I alter settings profile using if exists"):
node.query("ALTER SETTINGS PROFILE IF EXISTS profile0")
with Scenario("I alter settings profile if exists, profile does not exist", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter_IfExists("1.0")]):
profile = "profile1"
cleanup_profile(profile)
with When(f"I alter settings profile {profile} using if exists"):
node.query(f"ALTER SETTINGS PROFILE IF EXISTS {profile}")
del profile
with Scenario("I alter settings profile to rename, target available", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter_Rename("1.0")]):
with When("I alter settings profile by renaming it"):
node.query("ALTER SETTINGS PROFILE profile0 RENAME TO profile0")
with Scenario("I alter settings profile to rename, target unavailable", requirements=[RQ_SRS_006_RBAC_SettingsProfile_Alter_Rename("1.0")]):
new_profile = "profile1"
try:
with Given(f"Ensure target name {new_profile} is NOT available"):
node.query(f"CREATE SETTINGS PROFILE IF NOT EXISTS {new_profile}")
with When(f"I try to rename to {new_profile}"):
exitcode, message = errors.cannot_rename_settings_profile(name="profile0", name_new=new_profile)
node.query(f"ALTER SETTINGS PROFILE profile0 RENAME TO {new_profile}", exitcode=exitcode, message=message)
finally:
with Finally(f"I cleanup target name {new_profile}"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {new_profile}")
del new_profile
with Scenario("I alter settings profile with a setting value", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables("1.0"),
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Value("1.0")]):
with When("I alter settings profile using settings"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage = 100000001")
with Scenario("I alter settings profile with a setting value, does not exist, throws exception", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables("1.0"),
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Value("1.0")]):
with When("I alter settings profile using settings and nonexistent value"):
exitcode, message = errors.unknown_setting("fake_setting")
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS fake_setting = 100000001", exitcode=exitcode, message=message)
with Scenario("I alter settings profile with a min setting value", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Constraints("1.0")]):
with When("I alter settings profile using 2 minimum formats"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage MIN 100000001")
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage MIN = 100000001")
with Scenario("I alter settings profile with a max setting value", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Constraints("1.0")]):
with When("I alter settings profile using 2 maximum formats"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage MAX 100000001")
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage MAX = 100000001")
with Scenario("I alter settings profile with min and max setting values", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Constraints("1.0")]):
with When("I alter settings profile with both min and max"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage MIN 100000001 MAX 200000001")
with Scenario("I alter settings profile with a readonly setting", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Constraints("1.0")]):
with When("I alter settings profile with with readonly"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage READONLY")
with Scenario("I alter settings profile with a writable setting", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Constraints("1.0")]):
with When("I alter settings profile with writable"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS max_memory_usage WRITABLE")
with Scenario("I alter settings profile with inherited settings", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_Inherit("1.0")]):
with When("I alter settings profile with inherit"):
node.query("ALTER SETTINGS PROFILE profile0 SETTINGS INHERIT 'default'")
with Scenario("I alter settings profile with inherit, parent profile does not exist, throws exception", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_Inherit("1.0")]):
profile = "profile3"
with Given(f"I ensure that profile {profile} does not exist"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
with When("I alter settings profile inherit from nonexistant parent"):
exitcode, message = errors.settings_profile_not_found_in_disk(profile)
node.query(f"ALTER PROFILE profile0 SETTINGS INHERIT {profile}", exitcode=exitcode, message=message)
del profile
with Scenario("I alter settings profile with multiple settings", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables("1.0"),
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Value("1.0")]):
with When("I alter settings profile with multiple settings"):
node.query("ALTER SETTINGS PROFILE profile0"
" SETTINGS max_memory_usage = 100000001"
" SETTINGS max_memory_usage_for_user = 100000001")
with Scenario("I alter settings profile with multiple settings short form", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables("1.0"),
RQ_SRS_006_RBAC_SettingsProfile_Alter_Variables_Value("1.0")]):
with When("I alter settings profile with short form multiple settings"):
node.query("ALTER SETTINGS PROFILE profile0"
" SETTINGS max_memory_usage = 100000001,"
" max_memory_usage_for_user = 100000001")
with Scenario("I alter settings profile assigned to one role", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment("1.0")]):
with When("I alter settings profile with assignment to role"):
node.query("ALTER SETTINGS PROFILE profile0 TO role0")
with Scenario("I alter settings profile to assign to role that does not exist, throws exception", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment("1.0")]):
role = "role1"
with Given(f"I drop {role} if it exists"):
node.query(f"DROP ROLE IF EXISTS {role}")
with Then(f"I alter a settings profile, assign to role {role}, which does not exist"):
exitcode, message = errors.role_not_found_in_disk(name=role)
node.query(f"ALTER SETTINGS PROFILE profile0 TO {role}", exitcode=exitcode, message=message)
del role
with Scenario("I alter settings profile to assign to all except role that does not exist, throws exception", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment("1.0")]):
role = "role1"
with Given(f"I drop {role} if it exists"):
node.query(f"DROP ROLE IF EXISTS {role}")
with Then(f"I alter a settings profile, assign to all except role {role}, which does not exist"):
exitcode, message = errors.role_not_found_in_disk(name=role)
node.query(f"ALTER SETTINGS PROFILE profile0 TO ALL EXCEPT {role}", exitcode=exitcode, message=message)
del role
with Scenario("I alter settings profile assigned to multiple roles", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment("1.0")]):
with When("I alter settings profile with assignment to multiple roles"):
node.query("ALTER SETTINGS PROFILE profile0 TO role0, user0")
with Scenario("I alter settings profile assigned to all", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_All("1.0")]):
with When("I alter settings profile with assignment to all"):
node.query("ALTER SETTINGS PROFILE profile0 TO ALL")
with Scenario("I alter settings profile assigned to all except one role", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_AllExcept("1.0")]):
with When("I alter settings profile with assignment to all except a role"):
node.query("ALTER SETTINGS PROFILE profile0 TO ALL EXCEPT role0")
with Scenario("I alter settings profile assigned to all except multiple roles", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_AllExcept("1.0")]):
with When("I alter settings profile with assignmentto all except multiple roles"):
node.query("ALTER SETTINGS PROFILE profile0 TO ALL EXCEPT role0, user0")
with Scenario("I alter settings profile assigned to none", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_None("1.0")]):
with When("I alter settings profile with assignment to none"):
node.query("ALTER SETTINGS PROFILE profile0 TO NONE")
with Scenario("I alter settings profile on cluster", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_OnCluster("1.0")]):
try:
with Given("I have a settings profile on cluster"):
node.query("CREATE SETTINGS PROFILE profile1 ON CLUSTER sharded_cluster")
with When("I run alter settings profile command"):
node.query("ALTER SETTINGS PROFILE profile1 ON CLUSTER sharded_cluster")
with And("I alter settings profile with settings"):
node.query("ALTER SETTINGS PROFILE profile1 ON CLUSTER sharded_cluster SETTINGS max_memory_usage = 100000001")
with And("I alter settings profile with inherit"):
node.query("ALTER SETTINGS PROFILE profile1 ON CLUSTER sharded_cluster SETTINGS INHERIT 'default'")
with And("I alter settings profile to all"):
node.query("ALTER SETTINGS PROFILE profile1 ON CLUSTER sharded_cluster TO ALL")
finally:
with Finally("I drop the settings profile"):
node.query("DROP SETTINGS PROFILE IF EXISTS profile1 ON CLUSTER sharded_cluster")
with Scenario("I alter settings profile on fake cluster, throws exception", requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Alter_Assignment_OnCluster("1.0")]):
with When("I run alter settings profile command"):
exitcode, message = errors.cluster_not_found("fake_cluster")
node.query("ALTER SETTINGS PROFILE profile1 ON CLUSTER fake_cluster", exitcode=exitcode, message=message)
finally:
with Finally("I drop the profile and all the users and roles"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS profile0")
node.query(f"DROP USER IF EXISTS user0")
node.query(f"DROP ROLE IF EXISTS role0")
def feature(self, node="clickhouse1"):
"""Check alter role query syntax.
```sql
ALTER ROLE [IF EXISTS] name [ON CLUSTER cluster_name]
[RENAME TO new_name]
[SETTINGS variable [= value] [MIN [=] min_value] [MAX [=] max_value] [READONLY|WRITABLE] | PROFILE 'profile_name'] [,...]
```
"""
node = self.context.cluster.node(node)
@contextmanager
def setup(role, profile=None):
try:
with Given("I have a role"):
node.query(f"CREATE ROLE OR REPLACE {role}")
if profile != None: # create profile when name is given
with Given("And I have a profile"):
node.query(f"CREATE SETTINGS PROFILE OR REPLACE {profile}")
yield
finally:
with Finally("I drop the role"):
node.query(f"DROP ROLE IF EXISTS {role}")
if profile != "":
with Finally("I drop the profile"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
def cleanup_role(role):
with Given(f"I ensure that role {role} does not exist"):
node.query(f"DROP ROLE IF EXISTS {role}")
with Scenario("I alter role with no options",
requirements=[RQ_SRS_006_RBAC_Role_Alter("1.0")]):
with setup("role0"):
with When("I alter role"):
node.query("ALTER ROLE role0")
with Scenario(
"I alter role that does not exist, throws exception",
requirements=[RQ_SRS_006_RBAC_Role_Alter("1.0")],
):
role = "role0"
cleanup_role(role)
with When(f"I alter role {role} that does not exist"):
exitcode, message = errors.role_not_found_in_disk(name=role)
node.query(f"ALTER ROLE {role}",
exitcode=exitcode,
message=message)
del role
with Scenario(
"I alter role if exists, role does exist",
requirements=[RQ_SRS_006_RBAC_Role_Alter_IfExists("1.0")],
):
with setup("role1"):
with When("I alter role with if exists"):
node.query("ALTER ROLE IF EXISTS role1")
with Scenario(
"I alter role if exists, role does not exist",
requirements=[RQ_SRS_006_RBAC_Role_Alter_IfExists("1.0")],
):
role = "role0"
cleanup_role(role)
with When(f"I alter role {role} that does not exist"):
node.query(f"ALTER ROLE IF EXISTS {role}")
del role
with Scenario(
"I alter role on cluster",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Cluster("1.0")],
):
try:
with Given("I have a role on a cluster"):
node.query("CREATE ROLE role1 ON CLUSTER sharded_cluster")
with When("I run alter role on a cluster"):
node.query("ALTER ROLE role1 ON CLUSTER sharded_cluster")
with And("I rename role on a cluster"):
node.query(
"ALTER ROLE role1 ON CLUSTER sharded_cluster RENAME TO role2"
)
with And("I alter role with settings on a cluster"):
node.query(
"ALTER ROLE role2 ON CLUSTER sharded_cluster SETTINGS max_memory_usage=10000000 READONLY"
)
finally:
with Finally("I drop the role"):
node.query(
"DROP ROLE IF EXISTS role1,role2 ON CLUSTER sharded_cluster"
)
with Scenario(
"I alter role on nonexistent cluster, throws exception",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Cluster("1.0")],
):
with When("I run alter role on a cluster"):
exitcode, message = errors.cluster_not_found("fake_cluster")
node.query(
"ALTER ROLE role1 ON CLUSTER fake_cluster",
exitcode=exitcode,
message=message,
)
with Scenario(
"I alter role to rename, new name is available",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Rename("1.0")],
):
with setup("role2"):
new_role = "role3"
try:
with Given(f"Ensure target name {new_role} is available"):
node.query(f"DROP ROLE IF EXISTS {new_role}")
with When(f"I try to rename to {new_role}"):
node.query(f"ALTER ROLE role2 RENAME TO {new_role}")
finally:
with Finally(f"I cleanup new name {new_role}"):
node.query(f"DROP ROLE IF EXISTS {new_role}")
del new_role
with Scenario(
"I alter role to rename, new name is not available, throws exception",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Rename("1.0")],
):
with setup("role2a"):
new_role = "role3a"
try:
with Given(f"Ensure target name {new_role} is NOT available"):
node.query(f"CREATE ROLE IF NOT EXISTS {new_role}")
with When(f"I try to rename to {new_role}"):
exitcode, message = errors.cannot_rename_role(
name="role2a", name_new=new_role)
node.query(
f"ALTER ROLE role2a RENAME TO {new_role}",
exitcode=exitcode,
message=message,
)
finally:
with Finally(f"I cleanup target name {new_role}"):
node.query(f"DROP ROLE IF EXISTS {new_role}")
del new_role
with Scenario(
"I alter role settings profile",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role4"):
with When("I alter role with settings profile"):
node.query(
"ALTER ROLE role4 SETTINGS PROFILE default, max_memory_usage=10000000 READONLY"
)
with Scenario(
"I alter role settings profile, profile does not exist, throws exception",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role4a"):
with Given("I ensure profile profile0 does not exist"):
node.query("DROP SETTINGS PROFILE IF EXISTS profile0")
with When(
"I alter role with settings profile that does not exist"):
exitcode, message = errors.settings_profile_not_found_in_disk(
"profile0")
node.query(
"ALTER ROLE role4a SETTINGS PROFILE profile0",
exitcode=exitcode,
message=message,
)
with Scenario(
"I alter role settings profile multiple",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role4b", profile="profile0"):
with When("I alter role with multiple profiles"):
node.query(
"ALTER ROLE role4b SETTINGS PROFILE default, PROFILE profile0, \
max_memory_usage=10000000 READONLY")
with Scenario(
"I alter role settings without profile",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role5"):
with When("I alter role with settings and no profile"):
node.query(
"ALTER ROLE role5 SETTINGS max_memory_usage=10000000 READONLY"
)
with Scenario(
"I alter role settings, variable does not exist, throws exception",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role5a"):
with When("I alter role using settings and nonexistent value"):
exitcode, message = errors.unknown_setting("fake_setting")
node.query(
"ALTER ROLE role5a SETTINGS fake_setting = 100000001",
exitcode=exitcode,
message=message,
)
with Scenario(
"I alter role settings without profile multiple",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role6"):
with When("I alter role with multiple settings and no profile"):
node.query(
"ALTER ROLE role6 SETTINGS max_memory_usage=10000000 READONLY, \
max_rows_to_read MIN 20 MAX 25")
with Scenario(
"I alter role settings with multiple profiles multiple variables",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role7", profile="profile1"):
with When("I alter role with multiple settings and profiles"):
node.query(
"ALTER ROLE role7 SETTINGS PROFILE default, PROFILE profile1, \
max_memory_usage=10000000 READONLY, max_rows_to_read MIN 20 MAX 25"
)
with Scenario(
"I alter role settings readonly",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role8"):
with When("I alter role with readonly"):
node.query(
"ALTER ROLE role8 SETTINGS max_memory_usage READONLY")
with Scenario(
"I alter role settings writable",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role9"):
with When("I alter role with writable"):
node.query(
"ALTER ROLE role9 SETTINGS max_memory_usage WRITABLE")
with Scenario(
"I alter role settings min, with and without = sign",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role10"):
with When("I set min, no equals"):
node.query(
"ALTER ROLE role10 SETTINGS max_memory_usage MIN 200")
with When("I set min, yes equals"):
node.query(
"ALTER ROLE role10 SETTINGS max_memory_usage MIN = 200")
with Scenario(
"I alter role settings max, with and without = sign",
requirements=[RQ_SRS_006_RBAC_Role_Alter_Settings("1.0")],
):
with setup("role11"):
with When("I set max, no equals"):
node.query(
"ALTER ROLE role11 SETTINGS max_memory_usage MAX 2000")
with When("I set max, yes equals"):
node.query(
"ALTER ROLE role11 SETTINGS max_memory_usage MAX = 200")
def feature(self, node="clickhouse1"):
"""Check create user query syntax.
```sql
CREATE USER [IF NOT EXISTS | OR REPLACE] name [ON CLUSTER cluster_name]
[IDENTIFIED [WITH {NO_PASSWORD|PLAINTEXT_PASSWORD|SHA256_PASSWORD|SHA256_HASH|DOUBLE_SHA1_PASSWORD|DOUBLE_SHA1_HASH}] BY {'password'|'hash'}]
[HOST {LOCAL | NAME 'name' | NAME REGEXP 'name_regexp' | IP 'address' | LIKE 'pattern'} [,...] | ANY | NONE]
[DEFAULT ROLE role [,...]]
[SETTINGS variable [= value] [MIN [=] min_value] [MAX [=] max_value] [READONLY|WRITABLE] | PROFILE 'profile_name'] [,...]
```
"""
node = self.context.cluster.node(node)
@contextmanager
def cleanup(user):
try:
with Given("I ensure the user does not already exist", flags=TE):
node.query(f"DROP USER IF EXISTS {user}")
yield
finally:
with Finally("I drop the user", flags=TE):
node.query(f"DROP USER IF EXISTS {user}")
def create_user(user):
with Given(f"I ensure I do have user {user}"):
node.query(f"CREATE USER OR REPLACE {user}")
with Scenario("I create user with no options",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create("1.0"),
RQ_SRS_006_RBAC_User_Create_Host_Default("1.0")
]):
with cleanup("user0"):
with When("I create a user with no options"):
node.query("CREATE USER user0")
with Scenario("I create user that already exists, throws exception",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create("1.0"),
RQ_SRS_006_RBAC_User_Create_Host_Default("1.0")
]):
user = "******"
with cleanup(user):
create_user(user)
with When(
f"I create a user {user} that already exists without IF EXISTS, throws exception"
):
exitcode, message = errors.cannot_insert_user(name=user)
node.query(f"CREATE USER {user}",
exitcode=exitcode,
message=message)
del user
with Scenario(
"I create user with if not exists, user does not exist",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_IfNotExists("1.0")]):
user = "******"
with cleanup(user):
with When(f"I create a user {user} with if not exists"):
node.query(f"CREATE USER IF NOT EXISTS {user}")
del user
#Bug exists, mark as xfail
with Scenario(
"I create user with if not exists, user does exist",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_IfNotExists("1.0")]):
user = "******"
with cleanup(user):
create_user(user)
with When(f"I create a user {user} with if not exists"):
node.query(f"CREATE USER IF NOT EXISTS {user}")
del user
with Scenario("I create user or replace, user does not exist",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Replace("1.0")]):
user = "******"
with cleanup(user):
with When(f"I create a user {user} with or replace"):
node.query(f"CREATE USER OR REPLACE {user}")
del user
with Scenario("I create user or replace, user does exist",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Replace("1.0")]):
user = "******"
with cleanup(user):
create_user(user)
with When(f"I create a user {user} with or replace"):
node.query(f"CREATE USER OR REPLACE {user}")
del user
with Scenario("I create user with no password",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_NoPassword("1.0")
]):
with cleanup("user1"):
with When("I create a user with no password"):
node.query("CREATE USER user1 IDENTIFIED WITH NO_PASSWORD")
with Scenario("I create user with plaintext password",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_PlainText("1.0")
]):
with cleanup("user1"):
with When("I create a user with plaintext password"):
node.query(
"CREATE USER user1 IDENTIFIED WITH PLAINTEXT_PASSWORD BY 'mypassword'"
)
with Scenario(
"I create user with sha256 password",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_Sha256Password("1.0")
]):
with cleanup("user2"):
with When("I create a user with sha256 password"):
password = hashlib.sha256(
"mypassword".encode("utf-8")).hexdigest()
node.query(
f"CREATE USER user2 IDENTIFIED WITH SHA256_PASSWORD BY '{password}'"
)
with Scenario(
"I create user with sha256 password using IDENTIFIED BY",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_Sha256Password("1.0")
]):
with cleanup("user2"):
with When("I create a user with sha256 password using short form"):
password = hashlib.sha256(
"mypassword".encode("utf-8")).hexdigest()
node.query(f"CREATE USER user2 IDENTIFIED BY '{password}'")
with Scenario("I create user with sha256_hash password",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_Sha256Hash("1.0")
]):
with cleanup("user3"):
with When("I create a user with sha256_hash"):
def hash(password):
return hashlib.sha256(password.encode("utf-8")).hexdigest()
password = hash(hash("mypassword"))
node.query(
f"CREATE USER user3 IDENTIFIED WITH SHA256_HASH BY '{password}'"
)
with Scenario(
"I create user with double sha1 password",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_DoubleSha1Password("1.0")
]):
with cleanup("user3"):
with When("I create a user with double_sha1_password"):
node.query(
f"CREATE USER user3 IDENTIFIED WITH DOUBLE_SHA1_PASSWORD BY 'mypassword'"
)
with Scenario(
"I create user with double sha1 hash",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_Password_DoubleSha1Hash("1.0")
]):
with cleanup("user3"):
with When("I create a user with double_sha1_hash"):
def hash(password):
return hashlib.sha1(password.encode("utf-8")).hexdigest()
password = hash(hash("mypassword"))
node.query(
f"CREATE USER user3 IDENTIFIED WITH DOUBLE_SHA1_HASH BY '{password}'"
)
with Scenario("I create user with host name",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_Name("1.0")]):
with cleanup("user4"):
with When("I create a user with host name"):
node.query(
"CREATE USER user4 HOST NAME 'localhost', NAME 'clickhouse.com'"
)
with Scenario(
"I create user with host regexp",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_Regexp("1.0")]):
with cleanup("user5"):
with When("I create a user with host regexp"):
node.query(
"CREATE USER user5 HOST REGEXP 'lo.?*host', REGEXP 'lo*host'"
)
with Scenario("I create user with host ip",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_IP("1.0")]):
with cleanup("user6"):
with When("I create a user with host ip"):
node.query(
"CREATE USER user6 HOST IP '127.0.0.1', IP '127.0.0.2'")
with Scenario("I create user with host like",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_Like("1.0")]):
with cleanup("user7"):
with When("I create a user with host like"):
node.query("CREATE USER user7 HOST LIKE 'local%'")
with Scenario("I create user with host none",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_None("1.0")]):
with cleanup("user7"):
with When("I create a user with host none"):
node.query("CREATE USER user7 HOST NONE")
with Scenario("I create user with host local",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_Local("1.0")
]):
with cleanup("user7"):
with When("I create a user with host local"):
node.query("CREATE USER user7 HOST LOCAL")
with Scenario("I create user with host any",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Host_Any("1.0")]):
with cleanup("user7"):
with When("I create a user with host any"):
node.query("CREATE USER user7 HOST ANY")
with Scenario("I create user with default role set to none",
flags=TE,
requirements=[
RQ_SRS_006_RBAC_User_Create_DefaultRole_None("1.0")
]):
with cleanup("user8"):
with When("I create a user with no default role"):
node.query("CREATE USER user8 DEFAULT ROLE NONE")
with Scenario(
"I create user with default role",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_DefaultRole("1.0")]):
with Given("I have a role"):
node.query("CREATE ROLE default")
with cleanup("user9"):
with When("I create a user with a default role"):
node.query("CREATE USER user9 DEFAULT ROLE default")
with Finally("I drop the role"):
node.query("DROP ROLE default")
with Scenario(
"I create user default role, role doesn't exist, throws exception",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_DefaultRole("1.0")]):
with cleanup("user12"):
role = "role0"
with Given(f"I ensure that role {role} does not exist"):
node.query(f"DROP ROLE IF EXISTS {role}")
with When(f"I create user with default role {role}"):
exitcode, message = errors.role_not_found_in_disk(role)
node.query(f"CREATE USER user12 DEFAULT ROLE {role}",
exitcode=exitcode,
message=message)
del role
with Scenario(
"I create user default role, all except role doesn't exist, throws exception",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_DefaultRole("1.0")]):
with cleanup("user12"):
role = "role0"
with Given(f"I ensure that role {role} does not exist"):
node.query(f"DROP ROLE IF EXISTS {role}")
with When(f"I create user with default role {role}"):
exitcode, message = errors.role_not_found_in_disk(role)
node.query(
f"CREATE USER user12 DEFAULT ROLE ALL EXCEPT {role}",
exitcode=exitcode,
message=message)
del role
with Scenario(
"I create user with all roles set to default",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_DefaultRole_All("1.0")]):
with cleanup("user10"):
with When("I create a user with all roles as default"):
node.query("CREATE USER user10 DEFAULT ROLE ALL")
with Scenario("I create user with settings profile",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Settings("1.0")]):
with cleanup("user11"):
with When("I create a user with a settings profile"):
node.query(
"CREATE USER user11 SETTINGS PROFILE default, max_memory_usage=10000000 READONLY"
)
with Scenario(
"I create user settings profile, fake profile, throws exception",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Settings("1.0")]):
with cleanup("user18a"):
profile = "profile0"
with Given(f"I ensure that profile {profile} does not exist"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
with When(
f"I create user with Settings and set profile to fake profile {profile}"
):
exitcode, message = errors.settings_profile_not_found_in_disk(
profile)
node.query("CREATE USER user18a SETTINGS PROFILE profile0",
exitcode=exitcode,
message=message)
del profile
with Scenario(
"I create user settings with a fake setting, throws exception",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Settings("1.0")]):
with cleanup("user18b"):
with When(
"I create settings profile using settings and nonexistent value"
):
exitcode, message = errors.unknown_setting("fake_setting")
node.query(
"CREATE USER user18b SETTINGS fake_setting = 100000001",
exitcode=exitcode,
message=message)
with Scenario("I create user with settings without profile",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_Settings("1.0")]):
with cleanup("user12"):
with When("I create a user with settings and no profile"):
node.query(
"CREATE USER user12 SETTINGS max_memory_usage=10000000 READONLY"
)
with Scenario("I create user on cluster",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_OnCluster("1.0")]):
try:
with When("I create user on cluster"):
node.query("CREATE USER user13 ON CLUSTER sharded_cluster")
finally:
with Finally("I drop the user"):
node.query("DROP USER user13 ON CLUSTER sharded_cluster")
with Scenario("I create user on fake cluster, throws exception",
flags=TE,
requirements=[RQ_SRS_006_RBAC_User_Create_OnCluster("1.0")]):
with When("I create user on fake cluster"):
exitcode, message = errors.cluster_not_found("fake_cluster")
node.query("CREATE USER user14 ON CLUSTER fake_cluster",
exitcode=exitcode,
message=message)
def feature(self, node="clickhouse1"):
"""Check create settings profile query syntax.
```sql
CREATE [SETTINGS] PROFILE [IF NOT EXISTS | OR REPLACE] name [ON CLUSTER cluster_name]
[SETTINGS variable [= value] [MIN [=] min_value] [MAX [=] max_value]
[READONLY] | [INHERIT|PROFILE 'profile_name']] [,...]
[TO {role [,...] | ALL | ALL EXCEPT role [,...]}]
```
"""
node = self.context.cluster.node(node)
@contextmanager
def cleanup(profile):
try:
with Given(f"I ensure the profile {profile} does not exist"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
yield
finally:
with Finally("I drop the profile"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
def create_profile(profile):
with Given(f"I ensure I do have profile {profile}"):
node.query(f"CREATE SETTINGS PROFILE OR REPLACE {profile}")
try:
with Given("I have a user and a role"):
node.query(f"CREATE USER user0")
node.query(f"CREATE ROLE role0")
with Scenario(
"I create settings profile with no options",
requirements=[RQ_SRS_006_RBAC_SettingsProfile_Create("1.0")]):
with cleanup("profile0"):
with When("I create settings profile"):
node.query("CREATE SETTINGS PROFILE profile0")
with Scenario(
"I create settings profile that already exists, throws exception",
requirements=[RQ_SRS_006_RBAC_SettingsProfile_Create("1.0")]):
profile = "profile0"
with cleanup(profile):
create_profile(profile)
with When(
f"I create settings profile {profile} that already exists"
):
exitcode, message = errors.cannot_insert_settings_profile(
name=profile)
node.query(f"CREATE SETTINGS PROFILE {profile}",
exitcode=exitcode,
message=message)
del profile
with Scenario(
"I create settings profile if not exists, profile does not exist",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_IfNotExists("1.0")
]):
with cleanup("profile1"):
with When("I create settings profile with if not exists"):
node.query(
"CREATE SETTINGS PROFILE IF NOT EXISTS profile1")
with Scenario(
"I create settings profile if not exists, profile does exist",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_IfNotExists("1.0")
]):
profile = "profile1"
with cleanup(profile):
create_profile(profile)
with When(
f"I create settings profile {profile} with if not exists"
):
node.query(
f"CREATE SETTINGS PROFILE IF NOT EXISTS {profile}")
del profile
with Scenario(
"I create settings profile or replace, profile does not exist",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Replace("1.0")
]):
with cleanup("profile2"):
with When("I create settings policy with or replace"):
node.query("CREATE SETTINGS PROFILE OR REPLACE profile2")
with Scenario(
"I create settings profile or replace, profile does exist",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Replace("1.0")
]):
with cleanup("profile2"):
create_profile("profile2")
with When("I create settings policy with or replace"):
node.query("CREATE SETTINGS PROFILE OR REPLACE profile2")
with Scenario(
"I create settings profile short form",
requirements=[RQ_SRS_006_RBAC_SettingsProfile_Create("1.0")]):
with cleanup("profile3"):
with When("I create settings profile short form"):
node.query("CREATE PROFILE profile3")
with Scenario(
"I create settings profile with a setting value",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables("1.0"),
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Value(
"1.0")
]):
with cleanup("profile4"):
with When("I create settings profile with settings"):
node.query(
"CREATE SETTINGS PROFILE profile4 SETTINGS max_memory_usage = 100000001"
)
with Scenario(
"I create settings profile with a setting value, does not exist, throws exception",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables("1.0"),
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Value(
"1.0")
]):
with When(
"I create settings profile using settings and nonexistent value"
):
exitcode, message = errors.unknown_setting("fake_setting")
node.query(
"CREATE SETTINGS PROFILE profile0 SETTINGS fake_setting = 100000001",
exitcode=exitcode,
message=message)
with Scenario(
"I create settings profile with a min setting value",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile5"), cleanup("profile6"):
with When(
"I create settings profile with min setting with and without equals"
):
node.query(
"CREATE SETTINGS PROFILE profile5 SETTINGS max_memory_usage MIN 100000001"
)
node.query(
"CREATE SETTINGS PROFILE profile6 SETTINGS max_memory_usage MIN = 100000001"
)
with Scenario(
"I create settings profile with a max setting value",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile7"), cleanup("profile8"):
with When(
"I create settings profile with max setting with and without equals"
):
node.query(
"CREATE SETTINGS PROFILE profile7 SETTINGS max_memory_usage MAX 100000001"
)
node.query(
"CREATE SETTINGS PROFILE profile8 SETTINGS max_memory_usage MAX = 100000001"
)
with Scenario(
"I create settings profile with min and max setting values",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile9"):
with When(
"I create settings profile with min and max setting"):
node.query(
"CREATE SETTINGS PROFILE profile9 SETTINGS max_memory_usage MIN 100000001 MAX 200000001"
)
with Scenario(
"I create settings profile with a readonly setting",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile10"):
with When("I create settings profile with readonly"):
node.query(
"CREATE SETTINGS PROFILE profile10 SETTINGS max_memory_usage READONLY"
)
with Scenario(
"I create settings profile with a writable setting",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile21"):
with When("I create settings profile with writable"):
node.query(
"CREATE SETTINGS PROFILE profile21 SETTINGS max_memory_usage WRITABLE"
)
with Scenario("I create settings profile with inherited settings",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Inherit("1.0")
]):
with cleanup("profile11"):
with When("I create settings profile with inherit"):
node.query(
"CREATE SETTINGS PROFILE profile11 SETTINGS INHERIT 'default'"
)
with Scenario(
"I create settings profile with inherit/from profile, fake profile, throws exception",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Inherit("1.0")
]):
profile = "profile3"
with Given(f"I ensure that profile {profile} does not exist"):
node.query(f"DROP SETTINGS PROFILE IF EXISTS {profile}")
sources = {"INHERIT", "PROFILE"}
for source in sources:
with When(
f"I create settings profile {source} from nonexistant parent"
):
exitcode, message = errors.settings_profile_not_found_in_disk(
profile)
node.query(
f"CREATE PROFILE profile0 SETTINGS {source} {profile}",
exitcode=exitcode,
message=message)
del profile
with Scenario(
"I create settings profile with inherited settings other form",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Inherit("1.0")
]):
with cleanup("profile12"):
with When("I create settings profile with inherit short form"):
node.query(
"CREATE PROFILE profile12 SETTINGS PROFILE 'default'")
with Scenario(
"I create settings profile with multiple settings",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile13"):
with When("I create settings profile with multiple settings"):
node.query(
"CREATE SETTINGS PROFILE profile13"
" SETTINGS max_memory_usage = 100000001"
" SETTINGS max_memory_usage_for_user = 100000001")
with Scenario(
"I create settings profile with multiple settings short form",
requirements=
[
RQ_SRS_006_RBAC_SettingsProfile_Create_Variables_Constraints(
"1.0")
]):
with cleanup("profile14"):
with When(
"I create settings profile with multiple settings short form"
):
node.query("CREATE SETTINGS PROFILE profile14"
" SETTINGS max_memory_usage = 100000001,"
" max_memory_usage_for_user = 100000001")
with Scenario(
"I create settings profile assigned to one role",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment("1.0")
]):
with cleanup("profile15"):
with When("I create settings profile for a role"):
node.query("CREATE SETTINGS PROFILE profile15 TO role0")
with Scenario(
"I create settings profile to assign to role that does not exist, throws exception",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment("1.0")
]):
role = "role1"
with Given(f"I drop {role} if it exists"):
node.query(f"DROP ROLE IF EXISTS {role}")
with Then(
f"I create a settings profile, assign to role {role}, which does not exist"
):
exitcode, message = errors.role_not_found_in_disk(name=role)
node.query(f"CREATE SETTINGS PROFILE profile0 TO {role}",
exitcode=exitcode,
message=message)
del role
with Scenario(
"I create settings profile to assign to all except role that does not exist, throws exception",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment("1.0")
]):
role = "role1"
with Given(f"I drop {role} if it exists"):
node.query(f"DROP ROLE IF EXISTS {role}")
with Then(
f"I create a settings profile, assign to all except role {role}, which does not exist"
):
exitcode, message = errors.role_not_found_in_disk(name=role)
node.query(
f"CREATE SETTINGS PROFILE profile0 TO ALL EXCEPT {role}",
exitcode=exitcode,
message=message)
del role
with Scenario(
"I create settings profile assigned to multiple roles",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment("1.0")
]):
with cleanup("profile16"):
with When("I create settings profile for multiple roles"):
node.query(
"CREATE SETTINGS PROFILE profile16 TO role0, user0")
with Scenario(
"I create settings profile assigned to all",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment_All(
"1.0")
]):
with cleanup("profile17"):
with When("I create settings profile for all"):
node.query("CREATE SETTINGS PROFILE profile17 TO ALL")
with Scenario(
"I create settings profile assigned to all except one role",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment_AllExcept(
"1.0")
]):
with cleanup("profile18"):
with When("I create settings profile for all except one role"):
node.query(
"CREATE SETTINGS PROFILE profile18 TO ALL EXCEPT role0"
)
with Scenario(
"I create settings profile assigned to all except multiple roles",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment_AllExcept(
"1.0")
]):
with cleanup("profile19"):
with When(
"I create settings profile for all except multiple roles"
):
node.query(
"CREATE SETTINGS PROFILE profile19 TO ALL EXCEPT role0, user0"
)
with Scenario(
"I create settings profile assigned to none",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_Assignment_None(
"1.0")
]):
with cleanup("profile22"):
with When("I create settings profile for none"):
node.query("CREATE SETTINGS PROFILE profile22 TO NONE")
with Scenario(
"I create settings profile on cluster",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_OnCluster("1.0")
]):
try:
with When("I run create settings profile command"):
node.query(
"CREATE SETTINGS PROFILE profile20 ON CLUSTER sharded_cluster"
)
node.query(
"CREATE SETTINGS PROFILE OR REPLACE profile20 ON CLUSTER sharded_cluster SETTINGS max_memory_usage = 100000001"
)
node.query(
"CREATE SETTINGS PROFILE OR REPLACE profile20 ON CLUSTER sharded_cluster SETTINGS INHERIT 'default'"
)
node.query(
"CREATE SETTINGS PROFILE OR REPLACE profile20 ON CLUSTER sharded_cluster TO ALL"
)
finally:
with Finally("I drop the settings profile"):
node.query(
"DROP SETTINGS PROFILE IF EXISTS profile20 ON CLUSTER sharded_cluster"
)
with Scenario(
"I create settings profile on fake cluster, throws exception",
requirements=[
RQ_SRS_006_RBAC_SettingsProfile_Create_OnCluster("1.0")
]):
with When("I run create settings profile command"):
exitcode, message = errors.cluster_not_found("fake_cluster")
node.query(
"CREATE SETTINGS PROFILE profile1 ON CLUSTER fake_cluster",
exitcode=exitcode,
message=message)
finally:
with Finally("I drop all the users and roles"):
node.query(f"DROP USER IF EXISTS user0")
node.query(f"DROP ROLE IF EXISTS role0")