public void PrefixQueryShouldReturnHits()
{
var customer1 = new ElasticCallCustomer { Id = 1, Name = "Martijn" };
var customer2 = new ElasticCallCustomer { Id = 2, Name = "Thomas Tvedt" };
var calls = new[]
{
new ElasticCall {Id = 1, Duration=12315, Customer = customer1 },
new ElasticCall {Id = 2, Duration=345345, Customer = customer2 },
new ElasticCall {Id = 3, Duration=231, Customer = customer1 },
new ElasticCall {Id = 4, Duration=908, Customer = customer1 },
new ElasticCall {Id = 5, Duration=1231, Customer = customer2 },
new ElasticCall {Id = 6, Duration=2112, Customer = customer1 },
new ElasticCall {Id = 7, Duration=99891, Customer = customer1 },
new ElasticCall {Id = 8, Duration=29401281, Customer = customer1 },
new ElasticCall {Id = 9, Duration=2, Customer = customer1 },
new ElasticCall {Id = 10, Duration=21231, Customer = customer1 },
};
var result = this.Client.Bulk(b => b.IndexMany(calls).Refresh());
result.IsValid.Should().BeTrue();
var search = this.Client.Search<ElasticCall>(s => s
.Aggregations(agg => agg
.Terms("calls_per_customer", calls_per_customer => calls_per_customer
.Field(call=>call.Customer.Id)
.Size(10)
.Aggregations(callsPerCustomerAggs => callsPerCustomerAggs
.Terms("customer_name", customer_name => customer_name
.Script("_source.customer.name")
.Size(1)
)
.Sum("total_duration", total_duration => total_duration.Field("duration"))
.Average("average_duration", average_duration => average_duration.Field("duration"))
)
)
)
);
search.IsValid.Should().BeTrue();
var callsPerCustomer = search.Aggs.Terms("calls_per_customer");
callsPerCustomer.Items.Should().NotBeEmpty().And.HaveCount(2);
foreach(var term in callsPerCustomer.Items)
{
var name = term.Terms("customer_name");
name.Items.Should().NotBeEmpty().And.HaveCount(1);
var sum = term.Sum("total_duration").Value;
sum.Should().BeGreaterThan(10);
var average = term.Average("average_duration").Value;
average.Should().BeGreaterThan(10);
}
}
public void PrefixQueryShouldReturnHits()
{
var customer1 = new ElasticCallCustomer {
Id = 1, Name = "Martijn"
};
var customer2 = new ElasticCallCustomer {
Id = 2, Name = "Thomas Tvedt"
};
var calls = new[]
{
new ElasticCall {
Id = 1, Duration = 12315, Customer = customer1
},
new ElasticCall {
Id = 2, Duration = 345345, Customer = customer2
},
new ElasticCall {
Id = 3, Duration = 231, Customer = customer1
},
new ElasticCall {
Id = 4, Duration = 908, Customer = customer1
},
new ElasticCall {
Id = 5, Duration = 1231, Customer = customer2
},
new ElasticCall {
Id = 6, Duration = 2112, Customer = customer1
},
new ElasticCall {
Id = 7, Duration = 99891, Customer = customer1
},
new ElasticCall {
Id = 8, Duration = 29401281, Customer = customer1
},
new ElasticCall {
Id = 9, Duration = 2, Customer = customer1
},
new ElasticCall {
Id = 10, Duration = 21231, Customer = customer1
},
};
var result = this.Client.Bulk(b => b.IndexMany(calls).Refresh());
result.IsValid.Should().BeTrue();
var search = this.Client.Search <ElasticCall>(s => s
.Aggregations(agg => agg
.Terms("calls_per_customer", calls_per_customer => calls_per_customer
.Field(call => call.Customer.Id)
.Size(10)
.Aggregations(callsPerCustomerAggs => callsPerCustomerAggs
.Terms("customer_name", customer_name => customer_name
.Script("_source.customer.name")
.Size(1)
)
.Sum("total_duration", total_duration => total_duration.Field("duration"))
.Average("average_duration", average_duration => average_duration.Field("duration"))
)
)
)
);
search.IsValid.Should().BeTrue();
var callsPerCustomer = search.Aggs.Terms("calls_per_customer");
callsPerCustomer.Items.Should().NotBeEmpty().And.HaveCount(2);
foreach (var term in callsPerCustomer.Items)
{
var name = term.Terms("customer_name");
name.Items.Should().NotBeEmpty().And.HaveCount(1);
var sum = term.Sum("total_duration").Value;
sum.Should().BeGreaterThan(10);
var average = term.Average("average_duration").Value;
average.Should().BeGreaterThan(10);
}
}
