smart_intersectionV2.0/server/dao/dev_camera.go

package dao

import (
	"server/global"
)

type Camera struct {
	global.GVA_MODEL
	Name      string `json:"name" gorm:"column:name;comment:'名称'"`
	Ip        string `json:"ip" form:"ip" gorm:"comment:'ip'"`
	Port      string `json:"port" form:"port" gorm:"comment:'port'"`
	UserName  string `json:"username" gorm:"column:username;comment:'用户名'"`
	Password  string `json:"password" gorm:"column:password;comment:'密码'"`
	Channel   string `json:"channel" gorm:"column:channel;comment:'通道号'"`
	DevType   string `json:"devType" form:"devType" gorm:"comment:'设备类型'"`
	SerialNum string `json:"serialNum" form:"serialNum" gorm:"comment:'设备序列号'"`
	LocalTime string `json:"lacalTime" form:"lacalTime" gorm:"comment:'设备端系统时间'"`
	State     int    `json:"state" gorm:"column:state;comment:'状态'"`

	ScreensId int `json:"screensId" gorm:"column:screens_id;comment:'显示器id'"`
}

func QueryAllCameras() (cameras []Camera, err error) {
	err = global.GVA_DB.Model(&Camera{}).Find(&cameras).Error
	return
}

func QueryCameraList(limit, offset int) (cameras []Camera, total int64, err error) {
	db := global.GVA_DB.Model(&Camera{})

	err = db.Count(&total).Error
	if err != nil {
		return
	}
	err = db.Limit(limit).Offset(offset).Find(&cameras).Error
	return
}

func (c Camera) CreateCamera() error {
	return global.GVA_DB.Create(&c).Error
}

func (c Camera) UpdateCamera() error {
	return global.GVA_DB.Where("id = ?", c.ID).Updates(&c).Error
}

func DeleteCamera(id int) error {
	return global.GVA_DB.Unscoped().Delete(&Camera{}, id).Error
}