public void RevokePrivilege_AllOK_RevokePrivilege() { //Prefase IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); IDatabase database = databaseContainer.GetDatabase(SystemeConstants.DefaultDatabaseName); Table table = new Table("table"); database.AddTable(table); string profileName = SystemeConstants.DefaultProfile; string privilegeName = SystemeConstants.InsertPrivilegeName; GrantPrivilege grantPrivilege = TestGrantPrivilege.CreateGrantPrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName); grantPrivilege.SetData(privilegeName, profileName, database.databaseName, table.tableName); grantPrivilege.ValidateParameters(); grantPrivilege.Execute(); ITable profilesPrivilegesTable = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.PrivilegesOfProfilesOnTablesTableName); int rowCounts = profilesPrivilegesTable.GetRowCount(); //Test RevoquePrivilege revoquePrivilege = CreateRevokePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName); revoquePrivilege.SetData(profileName, database.databaseName, table.tableName, privilegeName); Assert.IsTrue(revoquePrivilege.ValidateParameters()); revoquePrivilege.Execute(); Assert.AreEqual(rowCounts - 1, profilesPrivilegesTable.GetRowCount()); }
public void GrantPrivilege_AllParametersAreOK_GrantThePrivilege() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); IDatabase database = databaseContainer.GetDatabase(SystemeConstants.DefaultDatabaseName); Table table = new Table("table"); database.AddTable(table); GrantPrivilege grantPrivilege = CreateGrantPrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName); grantPrivilege.SetData(SystemeConstants.InsertPrivilegeName, SystemeConstants.DefaultProfile, database.databaseName, table.tableName); Assert.IsTrue(grantPrivilege.ValidateParameters()); }
public void GrantPrivilege_DatabaseDoenstExist_NoticeInValidate() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); string randomDatabaseName = VariousFunctions.GenerateRandomString(8); while (databaseContainer.ExistDatabase(randomDatabaseName)) { randomDatabaseName = VariousFunctions.GenerateRandomString(8); } GrantPrivilege grantPrivilege = CreateGrantPrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName); grantPrivilege.SetData(SystemeConstants.InsertPrivilegeName, SystemeConstants.DefaultProfile, randomDatabaseName, "aaa"); Assert.IsFalse(grantPrivilege.ValidateParameters()); }
public void GrantPrivilege_ProfileDoenstExist_NoticeInValidate() { IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer(); IDatabase targetDatabase = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName); Column column = targetDatabase.GetTable(SystemeConstants.ProfilesTableName).GetColumn(SystemeConstants.ProfileNameColumn); string profileName = VariousFunctions.GenerateRandomString(8); while (column.ExistCells(profileName)) { profileName = VariousFunctions.GenerateRandomString(8); } GrantPrivilege grantPrivilege = CreateGrantPrivilege(databaseContainer, targetDatabase.databaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName); grantPrivilege.SetData(SystemeConstants.InsertPrivilegeName, profileName, targetDatabase.databaseName, SystemeConstants.PrivilegesTableName); Assert.IsFalse(grantPrivilege.ValidateParameters()); }