max method

Implementation

Future<dynamic> max(String columnName) async {
  try {
    final db = await database;
    final query = "SELECT MAX($columnName) as max_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['max_value'];
    }

    final result = await db.rawQuery(query);
    return result.first['max_value'];
  } catch (e) {
    throw DatabaseException('Failed to get max value for column $columnName: $e');
  }
}