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 环境变量注入
71 lines
1.6 KiB
Go
71 lines
1.6 KiB
Go
package tests
|
|
|
|
import (
|
|
"testing"
|
|
)
|
|
|
|
func TestDeleteSingle(t *testing.T) {
|
|
// 先确保表存在并清空
|
|
if err := DB.AutoMigrate(&User{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_USERS")
|
|
|
|
// 创建测试数据
|
|
user := User{Name: "Delete Test", Email: "delete@example.com", Age: 40}
|
|
DB.Create(&user)
|
|
|
|
// 删除
|
|
result := DB.Delete(&user)
|
|
if result.Error != nil {
|
|
t.Fatalf("failed to delete: %v", result.Error)
|
|
}
|
|
|
|
// 验证软删除（如果有 deleted_at）
|
|
var deleted User
|
|
result = DB.First(&deleted, user.ID)
|
|
if result.Error == nil {
|
|
t.Error("expected user to be soft deleted")
|
|
}
|
|
}
|
|
|
|
func TestDeleteWithoutWhere(t *testing.T) {
|
|
// 确保表存在
|
|
if err := DB.AutoMigrate(&User{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_USERS")
|
|
|
|
// 测试无 WHERE 条件的删除应该失败
|
|
result := DB.Delete(&User{})
|
|
if result.Error == nil {
|
|
t.Error("expected error for delete without WHERE condition")
|
|
}
|
|
t.Logf("Got expected error: %v", result.Error)
|
|
}
|
|
|
|
func TestHardDelete(t *testing.T) {
|
|
// 先确保表存在并清空
|
|
if err := DB.AutoMigrate(&User{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_USERS")
|
|
|
|
// 创建测试数据
|
|
user := User{Name: "Hard Delete", Email: "hard@example.com", Age: 50}
|
|
DB.Create(&user)
|
|
|
|
// 硬删除
|
|
result := DB.Unscoped().Delete(&user)
|
|
if result.Error != nil {
|
|
t.Fatalf("failed to hard delete: %v", result.Error)
|
|
}
|
|
|
|
// 验证完全删除
|
|
var deleted User
|
|
result = DB.Unscoped().First(&deleted, user.ID)
|
|
if result.Error == nil {
|
|
t.Error("expected user to be completely deleted")
|
|
}
|
|
}
|