CheckSchemaVersionsSynced checks if if the current migrated version of the DB matches the latest available version.

CursorPredicate generates an SQL predicate which excludes all rows before the supplied cursor, with regards to the supplied table ordering.

FilterRewardsQuery returns a WHERE part of the query and args for filtering the rewards table.

PaginateQuery takes a query string & bind arg list and returns the same with additional SQL to - exclude rows before the cursor (or after it if the cursor is a backwards looking one) - limit the number of rows to the pagination limit +1 (no cursor) or +2 (cursor) [for purposes of later figuring out whether there are next or previous pages] - order the query according to the TableOrdering supplied the order is reversed if pagination request is backwards For example with cursor to a row where foo=42, and a pagination saying get the next 3 then: PaginateQuery[MyCursor]("SELECT foo FROM my_table", args, ordering, pagination) Would append `42` to the arg list and return SELECT foo FROM my_table WHERE foo>=$1 ORDER BY foo ASC LIMIT 5 See CursorPredicate() for more details about how the cursor filtering is done.

nolint:nakedret.

StructValueForColumn replicates some of the unexported functionality from Scanny.

go:embed migrations/*.sql.