queries

Documentation

Index

• Constants
• func GetCountFetchedLastTwelveMonths(db *sql.DB) int
• func GetCountTotalTaxa(db *sql.DB) int
• type Counts
• type Query
  • func NewQuery(payload any) Query
  • func (q Query) GetCounts(db *sql.DB) Counts
  • func (q Query) GetTableData(db *sql.DB, increaseLimit ...bool) *TableRows
• type TableRow
• type TableRows
  • func (rows *TableRows) CreateCSV() string

Constants

const DefaultPageLimit = uint64(100)

const IncreasedPageLimit = uint64(1_000)

Functions

func GetCountFetchedLastTwelveMonths

func GetCountFetchedLastTwelveMonths(db *sql.DB) int

func GetCountTotalTaxa

func GetCountTotalTaxa(db *sql.DB) int

Types

type Counts

type Counts struct {
	TaxaCount        int
	ObservationCount int
}

type Query

type Query struct {
	ORDER_BY      string
	ORDER_DIR     string
	SEARCH        string
	COUNTRY       string
	RANK          string
	TAXA          string
	PAGE          string
	SHOW_SYNONYMS bool
}

func NewQuery

func NewQuery(payload any) Query

Create a new query object with default values or set values from payload struct

func (Query) GetCounts

func (q Query) GetCounts(db *sql.DB) Counts

Get the counts of taxa and observations based on the query

func (Query) GetTableData

func (q Query) GetTableData(db *sql.DB, increaseLimit ...bool) *TableRows

Get the table data based on the query

type TableRow

type TableRow struct {
	TaxonID          string
	ScientificName   sql.NullString
	CountryCode      sql.NullString
	CountryCodeClean string
	CountryFlag      string
	LastFetch        sql.NullTime
	ObservationID    sql.NullString
	ObservationDate  sql.NullTime
	ObservedDiff     string

	IsSynonym   bool
	SynonymName sql.NullString
	SynonymID   sql.NullString

	TaxonKingdom string
	TaxonPhylum  string
	TaxonClass   string
	TaxonOrder   string
	TaxonFamily  string
	Taxa         string
}

type TableRows

type TableRows struct {
	Rows []TableRow
}

func (*TableRows) CreateCSV

func (rows *TableRows) CreateCSV() string

Create a CSV string from the table data, this is used for exporting data