How to Apply aggregation function of column like sum , avg

[VarmaTech]

Hi ,
how to get total sum of particular column , some thing like aggregation functionality , does sembast function this types of function.

[alextekartik]

Unfortunately no. However, data being in memory getting all the records and performing operation on the results does not cost much. example below to compute the sum and average of the fied age:

var store = intMapStoreFactory.store();
await store.addAll(db, [
  {'name': 'cat', 'age': 13},
  {'name': 'dog', 'age': 12},
  {'name': 'rabbit', 'age': 8}
]);
var ages = (await store.find(db)).map((snapshot) => snapshot['age']);

// Compute sum
var sum = ages.reduce((value, element) => value + element);
// Compute average
var average = sum / ages.length;