github.com/ecodeclub/eorm@v0.0.2-0.20231001112437-dae71da914d0/select.go

// Copyright 2021 ecodeclub
//
// Licensed 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 eorm

import (
	"context"

	"github.com/ecodeclub/eorm/internal/errs"
	"github.com/valyala/bytebufferpool"
)

var _ QueryBuilder = &Selector[any]{}

// Selector select 构造器
type Selector[T any] struct {
	Session
	selectorBuilder
	table TableReference
}

// NewSelector 创建一个 Selector
func NewSelector[T any](sess Session) *Selector[T] {
	return &Selector[T]{
		selectorBuilder: selectorBuilder{
			builder: builder{
				core:   sess.getCore(),
				buffer: bytebufferpool.Get(),
			},
		},
		Session: sess,
	}
}

// tableOf -> get selector table
func (s *Selector[T]) tableOf() any {
	switch tb := s.table.(type) {
	case Table:
		return tb.entity
	default:
		// 不使用 new(T) 来规避内存分配
		return (*T)(nil)
	}
}

// Build returns Select Query
func (s *Selector[T]) Build() (Query, error) {
	defer bytebufferpool.Put(s.buffer)
	var err error
	s.meta, err = s.metaRegistry.Get(s.tableOf())
	if err != nil {
		return EmptyQuery, err
	}
	s.writeString("SELECT ")
	if s.distinct {
		s.writeString("DISTINCT ")
	}
	if len(s.columns) == 0 {
		switch s.table.(type) {
		case Table, nil:
			if err = s.buildAllColumns(); err != nil {
				return EmptyQuery, err
			}
		default:
			return EmptyQuery, errs.NewMustSpecifyColumnsError()
		}
	} else {
		err = s.buildSelectedList()
		if err != nil {
			return EmptyQuery, err
		}
	}
	s.writeString(" FROM ")

	if err = s.buildTable(s.table); err != nil {
		return EmptyQuery, err
	}

	if len(s.where) > 0 {
		s.writeString(" WHERE ")
		err = s.buildPredicates(s.where)
		if err != nil {
			return EmptyQuery, err
		}
	}

	// group by
	if len(s.groupBy) > 0 {
		err = s.buildGroupBy()
		if err != nil {
			return EmptyQuery, err
		}
	}

	// order by
	if len(s.orderBy) > 0 {
		err = s.buildOrderBy()
		if err != nil {
			return EmptyQuery, err
		}
	}

	// having
	if len(s.having) > 0 {
		s.writeString(" HAVING ")
		err = s.buildPredicates(s.having)
		if err != nil {
			return EmptyQuery, err
		}
	}

	if s.offset > 0 {
		s.writeString(" OFFSET ")
		s.parameter(s.offset)
	}

	if s.limit > 0 {
		s.writeString(" LIMIT ")
		s.parameter(s.limit)
	}
	s.end()
	return Query{SQL: s.buffer.String(), Args: s.args}, nil
}

func (s *Selector[T]) buildTable(table TableReference) error {
	switch t := table.(type) {
	case nil:
		s.quote(s.meta.TableName)
	case Table:
		m, err := s.metaRegistry.Get(t.entity)
		if err != nil {
			return err
		}
		s.quote(m.TableName)
		if t.alias != "" {
			s.writeString(" AS ")
			s.quote(t.alias)
		}
	case Join:
		if err := s.buildJoin(t); err != nil {
			return err
		}
	case Subquery:
		return s.buildSubquery(t, true)
	default:
		return errs.NewUnsupportedTableReferenceError(table)
	}
	return nil
}

func (s *Selector[T]) buildOrderBy() error {
	s.writeString(" ORDER BY ")
	for i, ob := range s.orderBy {
		if i > 0 {
			s.comma()
		}
		for _, c := range ob.fields {
			cMeta, ok := s.meta.FieldMap[c]
			if !ok {
				return errs.NewInvalidFieldError(c)
			}
			s.quote(cMeta.ColumnName)
		}
		s.space()
		s.writeString(ob.order)
	}
	return nil
}

func (s *Selector[T]) buildGroupBy() error {
	s.writeString(" GROUP BY ")
	for i, gb := range s.groupBy {
		cMeta, ok := s.meta.FieldMap[gb]
		if !ok {
			return errs.NewInvalidFieldError(gb)
		}
		if i > 0 {
			s.comma()
		}
		s.quote(cMeta.ColumnName)
	}
	return nil
}

func (s *Selector[T]) buildAllColumns() error {
	for i, cMeta := range s.meta.Columns {
		// 永远不会返回 error
		_ = s.buildColumns(i, cMeta.FieldName)
	}
	return nil
}

// buildSelectedList users specify columns
func (s *Selector[T]) buildSelectedList() error {
	for i, selectable := range s.columns {
		if i > 0 {
			s.comma()
		}
		switch expr := selectable.(type) {
		case Column:
			err := s.builder.buildColumn(expr)
			if err != nil {
				return errs.NewInvalidFieldError(expr.name)
			}
		case columns:
			for j, c := range expr.cs {
				err := s.buildColumns(j, c)
				if err != nil {
					return err
				}
			}
		case Aggregate:
			if err := s.selectAggregate(expr); err != nil {
				return err
			}
		case RawExpr:
			s.buildRawExpr(expr)
		}
	}
	return nil

}
func (s *Selector[T]) selectAggregate(aggregate Aggregate) error {
	s.writeString(aggregate.fn)

	s.writeByte('(')
	if aggregate.distinct {
		s.writeString("DISTINCT ")
	}
	cMeta, ok := s.meta.FieldMap[aggregate.arg]
	// s.aliases[aggregate.alias] = struct{}{}
	if !ok {
		return errs.NewInvalidFieldError(aggregate.arg)
	}
	if aggregate.table != nil {
		if alias := aggregate.table.getAlias(); alias != "" {
			s.quote(alias)
			s.point()
		}
	}
	s.quote(cMeta.ColumnName)
	s.writeByte(')')
	if aggregate.alias != "" {
		// if _, ok := s.aliases[aggregate.alias]; ok {
		// 	s.writeString(" AS ")
		// 	s.quote(aggregate.alias)
		// }
		s.writeString(" AS ")
		s.quote(aggregate.alias)
	}
	return nil
}

func (s *Selector[T]) buildColumns(index int, name string) error {
	if index > 0 {
		s.comma()
	}
	cMeta, ok := s.meta.FieldMap[name]
	if !ok {
		return errs.NewInvalidFieldError(name)
	}
	s.quote(cMeta.ColumnName)
	return nil
}

func (s *Selector[T]) buildUsing(using []string) error {
	s.writeString(" USING (")
	for i, col := range using {
		err := s.buildColumns(i, col)
		if err != nil {
			return err
		}
	}
	s.writeByte(')')
	return nil
}

// Select 指定查询的列。
// 列可以是物理列，也可以是聚合函数，或者 RawExpr
func (s *Selector[T]) Select(columns ...Selectable) *Selector[T] {
	s.columns = columns
	return s
}

// From specifies the table which must be pointer of structure
func (s *Selector[T]) From(tbl TableReference) *Selector[T] {
	s.table = tbl
	return s
}

// Where accepts predicates
func (s *Selector[T]) Where(predicates ...Predicate) *Selector[T] {
	s.where = predicates
	return s
}

// Distinct indicates using keyword DISTINCT
func (s *Selector[T]) Distinct() *Selector[T] {
	s.distinct = true
	return s
}

// Having accepts predicates
func (s *Selector[T]) Having(predicates ...Predicate) *Selector[T] {
	s.having = predicates
	return s
}

// GroupBy means "GROUP BY"
func (s *Selector[T]) GroupBy(columns ...string) *Selector[T] {
	s.groupBy = columns
	return s
}

// OrderBy means "ORDER BY"
func (s *Selector[T]) OrderBy(orderBys ...OrderBy) *Selector[T] {
	s.orderBy = orderBys
	return s
}

// Limit limits the size of result set
func (s *Selector[T]) Limit(limit int) *Selector[T] {
	s.limit = limit
	return s
}

// Offset was used by "LIMIT"
func (s *Selector[T]) Offset(offset int) *Selector[T] {
	s.offset = offset
	return s
}

func (s *Selector[T]) AsSubquery(alias string) Subquery {
	var table TableReference
	if s.table == nil {
		table = TableOf(new(T), alias)
	}
	return Subquery{
		entity:  table,
		q:       s,
		alias:   alias,
		columns: s.columns,
	}
}

// Get 方法会执行查询，并且返回一条数据
// 注意，在不同的数据库情况下，第一条数据可能是按照不同的列来排序的
// 而且要注意，这个方法会强制设置 Limit 1
// 在没有查找到数据的情况下，会返回 ErrNoRows
func (s *Selector[T]) Get(ctx context.Context) (*T, error) {
	query, err := s.Limit(1).Build()
	if err != nil {
		return nil, err
	}
	return newQuerier[T](s.Session, query, s.meta, SELECT).Get(ctx)
}

// OrderBy specify fields and ASC
type OrderBy struct {
	fields []string
	order  string
}

// ASC means ORDER BY fields ASC
func ASC(fields ...string) OrderBy {
	return OrderBy{
		fields: fields,
		order:  "ASC",
	}
}

// DESC means ORDER BY fields DESC
func DESC(fields ...string) OrderBy {
	return OrderBy{
		fields: fields,
		order:  "DESC",
	}
}

// Selectable is a tag interface which represents SELECT XXX
type Selectable interface {
	selected()
}

func (s *Selector[T]) GetMulti(ctx context.Context) ([]*T, error) {
	query, err := s.Build()
	if err != nil {
		return nil, err
	}
	return newQuerier[T](s.Session, query, s.meta, SELECT).GetMulti(ctx)
}

func (s *Selector[T]) buildJoin(t Join) error {
	s.writeByte('(')
	if err := s.buildTable(t.left); err != nil {
		return err
	}
	s.space()
	s.writeString(t.typ)
	s.space()
	if err := s.buildTable(t.right); err != nil {
		return err
	}
	if len(t.using) > 0 {
		if err := s.buildUsing(t.using); err != nil {
			return err
		}
	}
	if len(t.on) > 0 {
		s.writeString(" ON ")
		if err := s.buildPredicates(t.on); err != nil {
			return err
		}
	}
	s.writeByte(')')
	return nil
}