sum method

Implementation

Future<num?> sum(String columnName) async {
  try {
    final db = await database;
    final query = "SELECT SUM($columnName) as sum_value FROM $table";

    if (_whereConditions.isNotEmpty) {
      final whereClause = _whereConditions.join(" ");
      final fullQuery = "$query WHERE $whereClause";
      final result = await db.rawQuery(fullQuery, _bindings);
      return result.first['sum_value'] as num?;
    }

    final result = await db.rawQuery(query);
    return result.first['sum_value'] as num?;
  } catch (e) {
    throw DatabaseException('Failed to get sum for column $columnName: $e');
  }
}