Revize d6ccc8ca

Re #8471 - Implemented selection of all private keys

src/dao/private_key_repository.py

@@ -1 +1 @@
 from sqlite3 import Connection, Cursor, Error
+from typing import List
 
 from src.db_objects.private_key import PrivateKey
 from src.constants import *
@@ -70 +71 @@
         else:
             return None
 
+    def read_all(self):
+        """
+        Reads (selects) all private keys.
+
+        :return: list of private keys
+        """
+
+        try:
+            sql = f"SELECT * FROM {TAB_PRIVATE_KEYS}"
+            self.cursor.execute(sql)
+            private_key_rows = self.cursor.fetchall()
+
+            private_keys: List[PrivateKey] = []
+            for private_key_row in private_key_rows:
+                private_keys.append(PrivateKey(private_key_row[0],
+                                               private_key_row[1],
+                                               private_key_row[2]))
+        except Error as e:
+            print(e)
+            return None
+
+        if len(private_keys) > 0:
+            return private_keys
+        else:
+            return None
+
     def update(self, private_key_id: int, private_key: PrivateKey) -> bool:
         """
         Updates a private key.