/
map_layer.go
100 lines (86 loc) · 2.37 KB
/
map_layer.go
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
// This file is part of the Smart Home
// Program complex distribution https://github.com/e154/smart-home
// Copyright (C) 2016-2020, Filippov Alex
//
// This library is free software: you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 3 of the License, or (at your option) any later version.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// Library General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library. If not, see
// <https://www.gnu.org/licenses/>.
package db
import (
"time"
"github.com/jinzhu/gorm"
"fmt"
)
type MapLayers struct {
Db *gorm.DB
}
type MapLayer struct {
Id int64 `gorm:"primary_key"`
Name string
Description string
Map *Map
MapId int64
Status string
Weight int64
Elements []*MapElement
CreatedAt time.Time
UpdatedAt time.Time
}
func (d *MapLayer) TableName() string {
return "map_layers"
}
func (n MapLayers) Add(v *MapLayer) (id int64, err error) {
if err = n.Db.Create(&v).Error; err != nil {
return
}
id = v.Id
return
}
func (n MapLayers) GetById(mapId int64) (v *MapLayer, err error) {
v = &MapLayer{Id: mapId}
err = n.Db.First(&v).Error
return
}
func (n MapLayers) Update(m *MapLayer) (err error) {
err = n.Db.Model(&MapLayer{Id: m.Id}).Updates(map[string]interface{}{
"name": m.Name,
"description": m.Description,
"status": m.Status,
"weight": m.Weight,
"map_id": m.MapId,
}).Error
return
}
func (n MapLayers) Sort(m *MapLayer) (err error) {
err = n.Db.Model(&MapLayer{Id: m.Id}).Updates(map[string]interface{}{
"weight": m.Weight,
}).Error
return
}
func (n MapLayers) Delete(mapId int64) (err error) {
err = n.Db.Delete(&MapLayer{Id: mapId}).Error
return
}
func (n *MapLayers) List(limit, offset int64, orderBy, sort string) (list []*MapLayer, total int64, err error) {
if err = n.Db.Model(MapLayer{}).Count(&total).Error; err != nil {
return
}
list = make([]*MapLayer, 0)
err = n.Db.
Limit(limit).
Offset(offset).
Order(fmt.Sprintf("%s %s", sort, orderBy)).
Find(&list).
Error
return
}