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  }