Revize 25053504

Re #8471 - Corrected stylistics and warnings

src/impl/db_manager.py

@@ -7 +7 @@
 
 class DBManager(IRepository):
 
-    def create(self, sql: str, *args) -> bool:
+    @staticmethod
+    def create(sql: str, *args) -> bool:
         conn = None
         try:
             sql: str = args[0]
@@ -26 +27 @@
                 conn.close()
         return True
 
-    def read(self, sql: str, item_id: int = None):
+    @staticmethod
+    def read(sql: str, item_id: int = None):
         conn = None
         try:
             conn = sqlite3.connect(DATABASE_FILE)
             c = conn.cursor()
 
             if item_id is not None:
-                c.execute(sql, item_id)
+                list_item_id = [item_id]
+                c.execute(sql, list_item_id)
             else:
                 c.execute(sql)
 
@@ -47 +50 @@
                 conn.close()
         return records
 
-    def update(self, sql: str, *args) -> bool:
+    @staticmethod
+    def update(sql: str, *args) -> bool:
         conn = None
         try:
             conn = sqlite3.connect(DATABASE_FILE)
@@ -63 +67 @@
                 conn.close()
         return True
 
-    def delete(self, sql: str, item_id: int) -> bool:
+    @staticmethod
+    def delete(sql: str, item_id: int) -> bool:
         conn = None
         try:
             conn = sqlite3.connect(DATABASE_FILE)