min method

Implementation

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

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