protected override IEnumerable <PharmaceuticalPrescriptionSummary> Execute(FindPharmaceuticalPrescriptionsByPatient query, IDbConnection connection) { var expressions = connection.Expressions(); return(connection.Query <PharmaceuticalPrescriptionSummary>(SqlScripts.FindPharmaceuticalPrescriptionsByPatient.Replace("@", expressions.ParameterPrefix()), new { PatientId = query.PatientIdentifier }) .ToList()); }
public async Task HandleAsync_WhenCalled_ReturnsValidResults(FindPharmaceuticalPrescriptionsByPatient query, IEnumerable <PharmaceuticalPrescriptionSummary> expectedResults) { // Arrange this.fixture.ExecuteScriptFromResources("FindPharmaceuticalPrescriptionsByPatient"); var handler = new PharmaceuticalPrescriptionsByPatientFinder(this.fixture.ConnectionFactory); // Act var results = await handler.HandleAsync(query); // Assert results.Should().BeEquivalentTo(expectedResults, options => options.WithStrictOrdering()); }
protected override Task <IEnumerable <PharmaceuticalPrescriptionSummary> > ExecuteAsync(FindPharmaceuticalPrescriptionsByPatient query, IDbConnection connection, CancellationToken cancellationToken = default) { var expressions = connection.Expressions(); return(connection.QueryAsync <PharmaceuticalPrescriptionSummary> ( new CommandDefinition ( SqlScripts.FindPharmaceuticalPrescriptionsByPatient.Replace("@", expressions.ParameterPrefix()), new { PatientId = query.PatientIdentifier }, cancellationToken: cancellationToken ) )); }