Python.LocalDB.test_LocalDBCreate

Complexity

Total Complexity

6

Size/Duplication

Total Lines	95
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	UT_LocalDBCreate.test_LocalDBCreate()	0	42	3
A	UT_LocalDBCreate.test_LocalDBCreate_CNBP()	0	32	3

from pathlib import Path

The name test_LocalDBCreate 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.

import logging
import os
import sys
import unittest
from LocalDB.create_CNBP import LocalDB_createCNBP

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

Unable to import 'LocalDB.create_CNBP'

from LocalDB.create import LocalDB_create

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

Unable to import 'LocalDB.create'

from LocalDB.query import LocalDB_query

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

Unable to import 'LocalDB.query'

from LocalDB.schema import CNBP_blueprint

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

Unable to import 'LocalDB.schema'

logging.basicConfig(stream=sys.stdout, level=logging.INFO)


class UT_LocalDBCreate(unittest.TestCase):

The name UT_LocalDBCreate does not conform to the class naming conventions ([A-Z_][a-zA-Z0-9]+$).

This class should have a docstring.

The variable __class__ seems to be unused.

    @staticmethod
    def test_LocalDBCreate():

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

This method should have a docstring.

        logger = logging.getLogger('UT_LocalDBCreate')
        PathString = "Test.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 fiel and 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)

        table_name = 'whatchacallitid_table'  # All CNBP database should have this table name.
        KeyFieldString = 'whatchacalitkeyfield'

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

        # must pappend DBKEY creaed as the indexer column.
        NewColumns = ['whasdfasdfasdffsdf', '123345sdb', 'CNvaasa31NID', 'CNFUasdfNID', 'Ha1234sh1', 'Hasha2', 'adsfas']

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

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

        NewColumnsTypes = ['TEXT', 'BLOB', 'REAL', 'TEXT', 'TEXT', 'BLOB', 'TEXT']

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_]*))$).

        # Create the database
        assert LocalDB_create.database(PathString, table_name, KeyFieldString, NewColumnSpecList)

        table_header = LocalDB_query.check_header(PathString, table_name)

        # Remove database before assertion that potentially fail.
        os.remove(PathString)

        NewColumns = [KeyFieldString, 'whasdfasdfasdffsdf', '123345sdb', 'CNvaasa31NID', 'CNFUasdfNID', 'Ha1234sh1',

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

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

                      'Hasha2', 'adsfas']
        NewColumnsTypes = ['INTEGER', 'TEXT', 'BLOB', 'REAL', 'TEXT', 'TEXT', 'BLOB', 'TEXT']

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

        for index in range(0, len(NewColumns)):
            print(table_header[index][1])
            assert table_header[index][1] == NewColumns[index]
            print(table_header[index][2])
            assert table_header[index][2] == NewColumnsTypes[index]

        return True

    @staticmethod
    def test_LocalDBCreate_CNBP():

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

This method 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 LocalDB_createCNBP.database(PathString)


        tableName = CNBP_blueprint.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 = LocalDB_query.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_blueprint.schema)):
            print(fetchallResult[index][1])
            assert fetchallResult[index][1] == CNBP_blueprint.schema[index]
            print(fetchallResult[index][2])
            assert fetchallResult[index][2] == CNBP_blueprint.schema_types[index]
        return True

if __name__ == '__main__':
    UT_LocalDBCreate.test_LocalDBCreate()

Final newline missing