region.go 629 B

123456789101112131415161718192021222324252627282930
  1. package dao
  2. import "server/global"
  3. type Region struct {
  4. global.GVA_MODEL
  5. Name string `json:"name" gorm:"comment:名称"`
  6. Devices []Device `json:"devices"`
  7. }
  8. func (Region) TableName() string {
  9. return "region"
  10. }
  11. func QueryAllRegions() (regions []Region, err error) {
  12. err = global.GVA_DB.Find(&regions).Error
  13. return
  14. }
  15. func (r Region) CreateRegion() error {
  16. return global.GVA_DB.Create(&r).Error
  17. }
  18. func (r Region) UpdateRegion() error {
  19. return global.GVA_DB.Where("id = ?", r.ID).Updates(&r).Error
  20. }
  21. func DeleteRegion(id int) error {
  22. return global.GVA_DB.Where("id = ?", id).Unscoped().Delete(&Region{}).Error
  23. }