def test_count_with_predicate(self):
count_ = self.map.aggregate(count(), greater_or_equal("this", 1))
self.assertEqual(49, count_)
def test_count_with_attribute_path(self):
count_ = self.map.aggregate(count("this"))
self.assertEqual(50, count_)
def test_count(self):
count_ = self.map.aggregate(count())
self.assertEqual(50, count_)
"OrPredicate": predicate.or_(
predicate.sql(_sql_string),
predicate.equal(_sql_string, REFERENCE_OBJECTS["Integer"]),
predicate.not_equal(_sql_string, REFERENCE_OBJECTS["Integer"]),
predicate.greater(_sql_string, REFERENCE_OBJECTS["Integer"]),
predicate.greater_or_equal(_sql_string, REFERENCE_OBJECTS["Integer"]),
),
"InstanceOfPredicate": predicate.instance_of(
"com.hazelcast.nio.serialization.compatibility.CustomStreamSerializable"
),
"DistinctValuesAggregator": aggregator.distinct(_sql_string),
"MaxAggregator": aggregator.max_(_sql_string),
"MaxByAggregator": aggregator.max_by(_sql_string),
"MinAggregator": aggregator.min_(_sql_string),
"MinByAggregator": aggregator.min_by(_sql_string),
"CountAggregator": aggregator.count(_sql_string),
"NumberAverageAggregator": aggregator.number_avg(_sql_string),
"IntegerAverageAggregator": aggregator.int_avg(_sql_string),
"LongAverageAggregator": aggregator.long_avg(_sql_string),
"DoubleAverageAggregator": aggregator.double_avg(_sql_string),
"IntegerSumAggregator": aggregator.int_sum(_sql_string),
"LongSumAggregator": aggregator.long_sum(_sql_string),
"DoubleSumAggregator": aggregator.double_sum(_sql_string),
"FixedSumAggregator": aggregator.fixed_point_sum(_sql_string),
"FloatingPointSumAggregator": aggregator.floating_point_sum(_sql_string),
"SingleAttributeProjection": projection.single_attribute(_sql_string),
"MultiAttributeProjection": projection.multi_attribute(
_sql_string, _sql_string, _sql_string
),
"IdentityProjection": projection.identity(),
}
import hazelcast
from hazelcast.aggregator import count, number_avg, max_by
from hazelcast.predicate import less_or_equal
client = hazelcast.HazelcastClient()
people = client.get_map("people").blocking()
people.put_all({
"Philip": 46,
"Elizabeth": 44,
"Henry": 13,
"Paige": 15,
})
people_count = people.aggregate(count())
print("There are %d people." % people_count)
children_count = people.aggregate(count(), less_or_equal("this", 18))
print("There are %d children." % children_count)
average_age = people.aggregate(number_avg())
print("Average age is %f." % average_age)
eldest_person = people.aggregate(max_by("this"))
print("Eldest person is %s, with the age of %d." %
(eldest_person.key, eldest_person.value))
client.shutdown()
"InstanceOfPredicate":
predicate.instance_of(
"com.hazelcast.nio.serialization.compatibility.CustomStreamSerializable"
),
"DistinctValuesAggregator":
aggregator.distinct(_sql_string),
"MaxAggregator":
aggregator.max_(_sql_string),
"MaxByAggregator":
aggregator.max_by(_sql_string),
"MinAggregator":
aggregator.min_(_sql_string),
"MinByAggregator":
aggregator.min_by(_sql_string),
"CountAggregator":
aggregator.count(_sql_string),
"NumberAverageAggregator":
aggregator.number_avg(_sql_string),
"IntegerAverageAggregator":
aggregator.int_avg(_sql_string),
"LongAverageAggregator":
aggregator.long_avg(_sql_string),
"DoubleAverageAggregator":
aggregator.double_avg(_sql_string),
"IntegerSumAggregator":
aggregator.int_sum(_sql_string),
"LongSumAggregator":
aggregator.long_sum(_sql_string),
"DoubleSumAggregator":
aggregator.double_sum(_sql_string),
"FixedSumAggregator":