-
Notifications
You must be signed in to change notification settings - Fork 0
/
import.go
56 lines (46 loc) · 1.1 KB
/
import.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
package groups
import (
"database/sql"
"io"
"github.com/lflux/eve-sdeloader/utils"
)
func InsertGroupStmt(tx *sql.Tx) (*sql.Stmt, error) {
return tx.Prepare(`INSERT INTO "invGroups" VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)`)
}
func Import(db *sql.DB, r io.Reader) error {
entries := make(map[string]*Group)
err := utils.LoadFromReader(r, entries)
if err != nil {
return err
}
tx, err := db.Begin()
if err != nil {
return err
}
stmt, err := InsertGroupStmt(tx)
if err != nil {
return err
}
insertTrnTranslations, err := utils.InsertTrnTranslations(tx)
for groupID, group := range entries {
_, err = stmt.Exec(groupID, group.CategoryID, group.Name["en"], group.IconID, group.UseBasePrice, group.Anchored, group.Anchorable, group.FittableNonSingleton, group.Published)
if err != nil {
return err
}
for lang, val := range group.Name {
_, err = insertTrnTranslations.Exec(7, groupID, lang, val)
if err != nil {
return err
}
}
}
err = insertTrnTranslations.Close()
if err != nil {
return err
}
err = stmt.Close()
if err != nil {
return err
}
return tx.Commit()
}