Deleted

Deleted

Deleted will not really remove one record from table but only tag as deleted via current time. This feature ask you use xorm:"deleted", The field type could be time.Time, type MyTime time.Time or int, int64. For example,

1. type User struct {
2. Id int64
3. Name string
4. DeletedAt time.Time `xorm:"deleted"`
5. }

When Delete() will be called, tag deleted will automatically be filled as current time and this record will not be deleted in fact. For example:

1. var user User
2. engine.ID(1).Get(&user)
3. // SELECT * FROM user WHERE id = ?
4. engine.ID(1).Delete(&user)
5. // UPDATE user SET ..., deleted_at = ? WHERE id = ?
6. engine.ID(1).Get(&user)
7. // Call Get again, this time it will return false, nil
8. engine.ID(1).Delete(&user)
9. // Call delete again, it will return 0, nil

But how to get this record if you really need retrieve it? You need Unscoped, for example:

1. var user User
2. engine.ID(1).Unscoped().Get(&user)
3. // Then you will return true, nil
4. engine.ID(1).Unscoped().Delete(&user)
5. // Then this record will be really deleted