github.com/predbdotovh/pre-api@v0.0.0-20211230223408-096f265fde6a/nuke.go (about) 1 package main 2 3 import ( 4 "database/sql" 5 "fmt" 6 ) 7 8 const nukeTable = "nuke" 9 10 type nuke struct { 11 ID int `json:"id"` 12 TypeID int `json:"typeId"` 13 Type string `json:"type"` 14 PreID int `json:"preId"` 15 Reason string `json:"reason"` 16 Net string `json:"net"` 17 source string 18 NukeAt int64 `json:"nukeAt"` 19 } 20 21 var nukeTypes = map[int]string{ 22 1: "nuke", 23 2: "unnuke", 24 3: "modnuke", 25 4: "delpre", 26 5: "undelpre", 27 } 28 29 func (n *nuke) setType() { 30 if n.Type == "" { 31 n.Type = nukeTypes[n.TypeID] 32 } 33 } 34 35 func getNuke(db *sql.DB, preID int) (*nuke, error) { 36 sqlQuery := fmt.Sprintf("SELECT id, pre_id, nuke_id, reason, net, source, UNIX_TIMESTAMP(set_at) FROM %s WHERE pre_id = ? ORDER BY id DESC LIMIT 1", nukeTable) 37 38 var r nuke 39 40 err := db.QueryRow(sqlQuery, preID).Scan(&r.ID, &r.PreID, &r.TypeID, &r.Reason, &r.Net, &r.source, &r.NukeAt) 41 if err != nil { 42 return nil, err 43 } 44 45 return &r, nil 46 }