Added get api for libraryquery object for import/export feature in EE

dragonpoo · ludomikula · commit df479c6f67ec · 2025-03-12T08:40:17.000+01:00
diff --git a/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryApiService.java b/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryApiService.java
@@ -11,6 +11,8 @@
 public interface LibraryQueryApiService {
     Mono<List<LibraryQueryView>> listLibraryQueries(String name);
 
+    Mono<LibraryQueryView> get(String libraryQueryId);
+
     Mono<LibraryQueryView> create(LibraryQuery libraryQuery);
 
     Mono<Boolean> update(String libraryQueryId, UpsertLibraryQueryRequest upsertLibraryQueryRequest);
diff --git a/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryApiServiceImpl.java b/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryApiServiceImpl.java
@@ -113,6 +113,13 @@ private Flux<LibraryQuery> getByOrgIdWithDatasourcePermissions(String orgId) {
                         set -> set.contains(libraryQuery.getQuery().getDatasourceId())));
     }
 
+    @Override
+    public Mono<LibraryQueryView> get(String libraryQueryId) {
+        return libraryQueryService.getById(libraryQueryId)
+                .zipWhen(lb -> userService.findById(lb.getCreatedBy()))
+                .map(tuple -> LibraryQueryView.from(tuple.getT1(), tuple.getT2()));
+    }
+
     @Override
     public Mono<LibraryQueryView> create(LibraryQuery libraryQuery) {
         return checkLibraryQueryManagementPermission(libraryQuery)
diff --git a/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryController.java b/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryController.java
@@ -53,6 +53,12 @@ public Mono<PageResponseView<?>> list(@RequestParam(required = false, defaultVal
         return fluxToPageResponseView(pageNum, pageSize, flux);
     }
 
+    @Override
+    public Mono<ResponseView<LibraryQueryView>> get(@PathVariable String libraryQueryId) {
+        return libraryQueryApiService.get(libraryQueryId)
+                .map(ResponseView::success);
+    }
+
     @Override
     public Mono<ResponseView<LibraryQueryView>> create(@RequestBody LibraryQuery libraryQuery) {
         return libraryQueryApiService.create(libraryQuery)
diff --git a/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryEndpoints.java b/server/api-service/lowcoder-server/src/main/java/org/lowcoder/api/query/LibraryQueryEndpoints.java
@@ -43,6 +43,15 @@ public Mono<PageResponseView<?>> list(@RequestParam(required = false, defaultVal
 															   @RequestParam(required = false, defaultValue = "1") int pageNum,
 															   @RequestParam(required = false, defaultValue = "100") int pageSize);
 
+	@Operation(
+			tags = TAG_LIBRARY_QUERY_MANAGEMENT,
+			operationId = "getLibraryQuery",
+			summary = "Get a Library By Id",
+			description = "Get a Library Query by Id."
+	)
+	@GetMapping("/{libraryQueryId}")
+	public Mono<ResponseView<LibraryQueryView>> get(@PathVariable String libraryQueryId);
+
 	@Operation(
 			tags = TAG_LIBRARY_QUERY_MANAGEMENT,
 		    operationId = "createLibraryQuery",
