Revize 33523b92

SQL for deleting external catalog items changed

re #9753

backend/src/main/java/cz/zcu/kiv/backendapi/external/ExternalCatalogItemItemServiceImpl.java

@@ -19 +19 @@
 import java.nio.file.Paths;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
+import java.sql.Statement;
 import java.util.ArrayList;
 import java.util.List;
 import java.util.concurrent.Callable;
@@ -124 +125 @@
             e.printStackTrace();
         }
 
-        externalCatalogItemRepository.deleteAll(); // clears database – updated list will be stored later
+        // clears database – updated list will be stored later
+        String sqlDelete = String.format("DELETE FROM %s", ExternalCatalogItem.class.getAnnotation(Table.class).name());
+        try (Connection connection = hikariDataSource.getConnection();
+             Statement statementDelete = connection.createStatement()) {
+            statementDelete.execute(sqlDelete);
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
 
         try {
             addPleiadesRecords();