page_builder.go

// Copyright 2020 io.xream.sqlxb
//
// Licensed to the Apache Software Foundation (ASF) under one or more
// contributor license agreements.  See the NOTICE file distributed with
// this work for additional information regarding copyright ownership.
// The ASF licenses this file to You under the Apache License, Version 2.0
// (the "License"); you may not use this file except in compliance with
// the License.  You may obtain a copy of the License at
//
//	http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
package sqlxb

type PageCondition struct {
	page               uint
	rows               uint
	last               uint64
	isTotalRowsIgnored bool
}

type PageBuilder struct {
	condition PageCondition
}

type TotalRows struct {
	Count int64 `db:"COUNT(*)"`
}

func (pb *PageBuilder) Page(page uint) *PageBuilder {
	pb.condition.page = page
	return pb
}

func (pb *PageBuilder) Rows(rows uint) *PageBuilder {
	pb.condition.rows = rows
	return pb
}

// Last
// if ASC: orderBy > last else DESC: orderBy < last
// LIMIT rows
func (pb *PageBuilder) Last(last uint64) *PageBuilder {
	pb.condition.last = last
	return pb
}

func (pb *PageBuilder) IgnoreTotalRows() *PageBuilder {
	pb.condition.isTotalRowsIgnored = true
	return pb
}

func (pb *PageBuilder) SetTotalRowsIgnored(ignored bool) *PageBuilder {
	pb.condition.isTotalRowsIgnored = ignored
	return pb
}