public static RevokeDatabasePrivilege CreateRevoqueDatabasePrivilege(IDatabaseContainer container, string databaseName, string tableName)
{
RevokeDatabasePrivilege revoqueDatabasePrivilege = new RevokeDatabasePrivilege(container);
revoqueDatabasePrivilege.targetDatabase = databaseName;
revoqueDatabasePrivilege.targetTableName = tableName;
return(revoqueDatabasePrivilege);
}
public void RevoqueDatabasePrivilege_DatabaseDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string databaseName = VariousFunctions.GenerateRandomString(8);
while (databaseContainer.ExistDatabase(databaseName))
{
databaseName = VariousFunctions.GenerateRandomString(8);
}
RevokeDatabasePrivilege revoqueDatabasePrivilege = CreateRevoqueDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName);
revoqueDatabasePrivilege.SetData(SystemeConstants.DefaultProfile, databaseName, SystemeConstants.CreatePrivilegeName);
Assert.IsFalse(revoqueDatabasePrivilege.ValidateParameters());
}
public void RevoqueDatabasePrivilege_AllParamsExist_RowExist_DeleteRow()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName);
Row row = table.CreateRowDefinition();
row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName).data = SystemeConstants.DefaultProfile;
row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName).data = SystemeConstants.DefaultDatabaseName;
row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName).data = SystemeConstants.CreatePrivilegeName;
table.AddRow(row);
int rowNumber = table.GetRowCount();
RevokeDatabasePrivilege revoqueDatabasePrivilege = CreateRevoqueDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName);
revoqueDatabasePrivilege.SetData(SystemeConstants.DefaultProfile, SystemeConstants.DefaultDatabaseName, SystemeConstants.CreatePrivilegeName);
Assert.IsTrue(revoqueDatabasePrivilege.ValidateParameters());
revoqueDatabasePrivilege.Execute();
Assert.AreEqual(rowNumber - 1, table.GetRowCount());
}
