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  }