1
// Copyright 2016 The Xorm Authors. All rights reserved.
2
// Use of this source code is governed by a BSD-style
3
// license that can be found in the LICENSE file.
20
// In generates IN condition
21
func In(col string, values ...interface{}) Cond {
22
return condIn{col, values}
25
func (condIn condIn) handleBlank(w Writer) error {
26
if _, err := fmt.Fprintf(w, "%s IN ()", condIn.col); err != nil {
32
func (condIn condIn) WriteTo(w Writer) error {
33
if len(condIn.vals) <= 0 {
34
return condIn.handleBlank(w)
37
switch condIn.vals[0].(type) {
39
vals := condIn.vals[0].([]int8)
41
return condIn.handleBlank(w)
43
questionMark := strings.Repeat("?,", len(vals))
44
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
47
for _, val := range vals {
51
vals := condIn.vals[0].([]int16)
53
return condIn.handleBlank(w)
55
questionMark := strings.Repeat("?,", len(vals))
56
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
59
for _, val := range vals {
63
vals := condIn.vals[0].([]int)
65
return condIn.handleBlank(w)
67
questionMark := strings.Repeat("?,", len(vals))
68
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
71
for _, val := range vals {
75
vals := condIn.vals[0].([]int32)
77
return condIn.handleBlank(w)
79
questionMark := strings.Repeat("?,", len(vals))
80
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
83
for _, val := range vals {
87
vals := condIn.vals[0].([]int64)
89
return condIn.handleBlank(w)
91
questionMark := strings.Repeat("?,", len(vals))
92
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
95
for _, val := range vals {
99
vals := condIn.vals[0].([]uint8)
101
return condIn.handleBlank(w)
103
questionMark := strings.Repeat("?,", len(vals))
104
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
107
for _, val := range vals {
111
vals := condIn.vals[0].([]uint16)
113
return condIn.handleBlank(w)
115
questionMark := strings.Repeat("?,", len(vals))
116
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
119
for _, val := range vals {
123
vals := condIn.vals[0].([]uint)
125
return condIn.handleBlank(w)
127
questionMark := strings.Repeat("?,", len(vals))
128
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
131
for _, val := range vals {
135
vals := condIn.vals[0].([]uint32)
137
return condIn.handleBlank(w)
139
questionMark := strings.Repeat("?,", len(vals))
140
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
143
for _, val := range vals {
147
vals := condIn.vals[0].([]uint64)
149
return condIn.handleBlank(w)
151
questionMark := strings.Repeat("?,", len(vals))
152
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
155
for _, val := range vals {
159
vals := condIn.vals[0].([]string)
161
return condIn.handleBlank(w)
163
questionMark := strings.Repeat("?,", len(vals))
164
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
167
for _, val := range vals {
171
vals := condIn.vals[0].([]interface{})
173
return condIn.handleBlank(w)
175
questionMark := strings.Repeat("?,", len(vals))
176
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
181
val := condIn.vals[0].(expr)
182
if _, err := fmt.Fprintf(w, "%s IN (", condIn.col); err != nil {
185
if err := val.WriteTo(w); err != nil {
188
if _, err := fmt.Fprintf(w, ")"); err != nil {
192
bd := condIn.vals[0].(*Builder)
193
if _, err := fmt.Fprintf(w, "%s IN (", condIn.col); err != nil {
196
if err := bd.WriteTo(w); err != nil {
199
if _, err := fmt.Fprintf(w, ")"); err != nil {
203
v := reflect.ValueOf(condIn.vals[0])
204
if v.Kind() == reflect.Slice {
207
return condIn.handleBlank(w)
210
questionMark := strings.Repeat("?,", l)
211
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
215
for i := 0; i < l; i++ {
216
w.Append(v.Index(i).Interface())
219
questionMark := strings.Repeat("?,", len(condIn.vals))
220
if _, err := fmt.Fprintf(w, "%s IN (%s)", condIn.col, questionMark[:len(questionMark)-1]); err != nil {
223
w.Append(condIn.vals...)
229
func (condIn condIn) And(conds ...Cond) Cond {
230
return And(condIn, And(conds...))
233
func (condIn condIn) Or(conds ...Cond) Cond {
234
return Or(condIn, Or(conds...))
237
func (condIn condIn) IsValid() bool {
238
return len(condIn.col) > 0 && len(condIn.vals) > 0