Python.LocalDB.test_LocalDBCreate.test_LocalDBCreate_CNBP()

Complexity

Conditions

6

Size

Total Lines	33
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

from pathlib import Path
def test_LocalDBCreate_CNBP():

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

This function should have a docstring.

    logger = logging.getLogger('UT_LocalDBCreate_CNBP')
    PathString = "TestCNBP.sqlite"

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

    # if SQL already exist, quit script.
    SQLPath = Path(PathString)

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

    # check if path is a fiela nd exist.
    if SQLPath.is_file():
        logger.info('Test SQLite database file already exist. Gonna mess with it!')
        ''''Delete current database! During testing only'''

This string statement has no effect and could be removed.

        os.remove(PathString)

    # Create the database
    assert create_localDB_CNBP(PathString)


    tableName = CNBP_schema_table_name #All CNBP database should have this table name.

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

    fetchallResult = check_header(PathString, tableName)

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

    # remove test database
    os.remove(PathString)

    # must pappend DBKEY creaed as the indexer column.

    for index in range(0, len(CNBP_schema)):
        print(fetchallResult[index][1])
        assert fetchallResult[index][1] == CNBP_schema[index]
        print(fetchallResult[index][2])
        assert fetchallResult[index][2] == CNBP_schema_types[index]


    return True

    test_LocalDBCreate()

Final newline missing