Changeset - 18195f35a1bf
[Not reviewed]
0 1 0
Branko Majic (branko) - 4 years ago 2020-01-06 20:44:21
branko@majic.rs
MAR-148: Fix tests for the database role (added some newlines to expected outputs).
1 file changed with 7 insertions and 6 deletions:
0 comments (0 inline, 0 general)
roles/database/molecule/default/tests/test_default.py
Show inline comments
 
@@ -16,7 +16,7 @@ def test_database_created(host):
 
        show_databases = host.run("mysql -BNe \"show databases like 'testdb'\"")
 

	
 
        assert show_databases.rc == 0
 
        assert show_databases.stdout == "testdb"
 
        assert show_databases.stdout == "testdb\n"
 

	
 

	
 
def test_database_user_login(host):
 
@@ -37,10 +37,11 @@ def test_database_user_permissions(host):
 
    visible_databases = host.run("mysql -utestdb -ptestdbpassword -BNe 'show databases'")
 

	
 
    assert visible_databases.rc == 0
 
    assert visible_databases.stdout == "information_schema\ntestdb"
 
    assert visible_databases.stdout == "information_schema\ntestdb\n"
 

	
 
    with host.sudo():
 
        permissions = host.run("mysql -BNe 'show grants for testdb@localhost'")
 
        assert len(permissions.stdout.split("\n")) == 2
 
        assert "GRANT USAGE ON *.* TO 'testdb'@'localhost' IDENTIFIED BY PASSWORD '*676852B7FAE972722AD20D6E74781D6B1A100544'" in permissions.stdout.split("\n")
 
        assert "GRANT ALL PRIVILEGES ON `testdb`.* TO 'testdb'@'localhost'" in permissions.stdout.split("\n")
 
        permissions_command = host.run("mysql -BNe 'show grants for testdb@localhost'")
 
        permissions = permissions_command.stdout.rstrip().split("\n")
 
        assert len(permissions) == 2
 
        assert "GRANT USAGE ON *.* TO 'testdb'@'localhost' IDENTIFIED BY PASSWORD '*676852B7FAE972722AD20D6E74781D6B1A100544'" in permissions
 
        assert "GRANT ALL PRIVILEGES ON `testdb`.* TO 'testdb'@'localhost'" in permissions
0 comments (0 inline, 0 general)