Method AllAndCount

database/gdb/gdb_model_select.go:51–89

AllAndCount retrieves all records and the total count of records from the model. If useFieldForCount is true, it will use the fields specified in the model for counting; otherwise, it will use a constant value of 1 for counting. It returns the result as a slice of records, the total count of records

(useFieldForCount bool)

//	}
//	fmt.Println(result, count)
func (m *Model) AllAndCount(useFieldForCount bool) (result Result, totalCount int, err error) {
	// Clone the model for counting
	countModel := m.Clone()

	// Decide how to build the COUNT() expression:
	// - If caller explicitly wants to use the single field expression for counting,
	//   honor it (e.g. Fields("DISTINCT col") with useFieldForCount = true).
	// - Otherwise, clear fields to let Count() use its default COUNT(1),
	//   avoiding invalid COUNT(field1, field2, ...) with multiple fields,
	//   or incorrect COUNT(DISTINCT 1) when Distinct() is set.
	if useFieldForCount && len(m.fields) == 1 {
		countModel.fields = m.fields
	} else {
		countModel.fields = nil
	}
	if len(m.pageCacheOption) > 0 {
		countModel = countModel.Cache(m.pageCacheOption[0])
	}

	// Get the total count of records
	totalCount, err = countModel.Count()
	if err != nil {
		return
	}

	// If the total count is 0, there are no records to retrieve, so return early
	if totalCount == 0 {
		return
	}

	resultModel := m.Clone()
	if len(m.pageCacheOption) > 1 {
		resultModel = resultModel.Cache(m.pageCacheOption[1])
	}

	// Retrieve all records
	result, err = resultModel.doGetAll(m.GetCtx(), SelectTypeDefault, false)
	return
}

// Chunk iterates the query result with given `size` and `handler` function.
func (m *Model) Chunk(size int, handler ChunkHandler) {