join

package

v0.0.3 Latest Latest Go to latest Published: Oct 23, 2023 License: MIT Imports: 7 Imported by: 0

Details

This section is empty.

This section is empty.

func Write(sw io.StringWriter, joinType JoinType, from string, match JoinMatcher) error

Join writes a JOIN clause to a strings.Builder.

Example:

LEFT JOIN table ON table.field = other_table.field AND table.field2 = other_table.field2
LEFT JOIN table USING (field, field2)

type Clause struct {
	// contains filtered or unexported fields
}

Clause represents a JOIN clause.

func New(j []Options) *Clause

New creates a new join clause.

func (j *Clause) Type() clauses.ClauseType

func (j *Clause) Write(sw io.StringWriter) error

type JoinMatcher interface {
	expressions.Expression
}

JoinMatcher is a join clause.

type JoinOn struct {
	Predicates []predicates.Predicate
}

JoinOn is a join clause that uses a list of predicates to match.

Example:

LEFT JOIN table ON table.field = other_table.field AND table.field2 = other_table.field2

func (j *JoinOn) Write(sw io.StringWriter) error

type JoinType int

const (
	InnerJoin JoinType = iota
	LeftJoin
	RightJoin
	FullJoin
)

type JoinUsing struct {
	Uses []string
}

JoinUsing is a join clause that uses a list of columns to match.

Example:

LEFT JOIN table USING (field, field2)

func (j *JoinUsing) Write(sw io.StringWriter) error

type Options struct {
	Type  JoinType
	From  string
	Match JoinMatcher // JoinOn or JoinUsing
}