1

2

3

4

5

6

func (user *User) BeforeUpdate(scope *gorm.Scope) {

  if pw, err := bcrypt.GenerateFromPassword(user.Password, 0); err == nil {

    scope.SetColumn("EncryptedPassword", pw)

    // user.EncryptedPassword = pw  // 不工作，更新时不会包括EncryptedPassword字段

  }

}

1

SELECT * FROM users WHERE deleted_at IS NULL OR deleted_at <= '0001-01-02'

1

SELECT * FROM users WHERE deleted_at IS NULL

1

2

3

4

5

6

7

8

9

import (

    "github.com/jinzhu/now"

)

func main() {

  var models = []interface{}{&User{}, &Image{}}

  for _, model := range models {

    db.Unscoped().Model(model).Where("deleted_at < ?", now.MustParse("0001-01-02")).Update("deleted_at", gorm.Expr("NULL"))

  }

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

type Object interface {

  GroupOrderOpenlog() (uidList []int)

}

func (o *object) GroupOrderOpenlog() {

    type res struct {

        Uid int `json:"uid"`

    }

    var re []res

    sql:= "SELECT uid FROM order_openlog  GROUP BY uid"

    o.Db.Raw(sql).Scan(&amp;re)

    fmt.Println(re)

    for _,k :=range re{

        fmt.Println(k.Uid)

    }

}