From 99647c423596c86a314cb43edb5a6fb70817cca6 Mon Sep 17 00:00:00 2001
From: liusuyi <1951119284@qq.com>
Date: Wed, 01 Apr 2026 11:17:57 +0800
Subject: [PATCH] 优化

---
 ard-work/src/main/java/com/ard/work/mapper/ArdMediaVideoMapper.java |   18 +++++++++++++++---
 1 files changed, 15 insertions(+), 3 deletions(-)

diff --git a/ard-work/src/main/java/com/ard/work/mapper/ArdMediaVideoMapper.java b/ard-work/src/main/java/com/ard/work/mapper/ArdMediaVideoMapper.java
index cdc752b..bb465eb 100644
--- a/ard-work/src/main/java/com/ard/work/mapper/ArdMediaVideoMapper.java
+++ b/ard-work/src/main/java/com/ard/work/mapper/ArdMediaVideoMapper.java
@@ -15,11 +15,23 @@
     List<ArdMediaVideo> selectArdMediaVideoList(ArdMediaVideo query);
 
     /**
-     * 查询视频列表中本地视频和缩略图为null的数据
+     * 查询待处理视频(sync_status = 0)
      */
-    List<ArdMediaVideo> selectVideosWithNullMedia();
+    List<ArdMediaVideo> selectPendingVideos(@Param("limit") int limit);
 
-    List<ArdMediaVideo> selectVideosWithThumbnailNull();
+    /**
+     * 原子抢占:0 → 1
+     */
+    int markProcessing(@Param("id") Long id);
+
+    /**
+     * 更新同步状态
+     * 0 = 待处理
+     * 1 = 处理中
+     * 2 = 已完成
+     */
+    int updateSyncStatus(@Param("id") Long id, @Param("status") Integer status);
+
     /**
      * 根据任务ID查询视频
      */

--
Gitblit v1.9.3