github.com/predbdotovh/pre-api@v0.0.0-20211230223408-096f265fde6a/pre.go (about) 1 package main 2 3 import ( 4 "database/sql" 5 "fmt" 6 "log" 7 "strconv" 8 "strings" 9 ) 10 11 type preRow struct { 12 ID int `json:"id"` 13 Name string `json:"name"` 14 Team string `json:"team"` 15 Cat string `json:"cat"` 16 Genre string `json:"genre"` 17 URL string `json:"url"` 18 Size float64 `json:"size"` 19 Files int `json:"files"` 20 PreAt int `json:"preAt"` 21 Nuke *nuke `json:"nuke"` 22 } 23 24 var replacer = strings.NewReplacer("(", "\\(", ")", "\\)") 25 26 const preColumns = "id, name, team, cat, genre, url, size, files, pre_at" 27 const defaultMaxMatches = 1000 28 29 func (p *preRow) proc() { 30 p.Size /= 1000 31 } 32 33 func scanPresRows(rows *sql.Rows, appendNukes bool) []preRow { 34 res := make([]preRow, 0) 35 for rows.Next() { 36 var r preRow 37 err := rows.Scan(&r.ID, &r.Name, &r.Team, &r.Cat, &r.Genre, &r.URL, &r.Size, &r.Files, &r.PreAt) 38 if err != nil { 39 log.Print(err) 40 continue 41 } 42 43 r.proc() 44 if appendNukes { 45 r.fetchNuke(mysql) 46 } 47 48 res = append(res, r) 49 } 50 51 return res 52 } 53 54 func getPre(db *sql.DB, preID int, withNuke bool) (*preRow, error) { 55 sqlQuery := fmt.Sprintf("SELECT %s FROM %s WHERE id = ?", preColumns, sphinxTable) 56 57 var r preRow 58 59 err := db.QueryRow(sqlQuery, preID).Scan(&r.ID, &r.Name, &r.Team, &r.Cat, &r.Genre, &r.URL, &r.Size, &r.Files, &r.PreAt) 60 if err != nil { 61 return nil, err 62 } 63 64 r.proc() 65 if withNuke { 66 r.fetchNuke(mysql) 67 } 68 69 return &r, nil 70 } 71 72 func getPresById(tx *sql.Tx, preID int, withNuke bool) ([]preRow, error) { 73 sqlQuery := fmt.Sprintf("SELECT %s FROM %s WHERE id = ?", preColumns, sphinxTable) 74 75 var r preRow 76 77 err := tx.QueryRow(sqlQuery, preID).Scan(&r.ID, &r.Name, &r.Team, &r.Cat, &r.Genre, &r.URL, &r.Size, &r.Files, &r.PreAt) 78 if err != nil { 79 return nil, err 80 } 81 82 r.proc() 83 if withNuke { 84 r.fetchNuke(mysql) 85 } 86 87 return []preRow{r}, nil 88 } 89 90 func searchPres(tx *sql.Tx, q string, offsetInt, countInt int, withNukes bool) ([]preRow, error) { 91 sqlQuery := fmt.Sprintf("SELECT %s FROM %s WHERE MATCH(?) ORDER BY id DESC LIMIT %d,%d", preColumns, sphinxTable, offsetInt, countInt) 92 93 if offsetInt+countInt > defaultMaxMatches { 94 sqlQuery += ", max_matches = " + strconv.Itoa(offsetInt+countInt) 95 } 96 97 sqlRows, err := tx.Query(sqlQuery, replacer.Replace(q)) 98 if err != nil { 99 return nil, err 100 } 101 defer sqlRows.Close() 102 103 return scanPresRows(sqlRows, withNukes), nil 104 } 105 106 func latestPres(tx *sql.Tx, offsetInt, countInt int, withNukes bool) ([]preRow, error) { 107 sqlQuery := fmt.Sprintf("SELECT %s FROM %s ORDER BY id DESC LIMIT %d,%d", preColumns, sphinxTable, offsetInt, countInt) 108 109 if offsetInt+countInt > defaultMaxMatches { 110 sqlQuery += ", max_matches = " + strconv.Itoa(offsetInt+countInt) 111 } 112 113 sqlRows, err := tx.Query(sqlQuery) 114 if err != nil { 115 return nil, err 116 } 117 defer sqlRows.Close() 118 119 return scanPresRows(sqlRows, withNukes), nil 120 } 121 122 func (p *preRow) fetchNuke(db *sql.DB) { 123 n, err := getNuke(db, p.ID) 124 if err != nil { 125 return 126 } 127 p.setNuke(n) 128 } 129 130 func (p *preRow) setNuke(n *nuke) { 131 if n != nil { 132 n.setType() 133 p.Nuke = n 134 } 135 } 136 137 func (p *preRow) insertOrUpdateIndex() (int64, error) { 138 sqlQuery := fmt.Sprintf("REPLACE INTO %s (%s) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", realTimeIndex, preColumns) 139 140 res, err := sphinx.Exec(sqlQuery, p.ID, p.Name, p.Team, p.Cat, p.Genre, p.URL, p.Size, p.Files, p.PreAt) 141 if err != nil { 142 return 0, err 143 } 144 145 return res.RowsAffected() 146 } 147 148 func (p *preRow) deleteFromIndex() (int64, error) { 149 sqlQuery := fmt.Sprintf("DELETE FROM %s WHERE id = ?", realTimeIndex) 150 151 res, err := sphinx.Exec(sqlQuery, p.ID) 152 if err != nil { 153 return 0, err 154 } 155 156 return res.RowsAffected() 157 }