public void CreateSecurityProfile_ProfileDoenstExits_CreateProfile()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
CreateSecurityProfile query = CreateCreateSecurityProfile(databaseContainer);
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.ProfilesTableName);
Column column = table.GetColumn(SystemeConstants.ProfileNameColumn);
string profileName = VariousFunctions.GenerateRandomString(8);
while (column.ExistCells(profileName))
{
profileName = VariousFunctions.GenerateRandomString(8);
}
query.SetProfileName(profileName);
Assert.IsTrue(query.ValidateParameters());
query.Execute();
Assert.IsTrue(column.ExistCells(profileName));
}
public void RevokePrivilege_AllParamsExistsButTheCombinationIsNotValid_NoticeInValidate()
{
//Prefase
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
CreateSecurityProfile createSecurityProfile = TestCreateSecurityProfile.CreateCreateSecurityProfile(databaseContainer);
Column profileNamesColumn = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.ProfilesTableName).GetColumn(SystemeConstants.ProfileNameColumn);
string profileName = VariousFunctions.GenerateRandomString(8);
while (profileNamesColumn.ExistCells(profileName))
{
profileName = VariousFunctions.GenerateRandomString(8);
}
createSecurityProfile.SetProfileName(profileName);
createSecurityProfile.ValidateParameters();
createSecurityProfile.Execute();
//TEST
RevoquePrivilege revoquePrivilege = CreateRevokePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName);
revoquePrivilege.SetData(profileName, SystemeConstants.SystemDatabaseName, SystemeConstants.ProfilesTableName, SystemeConstants.InsertPrivilegeName);
Assert.IsFalse(revoquePrivilege.ValidateParameters());
}