/
delete_layer_items.go
66 lines (55 loc) · 1.35 KB
/
delete_layer_items.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
package character
import (
"errors"
"github.com/jmoiron/sqlx"
)
func (db *CharacterRepository) DeleteLayerItems(characterId int, itemIds *[]int) error {
query := `
SELECT
EXISTS (
SELECT
*
FROM
characters_icon_layer_items
JOIN
characters_icon_layer_groups ON (characters_icon_layer_items.layer_group = characters_icon_layer_groups.id)
JOIN
characters_icon_layering_groups ON (characters_icon_layer_groups.layering_group = characters_icon_layering_groups.id)
WHERE
characters_icon_layer_items.id IN (:list) AND
characters_icon_layering_groups.character != :character
);
`
query, args, err := sqlx.Named(query, map[string]interface{}{
"character": characterId,
"list": *itemIds,
})
if err != nil {
return err
}
query, args, err = sqlx.In(query, args...)
if err != nil {
return err
}
row := db.QueryRowx(db.Rebind(query), args...)
var existsOtherCharacterItems bool
err = row.Scan(&existsOtherCharacterItems)
if err != nil {
return err
}
if existsOtherCharacterItems {
return errors.New("自身のものではないレイヤーアイテムが含まれています")
}
query = `
DELETE FROM
characters_icon_layer_items
WHERE
id IN (?);
`
query, args, err = sqlx.In(query, *itemIds)
if err != nil {
return err
}
_, err = db.Exec(db.Rebind(query), args...)
return err
}