- Sort Score
- Result 10 results
- Languages All
Results 1 - 10 of 28 for qselect (1.02 sec)
-
tests/count_test.go
result := dryDB.Table("users").Select("name").Count(&count) if !regexp.MustCompile(`SELECT COUNT\(.name.\) FROM .*users.*`).MatchString(result.Statement.SQL.String()) { t.Fatalf("Build count with select, but got %v", result.Statement.SQL.String()) } result = dryDB.Table("users").Distinct("name").Count(&count)
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Mon Oct 30 09:15:49 GMT 2023 - 6.9K bytes - Viewed (0) -
tests/soft_delete_test.go
t.Fatalf("invalid sql generated, got %v", sql) } sql = DB.Session(&gorm.Session{DryRun: true}).Table("user u").Select("name").Find(&User{}).Statement.SQL.String() if !regexp.MustCompile(`SELECT .name. FROM user u WHERE .u.\..deleted_at. IS NULL`).MatchString(sql) { t.Errorf("Table with escape character, got %v", sql) }
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Wed Feb 01 06:40:55 GMT 2023 - 5.7K bytes - Viewed (0) -
tests/connpool_test.go
"SELECT * FROM `users` WHERE name = ? AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT ?", "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 (?,?,?,?,?,?,?,?,?)",
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Tue Feb 06 02:54:40 GMT 2024 - 5.5K bytes - Viewed (0) -
tests/benchmark_test.go
b.ResetTimer() for x := 0; x < b.N; x++ { DB.Raw("select * from users where id = ?", user.ID).Scan(&u) } } func BenchmarkScanSlice(b *testing.B) { DB.Exec("delete from users") for i := 0; i < 10_000; i++ { user := *GetUser(fmt.Sprintf("scan-%d", i), Config{}) DB.Create(&user) } var u []User b.ResetTimer() for x := 0; x < b.N; x++ { DB.Raw("select * from users").Scan(&u) } }
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Wed Jun 01 03:50:57 GMT 2022 - 1.5K bytes - Viewed (0) -
tests/named_argument_test.go
var result5 NamedUser if err := DB.Raw("SELECT * FROM named_users WHERE (name1 = @name AND name3 = @name) AND name2 = @name2", map[string]interface{}{"name": "jinzhu-new", "name2": "jinzhu-new2"}).Find(&result5).Error; err != nil { t.Errorf("failed to update with named arg") } AssertEqual(t, result5, namedUser) var result6 NamedUser if err := DB.Raw(`SELECT * FROM named_users WHERE (name1 = @name
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Tue Dec 21 11:50:00 GMT 2021 - 2.7K bytes - Viewed (0) -
clause/select_test.go
}{ { []clause.Interface{clause.Select{}, clause.From{}}, "SELECT * FROM `users`", nil, }, { []clause.Interface{clause.Select{ Columns: []clause.Column{clause.PrimaryColumn}, }, clause.From{}}, "SELECT `users`.`id` FROM `users`", nil, }, { []clause.Interface{clause.Select{ Columns: []clause.Column{clause.PrimaryColumn}, }, clause.Select{ Columns: []clause.Column{{Name: "name"}},
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Sat Feb 18 01:06:43 GMT 2023 - 1.7K bytes - Viewed (0) -
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() } }
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Fri Oct 07 12:14:14 GMT 2022 - 1.9K bytes - Viewed (0) -
tests/scopes_test.go
} var maxId int64 userTable := func(db *gorm.DB) *gorm.DB { return db.WithContext(context.Background()).Table("users") } if err := DB.Scopes(userTable).Select("max(id)").Scan(&maxId).Error; err != nil { t.Errorf("select max(id)") } } func TestComplexScopes(t *testing.T) { tests := []struct { name string queryFn func(tx *gorm.DB) *gorm.DB expected string }{ {
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Fri Jan 12 08:42:21 GMT 2024 - 3.3K bytes - Viewed (0) -
callbacks/delete.go
tx = tx.Unscoped() } if len(db.Statement.Selects) > 0 { selects := make([]string, 0, len(db.Statement.Selects)) for _, s := range db.Statement.Selects { if s == clause.Associations { selects = append(selects, s) } else if columnPrefix := column + "."; strings.HasPrefix(s, columnPrefix) { selects = append(selects, strings.TrimPrefix(s, columnPrefix)) } }
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Fri Feb 25 02:48:23 GMT 2022 - 5.6K bytes - Viewed (0) -
tests/distinct_test.go
r := dryDB.Distinct("u.id, u.*").Table("user_speaks as s").Joins("inner join users as u on u.id = s.user_id").Where("s.language_code ='US' or s.language_code ='ES'").Find(&User{}) if !regexp.MustCompile(`SELECT DISTINCT u\.id, u\.\* FROM user_speaks as s inner join users as u`).MatchString(r.Statement.SQL.String()) { t.Fatalf("Build Distinct with u.*, but got %v", r.Statement.SQL.String()) }
Go - Registered: Sun May 05 09:35:13 GMT 2024 - Last Modified: Thu Jan 06 07:02:53 GMT 2022 - 2.5K bytes - Viewed (0)