charlie
9154afab6b
- 新增驱动抽象层 driver_adapter（go-ora/godror 双驱动切换） - 新增 Update/Delete/Query 回调，完善 RETURNING INTO 子句 - 修复 create.go 事务悬挂行 BUG、批量 RowsAffected、主键 WHERE 注入 - 版本感知体系：分页/自增/序列默认值/BOOLEAN/32k VARCHAR2 分级能力判定 - 11g 序列+触发器自增、ON UPDATE 触发器、默认值智能转换 - 升级 go-ora v2.8.19 → v2.9.0 - 单元测试+模块测试+集成测试共 96 个，真实 Oracle 11g 全绿 - 测试 DSN 密码移除，改为 ORACLE_DSN 环境变量注入
38 lines
1.1 KiB
Go
38 lines
1.1 KiB
Go
package tests
|
|
|
|
import (
|
|
"testing"
|
|
)
|
|
|
|
// TestSoftDeleteSetsDeletedAt 精确验证软删除后 DELETED_AT 确实被写入数据库
|
|
func TestSoftDeleteSetsDeletedAt(t *testing.T) {
|
|
// 确保表存在并清空
|
|
if err := DB.AutoMigrate(&User{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_USERS")
|
|
|
|
user := User{Name: "Soft Delete Exact", Email: "soft_exact@example.com", Age: 40}
|
|
if err := DB.Create(&user).Error; err != nil {
|
|
t.Fatalf("failed to create: %v", err)
|
|
}
|
|
|
|
// 软删除
|
|
if err := DB.Delete(&user).Error; err != nil {
|
|
t.Fatalf("failed to soft delete: %v", err)
|
|
}
|
|
|
|
// 直接验证 DELETED_AT 被写入：用 Unscoped 查询（绕过软删除过滤）
|
|
var deleted User
|
|
if err := DB.Unscoped().First(&deleted, user.ID).Error; err != nil {
|
|
t.Fatalf("failed to query unscoped: %v", err)
|
|
}
|
|
if !deleted.DeletedAt.Valid {
|
|
t.Errorf("expected DeletedAt to be valid (set), got invalid")
|
|
}
|
|
if deleted.DeletedAt.Time.IsZero() {
|
|
t.Errorf("expected DeletedAt to have a timestamp, got zero")
|
|
}
|
|
t.Logf("DeletedAt set to: %v", deleted.DeletedAt.Time)
|
|
}
|