Revize d65b022d

Re #8578 - Cover private_key_repository tests
- created tests for functions create, read, read_all, update, delete
- (+) edited certificate_repository to the same stylistics

src/dao/private_key_repository.py

@@ -1 +1 @@
 from sqlite3 import Connection, Cursor, Error
 from typing import List
 
+from src.exceptions.database_exception import DatabaseException
 from src.model.private_key import PrivateKey
 from src.constants import *
 
@@ -38 +39 @@
             last_id = self.cursor.lastrowid
             self.connection.commit()
         except Error as e:
-            print(e)
-            return None
+            raise DatabaseException(e)
 
         return last_id
 
@@ -59 +59 @@
             self.cursor.execute(sql, values)
             private_key_row = self.cursor.fetchone()
 
+            if private_key_row is None:
+                return None
+
             private_key: PrivateKey = PrivateKey(private_key_row[0],
                                                  private_key_row[1],
                                                  private_key_row[2])
         except Error as e:
-            print(e)
-            return None
+            raise DatabaseException(e)
 
-        if len(private_key_row) > 0:
-            return private_key
-        else:
-            return None
+        return private_key
 
     def read_all(self):
         """
@@ -89 +88 @@
                                                private_key_row[1],
                                                private_key_row[2]))
         except Error as e:
-            print(e)
-            return None
+            raise DatabaseException(e)
 
-        if len(private_keys) > 0:
-            return private_keys
-        else:
-            return None
+        return private_keys
 
     def update(self, private_key_id: int, private_key: PrivateKey) -> bool:
         """
@@ -118 +113 @@
             self.cursor.execute(sql, values)
             self.connection.commit()
         except Error as e:
-            print(e)
-            return False
+            raise DatabaseException(e)
 
-        return True
+        return self.cursor.rowcount > 0
 
     def delete(self, private_key_id: int) -> bool:
         """
@@ -139 +133 @@
             self.cursor.execute(sql, values)
             self.connection.commit()
         except Error as e:
-            print(e)
-            return False
+            raise DatabaseException
 
         return self.cursor.rowcount > 0