pagesql

Documentation

Index

• Variables
• func WriteQuery(parameters Parameters) (query, countQuery string, args []interface{})
• type Parameters

Variables

var DefaultSortColumn = "id"

Functions

func WriteQuery

func WriteQuery(parameters Parameters) (query, countQuery string, args []interface{})

WriteQuery generates a SQL query for paginated results and a count query based on the provided filters, sorting, and pagination parameters. It constructs a SELECT query with conditions for filtering, ordering, pagination (LIMIT and OFFSET) and a COUNT query for the total number of records.

Types

type Parameters

type Parameters struct {
	Table      string
	Fields     []string
	Filters    map[paginate.FilterParameter]paginate.Filter
	SortColumn string
	Descending bool
	Limit      uint64
	Offset     uint64
}