/
retrieve_layering_group.go
122 lines (108 loc) · 2.53 KB
/
retrieve_layering_group.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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
package character
import (
"encoding/json"
"errors"
"github.com/kaikourok/lunchtote-backend/entity/model"
)
func (db *CharacterRepository) RetrieveLayeringGroup(characterId, groupId int) (layeringGroup *model.CharacterIconLayeringGroup, err error) {
layeringGroup = &model.CharacterIconLayeringGroup{}
layeringGroup.Id = groupId
var master int
row := db.QueryRowx(`
SELECT
character,
name
FROM
characters_icon_layering_groups
WHERE
id = $1;
`, groupId)
err = row.Scan(&master, &layeringGroup.Name)
if err != nil {
return nil, err
}
if characterId != master {
return nil, errors.New("レイヤリンググループの所有者ではありません")
}
rows, err := db.Queryx(`
SELECT
characters_icon_layer_groups.id,
characters_icon_layer_groups.name,
COALESCE(
JSON_AGG(JSON_BUILD_OBJECT(
'id', characters_icon_layer_items.id,
'path', characters_icon_layer_items.path
)) FILTER (WHERE characters_icon_layer_items.path IS NOT NULL),
'[]'
)
FROM
characters_icon_layer_groups
LEFT JOIN
characters_icon_layer_items ON (characters_icon_layer_groups.id = characters_icon_layer_items.layer_group)
WHERE
characters_icon_layer_groups.layering_group = $1
GROUP BY
characters_icon_layer_groups.id,
characters_icon_layer_groups.name
ORDER BY
characters_icon_layer_groups.layer_order DESC;
`, groupId)
if err != nil {
return nil, err
}
defer rows.Close()
layeringGroup.Layers = make([]model.CharacterIconLayerGroup, 0, 64)
for rows.Next() {
var layerGroup model.CharacterIconLayerGroup
var layerGroupItemsJson string
err = rows.Scan(
&layerGroup.Id,
&layerGroup.Name,
&layerGroupItemsJson,
)
if err != nil {
return nil, err
}
err = json.Unmarshal([]byte(layerGroupItemsJson), &layerGroup.Items)
if err != nil {
return nil, err
}
layeringGroup.Layers = append(layeringGroup.Layers, layerGroup)
}
rows, err = db.Queryx(`
SELECT
id,
name,
x,
y,
scale,
rotate
FROM
characters_icon_process_schemas
WHERE
layering_group = $1
ORDER BY
id;
`, groupId)
if err != nil {
return nil, err
}
defer rows.Close()
layeringGroup.Processes = make([]model.CharacterIconProcessSchemaEditData, 0, 64)
for rows.Next() {
var process model.CharacterIconProcessSchemaEditData
err = rows.Scan(
&process.Id,
&process.Name,
&process.X,
&process.Y,
&process.Scale,
&process.Rotate,
)
if err != nil {
return nil, err
}
layeringGroup.Processes = append(layeringGroup.Processes, process)
}
return
}