GoogleCloudPlatform / bigquery-utils - Conditional Complexity

Intro

Conditional complexity (also called cyclomatic complexity) is a term used to measure the complexity of software. The term refers to the number of possible paths through a program function. A higher value ofter means higher maintenance and testing costs (infosecinstitute.com).
Conditional complexity is calculated by counting all conditions in the program that can affect the execution path (e.g. if statement, loops, switches, and/or operators, try and catch blocks...).
Conditional complexity is measured at the unit level (methods, functions...).
Units are classified in four categories based on the measured McCabe index: 1-5 (simple units), 6-10 (medium complex units), 11-25 (complex units), 26+ (very complex units).

Learn more...

Conditional Complexity Overall

There are 649 units with 7,238 lines of code in units (42.8% of code).

0 very complex units (0 lines of code)
1 complex units (91 lines of code)
18 medium complex units (1,001 lines of code)
48 simple units (1,247 lines of code)
582 very simple units (4,899 lines of code)

Legend:

51+

26-50

11-25

6-10

1-5

Alternative Visuals

3D view of all units

Conditional Complexity per Extension

51+

26-50

11-25

6-10

1-5

Conditional Complexity per Logical Component

primary logical decomposition

51+

26-50

11-25

6-10

1-5

Most Complex Units

Top 50 most complex units

Unit	# lines	McCabe index	# params
def legacy_sql_scan() in tools/legacy_sql_tranlsation_helper/patternScan.py	91	31	1
def backlog_subscriber() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py	84	25	4
public QueryRegex() in tools/template_based_query_generation/src/main/java/token/QueryRegex.java	79	21	2
public int getNumColumns() in tools/template_based_query_generation/src/main/java/data/Table.java	81	20	0
public void generateQueries() in tools/template_based_query_generation/src/main/java/QueryGenerator.java	75	18	0
public static void main() in tools/query_breakdown/src/main/java/com/google/bigquery/Main.java	117	18	1
grpc::Status ToGrpcStatus() in tools/zetasql_helper/zetasql_helper/local_service/local_service_grpc.cc	40	17	1
def get_batches_for_gsurl() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	58	15	3
def create_job_id() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	31	15	3
public SkeletonPiece tokenize() in tools/template_based_query_generation/src/main/java/token/TokenProvider.java	41	14	2
public LocationTracker replace() in tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java	38	14	6
public static void main() in tools/query_verification/src/main/java/com/google/bigquery/Main.java	57	14	1
private List parseResults() in tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	40	14	2
public List parseResults() in tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java	51	13	2
private void loop() in tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java	48	12	5
public IFixer getFixer() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FixerFactory.java	39	11	2
def external_query() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	54	11	6
def start_backfill_subscriber_if_not_running() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py	34	11	3
def main() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py	34	11	2
public BigQuerySqlError getError() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/SqlErrorFactory.java	31	10	1
def main() in tools/cloud_functions/gcs_event_based_ingest/backfill.py	51	10	1
def triage_event() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py	51	10	5
def filter_tables() in tools/cloud_functions/bq_table_snapshots/bq_backup_fetch_tables_names/main.py	10	10	2
public static ArrayList replace() in tools/query_breakdown/src/main/java/com/google/bigquery/ReplacementLogic.java	27	10	3
def crawl() in tools/unsupervised_dataset/sql_crawler/crawler.py	20	9	1
public static void main() in tools/unsupervised_dataset/sql_classifier/classifier/src/main/java/Classifier.java	37	9	1
def check_for_bq_job_and_children_errors() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	33	9	4
private List convert() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/NoMatchingSignatureFixer.java	34	8	2
private static Signature parseArgumentTypes() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/NoMatchingSignatureError.java	28	8	1
public static CommandLineInteraction create() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/CommandLineInteraction.java	25	8	3
def get_folders_in_gcs_path_prefix() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	18	8	4
def wait_on_bq_job_id() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	18	8	5
public LocationTracker delete() in tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java	28	8	4
private void validateOAuthUserConfigObject() in tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserConfig.java	19	8	1
private static void exportToCsv() in tools/query_verification/src/main/java/com/google/bigquery/QueryVerifier.java	31	8	3
public List generateDdlStatementsFromJsonSchema() in tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	36	8	0
public List getTableInfoFromJsonSchema() in tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java	31	8	0
public static int editDistance() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/StringUtil.java	29	7	3
private SkeletonPiece generateValueExpression() in tools/template_based_query_generation/src/main/java/token/TokenProvider.java	24	7	1
def close() in tools/unsupervised_dataset/sql_crawler/crawler_log.py	15	7	1
def extract_links() in tools/unsupervised_dataset/sql_crawler/extractor.py	18	7	1
export function toCombinedString() in tools/vscode_sql_extraction/src/query.ts	24	7	1
def construct_config() in tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	31	7	3
private static Kind convertKind() in tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/Token.java	17	7	1
ParseTokenProto_Kind serialize_token_kind() in tools/zetasql_helper/zetasql_helper/token/token.cc	18	7	1
public static List readFromString() in tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java	41	7	1
override fun visitExpr_stmt() in tools/sql_extraction/src/main/kotlin/PythonAnalyzer.kt	29	7	1
public static List compareResults() in tools/query_verification/src/main/java/com/google/bigquery/QueryVerifier.java	26	7	2
public static CommandLine buildCommand() in tools/query_verification/src/main/java/com/google/bigquery/Main.java	27	7	1
public Kind getKind() in tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/ZetaSqlToken.java	15	6	0