File helpers.py has 1800 lines of code (exceeds 250 allowed). Consider refactoring.

Open

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the

Function get_sqla_query has a Cognitive Complexity of 228 (exceeds 5 allowed). Consider refactoring.

Open

    def get_sqla_query(  # pylint: disable=too-many-arguments,too-many-locals,too-many-branches,too-many-statements
        self,
        apply_fetch_values_predicate: bool = False,
        columns: Optional[list[Column]] = None,
        extras: Optional[dict[str, Any]] = None,

• Read up
  Read up

Function import_from_dict has a Cognitive Complexity of 43 (exceeds 5 allowed). Consider refactoring.

Open

    def import_from_dict(
        # pylint: disable=too-many-arguments,too-many-branches,too-many-locals
        cls,
        dict_rep: dict[Any, Any],
        parent: Optional[Any] = None,

• Read up
  Read up

ExploreMixin has 47 functions (exceeds 20 allowed). Consider refactoring.

Open

class ExploreMixin:  # pylint: disable=too-many-public-methods
    """
    Allows any flask_appbuilder.Model (Query, Table, etc.)
    to be used to power a chart inside /explore
    """

Function filter_values_handler has a Cognitive Complexity of 26 (exceeds 5 allowed). Consider refactoring.

Open

    def filter_values_handler(  # pylint: disable=too-many-arguments
        values: Optional[FilterValues],
        operator: str,
        target_generic_type: utils.GenericDataType,
        target_native_type: Optional[str] = None,

• Read up
  Read up

Function get_sqla_query has 24 arguments (exceeds 4 allowed). Consider refactoring.

Open

    def get_sqla_query(  # pylint: disable=too-many-arguments,too-many-locals,too-many-branches,too-many-statements

Function get_sqla_query has 64 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    def get_sqla_query(  # pylint: disable=too-many-arguments,too-many-locals,too-many-branches,too-many-statements
        self,
        apply_fetch_values_predicate: bool = False,
        columns: Optional[list[Column]] = None,
        extras: Optional[dict[str, Any]] = None,

Function _normalize_prequery_result_type has a Cognitive Complexity of 14 (exceeds 5 allowed). Consider refactoring.

Open

    def _normalize_prequery_result_type(
        self,
        row: pd.Series,
        dimension: str,
        columns_by_name: dict[str, "TableColumn"],

• Read up
  Read up

Function export_to_dict has a Cognitive Complexity of 13 (exceeds 5 allowed). Consider refactoring.

Open

    def export_to_dict(
        self,
        recursive: bool = True,
        include_parent_ref: bool = False,
        include_defaults: bool = False,

• Read up
  Read up

Function __init__ has 12 arguments (exceeds 4 allowed). Consider refactoring.

Open

    def __init__(  # pylint: disable=too-many-arguments

Function dttm_sql_literal has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

    def dttm_sql_literal(self, dttm: datetime, col: "TableColumn") -> str:
        """Convert datetime object to a SQL expression string"""

        sql = (
            self.db_engine_spec.convert_dttm(col.type, dttm, db_extra=self.db_extra)

• Read up
  Read up

Function filter_values_handler has 8 arguments (exceeds 4 allowed). Consider refactoring.

Open

    def filter_values_handler(  # pylint: disable=too-many-arguments

Function export_schema has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

    def export_schema(
        cls, recursive: bool = True, include_parent_ref: bool = False
    ) -> dict[str, Any]:
        """Export schema as a dictionary"""
        parent_excludes = set()

• Read up
  Read up

Function exc_query has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

    def exc_query(self, qry: Any) -> QueryResult:
        qry_start_dttm = datetime.now()
        query_str_ext = self.get_query_str_extended(qry)
        sql = query_str_ext.sql
        status = QueryStatus.SUCCESS

• Read up
  Read up

Function get_time_filter has 7 arguments (exceeds 4 allowed). Consider refactoring.

Open

    def get_time_filter(  # pylint: disable=too-many-arguments

Function import_from_dict has 6 arguments (exceeds 4 allowed). Consider refactoring.

Open

    def import_from_dict(

Avoid deeply nested control flow statements.

Open

                        if eq:
                            cond = or_(is_null_cond, sqla_col.in_(eq_without_none))
                        else:
                            cond = is_null_cond
                    else:

Avoid deeply nested control flow statements.

Open

                        if target_generic_type != GenericDataType.STRING:
                            sqla_col = sa.cast(sqla_col, sa.String)

Avoid deeply nested control flow statements.

Open

                        if op == utils.FilterOperator.LIKE.value:
                            where_clause_and.append(sqla_col.like(eq))
                        else:
                            where_clause_and.append(sqla_col.ilike(eq))
                    elif (

Function get_sqla_row_level_filters has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

    def get_sqla_row_level_filters(
        self,
        template_processor: BaseTemplateProcessor,
    ) -> list[TextClause]:
        """

• Read up
  Read up

Avoid too many return statements within this function.

Open

                return utils.cast_to_boolean(value)

Avoid too many return statements within this function.

Open

            return value

Avoid too many return statements within this function.

Open

        return f"""'{dttm.strftime("%Y-%m-%d %H:%M:%S.%f")}'"""

Function validate_adhoc_subquery has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

def validate_adhoc_subquery(
    sql: str,
    database_id: int,
    default_schema: str,
) -> str:

• Read up
  Read up

Function make_orderby_compatible has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

    def make_orderby_compatible(
        self, select_exprs: list[ColumnElement], orderby_exprs: list[ColumnElement]
    ) -> None:
        """
        If needed, make sure aliases for selected columns are not used in

• Read up
  Read up