Revize 805077f5

Re #8471 - Error correction after review

src/dao/private_key_repository.py

@@ -17 +17 @@
         self.connection = connection
         self.cursor = cursor
 
-    def create(self, private_key: PrivateKey) -> bool:
+    def create(self, private_key: PrivateKey):
         """
         Creates a private key.
 
@@ -34 +34 @@
             values = [private_key.private_key,
                       private_key.password]
             self.cursor.execute(sql, values)
+            last_id = self.cursor.lastrowid
             self.connection.commit()
-
         except Error as e:
             print(e)
-            return False
+            return None
 
-        return True
+        return last_id
 
     def read(self, private_key_id: int):
         """
@@ -65 +65 @@
             print(e)
             return None
 
-        return private_key
+        if len(private_key_row) > 0:
+            return private_key
+        else:
+            return None
 
     def update(self, private_key_id: int, private_key: PrivateKey) -> bool:
         """
@@ -83 +86 @@
                    f"{COL_PASSWORD} = ? "
                    f"WHERE {COL_ID} = ?")
             values = [private_key.private_key,
-                      private_key.password]
+                      private_key.password,
+                      private_key_id]
             self.cursor.execute(sql, values)
             self.connection.commit()
         except Error as e: