godoes / gorm-oracle Goto Github PK

func getDefaultValues(db *gorm.DB, idx int) {
	insertTo := db.Statement.ReflectValue
	switch insertTo.Kind() {
	case reflect.Slice, reflect.Array:
		insertTo = insertTo.Index(idx)
	default:
	}

	for _, val := range db.Statement.Vars {
		switch v := val.(type) {
		case sql.Out:
			switch insertTo.Kind() {
			case reflect.Slice, reflect.Array:
				for i := insertTo.Len() - 1; i >= 0; i-- {
					rv := insertTo.Index(i)
					if reflect.Indirect(rv).Kind() != reflect.Struct {
						break
					}

					_, isZero := db.Statement.Schema.PrioritizedPrimaryField.ValueOf(db.Statement.Context, rv)
					if isZero {
						_ = db.AddError(db.Statement.Schema.PrioritizedPrimaryField.Set(db.Statement.Context, rv, v.Dest))
					}
				}
			case reflect.Struct:
				_, isZero := db.Statement.Schema.PrioritizedPrimaryField.ValueOf(db.Statement.Context, insertTo)
				if isZero {
					_ = db.AddError(db.Statement.Schema.PrioritizedPrimaryField.Set(db.Statement.Context, insertTo, v.Dest))
				}
			default:
                               
                                 // 会跳到这里 insertTo.Kind()  = 22, 是指针类型
				}
			}
		default:
		}
	}
}

type User struct {
    PasswordHash []byte
}

u := User{}
u.PasswordHash = []byte("password")
db.Create(&u) // 插入失败，ORA-01465: invalid hex number

// GormDBDataType gorm db data type
func (JSONMap) GormDBDataType(db *gorm.DB, field *schema.Field) string {
	switch db.Dialector.Name() {
	case "sqlite":
		return "JSON"
	case "mysql":
		return "JSON"
	case "postgres":
		return "JSONB"
	case "sqlserver":
		return "NVARCHAR(MAX)"
	case "oracle": // 添加 oracle 类型
		return "BLOB"
	}
	return ""
}

type User struct {
	types.BaseModel
	Extras       datatypes.JSONMap `gorm:"check:extras IS JSON"`
}

type P struct {
Sort int 
}

func (m Migrator) CreateTable(values ...interface{}) (err error) {
	for _, value := range values {
		// _ = m.TryQuotifyReservedWords(value) // 注释掉这段，能够成功创建表
		_ = m.TryRemoveOnUpdate(value)
	}
   ...
}