github.com/erda-project/erda-infra@v1.0.9/providers/mysql/v2/plugins/fields/soft_delete_test.go (about)

     1  // Copyright (c) 2021 Terminus, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //      http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  
    15  package fields_test
    16  
    17  import (
    18  	"errors"
    19  	"os"
    20  	"path/filepath"
    21  	"regexp"
    22  	"testing"
    23  
    24  	"gorm.io/driver/sqlite"
    25  	"gorm.io/gorm"
    26  
    27  	"github.com/erda-project/erda-infra/providers/mysql/v2/plugins/fields"
    28  )
    29  
    30  type User struct {
    31  	ID        uint
    32  	Name      string
    33  	Age       uint
    34  	DeletedAt fields.DeletedAt
    35  }
    36  
    37  func TestSoftDelete(t *testing.T) {
    38  	dsn := filepath.Join(os.TempDir(), "gorm.db")
    39  	DB, err := gorm.Open(sqlite.Open(dsn), &gorm.Config{})
    40  	if err != nil {
    41  		t.Errorf("failed to connect database")
    42  	}
    43  	DB = DB.Debug()
    44  
    45  	user := User{Name: "jinzhu", Age: 20}
    46  	DB.Migrator().DropTable(&User{})
    47  	DB.AutoMigrate(&User{})
    48  	DB.Save(&user)
    49  
    50  	var count int64
    51  	var age uint
    52  
    53  	if DB.Model(&User{}).Where("name = ?", user.Name).Count(&count).Error != nil || count != 1 {
    54  		t.Errorf("Count soft deleted record, expects: %v, got: %v", 1, count)
    55  	}
    56  
    57  	if DB.Model(&User{}).Select("age").Where("name = ?", user.Name).Scan(&age).Error != nil || age != user.Age {
    58  		t.Errorf("Age soft deleted record, expects: %v, got: %v", user.Age, age)
    59  	}
    60  
    61  	if err := DB.Delete(&user).Error; err != nil {
    62  		t.Fatalf("No error should happen when soft delete user, but got %v", err)
    63  	}
    64  
    65  	if user.DeletedAt.Time.IsZero() {
    66  		t.Errorf("user's deleted at should not be zero, DeletedAt: %v", user.DeletedAt)
    67  	}
    68  
    69  	sql := DB.Session(&gorm.Session{DryRun: true}).Delete(&user).Statement.SQL.String()
    70  	if !regexp.MustCompile(`UPDATE .users. SET .deleted_at.=.* WHERE .users.\..id. = .* AND \(.users.\..deleted_at. <= \? OR .users.\..deleted_at. IS NULL\)`).MatchString(sql) {
    71  		t.Fatalf("invalid sql generated, got %v", sql)
    72  	}
    73  
    74  	if DB.First(&User{}, "name = ?", user.Name).Error == nil {
    75  		t.Errorf("Can't find a soft deleted record")
    76  	}
    77  
    78  	count = 0
    79  	if DB.Model(&User{}).Where("name = ?", user.Name).Count(&count).Error != nil || count != 0 {
    80  		t.Errorf("Count soft deleted record, expects: %v, got: %v", 0, count)
    81  	}
    82  
    83  	age = 0
    84  	if err := DB.Model(&User{}).Select("age").Where("name = ?", user.Name).Scan(&age).Error; err != nil || age != 0 {
    85  		t.Fatalf("Age soft deleted record, expects: %v, got: %v, err %v", 0, age, err)
    86  	}
    87  
    88  	if err := DB.Unscoped().First(&User{}, "name = ?", user.Name).Error; err != nil {
    89  		t.Errorf("Should find soft deleted record with Unscoped, but got err %s", err)
    90  	}
    91  
    92  	count = 0
    93  	if DB.Unscoped().Model(&User{}).Where("name = ?", user.Name).Count(&count).Error != nil || count != 1 {
    94  		t.Errorf("Count soft deleted record, expects: %v, count: %v", 1, count)
    95  	}
    96  
    97  	age = 0
    98  	if DB.Unscoped().Model(&User{}).Select("age").Where("name = ?", user.Name).Scan(&age).Error != nil || age != user.Age {
    99  		t.Errorf("Age soft deleted record, expects: %v, got: %v", 0, age)
   100  	}
   101  
   102  	DB.Unscoped().Delete(&user)
   103  	if err := DB.Unscoped().First(&User{}, "name = ?", user.Name).Error; !errors.Is(err, gorm.ErrRecordNotFound) {
   104  		t.Errorf("Can't find permanently deleted record")
   105  	}
   106  }