Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 10 of 39 for exprs (0.05 sec)

  1. clause/where.go

    	for idx, expr := range where.Exprs {
    		if v, ok := expr.(OrConditions); !ok || len(v.Exprs) > 1 {
    			if idx != 0 {
    				where.Exprs[0], where.Exprs[idx] = where.Exprs[idx], where.Exprs[0]
    			}
    			break
    		}
    	}
    
    	buildExprs(where.Exprs, builder, AndWithSpace)
    }
    
    func buildExprs(exprs []Expression, builder Builder, joinCond string) {
    	wrapInParentheses := false
    
    	for idx, expr := range exprs {
    		if idx > 0 {
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Thu Apr 25 12:22:53 UTC 2024
    - 5.1K bytes
    - Viewed (0)
  2. clause/where_test.go

    				Exprs: []clause.Expression{clause.Not(clause.Expr{SQL: "`score` <= ?", Vars: []interface{}{100}},
    					clause.Expr{SQL: "`age` <= ?", Vars: []interface{}{60}})},
    			}},
    			"SELECT * FROM `users` WHERE NOT (`score` <= ? AND `age` <= ?)",
    			[]interface{}{100, 60},
    		},
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Where{
    				Exprs: []clause.Expression{
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Thu Apr 25 12:22:53 UTC 2024
    - 6.2K bytes
    - Viewed (0)
  3. soft_delete.go

    				for _, expr := range where.Exprs {
    					if orCond, ok := expr.(clause.OrConditions); ok && len(orCond.Exprs) == 1 {
    						where.Exprs = []clause.Expression{clause.And(where.Exprs...)}
    						c.Expression = where
    						stmt.Clauses["WHERE"] = c
    						break
    					}
    				}
    			}
    		}
    
    		stmt.AddClause(clause.Where{Exprs: []clause.Expression{
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Wed Feb 01 06:40:55 UTC 2023
    - 4.5K bytes
    - Viewed (1)
  4. clause/on_conflict.go

    		}
    
    		if len(onConflict.TargetWhere.Exprs) > 0 {
    			builder.WriteString(" WHERE ")
    			onConflict.TargetWhere.Build(builder)
    			builder.WriteByte(' ')
    		}
    	}
    
    	if onConflict.DoNothing {
    		builder.WriteString("DO NOTHING")
    	} else {
    		builder.WriteString("DO UPDATE SET ")
    		onConflict.DoUpdates.Build(builder)
    	}
    
    	if len(onConflict.Where.Exprs) > 0 {
    		builder.WriteString(" WHERE ")
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Fri Oct 07 05:46:20 UTC 2022
    - 1.3K bytes
    - Viewed (0)
  5. clause/joins_test.go

    				ON: clause.Where{
    					Exprs: []clause.Expression{clause.Eq{clause.Column{Table: "user_info", Name: "user_id"}, clause.PrimaryColumn}},
    				},
    			},
    			sql: "LEFT JOIN `user` ON `user_info`.`user_id` = `users`.`id`",
    		},
    		{
    			name: "RIGHT JOIN",
    			join: clause.Join{
    				Type:  clause.RightJoin,
    				Table: clause.Table{Name: "user"},
    				ON: clause.Where{
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Thu Nov 03 13:03:13 UTC 2022
    - 2.6K bytes
    - Viewed (0)
  6. clause/select.go

    	if s.Expression != nil {
    		if s.Distinct {
    			if expr, ok := s.Expression.(Expr); ok {
    				expr.SQL = "DISTINCT " + expr.SQL
    				clause.Expression = expr
    				return
    			}
    		}
    
    		clause.Expression = s.Expression
    	} else {
    		clause.Expression = s
    	}
    }
    
    // CommaExpression represents a group of expressions separated by commas.
    type CommaExpression struct {
    	Exprs []Expression
    }
    
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Wed Jul 14 07:51:24 UTC 2021
    - 1.1K bytes
    - Viewed (0)
  7. callbacks/update.go

    					stmt.AddClause(clause.Where{Exprs: []clause.Expression{clause.IN{Column: column, Values: values}}})
    				}
    			}
    		case reflect.Struct:
    			for _, field := range stmt.Schema.PrimaryFields {
    				if value, isZero := field.ValueOf(stmt.Context, stmt.ReflectValue); !isZero {
    					stmt.AddClause(clause.Where{Exprs: []clause.Expression{clause.Eq{Column: field.DBName, Value: value}}})
    				}
    			}
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Mon Mar 18 05:44:55 UTC 2024
    - 9.4K bytes
    - Viewed (0)
  8. clause/benchmarks_test.go

    		clauses := []clause.Interface{
    			clause.Select{},
    			clause.From{},
    			clause.Where{Exprs: []clause.Expression{
    				clause.Eq{Column: clause.PrimaryColumn, Value: "1"},
    				clause.Gt{Column: "age", Value: 18},
    				clause.Or(clause.Neq{Column: "name", Value: "jinzhu"}),
    			}},
    			clause.Where{Exprs: []clause.Expression{
    				clause.Or(clause.Gt{Column: "score", Value: 100}, clause.Like{Column: "name", Value: "%linus%"}),
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Fri Oct 07 12:14:14 UTC 2022
    - 1.9K bytes
    - Viewed (0)
  9. statement_test.go

    			for w := 0; w < whereCount; w++ {
    				s = s.clone()
    				s.AddClause(clause.Where{
    					Exprs: s.BuildCondition(fmt.Sprintf("where%d", w)),
    				})
    			}
    
    			s1 := s.clone()
    			s1.AddClause(clause.Where{
    				Exprs: s.BuildCondition("FINAL1"),
    			})
    			s2 := s.clone()
    			s2.AddClause(clause.Where{
    				Exprs: s.BuildCondition("FINAL2"),
    			})
    
    			if reflect.DeepEqual(s1.Clauses["WHERE"], s2.Clauses["WHERE"]) {
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Sat Dec 23 13:19:41 UTC 2023
    - 1.9K bytes
    - Viewed (0)
  10. clause/select_test.go

    					},
    				},
    			}, clause.From{}},
    			"SELECT `id`, `name`, LENGTH(`mobile`) FROM `users`", nil,
    		},
    		{
    			[]clause.Interface{clause.Select{
    				Expression: clause.CommaExpression{
    					Exprs: []clause.Expression{
    						clause.Expr{
    							SQL: "? as name",
    							Vars: []interface{}{
    								clause.Eq{
    									Column: clause.Column{Name: "age"},
    									Value:  18,
    								},
    							},
    						},
    					},
    				},
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Sat Feb 18 01:06:43 UTC 2023
    - 1.7K bytes
    - Viewed (0)
Back to top