From fb5e5269118bdfbf324b410defcd0831d4ecea27 Mon Sep 17 00:00:00 2001
From: rain <167982779@qq.com>
Date: Tue, 23 Apr 2024 16:33:33 +0800
Subject: [PATCH] 完善DB文件上传接口

---
 src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java |    9 ++++++++-
 1 files changed, 8 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java b/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java
index 77272e0..c7a4fb8 100644
--- a/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java
+++ b/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java
@@ -103,13 +103,20 @@
 //                        .eq(MediaFileEntity::getWorkspaceId, workspaceId)
 //                        .orderByDesc(MediaFileEntity::getId));
         Page<MediaFileEntity> pageData = mapper.selectPage(new Page<MediaFileEntity>(page, pageSize), new LambdaQueryWrapper<MediaFileEntity>()
-                .eq(MediaFileEntity::getWorkspaceId,workspaceId));
+                .eq(MediaFileEntity::getWorkspaceId,workspaceId)
+                .orderByDesc(MediaFileEntity::getCreateTime));
+
         List<MediaFileEntity> records = pageData.getRecords()
                 .stream()
                 .collect(Collectors.toList());
         return new PaginationData<MediaFileEntity>(records, new Pagination(pageData));
     }
 
+    public int  deleteMedia(String workspaceId, String fileId) {
+    int count=mapper.delete(new LambdaUpdateWrapper<MediaFileEntity>().eq(MediaFileEntity::getFileId, fileId)
+                .eq(MediaFileEntity::getWorkspaceId, workspaceId));
+    return count;
+    }
     @Override
     public URL getObjectUrl(String workspaceId, String fileId) {
         Optional<MediaFileEntity> mediaFileOpt = getMediaByFileId(workspaceId, fileId);

--
Gitblit v1.9.3