Python.LocalDB.create_CNBP.create_localDB_CNBP()

Complexity

Conditions

1

Size

Total Lines	23
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

#This file create a SQLite local database for CNBP requirement.
def create_localDB_CNBP(Path):

The name create_localDB_CNBP does not conform to the function naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

The name Path does not conform to the argument naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

This function should have a docstring.

    # name of the TableName to be created


    #Create the PRIMARY KEY column.


    load_dotenv()

    username = os.getenv("LORISusername")

The variable username seems to be unused.

    password = os.getenv("LORISpassword")

The variable password seems to be unused.

    # Create the variable array that store the columns information to be used later in loop for column creation

This line is too long as per the coding-style (111/100).

    TableName = schema.CNBP_schema_table_name

The name TableName does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    KeyField = schema.CNBP_schema_keyfield

The name KeyField does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    NewColumns = schema.CNBP_schema_fields

The name NewColumns does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    NewColumnsTypes = schema.CNBP_schema_fields_types

The name NewColumnsTypes does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    NewColumnSpec = zip(NewColumns, NewColumnsTypes)

The name NewColumnSpec does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    NewColumnSpecList = list(NewColumnSpec)

The name NewColumnSpecList does not conform to the variable naming conventions ((([a-z][a-z0-9_]{2,30})|(_[a-z0-9_]*))$).

    return LocalDBCreate(Path, TableName, KeyField, NewColumnSpecList)

    create_localDB_CNBP("..\LocalDB\LocalDB_CNBPs.sqlite")

Final newline missing

A suspicious escape sequence \L was found. Did you maybe forget to add an r prefix?