forked from xorm/builder
71 lines
1.5 KiB
Go
71 lines
1.5 KiB
Go
// Copyright 2018 The Xorm Authors. All rights reserved.
|
|
// Use of this source code is governed by a BSD-style
|
|
// license that can be found in the LICENSE file.
|
|
|
|
package builder
|
|
|
|
import (
|
|
"fmt"
|
|
"strings"
|
|
)
|
|
|
|
func (b *Builder) setOpWriteTo(w Writer) error {
|
|
if b.limitation != nil || b.cond.IsValid() || b.having != "" || b.groupBy != "" {
|
|
return ErrNotUnexpectedUnionConditions
|
|
}
|
|
|
|
for idx, o := range b.setOps {
|
|
current := o.builder
|
|
if current.optype != selectType {
|
|
return ErrUnsupportedUnionMembers
|
|
}
|
|
|
|
if len(b.setOps) == 1 {
|
|
if err := current.selectWriteTo(w); err != nil {
|
|
return err
|
|
}
|
|
} else {
|
|
if b.dialect != "" && b.dialect != current.dialect {
|
|
return ErrInconsistentDialect
|
|
}
|
|
|
|
if idx != 0 {
|
|
if o.distinctType == "" {
|
|
fmt.Fprint(w, fmt.Sprintf(" %s ", strings.ToUpper(o.opType)))
|
|
} else {
|
|
fmt.Fprint(w, fmt.Sprintf(" %s %s ", strings.ToUpper(o.opType), strings.ToUpper(o.distinctType)))
|
|
}
|
|
}
|
|
fmt.Fprint(w, "(")
|
|
|
|
if err := current.selectWriteTo(w); err != nil {
|
|
return err
|
|
}
|
|
|
|
fmt.Fprint(w, ")")
|
|
}
|
|
}
|
|
|
|
if b.orderBy != nil {
|
|
switch c := b.orderBy.(type) {
|
|
case string:
|
|
if len(c) > 0 {
|
|
if _, err := fmt.Fprint(w, " ORDER BY ", c); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
case *Expression:
|
|
if _, err := fmt.Fprint(w, " ORDER BY "); err != nil {
|
|
return err
|
|
}
|
|
if err := c.WriteTo(w); err != nil {
|
|
return err
|
|
}
|
|
default:
|
|
return fmt.Errorf("unknow orderby parameter: %#v", b.orderBy)
|
|
}
|
|
}
|
|
|
|
return nil
|
|
}
|