sum<T extends Table, D> method

  1. @override
Future<double?> sum<T extends Table, D>(
  1. String columnName, {
  2. Expression<bool>? filter,
})
override

Implementation

@override
Future<double?> sum<T extends Table, D>(
  String columnName, {
  Expression<bool>? filter,
}) async {
  try {
    final table = _getTable<T, D>();
    final whereClause = filter != null ? ' WHERE $filter' : '';

    final sql =
        'SELECT SUM($columnName) as sum FROM ${table.actualTableName}$whereClause';
    final results = await _database.customSelect(sql).get();

    if (results.isEmpty) return null;
    return results.first.data['sum'] as double?;
  } catch (e) {
    throw DatabaseBridgeException(error: e);
  }
}