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 override bool ValidateParameters()
{
IDatabaseContainer container = this.GetContainer();
if (!container.ExistDatabase(this.targetDatabase))
{
this.SaveTheError(QuerysStringResultConstants.DatabaseDoesntExist(this.targetDatabase));
}
else
{
IDatabase targetDatabaseObject = container.GetDatabase(this.targetDatabase);
if (!targetDatabaseObject.ExistTable(this.targetTableName))
{
this.SaveTheError(QuerysStringResultConstants.TableDoensExist(this.targetDatabase, this.targetTableName));
}
else if (!this.GetPrivilegeModule().CheckProfileTablePrivileges(this.username, this.targetDatabase, this.targetTableName, this.GetNeededExecutePrivilege()))
{
this.SaveTheError("Not enought privileges");
}
else
{
this.DoTheOtherValidations(targetDatabaseObject.GetTable(this.targetTableName));
}
}
return(this.GetIsValidQuery());
}
public void RevokePrivilege_TableDoesntExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
IDatabase database = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName);
string tableName = ShittyUtilities.GetDoenstExistTableName(database);
RevoquePrivilege revoquePrivilege = CreateRevokePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName);
revoquePrivilege.SetData(SystemeConstants.DefaultProfile, SystemeConstants.SystemDatabaseName, tableName, SystemeConstants.InsertPrivilegeName);
Assert.IsFalse(revoquePrivilege.ValidateParameters());
}
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 GrandDatabasePrivilege_PKViolated_NoticeInValidate()
{
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);
GrantDatabasePrivilege grantDatabasePrivilege = CreateGrantDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, table.tableName);
grantDatabasePrivilege.SetData(row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesPrivilegeColumnName).data, row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesProfileColumnName).data, row.GetCell(SystemeConstants.PrivilegesOfProfilesOnDatabasesDatabaseNameColumnName).data);
Assert.IsFalse(grantDatabasePrivilege.ValidateParameters());
}
public void GrantDatabasePrivilege_ProfileDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string randomProfileName = VariousFunctions.GenerateRandomString(8);
Column column = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.ProfilesTableName).GetColumn(SystemeConstants.ProfileNameColumn);
while (column.ExistCells(randomProfileName))
{
randomProfileName = VariousFunctions.GenerateRandomString(8);
}
GrantDatabasePrivilege grantDatabasePrivilege = CreateGrantDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName);
grantDatabasePrivilege.SetData(SystemeConstants.CreatePrivilegeName, randomProfileName, SystemeConstants.DefaultDatabaseName);
Assert.IsFalse(grantDatabasePrivilege.ValidateParameters());
}
public void GrantPrivilege_TableDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
IDatabase database = databaseContainer.GetDatabase(SystemeConstants.DefaultDatabaseName);
string randomTableName = VariousFunctions.GenerateRandomString(8);
while (database.ExistTable(randomTableName))
{
randomTableName = VariousFunctions.GenerateRandomString(8);
}
GrantPrivilege grantPrivilege = CreateGrantPrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName);
grantPrivilege.SetData(SystemeConstants.InsertPrivilegeName, SystemeConstants.DefaultProfile, database.databaseName, randomTableName);
Assert.IsFalse(grantPrivilege.ValidateParameters());
}
public void DropSecurityProfile_TheProfileDoesntExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Column column = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.ProfilesTableName).GetColumn(SystemeConstants.ProfileNameColumn);
string profileName = VariousFunctions.GenerateRandomString(8);
while (column.ExistCells(profileName))
{
profileName = VariousFunctions.GenerateRandomString(8);
}
DropSecurityProfile dropSecurityProfile = CreateDropSecurityProfile(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.ProfilesTableName);
dropSecurityProfile.SetTargetSecurityProfile(profileName);
Assert.IsFalse(dropSecurityProfile.ValidateParameters());
}
public void RevoqueDatabasePrivilege_PrivilegeDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
Column databasePrivilegesColumn = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.DatabasesPrivilegesTableName).GetColumn(SystemeConstants.DatabasesPrivilegesPrivilegeNameColumnName);
string databasePrivilegeName = VariousFunctions.GenerateRandomString(8);
while (databasePrivilegesColumn.ExistCells(databasePrivilegeName))
{
databasePrivilegeName = VariousFunctions.GenerateRandomString(8);
}
RevokeDatabasePrivilege revoqueDatabasePrivilege = CreateRevoqueDatabasePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnDatabasesTableName);
revoqueDatabasePrivilege.SetData(SystemeConstants.DefaultProfile, SystemeConstants.DefaultDatabaseName, databasePrivilegeName);
Assert.IsFalse(revoqueDatabasePrivilege.ValidateParameters());
}
public void DeleteUser_TheUserDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName);
Column column = table.GetColumn(SystemeConstants.UsersNameColumnName);
string username = VariousFunctions.GenerateRandomString(8);
while (column.ExistCells(username))
{
username = VariousFunctions.GenerateRandomString(8);
}
DeleteUser deleteUser = CreateDeleteUser(databaseContainer);
deleteUser.SetTargetUserName(username);
Assert.IsFalse(deleteUser.ValidateParameters());
}
public void LoginUserExist_Login()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
IUserThread userThread = ObjectConstructor.GetFakeUserThread();
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName);
string newUsername = ShittyUtilities.GetDoesntExistUserName(databaseContainer);
string password = "******";
Row row = table.CreateRowDefinition();
row.GetCell(SystemeConstants.UsersNameColumnName).data = newUsername;
row.GetCell(SystemeConstants.UsersPasswordColumnName).data = password;
table.AddRow(row);
Login login = CreateLogin(databaseContainer, userThread, SystemeConstants.SystemDatabaseName, SystemeConstants.UsersTableName);
login.SetData(newUsername, password);
Assert.IsTrue(login.ValidateParameters());
}
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 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());
}
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());
}
public void DeleteUser_TheUserExist_DeleteUser()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName);
Column column = table.GetColumn(SystemeConstants.UsersNameColumnName);
string username = VariousFunctions.GenerateRandomString(8);
while (column.ExistCells(username))
{
username = VariousFunctions.GenerateRandomString(8);
}
Row row = table.CreateRowDefinition();
row.GetCell(SystemeConstants.UsersNameColumnName).data = username;
table.AddRow(row);
DeleteUser deleteUser = CreateDeleteUser(databaseContainer);
deleteUser.SetTargetUserName(username);
Assert.IsTrue(deleteUser.ValidateParameters());
deleteUser.Execute();
Assert.IsFalse(column.ExistCells(username));
}
public void DropSecurity_TheProfileCanDrop_DropTheProfile()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
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);
}
Row row = table.CreateRowDefinition();
row.GetCell(SystemeConstants.ProfileNameColumn).data = profileName;
table.AddRow(row);
int numberOfRow = table.GetRowCount();
DropSecurityProfile dropSecurityProfile = CreateDropSecurityProfile(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.ProfilesTableName);
dropSecurityProfile.SetTargetSecurityProfile(profileName);
Assert.IsTrue(dropSecurityProfile.ValidateParameters());
dropSecurityProfile.Execute();
Assert.AreEqual(numberOfRow - 1, table.GetRowCount());
}
public static string GetDoesntExistUserName(IDatabaseContainer databaseContainer)
{
ITable table = databaseContainer.GetDatabase(SystemeConstants.SystemDatabaseName).GetTable(SystemeConstants.UsersTableName);
return(GenerateADoenstExistNewValue(table.GetColumn(SystemeConstants.UsersNameColumnName)));
}