weekorm.db.execute_sql() - Code Metrics - mitrofun/weakorm - Measure and Improve Code Quality continuously with Scrutinizer

weekorm.db.execute_sql() A
last analyzed 2018-09-01 21:11 UTC

↳ Parent: weekorm.db

Complexity

Conditions

Size

Total Lines	7
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	7
nop	2
dl	0
loc	7
rs	10
c	0
b	0
f	0

import sqlite3
class SomeClass:
    def some_method(self):
        """Do x and return foo."""

SETTINGS = {
    'db_name': '',
    'connection': '',
}


def set_db_name(db_name):
class SomeClass:
    def some_method(self):
        """Do x and return foo."""
    SETTINGS['db_name'] = db_name
    SETTINGS['connection'] = sqlite3.connect(db_name)


def get_cursor():
class SomeClass:
    def some_method(self):
        """Do x and return foo."""
    if not SETTINGS.get('connection'):

        SETTINGS['connection'] = sqlite3.connect(SETTINGS['db_name'])
    cursor = SETTINGS['connection'].cursor()

    return cursor


def db_commit():
class SomeClass:
    def some_method(self):
        """Do x and return foo."""
    SETTINGS['connection'].commit()



def execute_sql(cursor, sql):
class SomeClass:
    def some_method(self):
        """Do x and return foo."""
    try:
        cursor.execute(sql)
    except Exception as e:

        print('error')
        print(sql)
        raise e


class DataBase:
class SomeClass:
    def some_method(self):
        """Do x and return foo."""

    def __init__(self, name):
        self.db_name = name
        self.connection = sqlite3.connect(name)
        self.cursor = self.connection.cursor()
        self._save_settings()

    def _save_settings(self):
        SETTINGS['connection'] = self.connection
        SETTINGS['db_name'] = self.db_name

    def __del__(self):
        self.connection.close()


1			import sqlite3
			0 ignored issues – show Coding Style introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report This module should have a docstring. The coding style of this project requires that you add a docstring to this code element. Below, you find an example for methods: class SomeClass: def some_method(self): """Do x and return foo.""" If you would like to know more about docstrings, we recommend to read PEP-257: Docstring Conventions. Loading history...
2
3			SETTINGS = {
4			'db_name': '',
5			'connection': '',
6			}
7
8
9			def set_db_name(db_name):
			0 ignored issues – show Coding Style introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report This function should have a docstring. The coding style of this project requires that you add a docstring to this code element. Below, you find an example for methods: class SomeClass: def some_method(self): """Do x and return foo.""" If you would like to know more about docstrings, we recommend to read PEP-257: Docstring Conventions. Loading history...
10			SETTINGS['db_name'] = db_name
11			SETTINGS['connection'] = sqlite3.connect(db_name)
12
13
14			def get_cursor():
			0 ignored issues – show Coding Style introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report This function should have a docstring. The coding style of this project requires that you add a docstring to this code element. Below, you find an example for methods: class SomeClass: def some_method(self): """Do x and return foo.""" If you would like to know more about docstrings, we recommend to read PEP-257: Docstring Conventions. Loading history...
15			if not SETTINGS.get('connection'):
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report The variable `SETTINGS` does not seem to be defined. Loading history...
16			SETTINGS['connection'] = sqlite3.connect(SETTINGS['db_name'])
17			cursor = SETTINGS['connection'].cursor()
			0 ignored issues – show Bug introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report The Instance of `str` does not seem to have a member named `cursor`. This check looks for calls to members that are non-existent. These calls will fail. The member could have been renamed or removed. Loading history...
18			return cursor
19
20
21			def db_commit():
			0 ignored issues – show Coding Style introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report This function should have a docstring. The coding style of this project requires that you add a docstring to this code element. Below, you find an example for methods: class SomeClass: def some_method(self): """Do x and return foo.""" If you would like to know more about docstrings, we recommend to read PEP-257: Docstring Conventions. Loading history...
22			SETTINGS['connection'].commit()
			0 ignored issues – show Bug introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report The Instance of `str` does not seem to have a member named `commit`. This check looks for calls to members that are non-existent. These calls will fail. The member could have been renamed or removed. Loading history...
23
24
25			def execute_sql(cursor, sql):
			0 ignored issues – show Coding Style introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report This function should have a docstring. The coding style of this project requires that you add a docstring to this code element. Below, you find an example for methods: class SomeClass: def some_method(self): """Do x and return foo.""" If you would like to know more about docstrings, we recommend to read PEP-257: Docstring Conventions. Loading history...
26			try:
27			cursor.execute(sql)
28			except Exception as e:
			0 ignored issues – show Coding Style Naming introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report The name `e` does not conform to the variable naming conventions (`(([a-z][a-z0-9_]{2,30})\|(_[a-z0-9_]*))$`). This check looks for invalid names for a range of different identifiers. You can set regular expressions to which the identifiers must conform if the defaults do not match your requirements. If your project includes a Pylint configuration file, the settings contained in that file take precedence. To find out more about Pylint, please refer to their site. Loading history...
29			print('error')
30			print(sql)
31			raise e
32
33
34			class DataBase:
			0 ignored issues – show Coding Style introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report This class should have a docstring. The coding style of this project requires that you add a docstring to this code element. Below, you find an example for methods: class SomeClass: def some_method(self): """Do x and return foo.""" If you would like to know more about docstrings, we recommend to read PEP-257: Docstring Conventions. Loading history... Unused Code introduced 2018-08-19 20:26 UTC by Report Bug Copy Issue Report The variable `__class__` seems to be unused. Loading history...
35
36			def __init__(self, name):
37			self.db_name = name
38			self.connection = sqlite3.connect(name)
39			self.cursor = self.connection.cursor()
40			self._save_settings()
41
42			def _save_settings(self):
43			SETTINGS['connection'] = self.connection
44			SETTINGS['db_name'] = self.db_name
45
46			def __del__(self):
47			self.connection.close()
48

mitrofun / weakorm

weekorm.db.execute_sql() A last analyzed 2018-09-01 21:11 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

weekorm.db.execute_sql() A
last analyzed 2018-09-01 21:11 UTC