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 环境变量注入
85 lines
1.7 KiB
Go
85 lines
1.7 KiB
Go
package tests
|
|
|
|
import (
|
|
"testing"
|
|
"time"
|
|
)
|
|
|
|
func TestCreateSingle(t *testing.T) {
|
|
// 先创建表
|
|
if err := DB.AutoMigrate(&User{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_USERS")
|
|
|
|
user := User{
|
|
Name: "Test User",
|
|
Email: "test@example.com",
|
|
Age: 25,
|
|
Active: true,
|
|
}
|
|
|
|
result := DB.Create(&user)
|
|
if result.Error != nil {
|
|
t.Fatalf("failed to create user: %v", result.Error)
|
|
}
|
|
|
|
if user.ID == 0 {
|
|
t.Error("expected user ID to be set after create")
|
|
}
|
|
|
|
t.Logf("Created user with ID: %d", user.ID)
|
|
}
|
|
|
|
func TestCreateBatch(t *testing.T) {
|
|
if err := DB.AutoMigrate(&User{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_USERS")
|
|
|
|
users := []User{
|
|
{Name: "User 1", Email: "user1@example.com", Age: 20},
|
|
{Name: "User 2", Email: "user2@example.com", Age: 22},
|
|
{Name: "User 3", Email: "user3@example.com", Age: 24},
|
|
}
|
|
|
|
result := DB.Create(&users)
|
|
if result.Error != nil {
|
|
t.Fatalf("failed to create users: %v", result.Error)
|
|
}
|
|
|
|
if result.RowsAffected != 3 {
|
|
t.Errorf("expected 3 rows affected, got %d", result.RowsAffected)
|
|
}
|
|
|
|
for i, user := range users {
|
|
if user.ID == 0 {
|
|
t.Errorf("user %d: expected ID to be set", i)
|
|
}
|
|
}
|
|
}
|
|
|
|
func TestCreateWithTimestamp(t *testing.T) {
|
|
if err := DB.AutoMigrate(&Product{}); err != nil {
|
|
t.Fatalf("failed to migrate: %v", err)
|
|
}
|
|
clearTable(t, "TEST_PRODUCTS")
|
|
|
|
product := Product{
|
|
Name: "Test Product",
|
|
Price: 99.99,
|
|
Stock: 100,
|
|
Description: "This is a test product with long description",
|
|
CreatedAt: time.Now(),
|
|
}
|
|
|
|
result := DB.Create(&product)
|
|
if result.Error != nil {
|
|
t.Fatalf("failed to create product: %v", result.Error)
|
|
}
|
|
|
|
if product.ID == 0 {
|
|
t.Error("expected product ID to be set")
|
|
}
|
|
}
|