// Page specifies the paging constraints for the query being built by `q`.
func (q *OperationsQ) Page(page db2.PageQuery) *OperationsQ {
if q.Err != nil {
return q
}
q.sql, q.Err = page.ApplyTo(q.sql, "hop.id")
return q
}
// Page specifies the paging constraints for the query being built by `q`.
func (q *AccountsQ) Page(page db2.PageQuery) *AccountsQ {
if q.Err != nil {
return q
}
q.sql, q.Err = page.ApplyTo(q.sql, "ha.id")
return q
}
// Page specifies the paging constraints for the query being built by `q`.
func (q *LedgersQ) Page(page db2.PageQuery) *LedgersQ {
if q.Err != nil {
return q
}
q.sql, q.Err = page.ApplyTo(q.sql, "hl.id")
return q
}
// Page specifies the paging constraints for the query being built by `q`.
func (q *TransactionsQ) Page(page db2.PageQuery) *TransactionsQ {
if q.Err != nil {
return q
}
q.sql, q.Err = page.ApplyTo(q.sql, "ht.id")
return q
}
// OffersByAddress loads a page of active offers for the given
// address.
func (q *Q) OffersByAddress(dest interface{}, addy string, pq db2.PageQuery) error {
sql := sq.Select("co.*").
From("offers co").
Where("co.sellerid = ?", addy).
Limit(uint64(pq.Limit))
cursor, err := pq.CursorInt64()
if err != nil {
return err
}
switch pq.Order {
case "asc":
sql = sql.Where("co.offerid > ?", cursor).OrderBy("co.offerid asc")
case "desc":
sql = sql.Where("co.offerid < ?", cursor).OrderBy("co.offerid desc")
}
return q.Select(dest, sql)
}
// Page specifies the paging constraints for the query being built by `q`.
func (q *EffectsQ) Page(page db2.PageQuery) *EffectsQ {
if q.Err != nil {
return q
}
op, idx, err := page.CursorInt64Pair(db2.DefaultPairSep)
if err != nil {
q.Err = err
return q
}
if idx > math.MaxInt32 {
idx = math.MaxInt32
}
switch page.Order {
case "asc":
q.sql = q.sql.
Where(`(
heff.history_operation_id > ?
OR (
heff.history_operation_id = ?
AND heff.order > ?
))`, op, op, idx).
OrderBy("heff.history_operation_id asc, heff.order asc")
case "desc":
q.sql = q.sql.
Where(`(
heff.history_operation_id < ?
OR (
heff.history_operation_id = ?
AND heff.order < ?
))`, op, op, idx).
OrderBy("heff.history_operation_id desc, heff.order desc")
}
q.sql = q.sql.Limit(page.Limit)
return q
}