@@ -47,6 +47,13 @@ def test_utf8_configuration(host):
Tests if UTF-8 configuration has been applied correctly to server.
"""
expected_character_set_and_collation = {
"bullseye": "utf8\nutf8_general_ci\n",
"bookworm": "utf8mb3\nutf8mb3_general_ci\n",
}
distribution_release = host.ansible("setup")["ansible_facts"]["ansible_distribution_release"]
with host.sudo():
assert host.run("mysql -uroot -BNe 'drop database if exists test'").rc == 0
assert host.run("mysql -uroot -BNe 'create database test'").rc == 0
@@ -54,14 +61,14 @@ def test_utf8_configuration(host):
check_server = host.run("mysql -uroot test -BNe 'select @@character_set_server; select @@collation_server'")
assert check_server.rc == 0
assert check_server.stdout == "utf8\nutf8_general_ci\n"
assert check_server.stdout == expected_character_set_and_collation[distribution_release]
check_database = host.run("mysql -uroot test -BNe 'select @@character_set_database; select @@collation_database'")
assert check_database.rc == 0
assert check_database.stdout == "utf8\nutf8_general_ci\n"
assert check_database.stdout == expected_character_set_and_collation[distribution_release]
check_database = host.run("mysql -uroot -BNe 'select @@character_set_connection; select @@collation_connection'")