File load_transactions_in_delta.py has 1270 lines of code (exceeds 250 allowed). Consider refactoring. Open
import copy
import logging
import re
from contextlib import contextmanagerFunction initial_run has a Cognitive Complexity of 51 (exceeds 15 allowed). Consider refactoring. Open
def initial_run(self, next_last_load):
"""
Procedure to create & set up transaction_id_lookup and award_id_lookup tables and create other tables in
int database that will be populated by subsequent calls.
"""- Read upRead up
Cognitive Complexity
Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.
A method's cognitive complexity is based on a few simple rules:
- Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
- Code is considered more complex for each "break in the linear flow of the code"
- Code is considered more complex when "flow breaking structures are nested"
Further reading
Cyclomatic complexity is too high in method initial_run. (47) Open
def initial_run(self, next_last_load):
"""
Procedure to create & set up transaction_id_lookup and award_id_lookup tables and create other tables in
int database that will be populated by subsequent calls.
"""- Read upRead up
- Exclude checks
Cyclomatic Complexity
Cyclomatic Complexity corresponds to the number of decisions a block of code contains plus 1. This number (also called McCabe number) is equal to the number of linearly independent paths through the code. This number can be used as a guide when testing conditional logic in blocks.
Radon analyzes the AST tree of a Python program to compute Cyclomatic Complexity. Statements have the following effects on Cyclomatic Complexity:
| Construct | Effect on CC | Reasoning |
|---|---|---|
| if | +1 | An if statement is a single decision. |
| elif | +1 | The elif statement adds another decision. |
| else | +0 | The else statement does not cause a new decision. The decision is at the if. |
| for | +1 | There is a decision at the start of the loop. |
| while | +1 | There is a decision at the while statement. |
| except | +1 | Each except branch adds a new conditional path of execution. |
| finally | +0 | The finally block is unconditionally executed. |
| with | +1 | The with statement roughly corresponds to a try/except block (see PEP 343 for details). |
| assert | +1 | The assert statement internally roughly equals a conditional statement. |
| Comprehension | +1 | A list/set/dict comprehension of generator expression is equivalent to a for loop. |
| Boolean Operator | +1 | Every boolean operator (and, or) adds a decision point. |
Function source_subquery_sql has a Cognitive Complexity of 34 (exceeds 15 allowed). Consider refactoring. Open
def source_subquery_sql(self, transaction_type=None):
def build_date_format_sql(col: TransactionColumn, is_casted_to_date: bool = True) -> str:
"""Builder function to wrap a column in date-parsing logic.
It will either parse it in mmddYYYY format with - or / as a required separator, or in YYYYmmdd format- Read upRead up
Cognitive Complexity
Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.
A method's cognitive complexity is based on a few simple rules:
- Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
- Code is considered more complex for each "break in the linear flow of the code"
- Code is considered more complex when "flow breaking structures are nested"