Search Options

Results per page
Sort
Preferred Languages
Advance

Results 21 - 30 of 554 for WHERE (0.21 sec)

  1. statement_test.go

    				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 Dec 28 09:35:17 UTC 2025
    - Last Modified: Sat Dec 23 13:19:41 UTC 2023
    - 1.9K bytes
    - Viewed (0)
  2. tests/soft_delete_test.go

    	user := *GetUser("SoftDelete", Config{})
    	DB.Save(&user)
    
    	var count int64
    	var age uint
    
    	if DB.Model(&User{}).Where("name = ?", user.Name).Count(&count).Error != nil || count != 1 {
    		t.Errorf("Count soft deleted record, expects: %v, got: %v", 1, count)
    	}
    
    	if DB.Model(&User{}).Select("age").Where("name = ?", user.Name).Scan(&age).Error != nil || age != user.Age {
    		t.Errorf("Age soft deleted record, expects: %v, got: %v", 0, age)
    	}
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Wed Feb 01 06:40:55 UTC 2023
    - 5.7K bytes
    - Viewed (0)
  3. clause/from_test.go

    							ON: clause.Where{
    								[]clause.Expression{clause.Eq{clause.Column{Table: "profiles", Name: "email"}, clause.Column{Table: clause.CurrentTable, Name: "email"}}},
    							},
    						},
    					},
    				}, clause.From{
    					Joins: []clause.Join{
    						{
    							Type:  clause.InnerJoin,
    							Table: clause.Table{Name: "articles"},
    							ON: clause.Where{
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Wed Jul 15 02:25:10 UTC 2020
    - 1.9K bytes
    - Viewed (0)
  4. tests/generics_test.go

    	}
    
    	results, err := gorm.G[User](DB).Where("name IN (?)", gorm.G[User](DB).Select("name").Where("name LIKE ?", "GenericsSubquery%")).Find(ctx)
    	if err != nil {
    		t.Fatalf("got error: %v", err)
    	}
    
    	if len(results) != 4 {
    		t.Errorf("Four users should be found, instead found %d", len(results))
    	}
    
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Sun Nov 02 14:09:18 UTC 2025
    - 33.7K bytes
    - Viewed (0)
  5. 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"})}}}
    
    		for _, clause := range clauses {
    			stmt.AddClause(clause)
    		}
    
    		stmt.Build("SELECT", "FROM", "WHERE")
    		_ = stmt.SQL.String()
    	}
    }
    
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Fri Oct 07 12:14:14 UTC 2022
    - 1.9K bytes
    - Viewed (0)
  6. clause/on_conflict.go

    			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 ")
    		onConflict.Where.Build(builder)
    		builder.WriteByte(' ')
    	}
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Fri Oct 07 05:46:20 UTC 2022
    - 1.3K bytes
    - Viewed (0)
  7. tests/joins_test.go

    	DB.Save(&user)
    
    	// test where
    	var user1 User
    	onQuery := DB.Where(&Pet{Name: "joins-args-db_pet_2"})
    	if err := DB.Joins("NamedPet", onQuery).Where("users.name = ?", user.Name).First(&user1).Error; err != nil {
    		t.Fatalf("Failed to load with joins on, got error: %v", err)
    	}
    
    	AssertEqual(t, user1.NamedPet.Name, "joins-args-db_pet_2")
    
    	// test where and omit
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Sun May 25 07:40:40 UTC 2025
    - 15K bytes
    - Viewed (0)
  8. tests/main_test.go

    	}
    
    	var columns []string
    	if DB.Where("sdsd.zaaa = ?", "sd;;;aa").Pluck("aaa", &columns).Error == nil {
    		t.Errorf("Should got error with invalid SQL")
    	}
    
    	if DB.Model(&User{}).Where("sdsd.zaaa = ?", "sd;;;aa").Pluck("aaa", &columns).Error == nil {
    		t.Errorf("Should got error with invalid SQL")
    	}
    
    	if DB.Where("sdsd.zaaa = ?", "sd;;;aa").Find(&User{}).Error == nil {
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Thu Mar 24 01:31:58 UTC 2022
    - 1.4K bytes
    - Viewed (0)
  9. tests/connpool_test.go

    			"SELECT * FROM `users` WHERE name = ? AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT ?",
    			"INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES (?,?,?,?,?,?,?,?,?)",
    			"SELECT * FROM `users` WHERE name = ? AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT ?",
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Sun May 25 07:40:40 UTC 2025
    - 5.5K bytes
    - Viewed (0)
  10. tests/upsert_test.go

    	var user1, user2, user3, user4, user5, user6 User
    	if err := DB.Where(&User{Name: "find or init", Age: 33}).FirstOrInit(&user1).Error; err != nil {
    		t.Errorf("no error should happen when FirstOrInit, but got %v", err)
    	}
    
    	if user1.Name != "find or init" || user1.ID != 0 || user1.Age != 33 {
    		t.Errorf("user should be initialized with search value")
    	}
    
    	DB.Where(User{Name: "find or init", Age: 33}).FirstOrInit(&user2)
    Registered: Sun Dec 28 09:35:17 UTC 2025
    - Last Modified: Tue Jul 29 11:06:13 UTC 2025
    - 13.1K bytes
    - Viewed (0)
Back to top