1
type UserStat struct {
2
  Status string
3
  Count  int64
4
}
5

6
var stats []UserStat
7
err := db.Raw(`
8
  SELECT status, COUNT(*) AS count
9
  FROM users
10
  WHERE created_at >= ?
11
  GROUP BY status
12
`, startAt).Scan(&stats).Error

1
result := db.Exec(
2
  "UPDATE users SET status = ? WHERE id IN ?",
3
  "inactive",
4
  []uint{1, 2, 3},
5
)
6
if result.Error != nil {
7
  return result.Error
8
}
9
fmt.Println(result.RowsAffected)

1
db.Raw(
2
  "SELECT * FROM users WHERE name = @name AND age >= @age",
3
  sql.Named("name", "Alice"),
4
  sql.Named("age", 18),
5
).Scan(&users)

1
db.Model(&Account{}).
2
  Where("id = ?", id).
3
  Update("balance", gorm.Expr("balance + ?", amount))

1
// Raw 已经表达了完整 SQL，不能期望后续 Where 自动安全地拼接到所有场景
2
db.Raw("SELECT * FROM users WHERE status = ?", "active").Scan(&users)

1
func Tenant(tenantID uint) func(*gorm.DB) *gorm.DB {
2
  return func(db *gorm.DB) *gorm.DB {
3
    return db.Where("tenant_id = ?", tenantID)
4
  }
5
}
6

7
func WithKeyword(keyword string) func(*gorm.DB) *gorm.DB {
8
  return func(db *gorm.DB) *gorm.DB {
9
    if keyword == "" {
10
      return db
11
    }
12
    return db.Where("name LIKE ?", "%"+keyword+"%")
13
  }
14
}
15

16
db.Scopes(Tenant(tenantID), WithKeyword(keyword)).Find(&users)

1
stmt := db.Session(&gorm.Session{DryRun: true}).
2
  Scopes(Tenant(1)).
3
  Where("status = ?", "active").
4
  Find(&User{}).Statement
5

6
fmt.Println(stmt.SQL.String())
7
fmt.Printf("vars: %#v\n", stmt.Vars)