From ef51da5404827e826e979ad614950a9e0192f4c6 Mon Sep 17 00:00:00 2001 From: qixiaoning <jony.kee@outlook.com> Date: 星期五, 08 八月 2025 09:15:26 +0800 Subject: [PATCH] 调整数据推送相关接口 --- sync-service/models/camera.go | 20 -------------------- 1 files changed, 0 insertions(+), 20 deletions(-) diff --git a/sync-service/models/camera.go b/sync-service/models/camera.go index 65bacd6..6a1e2fa 100644 --- a/sync-service/models/camera.go +++ b/sync-service/models/camera.go @@ -282,23 +282,3 @@ return dbdel.RowsAffected, nil } - -// 鏌ヨ鍒楄〃鏁版嵁 -func GetListTask(ids []string) (items []Task, err error) { - //idList := strings.Join(ids, ",") - idList := "'" + strings.Join(ids, "','") + "'" - // 涓绘煡璇QL - //sqlStr := `select c.task_id, c.task_name from mal_task_video_link a left join mal_smart_task c on a.task_id = c.task_id where a.video_id in(?) ORDER BY a.task_id desc` - sqlStr := fmt.Sprintf(` - SELECT c.task_id, c.task_name - FROM mal_task_video_link a - LEFT JOIN mal_smart_task c ON a.task_id = c.task_id - WHERE a.video_id IN (%s) - ORDER BY a.task_id DESC - `, idList) - if err := db.Raw(sqlStr).Scan(&items).Error; err != nil { - fmt.Println(err.Error()) - return nil, err - } - return -} -- Gitblit v1.8.0