public void WhenThereAreNoRelationshipsReturnsEmptyListForPersonalRelationships()
{
var(person, _, _, _, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext, withRelationship: false);
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
response.PersonalRelationships.Should().BeEmpty();
}
public void WhenIncludeEndedRelationshipsIsTrueReturnsPersonalRelationships()
{
var(person, _, _, _, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext, hasEnded: true);
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id, includeEndedRelationships: true);
response.PersonalRelationships.Should().NotBeEmpty();
}
public void WhenThereIsARelationshipWithDetailsReturnsTheDetails()
{
var(person, _, _, _, personalRelationshipDetail) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext, details: "Emergency contact");
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
response.PersonalRelationships.FirstOrDefault().Details.Details.Should().BeEquivalentTo(personalRelationshipDetail.Details);
}
public void WhenThereIsARelationshipReturnsTheDescriptionOfThePersonalRelationshipType()
{
var(person, _, _, personalRelationshipType, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext, relationshipType: "stepParent");
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
var personalRelationshipTypeInResponse = response.PersonalRelationships.FirstOrDefault().Type;
personalRelationshipTypeInResponse.Description.Should().Equals(personalRelationshipType.Description);
}
public void WhenMatchingIDReturnsRelationship()
{
var(person, _, personalRelationship, _, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
var response = _databaseGateway.GetPersonalRelationshipById(personalRelationship.Id);
response.Id.Should().Be(personalRelationship.Id);
response.PersonId.Should().Be(person.Id);
}
public void WhenThereIsARelationshipReturnsThePersonalRelationship()
{
var(person, _, personalRelationship, _, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
response.PersonalRelationships.FirstOrDefault().Id.Should().Be(personalRelationship.Id);
response.PersonalRelationships.FirstOrDefault().PersonId.Should().Be(personalRelationship.PersonId);
response.PersonalRelationships.FirstOrDefault().OtherPersonId.Should().Be(personalRelationship.OtherPersonId);
response.PersonalRelationships.FirstOrDefault().TypeId.Should().Be(personalRelationship.TypeId);
}
public void WhenThereIsARelationshipReturnsTheDetailsOfTheOtherPerson()
{
var(person, otherPerson, _, _, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
var otherPersonInResponse = response.PersonalRelationships.FirstOrDefault().OtherPerson;
otherPersonInResponse.Id.Should().Be(otherPerson.Id);
otherPersonInResponse.FirstName.Should().Be(otherPerson.FirstName);
otherPersonInResponse.LastName.Should().Be(otherPerson.LastName);
otherPersonInResponse.Gender.Should().Be(otherPerson.Gender);
}
public void WhenThereAreMultipleRelationshipsReturnsAllRelevantPersonalRelationships()
{
var(person, _, _, personalRelationshipType, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
var anotherPerson = TestHelpers.CreatePerson();
var anotherRelationship = PersonalRelationshipsHelper.CreatePersonalRelationship(person, anotherPerson, personalRelationshipType, id: 1);
var andAnotherPerson = TestHelpers.CreatePerson();
var andAnotherRelationship = PersonalRelationshipsHelper.CreatePersonalRelationship(person, andAnotherPerson, personalRelationshipType, hasEnded: true, id: 2);
DatabaseContext.Persons.Add(anotherPerson);
DatabaseContext.Persons.Add(andAnotherPerson);
DatabaseContext.PersonalRelationships.Add(anotherRelationship);
DatabaseContext.PersonalRelationships.Add(andAnotherRelationship);
DatabaseContext.SaveChanges();
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
response.PersonalRelationships.Should().HaveCount(2);
}
public void WhenThereAreRelationshipsDoesNotReturnRelationshipsAgainstPersonsMarkedForDeletion()
{
var(person, _, _, personalRelationshipType, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
var anotherPerson = TestHelpers.CreatePerson();
var anotherRelationship = PersonalRelationshipsHelper.CreatePersonalRelationship(person, anotherPerson, personalRelationshipType, id: 1);
var personMarkedForDeletion = TestHelpers.CreatePerson();
personMarkedForDeletion.MarkedForDeletion = true;
var andAnotherRelationship = PersonalRelationshipsHelper.CreatePersonalRelationship(person, personMarkedForDeletion, personalRelationshipType, id: 2);
DatabaseContext.Persons.Add(anotherPerson);
DatabaseContext.Persons.Add(personMarkedForDeletion);
DatabaseContext.PersonalRelationships.Add(anotherRelationship);
DatabaseContext.PersonalRelationships.Add(andAnotherRelationship);
DatabaseContext.SaveChanges();
var response = _databaseGateway.GetPersonWithPersonalRelationshipsByPersonId(person.Id);
response.PersonalRelationships.Should().HaveCount(2);
}
public void SetsTheMarkedForDeletionFlagToFalseForPersonAndRelatedEntitiesAndRemovesTheRecordFromDeletedPersonRecordTable()
{
//person to be restored, new master record and relationship
var(deletedPerson, newMasterPersonRecord, personalRelationship, personalRelationshipType, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
//address
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: deletedPerson.Id);
address.MarkedForDeletion = true;
DatabaseContext.Addresses.Add(address);
//telephone numbers
var telephoneNumber = DatabaseGatewayHelper.CreatePhoneNumberEntity(personId: deletedPerson.Id);
address.MarkedForDeletion = true;
DatabaseContext.PhoneNumbers.Add(telephoneNumber);
//other names
var otherName = DatabaseGatewayHelper.CreatePersonOtherNameDatabaseEntity(personId: deletedPerson.Id);
otherName.MarkedForDeletion = true;
DatabaseContext.PersonOtherNames.Add(otherName);
//allocations
var allocation = TestHelpers.CreateAllocation(personId: (int)deletedPerson.Id);
allocation.MarkedForDeletion = true;
DatabaseContext.Allocations.Add(allocation);
//warning notes
var warningNote = TestHelpers.CreateWarningNote(personId: deletedPerson.Id);
warningNote.MarkedForDeletion = true;
DatabaseContext.WarningNotes.Add(warningNote);
//inverse relationship (type not handled for simplicity)
var inversePersonalRelationship = PersonalRelationshipsHelper.CreatePersonalRelationship(newMasterPersonRecord, deletedPerson, personalRelationshipType);
inversePersonalRelationship.MarkedForDeletion = true;
DatabaseContext.PersonalRelationships.Add(inversePersonalRelationship);
//record marked as soft deleted
DatabaseContext.DeletedPersonRecords.Add(new DeletedPersonRecord()
{
DeletedId = deletedPerson.Id,
MasterId = newMasterPersonRecord.Id
});
DatabaseContext.SaveChanges();
//TODO: wrap into transaction when running manually (BEGIN; <SCRIPT> END;)
//TODO: this is designed to be run against individual IDs. Replace the {deletedPerson.Id} with appropriate MosaicId (long)
DatabaseContext.Database.ExecuteSqlInterpolated($@"
UPDATE dbo.dm_persons SET marked_for_deletion = false WHERE person_id = {deletedPerson.Id};
UPDATE dbo.dm_addresses SET marked_for_deletion = false WHERE person_id = {deletedPerson.Id};
UPDATE dbo.dm_telephone_numbers SET marked_for_deletion = false WHERE person_id = {deletedPerson.Id};
UPDATE dbo.sccv_person_other_name SET marked_for_deletion = false WHERE person_id = {deletedPerson.Id};
UPDATE dbo.sccv_allocations_combined SET marked_for_deletion = false WHERE mosaic_id = {deletedPerson.Id};
UPDATE dbo.sccv_warning_note SET marked_for_deletion = false WHERE person_id = {deletedPerson.Id};
UPDATE dbo.sccv_personal_relationship SET marked_for_deletion = false WHERE fk_person_id = {deletedPerson.Id};
UPDATE dbo.sccv_personal_relationship SET marked_for_deletion = false WHERE fk_other_person_id = {deletedPerson.Id};
DELETE from dbo.sccv_deleted_person_record where deleted_person_id = {deletedPerson.Id};
");
DatabaseContext.Persons.First(x => x.Id == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.Addresses.First(x => x.PersonId == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.PhoneNumbers.First(x => x.PersonId == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.PersonOtherNames.First(x => x.PersonId == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.Allocations.First(x => x.PersonId == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.WarningNotes.First(x => x.PersonId == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.PersonalRelationships.First(x => x.PersonId == deletedPerson.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.PersonalRelationships.First(x => x.OtherPersonId == newMasterPersonRecord.Id).MarkedForDeletion.Should().BeFalse();
DatabaseContext.DeletedPersonRecords.Any(x => x.DeletedId == deletedPerson.Id).Should().BeFalse();
}
public void SetsTheMarkedForDeletionFlagForPersonAndRelatedEntitiesAndUpdatesTheDeletedPersonRecordsTableWithCorrectRecords()
{
//person to be deleted, new master record and relationship
var(personToBeDeleted, newMasterPersonRecord, personalRelationship, personalRelationshipType, _) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipToDatabase(DatabaseContext);
//address
var address = DatabaseGatewayHelper.CreateAddressDatabaseEntity(personId: personToBeDeleted.Id);
DatabaseContext.Addresses.Add(address);
//telephone numbers
var telephoneNumber = DatabaseGatewayHelper.CreatePhoneNumberEntity(personId: personToBeDeleted.Id);
DatabaseContext.PhoneNumbers.Add(telephoneNumber);
//other names
var otherName = DatabaseGatewayHelper.CreatePersonOtherNameDatabaseEntity(personId: personToBeDeleted.Id);
DatabaseContext.PersonOtherNames.Add(otherName);
//allocations
var allocation = TestHelpers.CreateAllocation(personId: (int)personToBeDeleted.Id);
DatabaseContext.Allocations.Add(allocation);
//warning notes
var warningNote = TestHelpers.CreateWarningNote(personId: personToBeDeleted.Id);
DatabaseContext.WarningNotes.Add(warningNote);
//inverse relationship (type not handled for simplicity)
var inversePersonalRelationship = PersonalRelationshipsHelper.CreatePersonalRelationship(newMasterPersonRecord, personToBeDeleted, personalRelationshipType);
DatabaseContext.PersonalRelationships.Add(inversePersonalRelationship);
//record marked for deletion
DatabaseContext.PersonRecordsToBeDeleted.Add(new PersonRecordToBeDeleted()
{
IdToDelete = personToBeDeleted.Id,
MasterId = newMasterPersonRecord.Id
});
DatabaseContext.SaveChanges();
DatabaseContext.Database.ExecuteSqlInterpolated(_queryUnderTest);
//flags
DatabaseContext.Persons.First(x => x.Id == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.Addresses.First(x => x.PersonId == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.PhoneNumbers.First(x => x.PersonId == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.PersonOtherNames.First(x => x.PersonId == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.Allocations.First(x => x.PersonId == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.WarningNotes.First(x => x.PersonId == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.PersonalRelationships.First(x => x.PersonId == personToBeDeleted.Id).MarkedForDeletion.Should().BeTrue();
DatabaseContext.PersonalRelationships.First(x => x.OtherPersonId == newMasterPersonRecord.Id).MarkedForDeletion.Should().BeTrue();
//record in deleted person record table
var expectedDeletedPersonRecordEntry = new DeletedPersonRecord()
{
DeletedId = personToBeDeleted.Id,
MasterId = newMasterPersonRecord.Id,
Timestamp = DateTime.Now.ToUniversalTime()
};
DatabaseContext.DeletedPersonRecords.First(x => x.DeletedId == personToBeDeleted.Id).MasterId.Should().Be(expectedDeletedPersonRecordEntry.MasterId);
DatabaseContext.DeletedPersonRecords.First(x => x.DeletedId == personToBeDeleted.Id).DeletedId.Should().Be(expectedDeletedPersonRecordEntry.DeletedId);
DatabaseContext.DeletedPersonRecords.First(x => x.DeletedId == personToBeDeleted.Id).Timestamp.Should().BeCloseTo(expectedDeletedPersonRecordEntry.Timestamp, precision: 5000);
}