-
Notifications
You must be signed in to change notification settings - Fork 10
/
marketGroups.go
69 lines (61 loc) · 1.52 KB
/
marketGroups.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
package squirrel
import (
"context"
"log"
"sync"
sq "github.com/Masterminds/squirrel"
"github.com/antihax/goesi/esi"
)
var marketGroupsChannel = make(chan esi.GetMarketsGroupsMarketGroupIdOk, 10000)
func init() {
registerTrigger("marketGroups", func(s *Squirrel) error {
groups, _, err := s.esi.ESI.MarketApi.GetMarketsGroups(context.Background(), nil)
if err != nil {
return err
}
wg := sync.WaitGroup{}
for _, g := range groups {
wg.Add(1)
go func(g int32) {
defer func() { wg.Done() }()
group, _, err := s.esi.ESI.MarketApi.GetMarketsGroupsMarketGroupId(context.Background(), g, nil)
if err != nil {
return
}
marketGroupsChannel <- group
}(g)
}
// Wait for everything to finish
wg.Wait()
// Close the group to wrap up any final items
close(marketGroupsChannel)
return nil
})
registerCollector("marketGroups", func(s *Squirrel) error {
for {
count := 0
sql := sq.Insert("eve.invMarketGroups").Columns("marketGroupID", "parentGroupID", "marketGroupName", "description", "hasTypes")
for g := range marketGroupsChannel {
count++
sql = sql.Values(g.MarketGroupId, g.ParentGroupId, g.Name, g.Description, len(g.Types) > 0)
if count > 80 {
break
}
}
if count == 0 {
break
}
sqlq, args, err := sql.ToSql()
if err != nil {
log.Println(err)
return err
}
err = s.doSQL(sqlq+" ON DUPLICATE KEY UPDATE marketGroupID = marketGroupId", args...)
if err != nil {
log.Println(err)
return err
}
}
return nil
})
}