public async Task GetLatestEarlierPublishedProviderVersion() { PublishedProviderVersion document = await _repository.GetLatestEarlierPublishedProviderVersion("DSG", "FY-2021", 1584355885, //timestamp is v3 so should yield v2 "10007322"); document? .Version .Should() .Be(2); }
public async Task GetLatestEarlierPublishedProviderVersionByStatus() { string fundingStreamId = NewRandomString(); string fundingPeriodId = NewRandomString(); long timeStamp = NewRandomTimeStamp(); string providerId = NewRandomString(); PublishedProviderStatus status = new RandomEnum <PublishedProviderStatus>(); PublishedProviderVersion expectedLatestEarlierDocument = NewPublishedProviderVersion(); GivenTheLatestEarlierDocument(@"SELECT TOP 1 * FROM publishedProviderVersion p WHERE p.documentType = 'PublishedProviderVersion' AND p._ts < @sinceTimeStamp AND p.content.fundingStreamId = @fundingStreamId AND p.content.fundingPeriodId = @fundingPeriodId AND p.content.providerId = @providerId AND p.content.status = @status AND p.deleted = false ORDER BY p._ts DESC", expectedLatestEarlierDocument, ("@fundingPeriodId", fundingPeriodId), ("@fundingStreamId", fundingStreamId), ("@sinceTimeStamp", timeStamp), ("@providerId", providerId), ("@status", status)); PublishedProviderVersion actualLatestEarlierDocument = await _repository.GetLatestEarlierPublishedProviderVersion(fundingStreamId, fundingPeriodId, timeStamp, providerId, status); actualLatestEarlierDocument .Should() .BeSameAs(expectedLatestEarlierDocument); }