1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
| package models
|
| import (
| "sort"
| "strings"
| )
|
| type CameraTaskLink struct {
| CameraIds string `gorm:"column:camera_ids" json:"camera_ids"` //需要对摄像机id先进行排序
| LinkTaskId string `gorm:"column:link_task_id" json:"link_task_id"`
| }
|
| func (CameraTaskLink) TableName() string {
| return "camera_task_link"
| }
|
| func (ctl *CameraTaskLink) FindByCameraIds(cameraIds []string) (list []CameraTaskLink, err error) {
| sort.Strings(cameraIds)
| idStr := strings.Join(cameraIds, ",")
| if err := db.Table(ctl.TableName()).Where("camera_ids like ?", "%"+idStr+"%").Scan(&list).Error; err != nil {
| return nil, err
| }
| return list, err
| }
|
| func (ctl *CameraTaskLink) FindAll() (list []CameraTaskLink, err error) {
| if err := db.Table(ctl.TableName()).Find(&list).Error; err != nil {
| return nil, err
| }
| return list, err
| }
|
|
