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)); }