Python.LocalDB.create_CNBP

Complexity

Total Complexity

1

Size/Duplication

Total Lines	38
Duplicated Lines	0 %

Importance

Changes

0

1 Function

Rating	Name	Duplication	Size	Complexity
A	create_localDB_CNBP()	0	23	1

#This file create a SQLite local database for CNBP requirement.

The name create_CNBP does not conform to the module naming conventions ((([a-z_][a-z0-9_]*)|([A-Z][a-zA-Z0-9]+))$).

This module should have a docstring.

#Creation: 2018-07-11T160228EST
#Author: Yang Ding

import os
from dotenv import load_dotenv
from LocalDB.create import LocalDBCreate

The name create does not seem to exist in module LocalDB.

Unable to import 'LocalDB.create'

from LocalDB import schema

The name schema does not seem to exist in module LocalDB.

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)

# Only executed when running directly.
if __name__ == '__main__':
    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?