Revize 94f6d8b8

Re #8571 - Added get_next_id to CertificateRepository in order to be able to specify CRL/OCSP endpoints

src/dao/certificate_repository.py

@@ -388 +388 @@
             raise DatabaseException(e)
 
         return certificates
+
+    def get_next_id(self) -> int:
+        """
+        Get identifier of the next certificate that will be inserted into the database
+        :return: identifier of the next certificate that will be added into the database
+        """
+        # get next IDs of all tables
+        self.cursor.execute("SELECT * FROM SQLITE_SEQUENCE")
+        results = self.cursor.fetchall()
+
+        # search for next ID in Certificates table and return it
+        for result in results:
+            if result[0] == TAB_CERTIFICATES:
+                return result[1] + 1  # current last id + 1
+        # if certificates table is not present in the query results, return 1
+        return 1