- Sort Score
- Result 10 results
- Languages All
Results 11 - 20 of 1,058 for WHERE (0.25 sec)
-
chainable_api.go
tx.Statement.Omits = columns } return } // Where add conditions // // See the [docs] for details on the various formats that where clauses can take. By default, where clauses chain with AND. // // // Find the first user with name jinzhu // db.Where("name = ?", "jinzhu").First(&user) // // Find the first user with name jinzhu and age 20 // db.Where(&User{Name: "jinzhu", Age: 20}).First(&user)
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Wed Apr 17 03:38:55 GMT 2024 - 14.3K bytes - Viewed (1) -
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)
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Mon Sep 05 07:39:19 GMT 2022 - 11.4K bytes - Viewed (0) -
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) }
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Wed Feb 01 06:40:55 GMT 2023 - 5.7K bytes - Viewed (0) -
internal/s3select/sql/parser_test.go
cases := []string{ `select * from s3object where Name like 'abcd'`, `select Name like 'abc' from s3object`, `select * from s3object where Name not like 'abc'`, `select * from s3object where Name like 'abc' escape 't'`, `select * from s3object where Name like 'a\%' escape '?'`, `select * from s3object where Name not like 'abc\' escape '?'`, `select * from s3object where Name like 'a\%' escape LOWER('?')`,
Go - Registered: Sun Apr 21 19:28:08 GMT 2024 - Last Modified: Thu Jan 18 07:03:17 GMT 2024 - 9.2K bytes - Viewed (0) -
tests/count_test.go
}) var count1 int64 if err := DB.Model(&Company{}).Where("name = ?", "company_count_group_a").Group("name").Count(&count1).Error; err != nil { t.Errorf(fmt.Sprintf("Count should work, but got err %v", err)) } if count1 != 1 { t.Errorf("Count with group should be 1, but got count: %v", count1) } var count2 int64
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Mon Oct 30 09:15:49 GMT 2023 - 6.9K bytes - Viewed (0) -
tests/distinct_test.go
t.Fatalf("errors happened when create users: %v", err) } var names []string DB.Table("users").Where("name like ?", "distinct%").Order("name").Pluck("name", &names) AssertEqual(t, names, []string{"distinct", "distinct", "distinct", "distinct-2", "distinct-3"}) var names1 []string DB.Model(&User{}).Where("name like ?", "distinct%").Distinct().Order("name").Pluck("Name", &names1)
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Thu Jan 06 07:02:53 GMT 2022 - 2.5K bytes - Viewed (0) -
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"]) {
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Sat Dec 23 13:19:41 GMT 2023 - 1.9K bytes - Viewed (0) -
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
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Wed Apr 26 14:19:32 GMT 2023 - 13.5K bytes - Viewed (1) -
tests/named_argument_test.go
var result7 NamedUser if err := DB.Where("name1 = @name OR name2 = @name", sql.Named("name", "jinzhu-new")).Where("name3 = 'jinzhu-new3'").First(&result7).Error; err == nil || !errors.Is(err, gorm.ErrRecordNotFound) { t.Errorf("should return record not found error, but got %v", err) } DB.Delete(&namedUser) var result8 NamedUser
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Tue Dec 21 11:50:00 GMT 2021 - 2.7K bytes - Viewed (0) -
association.go
} joinStmt.Build("WHERE") if len(joinStmt.SQL.String()) > 0 { tx.Clauses(clause.Expr{SQL: strings.Replace(joinStmt.SQL.String(), "WHERE ", "", 1), Vars: joinStmt.Vars}) } } tx = tx.Session(&Session{QueryFields: true}).Clauses(clause.From{Joins: []clause.Join{{ Table: clause.Table{Name: association.Relationship.JoinTable.Table}, ON: clause.Where{Exprs: queryConds}, }}}) } else {
Go - Registered: Sun Apr 28 09:35:09 GMT 2024 - Last Modified: Thu May 04 11:30:45 GMT 2023 - 21.2K bytes - Viewed (0)