public void XtremeCase_TwoColumnAsPK_NewRowWithNoPKDuplicated_ButIndividuallyPKColumnsValuesAreDuplicated_EvalReturnTrue()
{
//Construct phase
Table table = CreatePrimaryKeysTable();
Column pkColumn1 = table.GetColumn(testTableColumns[0]);
Column pkColumn2 = table.GetColumn(testTableColumns[1]);
table.primaryKey.AddKey(pkColumn1);
table.primaryKey.AddKey(pkColumn2);
string noDuplicatedKey1 = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn1);
string noDuplicatedKey2 = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn2);
Row row = table.CreateRowDefinition();
row.GetCell(pkColumn1.columnName).data = noDuplicatedKey1;
row.GetCell(pkColumn2.columnName).data = noDuplicatedKey2;
table.AddRow(row);
string noDuplicatedKey3 = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn1);
string noDuplicatedKey4 = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn2);
row = table.CreateRowDefinition();
row.GetCell(pkColumn1.columnName).data = noDuplicatedKey3;
row.GetCell(pkColumn2.columnName).data = noDuplicatedKey4;
table.AddRow(row);
//Test
row = table.CreateRowDefinition();
row.GetCell(pkColumn1.columnName).data = noDuplicatedKey1;
row.GetCell(pkColumn2.columnName).data = noDuplicatedKey4;
Assert.IsTrue(table.primaryKey.Evaluate(row));
}
public void RevokePrivilege_PrivilegeDoesntExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
string privilegeName = ShittyUtilities.GetDoesntExistPrivilegeName(databaseContainer);
RevoquePrivilege revoquePrivilege = CreateRevokePrivilege(databaseContainer, SystemeConstants.SystemDatabaseName, SystemeConstants.PrivilegesOfProfilesOnTablesTableName);
revoquePrivilege.SetData(SystemeConstants.DefaultProfile, SystemeConstants.SystemDatabaseName, SystemeConstants.ProfilesTableName, privilegeName);
Assert.IsFalse(revoquePrivilege.ValidateParameters());
}
public void Login_UserDoenstExist_NoticeInValidate()
{
IDatabaseContainer databaseContainer = ObjectConstructor.CreateDatabaseContainer();
IUserThread userThread = ObjectConstructor.GetFakeUserThread();
string doenstExistUsername = ShittyUtilities.GetDoesntExistUserName(databaseContainer);
Login login = CreateLogin(databaseContainer, userThread, SystemeConstants.SystemDatabaseName, SystemeConstants.UsersTableName);
login.SetData(doenstExistUsername, "aaaa");
Assert.IsFalse(login.ValidateParameters());
}
public void OneColumnPk_InsertNewRowWithNoDuplicatedKey_EvalReturnTrue()
{
Table table = CreatePrimaryKeysTable();
Column pkColumn = table.GetColumn(testTableColumns[0]);
table.primaryKey.AddKey(pkColumn);
string noDuplicatedKey = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn);
Row row = table.CreateRowDefinition();
row.GetCell(pkColumn.columnName).data = noDuplicatedKey;
Assert.IsTrue(table.primaryKey.Evaluate(row));
}
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 TwoColumnPk_InsertNewRowWithNoDuplicatedKey_EvalReturnTrue()
{
//Construct phase
Table table = CreatePrimaryKeysTable();
Column pkColumn1 = table.GetColumn(testTableColumns[0]);
Column pkColumn2 = table.GetColumn(testTableColumns[1]);
table.primaryKey.AddKey(pkColumn1);
table.primaryKey.AddKey(pkColumn2);
string noDuplicatedKey1 = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn1);
string noDuplicatedKey2 = ShittyUtilities.GenerateADoenstExistNewValue(pkColumn2);
//Test
Row row = table.CreateRowDefinition();
row.GetCell(pkColumn1.columnName).data = noDuplicatedKey1;
row.GetCell(pkColumn2.columnName).data = noDuplicatedKey2;
Assert.IsTrue(table.primaryKey.Evaluate(row));
}
